Returns the cumulative interest paid on a loan between two specified periods.
Syntax
CUMIPMT(rate, nper, pv, start_period, end_period, type)Argument
rateobligatoriskt
The interest rate per period.
nperobligatoriskt
The total number of payment periods.
pvobligatoriskt
The present value of the loan.
start_periodobligatoriskt
The first period in the calculation.
end_periodobligatoriskt
The last period in the calculation.
typeobligatoriskt
When payments are due: 0 for end of period, 1 for beginning of period.
The CUMIPMT function calculates the total interest paid on a loan or investment between a start period and an end period. It is useful for determining the interest portion of payments over a specific range of time in an amortization schedule.
=CUMIPMT(0.06/12, 36, 10000, 1, 12, 0)→-534.33Calculates the total interest paid in the first year of a $10,000 loan at 6% annual interest over 3 years.
Define loan parameters
Ensure your interest rate and total periods are consistent with the payment frequency.
Apply the function
Input the start and end periods to define the range for which you want to calculate the cumulative interest.
In Excel financial functions, payments are represented as negative numbers because they represent cash outflows.