CUMIPMT
Returns the cumulative interest paid between two periods.
FinancialFinance & Accounting
What it does
Calculates total interest paid on a loan between start_period and end_period.
Syntax
CUMIPMT(rate, nper, pv, start_period, end_period, type)
Arguments
rate(number) — Interest rate per period.nper(number) — Total periods.pv(number) — Present value (loan amount).start_period(number) — First period to calculate.end_period(number) — Last period to calculate.type(number) — 0 = end of period, 1 = beginning.
Examples
Cumulative Interest
Interest paid in year 1 (periods 1-12).
FORMULA
=CUMIPMT(0.05/12, 60, 10000, 1, 12, 0)
RESULT
-450.5
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Loan | Rate | Years |
| 2 | 10000 | 5% | 5 |