please provide excel calculations

CSM Corporation has a bond isstwe onfstanding that has 15 years remaining to matiriry and carnics a coupon rate of 6%. Interest on the bond is paid on a semisumual basis. The par value of the CSM bond is $1,000, and it is currently velling for $874.42. Complete the steps below nising cell references to goven data or pressowr criculations. bo some cares, a simple cell reference is all you need. To copy pasite a formula across a row ar down a column, an absolute cell reference ar a maxed cell reference mas be prefered. If a specific Excel function is to be ased, the drections wall specify the ase of that fiunction Do not tope in hamerical data inio a celf or function. Instead, mate a rofevence fo the cell in which the data is fornd. Make yow courpurations only in the bitue cells hightighted To Do a. What is the bond's yicld to maturity? b. What would the price be if the yield to maturity were 29 higher than in part a? c. What would the price be if the yield to maturify were 2% lower than in part a? Solafion a. What is the bond's yield to maturity? a. What is the bond's yield to maturity? b. What wonld 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 yicld to maturity? b. What would the price be if the yield to matirity were 2% higher than in part a? c. What would the price be if the yield to maturity were 296 lower than in part a? Requiremeats 1 in cell D19. by using cell references, calculate the semainnual interest payment of the bond. Points 1 1 2 In cell D20, by asing cell references, calculate the mumber of periods to maturity of the boed. 3 in cell D21, by using cell references atnd the fienction R.ATE, calculate the semiannual yielil to matirity of the bond. Notes: 1. Enter 0.1 for Guess argument of the function R.ATE 2. Refer to the values from Steps 1 and 2 in your calculations. 4 In cell D22, by using cell references, calculate the munal yiekt to matarity of the bond. Note: Refer to the value from Step 3 in your calculations. 5. In cell D27, by asing cell references and the function PV, calculate the current price of the bond if the yield to maturity have increased by 276 . Notes: 1. Refer to the valoes from Steps 1 and 2 in your calculations. 2. The ontpot of the expession or function you typed in this cell is expected as a positive namber 6 In cell D32, by using cell references and the function PV, calculate the current price of the bond if the yield to maturity have decreased by 2%. Notesi. 1. Refer to the values from Steps 1 and 2 in your calculations. 2. The output of the expression or function you typed in this cell is expected as a positive mumber- 7 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed