CUMIPMT

CUMIPMT(rate, nper, pv, start_period, end_period, type)

Returns the cumulative interest payment on a loan between two dates.

rate	The fixed interest rate per period.
nper	The total number of payments.
pv	The present value of the loan.
start_period	The first period in the calculation.
end_period	The last period in the calculation.
type	The number indicating when the payments are due: 0 = the end of the period 1 = the start of the period

REMARKS

* The "rate" and "nper" must have the same units.
* Payment periods are numbered beginning with 1.
* If "rate" <= 0, then #NUM! is returned.
* If "nper" is not an integer, it is truncated.
* If "nper" <= 0, then #NUM! is returned.
* If "pv" <= 0, then #NUM! is returned.
* If "start_period" is not an integer, it is truncated.
* If "start_period" < 1, then #NUM! is returned.
* If "end_period" is not an integer, it is truncated.
* If "end_period" < 1, then #NUM! is returned.
* If "start_period" > "end_period", then #NUM! is returned.
* If "type" is not an integer, it is truncated.
* If "type" is any number other than 0 or 1, then #NUM! is returned.
* You can use the CUMPRINC function to return the cumulative principal paid on a loan between two dates.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=CUMIPMT(5.7%/12, 15*12, 20000, 1, 12, 0) = -1117.530
2	=CUMIPMT(0.00475, 15*12, 20000, 13, 24, 0) = -1066.680
3	=CUMIPMT(0.00475, 15*12, 20000, 25, 36, 0) = -1012.855

1 - How much of a £200,000 mortgage, which is repayable over 15 years at 5.7%, will be paid towards the interest in the first year.
2 - How much of a £200,000 mortgage, which is repayable over 15 years at 5.7%, will be paid towards the interest in the second year.
3 - How much of a £200,000 mortgage, which is repayable over 15 years at 5.7%, will be paid towards the interest in the third year.