an investor has two bonds in her portfolio

Mind Tap - Cengage Learning ng cengage.com Q Search this cours istory Bookmarks Window Help MindTap - Cengage Learning ondo CENGAGE MINDTAP Excel Online Activity: Bond valuation 2 Question 1 010 Video 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. www Open spreadsheet If you require an effective" annual interest rate (not a nominal rate) of 11.41%, how much should you be willing to pay for the bond? Do not found intermediate steps. Round your answer to the nearest cent. 5 935.11 ols Solution Colotion Excel Solution If you require an effective annual interest rate (not a nominal rate) of 11.41%, how much should you be willing to pay for the bond? Do not found intermediate steps. Round your answer to the nearest cent. actory Ne