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

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

  1. Principal repaid in the second year of the same mortgage

    ABCDE
    1RateYearsLoan
    29%30125000-934.11

    In E2: =CUMPRINC(A2/12, B2*12, C2, 13, 24, 0) → -934.11

    Try this example

  2. The whole of that year's payments

    ABCDE
    1RateYearsLoan
    29%30125000-12069.34

    In E2: =CUMPRINC(A2/12, B2*12, C2, 13, 24, 0)+CUMIPMT(A2/12, B2*12, C2, 13, 24, 0) → -12069.34

    Try this example

Common mistakes

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.

Translate a whole formula

Try CUMPRINC in the playground

Related functions