## Bootstrapping Yield Curve

Bootstrapping is a method to construct a zero-coupon yield curve. The following bootstrapping examples provide an overview of how a yield curve is constructed. Although, not every variation can be explained as there are many methods in bootstrapping because of difference in conventions used.

### Top 3 Examples of Bootstrapping Yield Curve in Excel

The following are examples of bootstrapping yield curve in excel.

#### Example #1

Consider different bonds with a face value of $ 100 with the yield to maturity equal to the coupon rate. The coupon details are as below:

**Solution:**

Now, for a zero coupon with a maturity of 6 months, it will receive a single coupon equivalent to the bond yield. Hence, the spot rate for 6-month zero coupon bond will be 3%.

For a 1-year bond, there will be two cashflows, at 6 months and at 1 year.

The cash flow at 6 months will be (3.5%/2 * 100 = $ 1.75) and cash flow at 1 year will be (100 + 1.75 = $ 101.75) i.e. principal payment plus the coupon payment.

4.6 (319 ratings)

From the 0.5-year maturity the spot rate or the discount rate is 3% and let us assume the discount rate for 1-year maturity be x%, then

- 100 = 1.75/(1+3%/2)^1 + 101.75/(1+x/2)^2
- 100-1.75/(1+3%/2)=101.75/(1+x%/2)^2
- 98.2758 = 101.75/(1+x%/2)^2
- (1+x%/2)^2 =101.75/ 98.2758
- (1+x%/2)^2 = 1.0353
- 1+x%/2 = (1.0353)^(1/2)
- 1+x%/2 = 1.0175
- x% = (1.0175-1)*2
**x% = 3.504%**

Solving the above equation, we get x = 3.504%

**Now, again for a 2 year bond maturity,**

- 100 = 3/(1+3%/2)^1 + 3/(1+3.504%/2)^2 + 3/(1+4.526%/2)^3 + 103/(1+x/2)^4
- 100 = 2.955665025 + 2.897579405 + 2.805211867 + 103/(1+x/2)^4
- 100-8.658456297 = 103/(1+x/2)^4
- 91.3415437 = 103/(1+x/2)^4
- (1+x/2)^4 = 103//91.3415437
- (1+x/2)^4 = 1.127635858
- (1+x/2) = 1.127635858^(1/4)
- (1+x/2) = 1.030486293
- x = 1.030486293-1
- x = 0.030486293*2
**x = 6.097%**

Solving for x we get, x = 6.097%

Similarly, for a 1.5-year bond maturity

100 = 2.25/(1+3%/2)^1 + 2.25/(1+3.504/2)^2 + 102.25/(1+x/2)^3

Solving the above equation, we get** x = 4.526%**

Thus, the bootstrapped zero yield curves will be:

#### Example #2

Let us consider a set of zero-coupon bonds of face value $ 100, with maturity 6 months, 9 months and 1 year. The bonds are zero-coupon i.e. they do not pay any coupon during the tenure. The prices of the bonds are as below:

**Solution:**

Considering a linear rate convention,

**FV = Price*(1+ r*t)**

Where r is the zero-coupon rate, t is the time

**Thus, for 6-month tenure:**

- 100 = 99*(1 + R
_{6}*6/12) - R
_{6}= (100/99 – 1)*12/6 **R**_{6 }= 2.0202%

**For 9-month Tenure:**

- 100 = 99*(1 + R
_{9}*6/12) - R
_{9}= (100/98.5 – 1)*12/9 **R**_{9 }= 2.0305%

**For 1-year Tenure:**

- 100 = 97.35*(1 + R
_{12}*6/12) - R
_{12}= (100/97.35 – 1)*12/12 **R**_{12 }= 2.7221%

Hence, the bootstrapped zero-coupon yield rates will be:

Note that the difference between the first and second example is that we have considered the zero-coupon rates to be linear in example 2 whereas they are compounding in example 1.

#### Example #3

Although this is not a direct example of bootstrapping yield curve, sometimes one needs to find the rate between two maturities. Consider the zero-rate curve for following maturities.

Now, if one needs the zero-coupon rate for 2-year maturity, he needs to linearly interpolate the zero rates between 1 year and 3 years.

**Solution:**

Calculation of zero coupon discount rate for 2 year –

Zero coupon rate for 2 year = 3.5% + (5% – 3.5%)*(2- 1)/(3 – 1) = 3.5% + 0.75%

**Zero Coupon Rate for 2 Years = 4.25%**

Hence, the zero coupon discount rate to be used for the 2-year bond will be 4.25%

### Conclusion

The bootstrap examples give an insight into how zero rates are calculated for the pricing of bonds and other financial products. One must correctly look at the market conventions for proper calculation of the zero rates.

### Recommended Articles

This has been a guide to Bootstrapping Yield Curve. Here we discuss how to construct a zero coupon yield curve using bootstrapping excel examples along with explanations. You can learn more about fixed income from following articles –