Returns the cumulative interest paid on a loan between two specified periods.
構文
CUMIPMT(rate, nper, pv, start_period, end_period, type)引数
rate必須
The interest rate per period.
nper必須
The total number of payment periods.
pv必須
The present value of the loan.
start_period必須
The first period in the calculation.
end_period必須
The last period in the calculation.
type必須
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.