Excel CUMPRINC Function

Using the Excel CUMPRINC Function


The CUMPRINC function returns the cumulative principal paid on a loan or investment between two user provided dates.

To find the principal paid per period for a loan or investment, see the PPMT function.


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

Syntax Breakdown

Required. Interest rate per period.

Required. Total number of payment periods.

Required. Present value that a series of future payments is worth today. PV should be entered as a positive number.

Start Period
Required. The first period in the calculation beginning with 1.

End Period
Required. Last period in the calculation.

Required. Argument indicating timing of the payments. Use 1 for beginning of the period and zero (0) for end of the period.

Usage Notes

CUMPRINC is one of Excel's financial functions and is used to find the cumulative principal paid between two dates. For example, the function can be used to calculate the total principal paid on a loan, or the principal between two specific periods.

Consistent Units
It is necessary to ensure rate and nper units are consistent. For example, if you make monthly payments for a 7 year loan at 6% annual interest, use 7*12 for nper and 6%/12 for rate. If you were making annual payments it would be acceptable to use 7 for nper and 6% for rate.

The CUMPRINC function will return the #NUM! error under the following circumstances:
  • Start period < 1; OR
  • End period < 1; OR
  • Start period > end period; OR
  • The type argument is any value besides 1 or zero (0); or
  • Rate, nper, or PV is <= 0