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 This question has to be done on excel, would like step by step help on what to input.

A) Create a spreasheet to solve for Yield to Maturity B) Create a spreadsheet to solve for the price of the bond if the yield to maturity is 2% higher C) Create a spreadsheet to solve the price of the bond if the yield to maturity is 2 % lower D) What can you summarize about the relationship between the price of the bond, the par value, the yield to maturity, and the coupon rate?