# Excel CUMIPMT Function

Summary

The Excel CUMIPMT function is a financial function that returns the cumulative interest paid on a loan between a start period and an end period. You can use CUMIPMT to calculate and verify the total interest paid on a loan, or the interest paid between any two payment periods.

Purpose

Get cumulative interest paid on a loan

Return value

The interest amount

Syntax

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

Arguments

**rate**- The interest rate per period.**nper**- The total number of payments for the loan.**pv**- The present value, or total value of all payments now.**start_period**- First payment in calculation.**end_period**- Last payment in calculation.**type**- When payments are due. 0 = end of period. 1 = beginning of period.

Usage notes

- Be consistent with inputs for rate. For example, for 5-year loan with 4.5% annual interest, enter the rate as 4.5%/12.
- The loan value (pv) must be entered as a positive value.