A Simple Model of Interest Rate Term Structure for the Classroom
14 Pages Posted: 22 Apr 2006
Date Written: June 16, 2006
Without much technical expertise, a yield curve model is presented that is very dynamic and can be easily programmed in Excel for classroom presentation or for assignments. By using the output of the model to have students find embedded rates within the yield curve, a discussion of how bond traders speculate on interest rates emerges very easily. Further, the model output can also be used for numerous exercises including the pricing of strips or for evaluating the positions of an entire bond portfolio. Within the exercises, the dynamic nature of the model can be exploited to provide sensitivity analysis.
Keywords: Interest Rate, Term Structure, Excel, Pedagogy
JEL Classification: G10
Suggested Citation: Suggested Citation