In: Finance
A 30-year maturity bond making annual coupon payments with a
coupon rate of 16.5% has duration of 11.19 years and convexity of
180.9. The bond currently sells at a yield to maturity of
8%.
a. Find the price of the bond if its yield to maturity falls to 7%. (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Price of the bond $
b. What price would be predicted by the duration
rule? (Do not round intermediate calculations. Round your
answer to 2 decimal places.)
Predicted price $
c. What price would be predicted by the
duration-with-convexity rule? (Do not round intermediate
calculations. Round your answer to 2 decimal places.)
Predicted price $
d-1. What is the percent error for each rule? (Enter your answer as a positive value. Do not round intermediate calculations. Round "Duration Rule" to 2 decimal places and "Duration-with-Convexity Rule" to 3 decimal places.)
Percent Error | ||
YTM | Duration Rule | Duration-with- Convexity Rule |
7% | % | % |
d-2. What do you conclude about the accuracy of the two rules?
The duration-with-convexity rule provides more accurate approximations to the actual change in price. | |
The duration rule provides more accurate approximations to the actual change in price. |
e-1. Find the price of the bond if it's yield to maturity rises to 9%. (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Price of the bond $
e-2. What price would be predicted by the duration rule? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Predicted price $
e-3. What price would be predicted by the
duration-with-convexity rule? (Do not round intermediate
calculations. Round your answer to 2 decimal places.)
Predicted price $
e-4. What is the percent error for each rule? (Do not round intermediate calculations. Round "Duration Rule" to 2 decimal places and "Duration-with-Convexity Rule" to 3 decimal places.)
Percent Error | ||
YTM | Duration Rule | Duration-with- Convexity Rule |
9% | % | % |
e-5. Are your conclusions about the accuracy of the two rules consistent with parts (a) – (d)?
Yes | |
No |
A1 | B | C | D | E | F | G | H | I | J |
2 | |||||||||
3 | |||||||||
4 | Face Value of Bond | $1,000.00 | |||||||
5 | Maturity Period | 30.00 | years | ||||||
6 | Coupon rate | 16.50% | |||||||
7 | YTM | 8.0% | |||||||
8 | |||||||||
9 | Annual Coupon | $165.00 | =D4*D6 | ||||||
10 | Price of the Bond will be the present value of future cash flows of the bond. | ||||||||
11 | Cash Flow of the Bond will be as follows: | ||||||||
12 | Year | 0 | 1 | 2 | 3 | … | 30 | ||
13 | Cash Flow | $165.00 | $165.00 | $165.00 | $165.00 | $1,165.00 | |||
14 | |||||||||
15 | Calculation of Price of Bond: | ||||||||
16 | Year (t) | 0 | 1 | 2 | 3 | … | 30 | ||
17 | Cash FLow (Ct) | $165.00 | $165.00 | $165.00 | $165.00 | $1,165.00 | |||
18 | YTM (i) | 8.00% | |||||||
19 | Price of the bond | =$165*(P/A,8%,30)+$1,000*(P/F,8%,30) | |||||||
20 | $1,956.91 | =E17*PV(D18,D5,-1,0)+D4*(1/((1+D7)^D5)) | |||||||
21 | |||||||||
22 | Hence current price of the bond is | $1,956.91 | |||||||
23 | |||||||||
24 | a) | ||||||||
25 | |||||||||
26 | New Yield to maturity | 7% | |||||||
27 | |||||||||
28 | New Price of the bond | =$165*(P/A,7%,30)+$1,000*(P/F,7%,30) | |||||||
29 | $2,178.86 | =D9*PV(D26,D5,-1,0)+D4*(1/((1+D26)^D5)) | |||||||
30 | |||||||||
31 | Hence new price of the bond is | $2,178.86 | |||||||
32 | |||||||||
33 | b) | ||||||||
34 | Calculation of price of bond on the basis of duration rule: | ||||||||
35 | Using duration rule, change in bond price can be calculated as: | ||||||||
36 | % Change in Bond price | = - Modified Duration * Change in Yield | |||||||
37 | |||||||||
38 | Using the Following Data | ||||||||
39 | Duration | 11.19 | Years | ||||||
40 | Yield | 8.0% | |||||||
41 | Modified duration | =Duration / (1+ Yield) | |||||||
42 | 10.36 | =D39/(1+D40) | |||||||
43 | |||||||||
44 | New Yield | 7.00% | |||||||
45 | Change in Yield | -1.00% | |||||||
46 | |||||||||
47 | Using duration rule, change in bond price can be calculated as: | ||||||||
48 | % Change in Bond price | = - Modified Duration * Change in Yield | |||||||
49 | 10.36% | =-D110*D113 | |||||||
50 | |||||||||
51 | Hence % Change in Bond price | 10.36% | |||||||
52 | |||||||||
53 | Price of bond Before change | $1,957 | |||||||
54 | |||||||||
55 | Price of predicted using Duration method | =Price before the change*(1+%change) | |||||||
56 | $2,159.67 | =D53*(1+D51) | |||||||
57 | |||||||||
58 | Hence price predicted using duration method | $2,159.67 | |||||||
59 |