## Purpose

Get cumulative interest paid on a loan

## Return value

The interest amount

## 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.

## Syntax

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

## 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.