Visual Timelines in Excel to Illustrate TVM Calculations

15 Pages Posted: 18 Feb 2021

See all articles by Maura Alexander

Maura Alexander

affiliation not provided to SSRN

Tom Arnold

University of Richmond - E. Claiborne Robins School of Business

Joseph Farizo

University of Richmond - E. Claiborne Robins School of Business

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

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

Maura Alexander

affiliation not provided to SSRN

Thomas M. Arnold (Contact Author)

University of Richmond - E. Claiborne Robins School of Business ( email )

102 UR Drive
University of Richmond, VA 23173
United States
804-287-6399 (Phone)
804-289-8878 (Fax)

Joseph Farizo

University of Richmond - E. Claiborne Robins School of Business ( email )

Richmond, VA 23173
United States

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
34
Abstract Views
103
PlumX Metrics