#### FINANCE.CUMIPMT

```
FINANCE.CUMIPMT(rate, periods, value, first_period, last_period, end_or_start = 0)
```

Calculate the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

**rate:**Interest rate.**periods:**Number of payments to be made.**value:**Present value of the annuity.**first_period:**Number of the payment period to begin the cumulative calculation. Must be greater than 1.**last_period:**Number of the payment period to end the cumulative calculation. Must be greater than first_period.**end_or_beginning:**Whether payments are due at the end (0) or the beginning (1) of each period.