Lenny D. answered 02/17/20
Financial Professional with many years of Wall Street Experience
For A Tables kinda hoky but you should be able to recreate in Excel. For be reduce the number of coupons to 8 and discount the coupons and the bullet at 3% to determine the PV of all cash flows
| Price | 1000.00 | 1010.00 | 990.02 | |||||
| PV Coupon | PV Bullet | PV Coupon | PV Bullet | PV Coupon | PV Bullet | |||
| 371.2765 | 628.7235 | 373.595 | 636.4094 | 368.956 | 621.0625 | |||
| Cash Flow | YTM | 4.75% | 4.6228% | 4.8785% | ||||
| Year | Coupon | Bullet | Coupon | Bullet | Coupon | Bullet | Coupon | Bullet |
| 1 | 47.5 | 0 | 45.3461 | 0 | 45.4012 | 0 | 45.2905 | 0 |
| 2 | 47.5 | 0 | 43.2898 | 0 | 43.3951 | 0 | 43.1838 | 0 |
| 3 | 47.5 | 0 | 41.3268 | 0 | 41.4777 | 0 | 41.1751 | 0 |
| 4 | 47.5 | 0 | 39.4528 | 0 | 39.6450 | 0 | 39.2598 | 0 |
| 5 | 47.5 | 0 | 37.6637 | 0 | 37.8933 | 0 | 37.4336 | 0 |
| 6 | 47.5 | 0 | 35.9558 | 0 | 36.2189 | 0 | 35.6923 | 0 |
| 7 | 47.5 | 0 | 34.3254 | 0 | 34.6186 | 0 | 34.0321 | 0 |
| 8 | 47.5 | 0 | 32.7689 | 0 | 33.0889 | 0 | 32.4490 | 0 |
| 9 | 47.5 | 0 | 31.2829 | 0 | 31.6269 | 0 | 30.9397 | 0 |
| 10 | 47.5 | 1000 | 29.8644 | 628.7235 | 30.2294 | 636.4094 | 29.5005 | 621.0625 |