i-nth logo
Factoring in the time value of money with Excel
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

Consulting

We can help you make better spreadsheets:

  • Reviewing your spreadsheets for errors.
  • Advice about improving your spreadsheets.
  • Training in spreadsheet good practice.

Contact us