ExcelFlux

PMT function

the periodic payment for an annuity.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Calculate a level periodic payment. Loan proceeds and repayments use opposite cash-flow signs.

A worked example from the workbook

RowABC
6Periodic ratePeriodsAmount
7012100
806150
9012100
Record 1
=PMT(A7,B7,C7)

Expected result-8.333333333

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=PMT(0,12,1200)
Turkish Excel · tr-TR
=DEVRESEL_ÖDEME(0;12;1200)

Expected result

−100

Worked examples

Calculate a level periodic payment. Loan proceeds and repayments use opposite cash-flow signs.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Periodic rate Periods Amount
7 0 12 100
8 0 6 150
9 0 12 100
Case Formula Expected result
Record 1 =PMT(A7,B7,C7) -8.333333333
Record 2 =PMT(A8,B8,C8) -25
Record 3 =PMT(A9,B9,C9) -8.333333333
Microsoft Excel reference