# CumIPmt

## CumIPmt(rate, nper, pv*, start_per, end_per, type*)

The cumulative interest received on an annuity (with periodic payments and constant interest rate) between «start_per» and «end_per» inclusive. A negative number represents cumulative interest paid.

Parameters:

- «Rate»
- The interest rate per period.
- «NPer»
- The total number of periods in the annity's lifetime.
- «Pv»
- The present value.
- If you receive a loan, this is the loan amount as a positive number.
- If you give someone a loan, this is a negative number.
- «Start_per»
- First period included in the sum.
- «End_per»
- Last period included in the sum.
- «Type»
- (Optional) Indicates whether payments are at the beginning of the period.
`True`

= Payments due at beginning of period, with first payment due immediately.`False`

= Payments due at end of period. (default)

Returns `SUM_{n = Start_per..End_per} IPmt(rate, n, NPer, Pv, 0, Type)`

*Note*: The CumIPmt function in some versions of Microsoft Excel returns the interest received between Start_per-1 and End_per, and thus may return different results than this function in Analytica.

## Library

Financial Functions

## Examples

Five years ago, you took out a 30-year fixed rate mortgage at a rate of 6.5% for an initial loan of $350K. How much have you paid in interest during the first five years?

`-CumIPmt(6.5%/12, 30*12, $350K, 1, 5*12) → $110,372.71`

How much interest will you pay this year?

`-CumIPmt(6.5%/12, 30*12, $350K, 5*12 + 1, 6*12) → $21,137.22`

## See Also

Comments

Enable comment auto-refresher