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
| Row | A | B | C |
|---|---|---|---|
| 6 | Value | Second input | Amount |
| 7 | 0 | 12 | 1200 |
| 8 | 0 | 6 | 150 |
| 9 | 0 | 3 | 75 |
Record 1
=PPMT(A7,1,B7,C7)Expected result-100
See the inputs and instructions for all 3 examplesCopyable 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 |