cumipmt

Cumulative interest paid between two periods.

Syntax

v = cumipmt(rate, nper, pv, start_period, end_period, type)

Description

Returns the total interest paid on a loan between start_period and end_period (inclusive). Useful for tax reporting and amortization summaries.

Example

cumipmt(0.06/12, 30*12, 250000, 1, 12, 0)    % first-year interest

See also

• ipmt — Interest portion of a periodic loan payment.
• ppmt — Principal portion of a periodic loan payment.
• pmt — Periodic payment for a loan or annuity.