please provide excel calculations

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. Complete the steps below numg cell references to gaven data or previous calculations. In some cases, a simple cell reference is all you need. To copilpasie a formula across a row or down a coliann, an absolute cell reference or a mared cell reference may be preformed. if a specific Excel function is to be wed, the directions will specify the wse of that function. Do not fype in numercal data info a cell or finction. Instead, make a reference fo the cell in which the data is found. Make yora compratations only in the bhue cells hightighted below: In all cases, unless otherwe directed, wse the earliost appearance of the data in your formulas, usually the Given Data section. To Do a. What is the bond's yield to maturity? b. What would the price be if the yield to matiarity were 2% higher than in part a? c. What would the price be if the yield to maturity were 2% lower than ia part a? b. What would the price be if the yield to maturity were 2% higher than in part a? c. What would the price be if the yield to maturity were 2% lower than in part a? Solution a. What is the bond's yield to maturity? b. What would the price be if the yield to maturity were 2% higher than in part a? c. What would the price be if the yield to maturity were 2% lower than in part a? Hat 2 Acceisibilyr investigate