<!-- https://learnsql.cpetoday.com/functions/dax/pmt -->
# PMT

Language: DAX
Category: Financial
Syntax: PMT(<rate>, <nper>, <pv> [, <fv>] [, <type>])
Summary: Returns the payment for each period of a loan or annuity that has a fixed rate.
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.
Level: Intermediate
Related: IPMT, PPMT, PV, FV, RATE, NPER

## 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
- rate: the interest rate per period. For monthly payments, divide the annual rate by 12. Required.
- nper: the total number of periods. For 30 years of monthly payments, use 30 times 12, which is 360. Required.
- pv: the present value, which is the loan amount you receive. Use a positive number for a loan you receive. Required.
- fv: the future value you want after the last payment. Optional, and 0 is the default, which means the loan is fully paid off.
- type: 0 when payments fall at the end of each period (the default), or 1 when they fall at the start.

## 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.

```dax
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.

```dax
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
- The rate and the number of periods must match. An annual rate with monthly payments is a common error that gives a payment far too high.
- Keep the signs consistent. If the loan is received as a positive amount, the payment is negative. Mixing the signs gives a result that looks right but is reversed.
- With type 1, the first payment is made at the start of the period, which lowers the interest charged. Use it only when the contract says so.
- PMT does not include fees, insurance or taxes in the payment. Add them separately.

## 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.
