Two Thumbs Up: An Excel-Based 'Movie' To Teach Term Structure Dynamics

Scott Smart

Indiana University Dept. of Finance

Craig W. Holden

Indiana University - Department of Finance

SUBJECT AREAS: Term structure of interest rates; Dynamics; Treasury bills; Treasure securities; Business cycle.

CASE SETTING: 1970 to present, U.S. risk-free, zero-coupon yield curves.

For twenty years, the modern theory of the term structure of interest rates has been based on dynamic models of how interest rates and other relevant factors evolve randomly over time. Yet most undergraduate and M.B.A. textbooks that cover the term structure say nothing about its dynamic features. The only exception to this rule is a handful of specialized textbooks intended for advanced courses in fixed-income securities or derivative securities. The insurmountable obstacle to covering term structure dynamics has always been the rigorous demands of continuous time mathematics. We offer a new approach. We explain simple techniques by which Microsoft Excel can be used to construct a #movie# of the term structure. This movie dramatically illustrates the important dynamic features of the term structure, including:
1. short rates are more volatile than long rates,
2. occasional sharp reactions to government intervention,
3. volatility is correlated with the level (i.e., volatility is lower when the level is lower), and
4. reversal in the slope of the yield curve is a noisy predictor of the business cycle.

We also make available the finished product to download at a Web address: www.bus.indiana.edu/finweb/holden.htm The raw material for this movie is a historical term structure database of monthly U.S. yield curves over the past 26 years. With a standard computer / projection setup, the instructor can show this movie in class. After seeing the visual history of the yield curve, students will immediately recognize the #stylized facts# about the term structure.

JEL Classification: E43, G12, G13

Case and Teaching Paper Series

Not Available For Download

Date posted: September 18, 1996  

Suggested Citation

Smart, Scott and Holden, Craig W., Two Thumbs Up: An Excel-Based 'Movie' To Teach Term Structure Dynamics. Available at SSRN: http://ssrn.com/abstract=9146

Contact Information

Scott B. Smart
Indiana University Dept. of Finance ( email )
1309 E. 10th St.
Kelley School of Business
Bloomington, IN 47405
United States
812-855-3401 (Phone)
812-855-5875 (Fax)
Craig W. Holden (Contact Author)
Indiana University - Department of Finance ( email )
Kelley School of Business
1309 E. 10th St.
Bloomington, IN 47405
United States
812-855-3383 (Phone)
812-855-5875 (Fax)
HOME PAGE: www.kelley.iu.edu/cholden
Feedback to SSRN

Paper statistics
Abstract Views: 1,447

© 2014 Social Science Electronic Publishing, Inc. All Rights Reserved.  FAQ   Terms of Use   Privacy Policy   Copyright   Contact Us
This page was processed by apollo2 in 0.343 seconds