PPMT

PPMT calculates the amount of a periodic payment that reduces the loan principal for a given period, complementing IPMT to account for the full payment. Together they let you build complete amortisation tables and see exactly how quickly a loan is being paid down.

Excel

=PPMT(0.06/12,1,120,-10000)

Google Sheets

=PPMT(0.06/12,1,120,-10000)

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Period	Rate	Nper	PV	PrincipalPmt
1	0.005	120	10000
2	0.005	120	10000
3	0.005	120	10000
12	0.005	120	10000

=PPMT(0.06/12,1,120,-10000)→61.0205019417

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2	Cell row 1 column 3	Cell row 1 column 4
Cell row 2 column 1	Cell row 2 column 2	Cell row 2 column 3	Cell row 2 column 4
Cell row 3 column 1	Cell row 3 column 2	Cell row 3 column 3	Cell row 3 column 4
Cell row 4 column 1	Cell row 4 column 2	Cell row 4 column 3	Cell row 4 column 4
Cell row 5 column 1	Cell row 5 column 2	Cell row 5 column 3	Cell row 5 column 4

Formula

Runs server-side · free · no signup

How it works

1Set up your loan parameters: annual rate, total periods (nper), and present value (loan amount).
2In a cell type =PPMT(rate/12, period, nper, -pv) to get the principal for that payment period.
3Add =IPMT(...)+PPMT(...) to verify the total equals the fixed payment from PMT.

Need a version for your data?

Try: “How much of payment 24 on my car loan goes toward reducing the principal?”

IPMT FV PV

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

PPMT

Verified example

Try it with your data

How it works

Related