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