 Formula Engine Reference Guide |
|
Back to Class Index
PV(P, R, N)
Returns the present value of an annuity given periodic payment P, interest rate R and N number of periods.
Parameters
P
periodic payment
R
interest range
N
number of periods
Example
PV(360, RATE, 4) = 1116.88
where RATE is a named cell = 11%
PV(V10, C6, 5) = 41001.97
where C6 = 7% and V10 = 10000
PV(4500, 0.05, -1) = Error - "Period" must be an integer 0