O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

FV()

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

Arguments

  • 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required