Returns the cumulative interest paid on a loan between two specified periods.
Sintaxis
CUMIPMT(rate, nper, pv, start_period, end_period, type)Argumentos
rateobligatorio
The interest rate per period.
nperobligatorio
The total number of payment periods.
pvobligatorio
The present value of the loan.
start_periodobligatorio
The first period in the calculation.
end_periodobligatorio
The last period in the calculation.
typeobligatorio
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.