PMT(PV, R, N)

Description
Returns the periodic payment for a loan, given present value PV and interest rate R.

Parameters
PV
present value of an investment

R
interest rate

N
number of periods

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