Wednesday, 20 June 2012

Calculating Present Value, Future Value and Payment In Excel - Formulas

When writing the CMA Case Exam or the CMA Board Report you can (and should) use formulas to help you compute Present, Future and Payment values. After posting my NPV Template where I utilize these formulas, I have received some email questions about setting up these Time Value of Money formulas (present value, future value and payment) in excel. I put the above together so that you can see how I calculate these values in excel, using formulas. Let me know if you have any questions on the above.

  • rate is the discount rate per period
  • nper is the number of periods
  • PMT is the payment per period
  • PV is the present value
  • type indicates whether it is a regular annuity or an annuity due (whether payment is due at the end of a period or at the beginning)
  • FV is future value

If you have other questions on excel (pivot tables, formulas, formating, etc. post them in the comments and I will do a post on these).



  1. Hi, Casemaster,

    The above template is awesome. my question is: for example, in pv formula box you provided above, there is no pmt amount given, if the question provided pmt amount, we just need to plug the number in there, am I correct?

    Thank you.

    1. if payment info is provided then you need to incorporate it.


Popular Posts