Excel Function : CUMIPMT
Category
Financial
Description
Returns the cumulative interest paid between two periods
Microsoft Excel Reference Page
https://support.office.com/en-us/article/CUMIPMT-function-61067bb0-9016-427d-b95b-1a752af0e606
Syntax and Description of the CUMIPMT Excel Function
syntax CUMIRR excel function syntax CUMPRINC excel function syntax CURRENCY excel function syntax CURRENT excel function syntax CURRENT.DATE excel function syntax CURRENT.TIME excel function syntax DATE excel function syntax DATEDIF excel function syntax DATEVALUE excel function syntax DAY excel function syntax DAY360 excel function syntax DAYS excel function syntax DAYS360 excel function syntax DB excel function syntax DDB excel function syntax DEC2BIN excel function syntax DEC2HEX excel function syntax DEC2OCT excel function syntax DEGREES excel function syntax DELTA excel function syntax DOLLARDE excel function syntax DOLLARFR excel function syntax EOMONTH excel function syntax ERF excel function syntax ERF.PREC
About CUMIPMT Excel Function
The CUMIPMT function calculates the cumulative interest payment for a loan over a specified period. The syntax for the CUMIPMT function is as follows: CUMIPMT(rate, nper, pv, start_period, end_period, type) where rate = the interest rate for the loan nper = the total number of payments for the loan pv = the present value of the loan start_period = the number of the period to start the calculation end_period = the number of the period to end the calculation type = the type of payment for the loan
