Returns the cumulative interest paid on a loan between two specified periods.
Söz dizimi
CUMIPMT(rate, nper, pv, start_period, end_period, type)Bağımsız değişkenler
ratezorunlu
The interest rate per period.
nperzorunlu
The total number of payment periods.
pvzorunlu
The present value of the loan.
start_periodzorunlu
The first period in the calculation.
end_periodzorunlu
The last period in the calculation.
typezorunlu
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.