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 valuation-Semiannual 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.) Coupon interest rate Years to maturity Required stated annual return Bond Par Value A $1,000 10% 12 8% B 1,000 12 20 500 12 5 12 14