Returns the cumulative interest paid on a loan between two specified periods.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
CUMIPMT(rate, nper, pv, start_period, end_period, type)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.33
Calculates the total interest paid in the first year of a $10,000 loan at 6% annual interest over 3 years.
In Excel financial functions, payments are represented as negative numbers because they represent cash outflows.