PV( ) Function
Returns the present value of an investment.
PV(nPayment, nInterestRate, nTotalPayments) 
Parameters
 nPayment

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

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

Specifies the total number of payments.
Return Value
Remarks
Example
See Also
© , 19962020 • Updated: 11/10/20
Comment or report problem with topic