Excel Templates for Illustrating TVM Calculations and a Financial Calculator with Associated Excel Functions

Authors

Abstract

Time value of money calculations are illustrated through developing a timeline with cash flow graphics in Excel. The graphic is readily adjustable to different scenarios making it useful for multiple time value of money topics (e.g., NPV, MIRR, etc.). Further, a second graphic illustrates a financial calculator that also provides the associated Excel functions. Both graphics can be used in the live or virtual classroom and as a resource for students outside of the classroom.

Recommended Citation

(2026) "Excel Templates for Illustrating TVM Calculations and a Financial Calculator with Associated Excel Functions," Journal of Economics and Finance Education: Vol. 21: Iss. 2, Article 7.
Available at: https://scholarship.rollins.edu/jefe/vol21/iss2/7