Question

ads from the following table with quarterly coupon payments: !! Hint Make sure to round all intermediate calcul A Data Table - Х on (Click on the following icon in order to copy its contents into a spreadsheet.) Coupon Rate Price 6% Par Value $5,000.00 $5,000.00 $1,000.00 $5,000.00 5% 8% Years to Yield to Maturity Maturity 56% 30 . 9% 5 12% 10% Print Done wer box and then click Check Answer Clear All

Answer 1

Α Par Value 2 $5,000 $5,000 $1,000 $5,000 B I c Coupon Years to Yield to Price Rate Maturity Maturity 6% 5 6 % $5,000.00 5% 30 % $2,931.66 8% - 5 12% $851.23 7% 15 10% $3,840.93 7 Frequency 4 quarterly

Ε Par Value Coupon Rate Years to Maturity Yield to Maturity Price 30 2 5000 3 5000 4 1000 5 5000 0.06 0.05 0.08 0.07 0.06 0.09 0.12 0.1 =-PV(D2/$B$7,C2*$B$7,B2* A2/$B$7,A2) =-PV(D3/$B$7,03*$B$7,B3*A3/$B$7,A3) =-PV(D4/$B$7,04*$B$7,B4*A4/$B$7,A4) =-PV(D5/$B$7,C5*$B$7,B5*A5/$B$7,A5) 5 quarterly 7 Frequency 8