Difference between revisions of "Documentation/How Tos/Calc: IPMT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
(12 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE: IPMT function}} |
+ | {{Documentation/CalcFunc FinancialTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_FVSCHEDULE_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_IRR_function | ||
+ | }}__NOTOC__ | ||
== IPMT == | == IPMT == | ||
− | Returns the interest | + | Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity. |
=== Syntax: === | === Syntax: === | ||
− | <tt>'''IPMT(rate; period; numperiods; | + | <tt>'''IPMT(rate; period; numperiods; presentvalue; futurevalue; type)'''</tt> |
− | : <tt>'''rate'''</tt>: the interest rate per period. | + | : <tt>'''rate'''</tt>: the interest rate, per period. |
− | : <tt>'''period'''</tt>: the period | + | : <tt>'''period'''</tt>: the period of the payment whose interest portion is to be calculated, numbered from 1. |
: <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 or invested. |
− | : <tt>''' | + | : <tt>'''futurevalue'''</tt>: the cash balance you wish to attain at the end of the term (optional - defaults to 0). With a loan, this would normally be 0. |
: <tt>'''type'''</tt>: when payments are made (optional - defaults to 0): | : <tt>'''type'''</tt>: when payments are made (optional - defaults to 0): | ||
:: 0 - at the end of each period. | :: 0 - at the end of each period. | ||
Line 16: | Line 21: | ||
− | : 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>. |
+ | |||
+ | : When payments are made at the end of each period, the interest arises during that period. | ||
+ | |||
+ | : When payments are made at the start of each period, the interest arises <u>during the preceding period</u>. | ||
+ | |||
+ | : By convention, money that you receive is positive, and money you pay is negative. For a loan where you receive a lump sum at the start, <tt>'''presentvalue'''</tt> is positive. For an investment where you pay a lump sum at the start, <tt>'''presentvalue'''</tt> is negative. | ||
=== Example: === | === Example: === | ||
Line 24: | Line 35: | ||
: returns <tt>'''-12.72'''</tt> in currency units. You take 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. In the 12<sup>th</sup> month you make your usual monthly repayment, of which 12.72 is interest. | : returns <tt>'''-12.72'''</tt> in currency units. You take 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. In the 12<sup>th</sup> month you make your usual monthly repayment, of which 12.72 is interest. | ||
− | === | + | === Issues: === |
− | + | * '''IPMT''' formats the result as currency if the cell has default formatting. It thus displays a real currency amount. The amount returned by '''IPMT''' may still be fractional - the display rounds this to the nearest real currency. Note that your loan provider might round in a different way (for example always downwards). | |
− | + | * Excel claims that this function calculates the "interest payment for a given period". This seems to be wrong - it is the interest in the <u>payment</u> for that period. Calc and Excel produce the same results. Gnumeric returns slightly different results when payment is at the start of each period; possibly it calculates what Excel says it calculates. | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | {{SeeAlso|EN| | |
+ | * [[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]] | ||
+ | * [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]] | ||
+ | * [[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: | + | * [[Documentation/How_Tos/Calc: ISPMT function|ISPMT]] |
− | + | * [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]] | |
− | * | + | |
+ | * [[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:53, 30 January 2024
- Financial FunctionsDepreciation
- AMORDEGRCAMORLINCDBDDBSLNSYDVDBPayment Streams, Annuities, Loans
- CUMIPMTCUMIPMT_ADDCUMPRINCCUMPRINC ADDFVFVSCHEDULEIPMTIRRISPMTMIRRNPERNPVPMTPPMTPVRATERRIXIRRXNPVSecurities
-