CUMPRINC FunctionWayne Becker20150913T11:04:22+00:00
The CUMPRINC function calculates the cumulative payment on the principal of a loan or investment, between two specified periods.
Syntax
=CUMPRINC(rate,nper,pv,start_period,end_period,type)
Arguments
Argument 
Description 
rate 
The interest rate – per period 
nper 
The number of periods over which the loan or investment is to be paid 
pv 
The present value of the loan / investment 
start_period 
The first period in the calculation. Payment periods are numbered beginning with 1 
end_period 
The last period in the calculation 
type 
The timing of the payment. The value 0 or 1 has the following meaning:

0 
– 
the payment is made at the end of the period 

1 
– 
the payment is made at the beginning of the period 

Examples

A 
B 
C 
D 
1 
Data 



2 
9% 
Annual interest rate 


3 
30 
Loan term – years 


4 
$125,000 
Present value 


5 




6 
Formula 
Result 
Notes 
7 
=CUMPRINC(A2/12,A3*12,A4,13,24,0) 
$934.1071 
Principal paid in the second year of payments, periods 13 through 24 
8 
=COMPRINC(A2/12,A3*12,A4,1,1,0) 
$68.27827 
Principal paid in the first month payment 
Note: In the above example, the payments are made monthly, so
 the annual interest rate of 9% had to be converted into a monthly rate (=9%/12), and
 the number of years had to be converted into months (=30*12)
Cash Flow Convention: In line with general cash flow conventions, outgoing payments are represented by negative numbers and incoming payments are represented by positive numbers.
Common Function Error(s)
Problem 
What went wrong 
#VALUE! 
Occurs if any of the supplied arguments are not recognized as numeric values 
#NUM! 
Occurs if:

• 
the start_period or end_period is ≤ 0 or > nper 

• 
the start_period > end_period 

• 
either of the supplied rate, nper or pv arguments are ≤ 0 

• 
the type argument is not equal to 0 or 1 

Result is much higher or much lower than expected 
Usually occurs due to failure to convert the rate or the nper to months or quarters, i.e.:

months 
= 
12 * years 

monthly rate 
= 
annual rate/12 

quarters 
= 
4 * years 

quarterly rate 
= 
annual rate/4 
