In: Finance
A firm's bonds have a maturity of 10 years with a $1,000 face value, have an 8% semiannual coupon, are callable in 5 years at $1,049, and currently sell at a price of $1,096.70.
a. YTM is the internal rate of return for all the cash flows including the price in you can use the excel and the IRR function with all the cash flows.
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |||||||||||
| Year 0 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 |
| $ (1,096.70) | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 1,040.00 |
| 3.33% | ||||||||||||||||||||
you can also type in the formula

use Excel to goal seek
b. For Next question(YTC) the yield is only calculated till year 5 and update the call value with the last installment
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||
| Year 0 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 | Install 1 | Install 2 |
| $ (1,096.70) | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 40.00 | $ 1,089.00 |
| 3.27% | ||||||||||
c . Clearly YTM > YTC Therefore option III is right