CUMIPMT

Description: Returns the cumulative interest paid between two periods.

Syntax: CUMIPMT(Rate, Nper, PV, Start_Period, End_Period, Type)

Rate is the interest rate.
Nper is the total number of payment periods.
PV is the present value.
Start_Period is the first period in the calculation. Payment periods are numbered beginning with 1.
End_Period is the last period in the calculation.
Type is the timing of the payment.

Type	Timing
0 (zero)	Payment at the end of the period
1	Payment at the beginning of the period

Remarks:

Make sure that you are consistent about the units you use for specifying Rate and Nper. If you make monthly payments (12 per year) on a four-year loan at an annual interest rate of 10 percent, use (0.1/12) for Rate and (4*12) for Nper. If you make annual payments on the same loan, use 0.1 for Rate and 4 for Nper.
Nper, Start_Period, End_Period, must be integers.
Rate, Nper and PV must be >= 0.
Start_Period and End_Period must be >= 1 and Start_Period <= End_Period.
Type must be either 0 or 1.

Example:

Total interest paid in the second year of payments, periods 13 through 24 assuming a 9% annual interest rate:

CUMIPMT(0.09/12, 30*12, 125000, 13, 24, 0) = -11135.23