View source for CumIPmt

[[category:Financial Functions]]
[[Category:Doc Status D]] <!-- For Lumina use, do not change -->

== 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.
:<code>True</code>  = Payments due at beginning of period, with first payment due immediately.
:<code>False</code> = Payments due at end of period. (default)

Returns <code>SUM_{n = Start_per..End_per} IPmt(rate, n, NPer, Pv, 0, Type)</code>

''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? 
:<code>-CumIPmt(6.5%/12, 30*12, $350K, 1, 5*12) &rarr; $110,372.71</code>

How much interest will you pay this year?
:<code>-CumIPmt(6.5%/12, 30*12, $350K, 5*12 + 1, 6*12) &rarr; $21,137.22</code>

== See Also ==
* [[IPmt]]
* [[Pmt]]
* [[PPmt]]
* [[CumPrinc]]
* [[Pv]]
* [[NPer]]
* [[Rate]]
* [[Financial functions]]