Quantitative finance collector
Sep 8

Bootstrapping interest rate curve

Posted by abiao at 15:49 | Code » VBA/Excel | Comments(2) | Reads(32451)

Print
Bootstrapping is a technique for building a zero-coupon yield curve from the prices of a set of coupon bonds through forward replacement.

Using these zero-coupon bonds we can deduce forward and spot rates for all time to maturities by making a couple of assumptions (including linear interpolation). The term structure of spot rates is recovered from the bond yields by solving for them recursively, this iterative process is called the BootStrap Method.

http://janroman.dhis.org/stud/Bootstrap_2006.xls shows how to implement Boostrapping method in Excel, more can be found at his website http://janroman.dhis.org/index_eng2.html.

Unclear about this post? Asking questions and receiving answers.
Link appears broken
the site is back alive.
Pages: 1/1 First page 1 Final page
Add a comment
Emots
Enable HTML
Enable UBB
Enable Emots
Hidden
Remember
Nickname   Password   Optional
Site URI   Email   [Register]