A Simple Model of Interest Rate Term Structure

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