Question

Bond prices. Price the bonds from the following table with monthly coupon payments: P . Hint: make sure to round all intermediate calculations to at least seven decimal places. i Data Table (Click on the following icon 2 in order to copy its contents into a spreadsheet.) Coupon Rate Years to Maturity Price 6% - 5 Par Value $5,000.00 $1,000.00 $1,000.00 $1,000.00 Yield to Maturity 9% 10% 6% 8% 5% 15 7% 12% Print Done

Answer 1

Par value Coupon Years yield Price $5,000.00 6% 5 9% $4,397.83 $1,000.00 5% 5 10% $803.89 $ 1.000.00 15 6% $1,098.75 $ 1,000.00 12% 10 8% $1,274.74 Par value Coupon Years lyield Price (5000 10.06 15 10.09 ]=-PV(D2/12,C2*12,B2/12*A2,A2) ! 1000 10.05 15 0.1 ]=-PV(D3/12,C3*12,B3/12*A3,A3) | 1000 0.07 15 0.06 =-PV(D4/12,C4*12,14/12*A4,A4) | 1000 0.12 10 0.08 =-PV(D5/12,C5*12, B5/12*A5,A5)