CUMIPMT function
Rate
The interest rate per period.
NumberOfPeriods
The total number of payment periods in the term.
PresentValue
The initial sum borrowed.
Start
The first period to include (periods are numbered beginning with 1).
End
The last period to include.
Type
0 to specify that payments are made at the end of each period and 1 to specify that payments are made at the start of each period (including a payment at the start of the term).
Returns
The total interest paid on a loan.
Returns the total interest paid on a loan in specified periodic payments.
Example
Returns roughly $-57.80. Let's assume that you took out a two-year loan of $5,000 at a yearly interest rate of 5.5%, making monthly payments at the end of the month. The interest you pay in months 4, 5 and 6 is roughly $57.80. The returned number is negative because you pay the interest.