Please note javascript is required for full website functionality.

# A to Z of Excel Functions: the CUMPRINC Function

30 March 2018

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the CUMPRINC function.

The CUMPRINC function

This function returns the cumulative principal repaid on a loan between a designated start_period and end_period given a constant periodic discount rate.

The CUMPRINC function employs the following syntax to operate:

CUMPRINC(rate, nper, pv, start_period, end_period, type)

The CUMPRINC function has the following arguments:

• rate: this is required and represents the interest rate
• nper: this is also required and represents the total number of payment periods
• pv: this is required and represents the present value of the amount under finance
• start_period: this is required and represents the first period in the calculation.  Payment periods are numbered beginning with 1
• end_period: this is required and represents the last period in the calculation
• type: this is required and represents the timing of the payment.

It should be further noted that:

• make sure that you are consistent about the units you use for specifying rate and nper.  If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for nper.  If you make annual payments on the same loan, use 12% for rate and 4 for nper
• if rate ≤ 0, nper ≤ 0, or pv ≤ 0, CUMPRINC returns the #NUM! error value
• if start_period < 1, end_period < 1, or start_period > end_period, CUMPRINC returns the #NUM! error value
• if type is any number other than 0 or 1, CUMPRINC returns the #NUM! error value.