Bootstrapping Solution
What is the Bootstrapping method?
Bootstrapping is a method for constructing a zero-coupon yield curve from the prices of a set of coupon-bearing products.As you may know Treasury bills offered by the government are not available for every time period hence the bootstrapping method is used mainly to fill in the missing figures in order to derive the yield curve. The bootstrapping method uses interpolation to determine the yields for Treasury zero-coupon securities with various maturities.
Let’s consider following example:
We have bonds/instruments with face value of $100 with maturity of 6months, 1 year, 1.5 years and 2 years. Let’s assume for simplicity that coupon for those individual bonds equal to YTM on those bonds implying that Bonds are trading at Par. i.e. $100
Power Interest Grid
Face Value | 100 | |||
YTM | 5 | 1 | 1.5 | 2 |
Bond Price | 100 | 100 | 100 | 100 |
Coupon =YTM | 3.00% | 4.00% | 5.00% | 6.00% |
As you can see for 6-month security we are going to receive only single bullet payment implying that its yield is equivalent to zero coupon bonds. Hence we can say 6 months Spot rate is 3%. Now if we consider 1 year security you can see that we are going to receive two cashflows, first one after 6 months (of $2) and another at the end of a year (of $102 = principal + coupon). Discounting this cashflow @ 4% will give us its market price of $100 however we know that first cashflow should be discounted at 3% as that is the spot rate for that tenor. So the question becomes at what rate we should discount next cashflow which we are going to get at the end of year 1 so that price comes to $100?
We can get this answer by solving simple equation:
Solving for ‘X’ gives us value if 4.01%. This rate is effectively zero coupon rate for 1 year security and we will call it 1 year Spot rate. Now similarly we can continue this process for maturity of 1.5 year, 2 years & so on…
The formula, however to calculate next spot rate can be simplified as
You can also watch the youtube video for more theoretical explanation.
The attached excel file provides you with complete reconciliation and explanation on how to bootstrap.
Bootstrapping Solution
MAKE YOUR CAREER IN
Need more Info?
Tags
- ABOUT FRM COURSE IN INDIA
- ACCA
- ACCA CERTIFICATION
- ACCA COURSE
- ACCA COURSE DETAILS
- ACCA COURSE DURATION
- ACCA COURSE ELIGIBILITY CRITERIA
- ACCA COURSE STRUCTURE AND FEES IN INDIA
- ACCA COURSE SYLLABUS
- ADMISSION TO CFA
- BAT COURSE
- BEST FINANCIAL MODELING COURSE
- BEST FINANCIAL MODELING COURSE IN INDIA
- BEST ONLINE CFA PREP COURSE
- BEST ONLINE FINANCIAL MODELING COURSE
- CFA CERTIFICATION
- CFA COURSE
- CFA COURSE DETAILS
- CFA COURSE DURATION
- CFA COURSE FEES
- CFA COURSE FEES IN INDIA
- CFA COURSE IN INDIA
- CFA COURSE SYLLABUS
- CFA COURSE TRAINING
- CFA FOUNDATION COURSE
- CMA COURSE
- CMA COURSE DETAILS
- CMA COURSE DETAILS IN INDIA
- CMA COURSE DURATION.
- CMA COURSE ELIGIBILTY
- CMA COURSE IN INDIA
- CMA COURSE SYLLABUS
- CPA ACCOUNTANT
- CPA COURSE
- CPA COURSE DETAILS
- CPA COURSE DURATION
- CPA COURSE IN INDIA
- FINANCIAL MODELING
- FINANCIAL MODELING AND VALUATION
- FINANCIAL MODELING COURSE
- FINANCIAL MODELING COURSE IN INDIA
- FINANCIAL RISK MANAGER
- FRM COURSE
- FRM COURSE CERTIFICATION
- FRM COURSE CURRICULUM
- FRM COURSE DETAILS
- FRM COURSE DURATION
- FRM COURSE ELIGIBILITY
- FRM COURSE FEES
- FRM COURSE IN INDIA
- PGP BAT COURSE FEES
- PGP BAT COURSE SALARY IN INDIA
- PGP-BAT COURSE
- PGP-BAT COURSE DETAILS
- PGP-BAT COURSE DURATION
- PGP-BAT COURSE ELIGIBILITY
- PGP-BAT COURSE IN INDIA
- PGP-BAT COURSE INSTITUTE IN INDIA
- PLACEMENTS TO CFA
- US CMA COURSE
- US CMA PREPARATION
- US CPA COURSE
- WHAT IS ACCA COURSE
- WHAT IS CMA COURSE
- WHAT IS FINANCIAL MODELING COURSE
Leave a Reply