Difference between revisions of "CumIPmt"

 
(One intermediate revision by one other user not shown)
Line 2: Line 2:
 
[[Category:Doc Status D]] <!-- For Lumina use, do not change -->
 
[[Category:Doc Status D]] <!-- For Lumina use, do not change -->
  
= CumIPmt(rate,nper,pv'',start_per,end_per,type'') =
+
== 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.
+
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:
 
Parameters:
  Rate: The interest rate per period.
+
;«Rate»: The interest rate per period.
  NPer: The total number of periods in the annity's lifetime.
+
;«NPer»: The total number of periods in the annity's lifetime.
  Pv:   The present value. If you receive a loan, this is the
+
;«Pv»: The present value.  
        loan amount as a positive number.  If you give someone
+
:If you receive a loan, this is the loan amount as a positive number.   
        a loan, this is a negative number.
+
:If you give someone a loan, this is a negative number.
  Start_per: First period included in the sum.
+
;«Start_per»: First period included in the sum.
  End_per: Last period included in the sum.
+
;«End_per»: Last period included in the sum.
  Type: (Optional) Indicates whether payments are at the beginning of the
+
;«Type»: (Optional) Indicates whether payments are at the beginning of the period.
        period.
+
:<code>True</code> = Payments due at beginning of period, with first payment due immediately.
        True  = Payments due at beginning of period, with first payment  
+
:<code>False</code> = Payments due at end of period. (default)
                due immediately.
 
        False = Payments due at end of period. (default)
 
  
Returns SUM_{n=Start_per..End_per} IPmt(rate,n,NPer,Pv,0,Type)
+
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.
+
''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 =
 
  
 +
== Library ==
 
Financial Functions  
 
Financial Functions  
  
= Examples =
+
== 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>
  
= See Also =
+
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>
  
* [[IPmt]]()
+
== See Also ==
* [[Pmt]](), [[PPmt]](), [[CumPrinc]]()
+
* [[IPmt]]
* [[Pv]](), [[NPer]](), [[Rate]]()
+
* [[Pmt]]
 +
* [[PPmt]]
 +
* [[CumPrinc]]
 +
* [[Pv]]
 +
* [[NPer]]
 +
* [[Rate]]
 +
* [[Financial functions]]

Latest revision as of 01:02, 30 January 2016


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


You are not allowed to post comments.