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.
Please note that downloads of this working paper are for private/personal use only. Do not cite without permission.
Alexander, Maura, Tom Arnold, and Joseph Farizo. “Visual Timelines in Excel to Illustrate TVM Calculations.” University of Richmond, (January, 2021): 1-15.
Click below to download supplemental content.TIMELINE-10-PERIOD-PAPER.xlsx (16 kB)
Single and Multiple Cash Flow Graphics in Excel