Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .