Question

Please solve for A B C

P6-25 (similar to) Question Help 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.) Bond Coupon interest rate 8% Years to maturity 12 Required stated annual return 10% Par Value $500 1,000 500 13 15 13 15 The value of bond A is $ . (Round to the nearest cent.)

Answer 1

A B Bond Par Value Coupon interest rate I EF Required Years to stated Price Maturity annual return 12 10% $431.0 15 13% $1,000.0 5 16% $483.2 $500 $1,000 $500 8% 13% 15% з в 4c 5 6 Frequency 2 semi-annual 7

F Bond Par Value Coupon interest rate Years to Maturity Required stated annual return Price 0.1 1 2 A з в 4c 500 1000 500 0.08 0.13 0.15 0.13 0.16 --PV(E2/$B$6,D2*$B$6,C2*B2/$B$6,B2) --PV(E3/$B$6,D3*$B$6,03*B3/$B$6,B3) --PV(E4/$B$6,04* $B$6,04*B4/$B$6,B4) 5 Frequency semi-annual 6 7 8