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 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. * In Excel 2010 the accuracy of this function was improved. * For the Microsoft documentation refer to support.office.com 

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. 
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top