In: Finance
Stewart County School District is about to raise funds for a new school through a bond issue. The plan is to raise $3,475,000 with a 3.15% coupon, 12-year bond. The underwriter indicates the bonds will be sold at a price of $100.65 per $100. The yield to maturity on the bond is:
Bond price=100.65
Coupon amount=3.15
Bond face value=100
YTM can be calculated using the '=IRR' function in excel as shown below.
| Year | Cash flow | 
| 1 | -100.65 | 
| 2 | 3.15 | 
| 3 | 3.15 | 
| 4 | 3.15 | 
| 5 | 3.15 | 
| 6 | 3.15 | 
| 7 | 3.15 | 
| 8 | 3.15 | 
| 9 | 3.15 | 
| 10 | 3.15 | 
| 11 | 3.15 | 
| 12 | 103.15 | 
| YTM | 3.08% | 
Showing formula:
