CUMPRINC Function
Calculates the cumulative principal 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 principal paid in the first year of a mortgage
=CUMPRINC(0.05/12, 360, 300000, 1, 12, 0)For a $300,000 mortgage at 5% over 30 years, about $4,425 of principal is paid in the first year.
Advanced Examples
Example 1: Principal paid in later years
Equity trackingPrincipal paid in years 6-10
=CUMPRINC(0.05/12, 360, 300000, 61, 120, 0)How CUMPRINC Works
CUMPRINC sums the principal portions of all payments from start_period to end_period. It is the counterpart of CUMIPMT.
Important Notes & Limitations
Requires consistent period units.
The type argument is required.
Returns a negative value because principal payments are outflows.
Common Errors & Fixes
#NUM! errorPeriod values are invalid or type is not 0 or 1.Fix: Check that 1 <= start_period <= end_period <= nper and type is 0 or 1.
Annual rate not dividedRate was not adjusted for period.Fix: Use monthly rate for monthly periods.
Download Practice File
CUMPRINC
cumprincPractice CUMPRINC with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the CUMPRINC function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps