Financial Math on Spreadsheet and Calculator
22 Pages Posted: 1 Oct 2002
First graduate-level finance courses in investments or corporate finance often presuppose knowledge of the first essential finance paradigm: time value of money (TVM). Yet, many incoming MBAs do not know the concept and need to get up the learning curve quickly on how to calculate present and future values of single cash flows and annuities. This tutorial attempts to link the mathematical concepts (and their equations) to step-by-step calculating steps a student needs to learn on both spreadsheet and calculator. It has been used with success as a self-contained, pre-course tutorial that takes the typical student 2-3 hours to complete. Additional practice problems with worked out answers are also included.
Suggested Citation: Suggested Citation