MINDTAP Q Search this course vity: Bond valuation 2 Video Excel Online Structured Activity: Bond valuation You are considering a 15-year, $1,000 par value bond. Its coupon rate is 11%, 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 iiiii Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 10.96%, 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