Videe Excel Online Structured Activity: Bond valuation You are considering a 25-yeac, $1,000 par value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been eollected in the Mirosoft Excel Online fle below. Open the spreadheet 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.86 %, how much should you be willing to pay for the bond? De not round intermediate steps Round your anwer to the neat E Check My Work Reet Proe