CUMPRINC function
CUMPRINC adds up the principal part of a loan's payments over a range of periods and returns it as a negative number. It shows how much debt you cut down in that stretch.
Example
Read it as a sentence: for a $125,000 loan at 9% a year with 30 years of monthly payments, add up the principal paid in payments 13 through 24, with payments made at the end of each period.
A
B
C
D
1
-934.107123420898
2
3
Syntax
CUMPRINC(rate, nper, pv, start_period, end_period, type)
-
rate(required) - Interest rate per period.
-
nper(required) - Total number of payment periods.
-
pv(required) - Loan amount today.
-
start_period(required) - First period to include (1 is the first payment).
-
end_period(required) - Last period to include.
-
type(required) - 0 = payments at period end, 1 = at period start.
Returns: Total principal repaid across the chosen payments, as a negative number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=CUMPRINC(0.09/12,360,125000,1,12,0) | -853.996373 | First year |
=CUMPRINC(0.01,10,1000,1,10,0) | -1000 | All periods sum to -pv |
=CUMPRINC(0.01,10,1000,5,1,0) | #NUM! | Start > end |
=CUMPRINC(0.01,10,1000,0,2,0) | #NUM! | Start 0 |
=CUMPRINC(0.01,10,1000,1,2,2) | #NUM! | Type 2 |
=CUMPRINC(0,10,1000,1,2,0) | #NUM! | Rate 0 |
=CUMPRINC(0.01,10,-1000,1,2,0) | #NUM! | Negative pv |
=CUMPRINC("a",10,1000,1,2,0) | #VALUE! | Text |
Watch out for
- Rate and nper must use the same time unit.
- All six arguments are required, including type.
Where it works
- Excel
- CUMPRINC is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .