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

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:

displaymath16285

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


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

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