In: Finance
The YTM on a bond is the interest rate you earn on your investment if interest rates don’t change. If you actually sell the bond before it matures, your realized return is known as the holding period yield (HPY). |
a. |
Suppose that today you buy a bond with an annual coupon of 8 percent for $1,170. The bond has 16 years to maturity. What rate of return do you expect to earn on your investment? Assume a par value of $1,000. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
Expected rate of return ???? | % |
b1. |
Two years from now, the YTM on your bond has declined by 1 percent, and you decide to sell. What price will your bond sell for? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
Bond price ??? | $ |
b2. | What is the HPY on your investment? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
HPY ??? | % |
Yield to maturity is the rate of return the investor will get if he/she hold the bold till maturity period
So YTM is like internal rate of return, if we discount all the cash inflow from the bond using YTM, the present value will be equal to the bond current price.
YTM is calculated using Excel, the function used is (IRR)
Pls refer below table
Year |
Cash flow |
Amount |
0 |
Bod price (Outflow) |
-1170 |
1 |
Coupon (Inflow) |
80 |
2 |
Coupon (Inflow) |
80 |
3 |
Coupon (Inflow) |
80 |
4 |
Coupon (Inflow) |
80 |
5 |
Coupon (Inflow) |
80 |
6 |
Coupon (Inflow) |
80 |
7 |
Coupon (Inflow) |
80 |
8 |
Coupon (Inflow) |
80 |
9 |
Coupon (Inflow) |
80 |
10 |
Coupon (Inflow) |
80 |
11 |
Coupon (Inflow) |
80 |
12 |
Coupon (Inflow) |
80 |
13 |
Coupon (Inflow) |
80 |
14 |
Coupon (Inflow) |
80 |
15 |
Coupon (Inflow) |
80 |
16 |
Par + Coupon (Inflow |
1080 |
YTM |
6.28% |
|
Formula |
=IRR(G44:G64) |
--------------------------------------------------------------------------------------------------------------------------
After 2 year the price of the bond will be
Price of the bond could be calculated using below formula.
P = C* [{1 - (1 + YTM) ^ -n}/ (YTM)] + [F/ (1 + YTM) ^ -n]
Where,
Face value = $1000
Coupon rate = 8%
YTM or Required rate = 5.28%
Time to maturity (n) = 14 years
Annual coupon C = $80
Let's put all the values in the formula to find the bond current value
P = 80* [{1 - (1 + 0.0528) ^ -14}/ (0.0528)] + [1000/ (1 + 0.0528) ^14]
P = 80* [{1 - (1.0528) ^ -14}/ (0.0528)] + [1000/ (1.0528) ^14]
P = 80* [{1 - 0.48658}/ 0.0528] + [1000/ 2.05514]
P = 80* [0.51342/ 0.0528] + [486.58486]
P = 80* 9.72386 + 486.58486
P = 777.9088 + 486.58486
P = 1264.49366
So price of the bond is $1264.49
--------------------------------------------------------------------------------------------------------------------------
Holding period return = (Selling price – initial investment)/Initial investment * 100
= (1264.49 – 1170)/ 1170 * 100
= 94.49/1170 * 100
= 0.0808 * 100
= 8.08%
--------------------------------------------------------------------------------------------------------------------------
Hope that helps.
Feel free to comment if you need further assistance J