Excel like a finance pro.
← The libraryPractice · 3 questions →
Financial function
CUMIPMT
Returns the cumulative interest paid between two periods.
OccasionalDifficulty 1500 · AdvancedUsage rank #225 of 520
When to use it
Total interest paid between two periods of a loan. Year-by-year interest for a mortgage in one call.
The shape of it
- Syntax
=CUMIPMT(rate, nper, pv, start_period, end_period, type)
Worked examples
First year
=CUMIPMT(0.06/12,360,250000,1,12,0) → -14,916.46
Interest in the first year of the mortgage.
Whole loan
=CUMIPMT(0.06/12,360,250000,1,360,0) → -289,595.47
Total interest over the life of the loan.
Second year
=CUMIPMT(0.09/12,360,125000,13,24,0) → -11,135.23
Second-year interest on a 125,000 loan at 9%.
Worth knowing
- Type is required: 0 for end of period.
- Periods are 1-based and inclusive.
- Compare loans by total interest, not just payment.
Where it goes wrong
- #NUM! when start is below 1, end exceeds nper, or start exceeds end.
- The type argument cannot be omitted, unlike PMT.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.