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


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:

\begin{displaymath}
P \frac{1 - (1+R)^{-N}}{R}
\end{displaymath}

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

Excel function: N/A


next up previous contents index
Next: QUARTILE Up: A. Function Reference Previous: PTTEST   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003