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 CFA COURSE
- ABOUT FRM COURSE IN INDIA
- ABOUT THE US CPA COURSE
- ACCA
- ACCA CERTIFICATION
- ACCA COURSE
- ACCA COURSE DETAILS
- ACCA COURSE DURATION
- ACCA COURSE ELIGIBILITY
- ACCA COURSE ELIGIBILITY CRITERIA
- ACCA COURSE ELIGIBILITY IN INDIA
- ACCA COURSE FEES
- ACCA COURSE FEES IN INDIA
- ACCA COURSE IN INDIA
- ACCA COURSE STRUCTURE
- ACCA COURSE STRUCTURE AND FEES IN INDIA
- ACCA COURSE SUBJECTS
- ACCA COURSE SYLLABUS
- ACCA EXAM STRUCTURE AND PATTERN
- ADMISSION TO CFA
- AI-POWERED FRAUD DETECTION IN ACCOUNTING
- APPLICATIONS OF AI IN ACCOUNTING
- AUDITING AND COMPLIANCE
- AUTOMATED DATA ENTRY
- AUTOMATED DATA ENTRY AND PROCESSING
- BAT COURSE
- BEST FINANCIAL MODELING COURSE
- BEST FINANCIAL MODELING COURSE IN INDIA
- BEST ONLINE CFA PREP COURSE
- BEST ONLINE FINANCIAL MODELING COURSE
- CAREER OPPORTUNITIES FOR CPA
- CERTIFIED FINANCIAL PLANNER (CFP®) COURSE
- CFA
- CFA CERTIFICATION
- CFA COURSE
- CFA COURSE CURRICULUM
- CFA COURSE DETAILS
- CFA COURSE DURATION
- CFA COURSE FEES
- CFA COURSE FEES IN INDIA
- CFA COURSE FULL DETAILS
- CFA COURSE IN INDIA
- CFA COURSE IN INDIA CFA COURSE CFA COURSE DETAILS CFA COURSE SUBJECTS
- CFA COURSE SUBJECTS
- CFA COURSE SYLLABUS
- CFA COURSE TRAINING
- CFA CURRICULUM
- CFA FOUNDATION COURSE
- CFP CERTIFICATION
- CFP COURSE
- CFP COURSE DETAILS
- CFP COURSE FEE
- CFP® COURSE FEES
- CFP® COURSE SYLLABUS
- CFP® ELIGIBILITY
- CMA COURSE
- CMA COURSE DETAILS
- CMA COURSE DETAILS IN INDIA
- CMA COURSE DURATION.
- CMA COURSE ELIGIBILITY
- CMA COURSE ELIGIBILTY
- CMA COURSE FEES
- CMA COURSE FULL DETAILS
- CMA COURSE IN INDIA
- CMA COURSE SUBJECTS
- CMA COURSE SYLLABUS
- CPA ACCOUNTANT
- CPA COURSE
- CPA COURSE DETAILS
- CPA COURSE DURATION
- CPA COURSE ELIGIBILITY
- CPA COURSE FEES
- CPA COURSE FEES IN INDIA
- CPA COURSE IN INDIA
- CPA COURSE STRUCTURE
- CPA COURSE SYLLABUS
- CPA EXAM
- EVOLUTION OF AI IN ACCOUNTING
- EVOLUTION OF AI IN FINANCE
- FINANCIAL MODELING
- FINANCIAL MODELING AND VALUATION
- FINANCIAL MODELING AND VALUATION COURSE
- FINANCIAL MODELING COURSE
- FINANCIAL MODELING COURSE CURRICULUM
- FINANCIAL MODELING COURSE DETAILS
- FINANCIAL MODELING COURSE FEE
- FINANCIAL MODELING COURSE IN INDIA
- FINANCIAL MODELING COURSE USEFUL
- FINANCIAL MODELING COURSE WITH PLACEMENT
- FINANCIAL MODELLING COURSE
- FINANCIAL MODELLING COURSE DURATION
- FINANCIAL MODELLING COURSE FEES
- FINANCIAL MODELLING COURSE ONLINE
- FINANCIAL RISK MANAGER
- FM COURSE & FRM® COURSE
- FRM
- FRM COURSE
- FRM COURSE CERTIFICATION
- FRM COURSE CURRICULUM
- FRM COURSE DETAILS
- FRM COURSE DURATION
- FRM COURSE ELIGIBILITY
- FRM COURSE FEES
- FRM COURSE IN INDIA
- FRM COURSE SYLLABUS
- FRM® COURSE SUBJECTS
- FRM® COURSE SYLLABUS & HOW TO APPLY FOR FRM® COURSE
- IN FINANCE
- PG PROGRAM IN BUSINESS ACCOUNTING & TAXATION
- PGP BAT COURSE FEES
- PGP BAT COURSE SALARY IN INDIA
- PGP-BAT COURSE
- PGP-BAT COURSE COURSE IN INDIA
- PGP-BAT COURSE DETAILS
- PGP-BAT COURSE DURATION
- PGP-BAT COURSE ELIGIBILITY
- PGP-BAT COURSE FULL FORM
- PGP-BAT COURSE IN INDIA
- PGP-BAT COURSE INSTITUTE IN INDIA
- PGP-BAT COURSE SYLLABUS
- PLACEMENTS TO CFA
- SOFT SKILLS
- TAX PREPARATION
- TAX PREPARATION AND PLANNING
- US CMA COURSE
- US CMA COURSE DETAILS
- US CMA PREPARATION
- US CPA COURSE
- US CPA COURSE DETAILS
- US CPA COURSE FEES
- US CPA COURSE FULL FORM
- US CPA COURSE TRAINING
- US CPA EXAMS
- US CPA MEANING
- US-CMA
- US-CPA
- WHAT IS ACCA COURSE
- WHAT IS CFP® CERTIFICATION?
- WHAT IS CMA COURSE
- WHAT IS CPA COURSE
- WHAT IS FINANCIAL MODELING ALL ABOUT
- WHAT IS FINANCIAL MODELING COURSE
- WHAT IS FRM® COURSE? FRM® COURSE DETAILS
- WHAT IS FRM® COURSE? FRM® COURSE REVIEW
- WHAT IS THE CPA COURSE
- WHAT IS US CPA COURSE?
- WHAT IS US-CMA COURSE
Leave a Reply