CUMIPMT function calculates the cumulative interest paid between the start date and the end date or It is used to get interest paid between any two loan payment period.
=CUMIPMT(rate, nper, pv, start_period, end_period, type)
rate – The rate of interest
nper – The total number of payments period.
pv – The present value
start_period – The first period in calculation, starts with 1.
end_period – The last period in the calculation.
type – The timing of the payment.
|0 (zero)||Payment at the end of the period|
|1||Payment at the beginning of the period|