Syntax
CUMIPMT(rate, nper, pv, start, end, type)
| Parameter | Description |
|---|---|
| rate | Parameter of the CUMIPMT function. |
| nper | Parameter of the CUMIPMT function. |
| pv | Parameter of the CUMIPMT function. |
| start | Parameter of the CUMIPMT function. |
| end | Parameter of the CUMIPMT function. |
| type | Parameter of the CUMIPMT function. |
Examples
Total interest in year 1 of mortgage
Formula
=CUMIPMT(0.065/12, 360, 350000, 1, 12, 0)
-$22,584.73. You pay about $22,585 in interest during the first year of a $350K mortgage at 6.5%. The result is negative to indicate cash outflow.
Interest over the entire loan life
Formula
=CUMIPMT(0.065/12, 360, 350000, 1, 360, 0)
-$446,785.68. Over 30 years, you pay nearly $447K in interest on a $350K loan — more than the original principal.
Interest in years 5-10
Formula
=CUMIPMT(0.065/12, 360, 350000, 49, 120, 0)
-$125,747.21. The cumulative interest paid between months 49 and 120 (years 5 through 10).
Common Errors
#NUM!
The start_period is less than 1, end_period is less than start_period, or rate/nper/pv is invalid (e.g., zero nper).
#VALUE!
Any argument is non-numeric.
Tips
Always returns negative
CUMIPMT returns a negative number because interest paid is a cash outflow. Wrap it in ABS() if you want a positive figure for reporting.
Type argument is required
Unlike PMT where type is optional, CUMIPMT requires it. Use 0 for end-of-period payments (most loans) or 1 for beginning-of-period.
Quick annual tax summaries
Use start=N*12-11 and end=N*12 to get interest paid in year N. Loop this pattern to create a year-by-year interest summary.
Try CUMIPMT in Viztab
Import your data and use CUMIPMT with 370+ other formulas. No signup required.
Open Viztab