Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
CUMIPMT
CUMIPMT sums the interest portions of loan payments across a range of periods, avoiding the need to calculate each period individually. It is useful for preparing loan schedules and identifying total interest cost over any slice of a loan's term.
Excel
=CUMIPMT(0.005,60,10000,1,12,0)Google Sheets
=CUMIPMT(0.005,60,10000,1,12,0)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Parameter | Value |
| Rate/mo | 0.005 |
| Nper | 60 |
| PV | 10000 |
| Start | 1 |
| End | 12 |
=CUMIPMT(0.005,60,10000,1,12,0)→-551.9045110848
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
- 1Gather the periodic rate (annual rate ÷ 12 for monthly), total periods, loan present value, start period, end period, and type (0 = end-of-period payments).
- 2Enter =CUMIPMT(rate, nper, pv, start_period, end_period, type) — the result is negative (representing cash out).
- 3Use ABS() to display the amount as positive if needed for reports.
Need a version for your data?
Try: “How much total interest will I pay in the first 12 months of a $10,000 loan at 6% annually over 60 months?”