Returns the cumulative interest paid on a loan between two specified periods.
Składnia
CUMIPMT(rate, nper, pv, start_period, end_period, type)Argumenty
ratewymagane
The interest rate per period.
nperwymagane
The total number of payment periods.
pvwymagane
The present value of the loan.
start_periodwymagane
The first period in the calculation.
end_periodwymagane
The last period in the calculation.
typewymagane
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.