Using the Excel CUMPRINC Function
SummaryThe 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.
Syntax=CUMPRINC (rate, nper, pv, start_period, end_period, type)
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.
Required. The first period in the calculation beginning with 1.
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 NotesCUMPRINC 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.
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