Term Structure Estimation
45 Pages Posted: 21 Feb 2008 Last revised: 6 Nov 2020
Date Written: February 19, 2009
The term structure of interest rates gives the relationship between the yield on an investment and the term to maturity of the investment. Since the term structure is typically measured using default-free, continuously-compounded, annualized zero-coupon yields, it is not directly observable from the published coupon bond prices and yields. This paper focuses on how to estimate the default-free term structure of interest rates from bond data using three methods: the bootstrapping method, the McCulloch cubic-spline method, and the Nelson and Siegel method. Nelson and Siegel method is shown to be more robust than the other two methods. The results of this paper can be implemented using user-friendly Excel spreadsheets.
Keywords: interest rates, term structure, bonds, fixed income, Excel
JEL Classification: G0, G11, G12, G13, G20, G21, G22, G23, G24
Suggested Citation: Suggested Citation