CUMIPMT Function
Calculates the cumulative interest paid on a loan between two periods.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| rate | Interest rate per period. | Required |
| nper | Total number of payment periods. | Required |
| pv | Present value or loan principal. | Required |
| start_period | First period in the range to include. | Required |
| end_period | Last period in the range to include. | Required |
| type | 0 = end of period, 1 = beginning of period. | Required |
Basic Example
Total interest paid in the first year of a loan
=CUMIPMT(0.05/12, 360, 300000, 1, 12, 0)For a $300,000 mortgage at 5% over 30 years, the first year of interest is about $14,935.
Advanced Examples
Example 1: Cumulative interest over several years
Amortization analysisInterest paid in years 6-10 of a mortgage
=CUMIPMT(0.05/12, 360, 300000, 61, 120, 0)How CUMIPMT Works
CUMIPMT sums the interest portions of all payments from start_period to end_period. It uses the same amortization logic as PMT and IPMT.
Important Notes & Limitations
Requires consistent period units.
The type argument is required, not optional.
Returns a negative value because interest is an outflow.
Common Errors & Fixes
#NUM! errorstart_period or end_period is invalid, or type is not 0 or 1.Fix: Ensure 1 <= start_period <= end_period <= nper and type is 0 or 1.
Wrong resultAnnual rate was not divided by 12.Fix: Use the monthly rate for monthly periods.
Download Practice File
CUMIPMT
cumipmtPractice CUMIPMT with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the CUMIPMT function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps