PV( ) Function

Returns the present value of an investment.

PV(nPayment, nInterestRate, nTotalPayments)



Specifies the periodic payment amount. nPayment can evaluate to a positive or negative number. PV( ) assumes that the payments are made at the end of each period.


Specifies the periodic interest rate. If the interest rate of an investment is annual and the payments are made monthly, divide the annual interest rate by 12.


Specifies the total number of payments.

Expand imageReturn Value

Expand imageRemarks

Expand imageExample

Expand imageSee Also

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic