23 March 2018
This article provides example scenarios and explains various approaches for calculating the time value of money using Microsoft Excel.
The functions discussed include FV
, FVSCHEDULE
, PV
, NPV
, PMT
, RATE
, and NPER
.
For more information, also see Pitfalls of Excel's NPV function.
Full article: Factoring in the time value of money with Excel