CUMIPMT:
Returns the cumulative interest paid between two periods
The CUMIPMT function calculates the cumulative interest paid between two periods. It can be a very handy function and is relatively straightforward.
Using the CUMIPMT function:
Using the CUMIPMT function to calculate the interest for a single period:
The arguments for the CUMIPMT function are:
Argument

Required?

Description

rate 
Required 
The interest rate. 
nper 
Required 
The total number of payment periods. 
pv 
Required 
The present value. 
start_period 
Required 
The first period in the calculation. Payment periods are numbered beginning with 1. 
end_period 
Required 
The last period in the calculation. 
type 
Optional 
The timing of the payment 
The CUMIPMT function calculates the cumulative interest paid between two periods.