Bond valuation-Annual interest Calculate the value of the bond shown in the following table, assuming it pays interest annuall? (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Excel spreadsheet, you will need to enter the values of Rate, Nper, Fv, Pmt, and Type into the present value function. The number of years to maturity, n, is years. (Type a whole number.) The required rate of return on the bond, rd, is 7%. (Type a whole percentage.) The annual interest payment, I, is $ (Round to the nearest dollar.) The par value of the bond, M, is $ (Round to the nearest dollar.) The value of the bond, 0, is \$ (Round to the nearest cent.)