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.
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
Comment or report problem with topic