Excel functions / Financial
CUMPRINC function
Total paid off the loan itself (not interest) between two payment numbers.
Syntax
=CUMPRINC(rate, nper, pv, start_period, end_period, type)
Arguments
rate: Interest rate per period, e.g. 5%/12 for monthly payments at 5% a year.nper: Total number of payments.pv: The loan amount (present value).start_period: First payment to include.end_period: Last payment to include.type: 0 = payments at the end of each period, 1 = at the start.
When to use it
CUMPRINC adds up the principal repaid between two payments of a loan: how much the balance falls in a given year. With CUMIPMT it splits a year of payments into interest and repayment.
Examples
Principal repaid in the second year of the same mortgage
A B C D E 1 Rate Years Loan 2 9% 30 125000 -934.11 In E2:
=CUMPRINC(A2/12, B2*12, C2, 13, 24, 0)→ -934.11The whole of that year's payments
A B C D E 1 Rate Years Loan 2 9% 30 125000 -12069.34 In E2:
=CUMPRINC(A2/12, B2*12, C2, 13, 24, 0)+CUMIPMT(A2/12, B2*12, C2, 13, 24, 0)→ -12069.34
Common mistakes
- Start after end. The first period must not be after the last, or the result is #NUM!.
CUMPRINC in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: CUMPRINC
- Danish: AKKUM.HOVEDSTOL
- Dutch: CUM.HOOFDSOM
- Finnish: MAKSETTU.LYHENNYS
- French: CUMUL.PRINCPER
- German: KUMKAPITAL
- Hungarian: ÖSSZES.TŐKERÉSZ
- Italian: CAP.CUM
- Norwegian: SAMLET.HOVEDSTOL
- Polish: SPŁAC.KAPIT
- Portuguese (Brazil): PGTOCAPACUM
- Portuguese (Portugal): PGTOCAPACUM
- Russian: ОБЩДОХОД
- Spanish: PAGO.PRINC.ENTRE
- Swedish: KUMPRIS
- Turkish: TOPANAPARA
Try CUMPRINC in the playground