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

• IPmt()
• Pmt(), PPmt(), CumPrinc()
• Pv(), NPer(), Rate()