Excel Function : PMT
Category
Financial
Description
Returns the periodic payment for an annuity
Microsoft Excel Reference Page
https://support.office.com/en-us/article/PMT-function-0214da64-9a63-4996-bc20-214433fa6441
Syntax and Description of the PMT Excel Function
The syntax for the PMT function in Excel is as follows: =PMT(rate, nper, pv, [fv], [type]) where "rate" is the interest rate per period, "nper" is the total number of payment periods, "pv" is the present value of the loan, "fv" is the future value of the loan, and "type" is the number of the payment period at which to begin payment (1=begin immediately, 0=begin at the end of the period).
About PMT Excel Function
The PMT function calculates the periodic payment for a loan based on constant payments and a constant interest rate. =PMT(rate, nper, pv, [fv], [type]) rate - The interest rate for the loan. nper - The total number of payments for the loan. pv - The present value of the loan. [fv] - The future value of the loan. [type] - The type of loan.