Downloads
DAXFinancialIntermediate

PMT

Returns the payment for each period of a loan or annuity that has a fixed rate.

Syntax
PMT(<rate>, <nper>, <pv> [, <fv>] [, <type>])

Returns: A number for the payment per period. It is negative when the loan amount is positive, because the payment is cash you pay out.

What it does

PMT calculates the regular payment that pays off a loan, or builds a balance from a series of equal deposits. Finance teams use it to check a lender's payment amount, to build a debt schedule, to plan debt service in the cash forecast and to work out the deposit needed to reach a savings target. The sign follows the Excel convention: money you receive is positive and money you pay is negative.

Syntax and arguments

Example

A buyer borrows 300,000 at 6% a year over 30 years, with monthly payments. The rate per month is 6% divided by 12, and the number of months is 360.

Monthly Payment = PMT(0.06 / 12, 30 * 12, 300000)

The result is -1,798.65. The minus sign is the Excel convention: the borrower pays this amount each month. To show the payment as a positive number on a report, put a minus sign in front of the function. The payment is the same every month, but the split between interest and principal changes over time (see IPMT and PPMT).

Example: a second, different use

A treasurer wants to save 50,000 in five years for an equipment purchase, with monthly deposits at 4% a year. The future value is 50,000, and the present value is 0 because nothing is deposited at the start.

Monthly Deposit = PMT(0.04 / 12, 5 * 12, 0, 50000)

The result is -754.16. The minus sign means the deposit is cash that leaves the business each month.

Things to watch

In business terms

PMT drives debt schedules, lease payment checks, the debt service line in the cash forecast, loan covenant tests and the savings plans for a capital project. Use it to confirm the payment on a loan statement before the cash is released.

Related functions

All DAX functions · View as Markdown · DAX fundamentals