CUMIPMT

Excel Functions

Get cumulative interest paid on a loan

Syntax

EXCEL

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

Arguments

Parameter	Description
`rate`	The interest rate per period.
`nper`	The total number of payments for the loan.
`pv`	The present value, or total value of all payments now.
`start_period`	First payment in calculation.
`end_period`	Last payment in calculation.
`type`	When payments are due. 0 = end of period. 1 = beginning of period.

Return Value

The interest amount

Details

The CUMIPMT function returns the cumulative interest over a range of time defined by a given start and end period. CUMIPMT is useful for financial analysis, particularly in scenarios involving loans and investments. It allows users to calculate the cumulative interest over specific periods, which makes it an important tool for understanding the financial impact of different loan terms or investment strategies. Typical use cases include assessing the total interest outlay on mortgages over various time frames, comparing interest accruals on different loan offers, or analyzing investment growth over time. The CUMIPMT function provides a useful view of financial obligations or growth which can help with more informed decision-making and effective financial planning Suppose you have a 5-year l

Examples

Example

Suppose you have a 5-year loan of $10,000 with an annual interest rate of 5% and 12 compounding periods per year. You want to find out the total inter

EXCEL

=CUMIPMT(5%/12,5*12,10000,1,5*12,0)

Worksheet example

The formula in cell C10 is evaluated like this:

EXCEL

=CUMIPMT(C5/C7,C6*C7,C4,1,C6*C7,0)
=CUMIPMT(0.05/12,5*12,10000,1,5*12,0)
=CUMIPMT(0.0041667,60,10000,1,60,0)
-1322.75

CUMIPMT

Syntax

Arguments

Return Value

Details

Examples

See Also