next up previous contents index
Next: POLY Up: A. Function Reference Previous: PLS   Contents   Index


PMT

Syntax: PMT(PV, R, N)

PV = present value of an investment
R = interest rate
N = number of periods

PMT returns the periodic payment for a loan, given present value PV and interest rate R. The formula is given by:

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

Examples:

PMT(15000, rate, 4) = 4834.90, where rate is a named cell = 11%

PMT(M4, 0.07, G4) = 8058.6404, where G4 = 30 and M4 = 100000

PMT(1700, 11, 0) = Error - ``Period'' must be an integer$>$0

Excel function: N/A


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