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.

Assignment Steps

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.

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