This is an finance class from University of Phoenix

This is an finance class from University of Phoenix

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.

Assignment Steps

Resources: Tutorial help on Excel® 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. See “Instructor Policies” for discussion of various ways to create and then submit your response.


Show all work and analysis on your submission.

  • 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 & 2 (Questions and Problems section)

Click the Assignment Files tab to submit your Excel workbook.