please include formulas on excel

Q Search ond valuation 2 Excel Online Structured Activity: Bond valuation You are considering a 10-year, $1,000 par value bond. Its coupon rate is 10%, 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 7.11%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. Check My Work Reset Problem B Bond valuation D 10 $1,000.00 10.00% 2 7.11% 2 Years to maturity Par value of bond Coupon rate 6 Frequency interest paid per year 7 Effective annual rate 3 Calculation of periodic rate: 0 Nominal annual rate 1 Periodic rate 2 3 Calculation of bond price: 4 Number of periods 5 Interest rate per period -6 Coupon payment per period -7 Par value of bond 18 Price of bond 19 20 Formulas #N/A #N/A Formulas #N/A 0.00% #N/A $1,000.00 #N/A 21