next up previous contents index
Next: QUARTILE Up: A Function Reference Previous: PTTEST

PV

 

Syntax: @PV(P, R, N)

P = periodic payment
R = interest range
N = number of periods

@PV returns the present value of an annuity given periodic payment P, interest rate R and N number of periods. The function is given by:

displaymath16308

Examples:

@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


next up previous contents index
Next: QUARTILE Up: A Function Reference Previous: PTTEST

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999