Bond valuationSemiannual interest Calculate the value of each of the bonds shown in the following table, all of which pay interest semiannually. (Click on the icon here to copy the contents of the data table below into a spreadsheet.) Bond . B Par Value $500 500 500 Coupon interest rate 11% 12 14 Years to maturity 10 20 4 Required stated annual return 9% 10 14 The value of bond Ais $. (Round to the nearest cent. data-9_24_2020-10_58 AM [Protected View] - Excel File Home Insert | Page Layout | Formulas Data Review | View Add-ins Team Tell me... sy veralab 2 : i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A1 . fax Bond F A A Bond 1 2 2 A 3 B B C D E Par Value Coupon interest rate Year to maturity Required stated annual return 500 11 10 9 500 12 20 101 500 14 4 14 4 C 5 6