Chapter 6 page 253.

Do you have the solutions to this problem? I would like to compare my answers to yours. Thank you.

CSM Corporation has a bond issue outstanding at the end of 2015. The bond has 15 years remaining to maturity and carries a coupon interest rate of 6%. Interest on the bond is compounded on a semiannual basis. The par value of the CSM bond is $1,000, and it is currently selling for $874.42. Create a spreadsheet to the Excel spreadsheet examples located in the chapter for yield to maturity and semiannual interest to model the following: Create a spreadsheet similar to the Excel spreadsheet examples located in the chapter to solve for the yield to maturity. Create a spreadsheet similar to the Excel spreadsheet examples located in the chapter to solve for the price of the bond if the yield to maturity is 2% higher. Create a spreadsheet similar to the Excel spreadsheet examples located in the chapter to solve for the price of the bond if the yield to maturity is 2% lower. What can you summarize about the relationship between the price of the bond, the par value, the yield to maturity, and the coupon rate? CSM Corporation has a bond issue outstanding at the end of 2015. The bond has 15 years remaining to maturity and carries a coupon interest rate of 6%. Interest on the bond is compounded on a semiannual basis. The par value of the CSM bond is $1,000, and it is currently selling for $874.42. Create a spreadsheet to the Excel spreadsheet examples located in the chapter for yield to maturity and semiannual interest to model the following: Create a spreadsheet similar to the Excel spreadsheet examples located in the chapter to solve for the yield to maturity. Create a spreadsheet similar to the Excel spreadsheet examples located in the chapter to solve for the price of the bond if the yield to maturity is 2% higher. Create a spreadsheet similar to the Excel spreadsheet examples located in the chapter to solve for the price of the bond if the yield to maturity is 2% lower. What can you summarize about the relationship between the price of the bond, the par value, the yield to maturity, and the coupon rate