Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
IPMT
IPMT calculates how much of a given periodic payment goes toward interest, given a constant interest rate, total number of periods, and present value. Use it to build amortisation tables, understand interest costs over time, or verify that a payment schedule is correct.
Excel
=IPMT(0.06/12,1,120,-10000)Google Sheets
=IPMT(0.06/12,1,120,-10000)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Period | Rate | Nper | PV | InterestPmt |
| 1 | 0.005 | 120 | 10000 | |
| 2 | 0.005 | 120 | 10000 | |
| 3 | 0.005 | 120 | 10000 | |
| 12 | 0.005 | 120 | 10000 |
=IPMT(0.06/12,1,120,-10000)→50
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
Runs server-side · free · no signup
How it works
- 1Identify your annual rate (e.g. 6%), number of periods (e.g. 120 monthly payments), and loan amount (present value).
- 2In a cell type =IPMT(rate/12, period, nper, -pv) where rate is annual, period is the specific payment number.
- 3Drag down for each period (1 through nper) to build a full amortisation schedule.
Need a version for your data?
Try: “Show me how much of each monthly mortgage payment goes to interest”