Purpose of Assignment
Students should be able to calculate time value of money problems including solving for; present value future value rate and payment determine the value and yield of corporate bonds and use the dividend discount model to calculate the value and expected return of a common stock.
Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft®Office website. There are also additional tutorials via the web that offer support for office products.
Complete the following Questions and Problems from each chapter as indicated.
Show all work and analysis. No computations/calculations; no points.
Please note: numerical text of computations will not be accepted. Students must either write out each step of an equation leading to the solution in Word or use equations within Excel (the proper way; copying and pasting equations in Excel is not the same as using an equation within a cell of Excel).
Prepare in Microsoft® Excel® or Word.
- Ch. 5: Questions 3 & 4 (Question and Problems section): Microsoft® Excel® templates provided for Problems 3 and 4
- Ch. 6: Questions 2 & 20 (Questions and Problems section)
- Ch. 7: Questions 3 &11 (Questions and Problems section)
- Ch. 8: Questions 1 & 6 (Questions and Problems section): Microsoft® Excel® template provided for Problem 6
Format your assignment consistent with APA guidelines if submitting in Microsoft® Word.
Click the Assignment Files tab to submit your assignment.