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
See Also
Comments
Enable comment auto-refresher