This function returns the cumulative interest paid on a loan between the starting and ending periods.
Syntax
CUMIPMT(rate,nper,pval,startperiod,endperiod,paytype)
Arguments
This function has these arguments:
Argument 
Description 
rate 
Interest rate 
nper 
Total number of payment periods 
pval 
Present value 
startperiod 
Starting period 
endperiod 
Ending period 
paytype 
Type of payment timing; can be any of: 

0  Payment at end of the period 

1  Payment at beginning of the period 
Remarks
This functions returns a #NUM! error when rate, nper, or pval is negative or zero. Nper, startperiod, endperiod, and paytype are truncated to integers. If startperiod or endperiod is less than 1 or startperiod is greater than endperiod, a #NUM! error is returned. If paytype is a number other than 0 or 1, a #NUM! error is returned.
Data Types
Accepts numeric and DateTime object data. Returns numeric data.
Examples
CUMIPMT(B2/12,B4*12,C4,14,20,0)
CUMIPMT(B2/12,B4*12,C4,14,20,0)
See Also