Syntax. PV(Rate,Nper,Pmt,Pv,Type)

Definition. The function PV() calculates the future (final) value of a regular payment flow, taking into consideration single payments at the beginning of the time period in question, according to the finance mathematical benefit principle:

Payment of the debtor + payment of the creditor = 0


  • Rate (required) The (constant) period interest rate as interest rate in arrears.

  • Nper (required) The number of interest periods. It is assumed that possible regular payments (that is, when the Pmt argument is greater than zero) take place at the end or the start of the interest period.

  • Pmt (required/optional, see Note) The amount of the regular payments; this can be interpreted as annuity.

  • Pv (required/optional, see ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.