Difference between revisions of "Documentation/How Tos/Calc: CUMIPMT ADD function"

Latest revision as of 15:25, 30 January 2024

FUNCTIONS

Depreciation

Payment Streams, Annuities, Loans

Securities

Coupons

Miscellaneous

< Previous Page

Next Page >

CUMIPMT_ADD

Returns the total interest paid on a loan in specified periodic payments.

This function is only available if the Analysis AddIn is installed.

Syntax:

CUMIPMT_ADD(rate; numperiods; presentvalue; start; end; type)

rate: the interest rate per period.

numperiods: the total number of payment periods in the term.

presentvalue: the initial sum borrowed.

start: the first period to include. Periods are numbered beginning with 1.

end: the last period to include.

type: when payments are made:

0 - at the end of each period.

1 - at the start of each period (including a payment at the start of the term).

With a fixed rate loan, where you make a constant payment each period to pay off the loan over the term, some of each period payment is interest on the outstanding capital, and some is a repayment of capital. Over time (as you pay off capital), the interest becomes less, and the capital repayment becomes more.

IPMT returns the interest in the payment of a specified period. PPMT returns the capital repaid in the payment of that period. Together they add up to the actual payment, given by PMT.

CUMIPMT_ADD returns the total interest paid during the periods start to end inclusive - that is, the sum of IPMT over that time.

Example:

CUMIPMT_ADD(5.5%/12; 12*2; 5000; 4; 6; 0)

returns approximately -57.80. You took out a 2-year loan of 5000 currency units at a yearly interest rate of 5.5%, making monthly payments at the end of the month. The interest you pay in the 4th-6th months inclusive is 57.80 currency units. It is given as negative because you pay it.

Issues:

CUMIPMT_ADD is compatible with Excel; it does not apply currency formatting and thus can show fractional amounts, for example 57.5412415... The CUMIPMT function formats the result as currency if the cell has default formatting, and thus shows a real (rounded) currency amount, for example $57.54; the amount may still be fractional - this just affects the display.
According to the ODFF standard, this function is renamed CUMIPMT and the existing CUMIPMT removed.
In contrast to PMT, IMPT, PPMT, this function has no futurevalue parameter.

See Also

Financial functions

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE: CUMIPMT_ADD function}}
+{{Documentation/CalcFunc FinancialTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_CUMIPMT_function
+|NextPage=Documentation/How_Tos/Calc:_CUMPRINC_function
+}}__NOTOC__
 == CUMIPMT_ADD ==
-Returns the total interest paid on a loan in specified periods.
+Returns the total interest paid on a loan in specified periodic payments.
 This function is only available if the '''Analysis AddIn''' is installed.
 === Syntax: ===
-<tt>'''CUMIPMT_ADD(rate; numperiods; value; start; end; type)'''</tt>
+<tt>'''CUMIPMT_ADD(rate; numperiods; presentvalue; start; end; type)'''</tt>
 : <tt>'''rate'''</tt>: the interest rate per period.
-: <tt>'''numperiods'''</tt>: the total number of payment periods remaining.
+: <tt>'''numperiods'''</tt>: the total number of payment periods in the term.
-: <tt>'''value'''</tt>: the current value of the loan.
+: <tt>'''presentvalue'''</tt>: the initial sum borrowed.
 : <tt>'''start'''</tt>: the first period to include. Periods are numbered beginning with 1.
 : <tt>'''end'''</tt>: the last period to include.
 : <tt>'''type'''</tt>: when payments are made:
 :: 0 - at the end of each period.
-:: 1 - at the start of each period.
+:: 1 - at the start of each period (including a payment at the start of the term).
-=== Example: ===
-<tt>'''CUMIPMT_ADD(5.5%/12; 12*2; 5000; 4; 6; 1)'''</tt>
-:  returns approximately <tt>'''-57.54'''</tt>. You took out a 2 year loan of 5000 currency units at a yearly interest rate of 5.5%, making monthly payments at the end of the month. The interest you pay in the 4th-6th months inclusive is 57.54 currency units. It is given as negative because you pay it.
-=== See also: ===
+: With a fixed rate loan, where you make a constant payment each period to pay off the loan over the term, some of each period payment is interest on the outstanding capital, and some is a repayment of capital. Over time (as you pay off capital), the interest becomes less, and the capital repayment becomes more.
-[[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']],
-[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']],
-[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']],
-[[Documentation/How_Tos/Calc: CUMPRINC function|'''CUMPRINC''']],
-[[Documentation/How_Tos/Calc: CUMPRINC_ADD function|'''CUMPRINC_ADD''']]
-[[Documentation/How_Tos/Calc: Financial functions|'''Financial functions''']]
+: <tt>'''IPMT'''</tt> returns the interest in the payment of a specified period. <tt>'''PPMT'''</tt> returns the capital repaid in the payment of that period. Together they add up to the actual payment, given by <tt>'''PMT'''</tt>.
+: <tt>'''CUMIPMT_ADD'''</tt> returns the total interest paid during the periods <tt>'''start'''</tt> to <tt>'''end'''</tt> inclusive - that is, the sum of  <tt>'''IPMT'''</tt> over that time.
+=== Example: ===
+<tt>'''CUMIPMT_ADD(5.5%/12; 12*2; 5000; 4; 6; 0)'''</tt>
+:  returns approximately <tt>'''-57.80'''</tt>. You took out a 2-year loan of 5000 currency units at a yearly interest rate of 5.5%, making monthly payments at the end of the month. The interest you pay in the 4th-6th months inclusive is 57.80 currency units. It is given as negative because you pay it.
 === Issues: ===
-* '''CUMIPMT_ADD''' is compatible with Excel; it does not apply currency formatting and thus can show fractional amounts, for example 57.5412415... The [[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']] function formats the result as currency if the cell has default formatting, and thus shows a real (rounded) currency amount, for example $57.54; the amount may still be fractional - this just affects the display.
+* '''CUMIPMT_ADD''' is compatible with Excel; it does not apply currency formatting and thus can show fractional amounts, for example 57.5412415... The [[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]] function formats the result as currency if the cell has default formatting, and thus shows a real (rounded) currency amount, for example $57.54; the amount may still be fractional - this just affects the display.
-* If <tt>'''type'''</tt> is 1, payments are made at the start of each period, including at the start of the first period - in other words, the first payment is made on the same day the loan is taken out. It is not clear if any loans are actually arranged on this basis.
+* According to the ODFF standard, this function is renamed [[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]] and the existing '''CUMIPMT''' removed.
+* In contrast to '''PMT''', '''IMPT''', '''PPMT''', this function has no <tt>'''futurevalue'''</tt> parameter.
+{{SeeAlso|EN|
+* [[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]]
+* [[Documentation/How_Tos/Calc: PMT function|PMT]]
+* [[Documentation/How_Tos/Calc: IPMT function|IPMT]]
+* [[Documentation/How_Tos/Calc: PPMT function|PPMT]]
+* [[Documentation/How_Tos/Calc: CUMPRINC function|CUMPRINC]]
+* [[Documentation/How_Tos/Calc: CUMPRINC_ADD function|CUMPRINC_ADD]]
+* [[Documentation/How_Tos/Calc: Financial functions|Financial functions]]
+* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
+* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
+[[Category: Documentation/Reference/Calc/Financial functions]]

Difference between revisions of "Documentation/How Tos/Calc: CUMIPMT ADD function"

Latest revision as of 15:25, 30 January 2024

CUMIPMT_ADD

Syntax:

Example:

Issues:

Views

Personal tools

Navigation

Search

Tools

In other languages