All functions / Financial

CUMIPMT

Total interest paid between two payment numbers.

Syntax

=CUMIPMT(rate, nper, pv, start_period, end_period, type)

Arguments

• rate: Interest rate per period, e.g. 5%/12 for monthly payments at 5% a year.
• nper: Total number of payments.
• pv: The loan amount (present value).
• start_period: First payment to include.
• end_period: Last payment to include.
• type: 0 = payments at the end of each period, 1 = at the start.

Example

=CUMIPMT(6%/12, 36, 20000, 1, 12, 0) → Interest paid in year one