Difference between revisions of "CumIPmt"

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

@@ Line 1: / Line 1: @@
 [[category:Financial Functions]]
-{{stub}}
+[[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]]