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