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.
PV(В ) computes the present value of an investment based on a series of equal periodic payments at a constant periodic interest rate.
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