Visual Timelines in Excel to Illustrate TVM Calculations

Authors

Maura AlexanderFollow
Tom Arnold, University of RichmondFollow
Joseph FarizoFollow

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.

Document Type

Working Paper

Publication Date

1-8-2021

Publisher Statement

Please note that downloads of this working paper are for private/personal use only. Do not cite without permission.

Recommended Citation

Alexander, Maura, Tom Arnold, and Joseph Farizo. “Visual Timelines in Excel to Illustrate TVM Calculations.” University of Richmond, (January, 2021): 1-15.