Syntax
CUMPRINC(rate, nper, pv, start, end, type)
| Parameter | Description |
|---|---|
| rate | Parameter of the CUMPRINC function. |
| nper | Parameter of the CUMPRINC function. |
| pv | Parameter of the CUMPRINC function. |
| start | Parameter of the CUMPRINC function. |
| end | Parameter of the CUMPRINC function. |
| type | Parameter of the CUMPRINC function. |
Examples
Principal paid in year 1
Formula
=CUMPRINC(0.065/12, 360, 350000, 1, 12, 0)
-$3,974.71. In the first year of a $350K mortgage at 6.5%, only about $3,975 goes toward reducing the balance.
Principal paid in year 10
Formula
=CUMPRINC(0.065/12, 360, 350000, 109, 120, 0)
-$6,729.94. By year 10, you're paying down about $6,730 in principal per year — significantly more than year 1.
Total principal over entire loan
Formula
=CUMPRINC(0.065/12, 360, 350000, 1, 360, 0)
-$350,000.00. Over the full term, cumulative principal paid equals the original loan amount, as expected.
Common Errors
#NUM!
Start period is less than 1, end period is before start period, or other numeric arguments are invalid.
#VALUE!
One or more arguments is not a number.
Tips
Track equity buildup
CUMPRINC tells you how much equity you've built. For a home worth $400K with a $350K mortgage, your equity after year 1 is $50K + ABS(CUMPRINC(...)).
Compare to CUMIPMT
Run both CUMPRINC and CUMIPMT for the same period range to see the principal-to-interest split. Early in a loan, CUMIPMT dwarfs CUMPRINC.
Result is always negative
Like CUMIPMT, the result is negative (outflow). Use ABS() or negate with a minus sign for display purposes.
Try CUMPRINC in Viztab
Import your data and use CUMPRINC with 370+ other formulas. No signup required.
Open Viztab