Video Excel Online Structured Activity: Bond valuation You are considering a 15-year, $1,000 par value bond. Its coupon rate is 9%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet If you require an effective" annual interest rate (not a nominal rate) of 9.19%, how much should you be willing to pay for the bond? Do not round Intermediate steps. Round your answer to the nearest cent. $ -10,000.97 Check My Work Reset Problem 123 B B C D 15 $1,000.00 9.00% 2 9.19% A 1 Bond valuation 2 3 Years to maturity 4 Par value of bond 5 Coupon rate 6 Frequency interest paid per year 7 Effective annual rate 8 9 Calculation of periodic rate: 10 Nominal annual rate 11 Periodic rate 12 13 Calculation of bond price: 14 Number of periods 15 Interest rate per period 16 Coupon payment per period 17 Par value of bond 18 Price of bond 19 20 21 22 8.99% 4.49% Formulas =NOMINAL(B7,B6) =B10/B6 Formulas =B3 B6 30 4.49% $45.00 $1,000.00 $1,000.97 =B5/B6 B4 =-PV(B15,B14,B16,B17)