Difference between revisions of "Documentation/How Tos/Calc: CUMIPMT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
(10 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE: CUMIPMT function}} |
+ | {{Documentation/CalcFunc FinancialTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_VDB_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_CUMIPMT_ADD_function | ||
+ | }}__NOTOC__ | ||
== CUMIPMT == | == CUMIPMT == | ||
− | Returns the total interest paid on a loan in specified | + | Returns the total interest paid on a loan in specified periodic payments. |
=== Syntax: === | === Syntax: === | ||
− | <tt>'''CUMIPMT(rate; numperiods; | + | <tt>'''CUMIPMT(rate; numperiods; presentvalue; start; end; type)'''</tt> |
: <tt>'''rate'''</tt>: the interest rate per period. | : <tt>'''rate'''</tt>: the interest rate per period. | ||
: <tt>'''numperiods'''</tt>: the total number of payment periods in the term. | : <tt>'''numperiods'''</tt>: the total number of payment periods in the term. | ||
− | : <tt>''' | + | : <tt>'''presentvalue'''</tt>: the initial sum borrowed. |
: <tt>'''start'''</tt>: the first period to include. Periods are numbered beginning with 1. | : <tt>'''start'''</tt>: the first period to include. Periods are numbered beginning with 1. | ||
: <tt>'''end'''</tt>: the last period to include. | : <tt>'''end'''</tt>: the last period to include. | ||
Line 18: | Line 23: | ||
: 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. | : 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. | ||
− | : <tt>'''IPMT'''</tt> returns the interest | + | : <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'''</tt> returns the total interest | + | : <tt>'''CUMIPMT'''</tt> returns the total interest in payments during the periods <tt>'''start'''</tt> to <tt>'''end'''</tt> inclusive - that is, the sum of <tt>'''IPMT'''</tt> over that time. |
=== Example: === | === Example: === | ||
Line 26: | Line 31: | ||
: returns <tt>'''-57.80'''</tt> in currency units. 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. | : returns <tt>'''-57.80'''</tt> in currency units. 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: === |
− | [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|''' | + | * '''CUMIPMT''' formats the result as currency if the cell has default formatting. It thus displays a real currency amount. The [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]] function is compatible with Excel; it does not apply formatting and can thus show fractional currency amounts, for example 57.5412415... The amount returned by '''CUMIPMT''' may still be fractional - the display rounds this to the nearest real currency. Note that your loan provider might round differently (for example, always downwards). |
− | [[Documentation/How_Tos/Calc: | + | * According to the forthcoming ODFF standard, this function is to be removed, and [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]] is to be renamed '''CUMIPMT'''. |
− | + | * In contrast to '''PMT''', '''IMPT''', '''PPMT''', this function has no <tt>'''futurevalue'''</tt> parameter. | |
− | |||
− | |||
− | |||
− | |||
− | [[Documentation/How_Tos/Calc: | + | {{SeeAlso|EN| |
− | [[Documentation/How_Tos/Calc: | + | * [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]] |
+ | * [[Documentation/How_Tos/Calc: IPMT function|IPMT]] | ||
+ | * [[Documentation/How_Tos/Calc: PMT function|PMT]] | ||
+ | * [[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]] |
Latest revision as of 15:21, 30 January 2024
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
CUMIPMT
Returns the total interest paid on a loan in specified periodic payments.
Syntax:
CUMIPMT(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 returns the total interest in payments during the periods start to end inclusive - that is, the sum of IPMT over that time.
Example:
CUMIPMT(5.5%/12; 12*2; 5000; 4; 6; 0)
- returns -57.80 in currency units. 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 formats the result as currency if the cell has default formatting. It thus displays a real currency amount. The CUMIPMT_ADD function is compatible with Excel; it does not apply formatting and can thus show fractional currency amounts, for example 57.5412415... The amount returned by CUMIPMT may still be fractional - the display rounds this to the nearest real currency. Note that your loan provider might round differently (for example, always downwards).
- According to the forthcoming ODFF standard, this function is to be removed, and CUMIPMT_ADD is to be renamed CUMIPMT.
- In contrast to PMT, IMPT, PPMT, this function has no futurevalue parameter.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}