Excel Function : CUMIPMT

Download now!

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