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 integer>0