CUMIPMT

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

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

rateThe fixed interest rate per period.
nperThe total number of payments.
pvThe present value of the loan.
start_periodThe first period in the calculation.
end_periodThe last period in the calculation.
typeThe 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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top