Difference between revisions of "Documentation/How Tos/Calc: CUMIPMT ADD function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(correction) |
|||
| Line 14: | Line 14: | ||
: <tt>'''end'''</tt>: the last period to include. | : <tt>'''end'''</tt>: the last period to include. | ||
: <tt>'''type'''</tt>: when payments are made: | : <tt>'''type'''</tt>: when payments are made: | ||
| − | :: 0 - at the | + | :: 0 - at the end of each period. |
| − | :: 1 - at the | + | :: 1 - at the start of each period. |
=== Example: === | === Example: === | ||
| Line 32: | Line 32: | ||
=== Issues: === | === 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 | + | * 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. |
Revision as of 16:59, 10 July 2008
CUMIPMT_ADD
Returns the total interest paid on a loan in specified periods.
This function is only available if the Analysis AddIn is installed.
Syntax:
CUMIPMT_ADD(rate; numperiods; value; start; end; type)
- rate: the interest rate per period.
- numperiods: the total number of payment periods remaining.
- value: the current value of the loan.
- 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.
Example:
CUMIPMT_ADD(5.5%/12; 12*2; 5000; 4; 6; 1)
- returns approximately -57.54. 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:
CUMIPMT, IPMT, PPMT, CUMPRINC, CUMPRINC_ADD
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.
- If type 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.
