Description

The CUMPRINC function returns the cumulative principal paid on a loan between start_period and end_period.

Syntax

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

Argument	Description	Required/ Optional
Rate	The interest rate.	Required
Nper	The total number of payment periods.	Required
Pv	The present value.	Required
Start_period	The first period in the calculation. Payment periods are numbered beginning with 1.	Required
End_period	The last period in the calculation.	Required
Type	The timing of the payment. Look at the Type-Timing Table given below.	Required

Type	Timing
0 (zero)	Payment at the end of the period
1	Payment at the beginning of the period

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.
If any of the specified arguments is not recognized as numeric value, CUMPRINC returns the #VALUE! error value.

Excel 2007, Excel 2010, Excel 2013, Excel 2016