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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial