Using Excel Spreadsheets to Teach the Time Value of Money

Abstract

Possibly the most important precursor of academic success for students of finance is an understanding of the mathematics of
interest and the time-value of money. Although a considerable portion of their first finance course is usually devoted to this
topic, students often proceed to their advanced courses with inadequate knowledge of this vital subject. In this article, we
present and make available Excel spreadsheet templates that provide students with a nearly unlimited collection of problems
and solutions to help them efficiently perfect their time-value skills.