Spreadsheet Exercise

Spreadsheet icon

CSM Corporation has a bond issue outstanding that has 15 years remaining to maturity and carries a coupon rate of 6%. Interest on the bond is paid on a semiannual basis. The par value of the CSM bond is $1,000, and it is currently selling for $874.42.

To Do

  1. Create a spreadsheet similar to the Excel spreadsheet examples in the chapter to solve for the yield to maturity.

  2. Create a spreadsheet similar to the Excel spreadsheet examples in the chapter to solve for the price of the bond if the yield to maturity is 2% higher.

  3. Create a spreadsheet similar to the Excel spreadsheet examples in the chapter to solve for the price of the ...

Get Principles of Managerial Finance, 15th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.