In: Finance
Problem 2
| 
 Maturity  | 
 Spot Rate  | 
| 
 1  | 
 5.0700  | 
| 
 2  | 
 5.1248  | 
| 
 3  | 
 5.1873  | 
| 
 4  | 
 5.2557  | 
| 
 5  | 
 5.3281  | 
| 
 6  | 
 5.4026  | 
| 
 7  | 
 5.4773  | 
a) Compute the Forward Rate Curve for the adjacent Term Structure
b) Price 5 year, 8% annual coupon bond. Assume these are risk adjusted rates.
c) Show that you will arrive at the same price by using the forward rates
Problem 3
What is the YTM of the above bond? What should its Par yield be?
a) Forward Rate f (t-1, 1) = [(1 + s(t))t / (1 + s(t-1))t-1 ] – 1
where,
s(t):t-period Spot Rate
s(t)-1:t-1-period Spot Rate
f(t-1, 1): forward Rate applicable for the period (t-1,1)
| 
 Maturity (t)  | 
 Spot Rate (S)  | 
 Forward Rate(t-1,1) F(t-1,1)  | 
| 
 1  | 
 5.0700%  | 
 5.0700%  | 
| 
 2  | 
 5.1248%  | 
 5.1796%  | 
| 
 3  | 
 5.1873%  | 
 5.3124%  | 
| 
 4  | 
 5.2557%  | 
 5.4612%  | 
| 
 5  | 
 5.3281%  | 
 5.6182%  | 
| 
 6  | 
 5.4026%  | 
 5.7759%  | 
| 
 7  | 
 5.4773%  | 
 5.9266%  | 
Excel formula for Forward Rate at t=2 is,
F(1,1) = ((1+S2)^t2)/((1+S1)^t1)-1
F(1,1) = ((1+5.1248%)^2)/((1+5.0700%)^1)-1 = 5.1796%
Similarly, we can compute F(t-1,1) for all maturities as in above excel and draw the Forward rate curve as below:

b) Price of 5 year, 8% annual coupon bond
Using Spot rate, Price of bond = C/(1+S1) + C/(1+S2)2 + C/(1+S3)3 + C/(1+S4)4 + C/(1+S5)5 + FV/(1+S5)5
Where, C is coupon payment
FV is par value
S1, S2, S3, S4, S5 are spot rates for respective maturity
Considering FV i,e, par value = $1000
| 
 Maturity (t)  | 
 Spot Rate (S)  | 
 Cash flows (CF)  | 
 Discounting factor using Spot rates D = 1/(1+S)t  | 
 PV CF*D  | 
| 
 1  | 
 5.0700%  | 
 80  | 
 0.951746455  | 
 76.13972  | 
| 
 2  | 
 5.1248%  | 
 80  | 
 0.904877178  | 
 72.39017  | 
| 
 3  | 
 5.1873%  | 
 80  | 
 0.859231277  | 
 68.7385  | 
| 
 4  | 
 5.2557%  | 
 80  | 
 0.814737122  | 
 65.17897  | 
| 
 5  | 
 5.3281%  | 
 1080  | 
 0.771398428  | 
 833.1103  | 
Price of Bond = sum of PV = $1115.56
C) Using Forward rate, Price of bond
P = C/(1+F(0,1))
+C/{(1+F(0,1))* (1+F(1,1))}
+ C/{(1+F(0,1))* (1+F(1,1))* (1+F(2,1)) }
+ C/{(1+F(0,1))* (1+F(1,1))* (1+F(2,1))* (1+F(3,1))}
+ C/{(1+F(0,1))* (1+F(1,1))* (1+F(2,1))* (1+F(3,1))* (1+F(4,1))}
+ FV/{(1+F(0,1))* (1+F(1,1))* (1+F(2,1))* (1+F(3,1))* (1+F(4,1))}
Where, P is price of bond
C is coupon payment
FV is par value
F(0,1), F(1,1) F(2,1), F(3,1), F(4,1) are forward rates for respective maturity
Considering FV i,e, par value = $1000
| 
 Maturity (t)  | 
 Forward Rate(t-1,1)  | 
 Cash flows CF  | 
 Discounting factor using Spot rates D = 1/{(1+F(0,1))* (1+F(1,1))…. (1+F(t-1,1))}  | 
 PV (CF*D)  | 
| 
 1  | 
 5.0700%  | 
 80  | 
 0.951746455  | 
 76.13972  | 
| 
 2  | 
 5.1796%  | 
 80  | 
 0.904877178  | 
 72.39017  | 
| 
 3  | 
 5.3124%  | 
 80  | 
 0.859231277  | 
 68.7385  | 
| 
 4  | 
 5.4612%  | 
 80  | 
 0.814737122  | 
 65.17897  | 
| 
 5  | 
 5.6182%  | 
 1080  | 
 0.771398428  | 
 833.1103  | 
Price of Bond = sum of PV = $1115.56
Hence, we can see that the price of bond is same by using either spot rates or forward rates.
3) YTM of Bond
Price of bond = C/(1+YTM) + C/(1+YTM)2 + C/(1+YTM)3 + C/(1+YTM)4 + C/(1+YTM)5 + FV/(1+YTM)5
Where, C is coupon payment
FV is par value
YTM is Yield to maturity
For above bond,
1115.56 = 80/(1+YTM) + 80/(1+YTM)2 + 80/(1+YTM)3 + 80/(1+YTM)4 + 90/(1+YTM)5 + 1000/(1+YTM)5
Solve for YTM,
YTM = 5.3081%