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:

**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 integer0

**Excel function:** *N/A*

Grey Trout Software

02 March 2003