PV( ) Function

JavaScript Editor js editor     Web development 



Main Page

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

See Also



JavaScript Editor js editor     Web development