Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

PMT

Description: Calculates the loan payment for a loan based on constant payments and constant interest rates.

Syntax: PMT(Rate, Nper, PV, [Fv], [Type])

Set Type equal to If payments are due
0 or omitted At the end of the period
1 At the beginning of the period

Remarks:

Examples:

PMT(.08/12, 10, 10000, 0, 0) = -1,037.03

PMT(.08/12, 10, 10000, 0, 1) = -1,030.16

PMT(.06/12, 18*12, 0, 50000, 0) = -129.08

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.