CUMIPMT Function
Adds up the interest paid between two loan periods.
Category
Financial
Available in
All versions, Microsoft 365
Returns
Total interest over a range of periods
Overview
CUMIPMT totals the interest paid from one period to another — the interest for year 2 of a loan, say, or over the loan's whole life. It saves summing a column of IPMT results.
Unlike most loan functions, every argument is required, pv must be positive, and type must be 0 or 1.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| rate | Yes | The interest rate per period (annual rate ÷ 12 for monthly payments). |
| nper | Yes | The total number of payment periods. |
| pv | Yes | The loan amount, as a positive number. |
| start_period | Yes | The first period to include (1 = first payment). |
| end_period | Yes | The last period to include. |
| type | Yes | 0 = payments at period end, 1 = at period start. Required here. |
Examples
Example 1 — Interest per year on the van loan
How much interest does Northstar pay in year 1, in year 2, and in total?
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Span | From | To | Interest |
| 2 | Year 1 | 1 | 12 | -$2,693.21 |
| 3 | Year 2 | 13 | 24 | -$2,165.97 |
| 4 | Whole loan | 1 | 60 | -$7,828.60 |
Handy for budgeting: the interest expense falls each year as the balance shrinks.
Common mistakes
- #NUM! error. pv must be positive, type must be 0 or 1, and start_period can't be after end_period or below 1.
- Rate and periods in different units. Keep them matched: for monthly payments divide the annual rate by 12 and multiply the years by 12. Mixing an annual rate with monthly periods gives wildly wrong answers.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.