# CUMIPMT

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

Returns the cumulative interest paid 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 period1 = 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.