Skip to main content



PV Function

Returns the end-of-period present value for a series of future payments given, the interest rate, the number of periods, the payment amount, and the future value remaining after all payments are made

Syntax​

PV(rate, period, payment, futureValue)

Returns the end-of-period present value for a series of future payments given, the interest rate, the number of periods, the payment amount, and the future value remaining after all payments are made

Arguments​

rate Numeric - the interest rate

period Numeric - the number of periods

payment Numeric - the payment made each period

futureValue Numeric - the future value remaining after all payments

Remarks​

Example:

PV(0.05, 36, -100, 0); // returns 1654.685