ExcelFlux

PPMT function

the payment on the principal for an investment for a given period.

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

Find the principal portion of a payment. At zero interest, the whole payment reduces principal.

A worked example from the workbook

RowABC
6ValueSecond inputAmount
70121200
806150
90375
Record 1
=PPMT(A7,1,B7,C7)

Expected result-100

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=PPMT(A7,1,B7,C7)
Turkish Excel · tr-TR
=ANA_PARA_ÖDEMESİ(A7;1;B7;C7)

Worked examples

Find the principal portion of a payment. At zero interest, the whole payment reduces principal.

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 Value Second input Amount
7 0 12 1200
8 0 6 150
9 0 3 75
Case Formula Expected result
Record 1 =PPMT(A7,1,B7,C7) -100
Record 2 =PPMT(A8,1,B8,C8) -25
Record 3 =PPMT(A9,1,B9,C9) -25
Microsoft Excel reference