PV( ) Function

  • Article

Returns the present value of an investment.

PV(nPayment, nInterestRate, nTotalPayments)

Return Values

Numeric

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.

Remarks

PV( ) computes the present value of an investment based on a series of equal periodic payments at a constant periodic interest rate.

Example

STORE 500 to gnPayment  && Periodic payments made monthly
STORE .075/12 TO gnInterest     && 7.5% annual interest rate
STORE 48 TO gnPeriods  && Four years (48 months)
CLEAR
? PV(gnPayment, gnInterest, gnPeriods)  && Displays 20679.19

See Also

CALCULATE | FV( ) | PAYMENT( )