Create a new table but this
time with a 10% rate
| Year | Coupon rate 10% | Initial yield 5% | 6% yield |
| 1 | 100 | 95.24 | 94.34 |
| 2 | 100 | 90.70 | 89.00 |
| 3 | 100 | 86.38 | 83.96 |
| 4 | 100 | 82.27 | 79.21 |
| 5 | 1100 | 861.88 | 821.98 |
| Sum | 1,216.47 | 1,168.49 | |
| Percentage change | -3.94% | ||
| (1,168.49 - 1,216.47) ÷ 1,216.47 × 100 | |||
Work:
| Year | Cash flow | PVF @ 5% | Discounted cash flow |
| 1 | 100 | 0.952380952 | 95.24 |
| 2 | 100 | 0.907029478 | 90.7 |
| 3 | 100 | 0.863837599 | 86.38 |
| 4 | 100 | 0.822702475 | 82.27 |
| 5 | 1100 | 0.783526166 | 861.88 |
| Price of bond @ YTM 5% | 1216.47 | ||
| Year | Cash flow | PVF @ 6% | Discounted cash flow |
| 1 | 100 | 0.943396226 | 94.34 |
| 2 | 100 | 0.88999644 | 89 |
| 3 | 100 | 0.839619283 | 83.96 |
| 4 | 100 | 0.792093663 | 79.21 |
| 5 | 1100 | 0.747258173 | 821.98 |
| Price of bond @ YTM 6% | 1168.49 | ||
Create a new table but this time with a 10% rate Example II Given Change in...
The question is stated on the excel sheet. Need a new table.
Example III Given Change in Yield on Notes with different coupons, but same maturity Extreme Case---Zero Coupon Bond Redo, but this time have rates fall from 5% to 4% What can we say about the relative price changes 50 22 0.00 ...........-5%, 20-year Bond- 5% coupoi 5% yield 6% yield 47.62 47.17 45.35 44.50 50 43.19 41.98 50 41.14 39.60 50 39.18 37.36 37.31 35.25 50 35.53 33.25...
Question is stated on the excel
sheet
Example Same Yield Change Different Maturities .......-5%, 5-year Note- 5% coupoi 5% yield 4% yield PV PV Recreate this example with yields rising to 6% instead of falling. What happenings to the price changes 50 50 50 50 1050 47.62 45.35 43.19 41.14 822.70 48.08 46.23 44.45 42.74 863.02 50 50 NUWE -5%, 20-year Bond 5% coupoi 5% yield 4% yield PV PY 50 47.62 48.08 50 45.35 46.23 50 43.19 44.45 41.14...