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