Excel Online Structured Activityn Bond valuation You are considering a 10 -year, 31,000 psr value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been collected in the Microseft Excrl Oriline file below. Open the spreadsheet and perform the required analysis to answer the question below. Opea spreadshent If you require an "eflective" annusl interest rate (not a nominal rate) of 10.46%, how much should you be willing to pay for the bond? Do not raund interimediate steps. Round your answer to the nearest cent