• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Investment Banking Guides

          • Investment Banking Basics
          • Investment Banking Careers
          • Mergers and Acquisitions
        • Investment-Banking-Guides
        • Accounting

          • Accounting Basics
          • Balance Sheet in Accounting
          • Cash Flow Statement
        • Accounting
        • Financial Statement Analysis

          • Ratio Analysis
          • Profitability Ratios
          • Turnover Ratios
        • Financial-Statement-Analysis
        • Valuation

          • Valuation Principles
          • Valuation Multiples
          • Other Valuation Tools
        • Valuation
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Private Equity Guides
          • Equity Research
          • Corporate Finance
          • Excel


          • VBA
          • Finance Certifications
          • Top Books
          • Asset Management
          • Risk Management Basics
          • Learn Economics
  • Free Courses
  • All Courses
        • Certification Courses

          Certificate
        • All in One Financial Analyst Bundle

          Financial-Analyst-Bundle
        • Investment Banking

          Investment-Banking-Training
        • Financial Modeling

          Financial-Modeling-Course
        • Others

          • MS Excel Course
          • Accounting Course
          • Equity Research Course

          • Venture Capital Course
          • Private Equity Course
          • View All
  • 250+ Courses All in One Bundle
  • Login

Bootstrapping Yield Curve

Home » Fixed Income » Bond Valuations » Bootstrapping Yield Curve

By Harshada Khot Leave a Comment

Bootstrapping Yield Curve

What is 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.

You can download this Bootstrapping Examples Excel Template here – Bootstrapping Examples Excel Template

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:

Bootstrapping Yield Curve Example 1

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 the 6-month zero-coupon bond will be 3%.

For a 1-year bond, there will be two cash flows, 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.

Popular Course in this category
Cyber Monday Sale
Fixed Income Course 9 Courses | 37+ Hours | Full Lifetime Access | Certificate of Completion
4.7 (487 ratings)
Course Price

View Course

Related Courses

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:

Bootstrapping Yield Curve Calculation 1.1

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:

Bootstrapping Example 2

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:

Bootstrapping Yield Curve Calculation 2.1

  • 100 = 99*(1 + R6*6/12)
  • R6 = (100/99 – 1)*12/6
  • R6 = 2.0202%

For 9-month Tenure:

Bootstrapping Example 2.2

  • 100 = 99*(1 + R9*6/12)
  • R9 = (100/98.5 – 1)*12/9
  • R9 = 2.0305%

For 1-year Tenure:

Calculation 2.0.3

  • 100 = 97.35*(1 + R12*6/12)
  • R12 = (100/97.35 – 1)*12/12
  • R12 = 2.7221%

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

Bootstrapping Example 2.0.4

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 a bootstrapping yield curve, sometimes one needs to find the rate between two maturities. Consider the zero-rate curve for the following maturities.

Calculation 3

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 –

Calculation 3.1

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 –

  • Importance of the Phillips Curve
  • Explanation of Convexity Formula
  • What is Fixed Income?
  • Compounding Definition
  • Convexity of a Bond
  • Formula for Coupon Bond
  • Bond Trading Course
  • Pricing a Bond
0 Shares
Share
Tweet
Share

Filed Under: Bond Valuations, Fixed Income

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Bootstrapping Examples Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Limited Period Offer - Fixed Income Course (9 courses, 37+ hours videos) View More