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 located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Bond A B Par Value $1,000 500 100 Coupon interest rate 9% 13 13 Years to maturity 8 20 5 Required stated annual return 8 % 14 12 The value of bond Ais $ (Round to the nearest cent.) AutoSave OFF BESU svo data-11_15_20... v Home Insert Draw >> Tell me Share o Comments A A v % v 1 Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Check for Updates Office Update To keep up-to-date with security updates... 4 X fx Bond A1 A F Bond 1 2 A 4 C 5 5 6 B Par Value Coupon interest rate 1000 9% 500 13 100 13 D D E Year to maturity Required stated annual return 88% 20 14 5 12 7 + + - - - 100%