Visual Timelines in Excel to Illustrate TVM Calculations
15 Pages Posted: 18 Feb 2021
Date Written: January 8, 2021
Abstract
Time value of money calculations are illustrated through developing a timeline with cash flow graphics in Excel. The cash flow graphics can be used in the live or virtual classroom and as a resource for students outside of the classroom. Further, the graphic is readily adjustable to different scenarios making it useful for multiple time value of money topics.
Keywords: Timeline, Time Value of Money, Pedagogy
JEL Classification: G00, G11, G12
Suggested Citation: Suggested Citation
Alexander, Maura and Arnold, Thomas M. and Farizo, Joseph, Visual Timelines in Excel to Illustrate TVM Calculations (January 8, 2021). Available at SSRN: https://ssrn.com/abstract=3762715 or http://dx.doi.org/10.2139/ssrn.3762715
Do you have negative results from your research you’d like to share?
Feedback
Feedback to SSRN
If you need immediate assistance, call 877-SSRNHelp (877 777 6435) in the United States, or +1 212 448 2500 outside of the United States, 8:30AM to 6:00PM U.S. Eastern, Monday - Friday.