Difference between revisions of "Documentation/How Tos/Calc: PPMT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
(3 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE: PPMT function}} |
+ | {{Documentation/CalcFunc FinancialTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_PMT_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_PV_function | ||
+ | }}__NOTOC__ | ||
== PPMT == | == PPMT == | ||
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>'''PPMT'''</tt> returns the capital repaid in the payment of a specified period. <tt>'''IPMT'''</tt> returns the interest paid in the payment of that period. Together they add up to the actual payment, given by <tt>'''PMT'''</tt>. <tt>'''PPMT'''</tt> is calculated as <tt>'''PMT'''</tt> - <tt>'''IPMT'''</tt>. | : <tt>'''PPMT'''</tt> returns the capital repaid in the payment of a specified period. <tt>'''IPMT'''</tt> returns the interest paid in the payment of that period. Together they add up to the actual payment, given by <tt>'''PMT'''</tt>. <tt>'''PPMT'''</tt> is calculated as <tt>'''PMT'''</tt> - <tt>'''IPMT'''</tt>. | ||
Line 28: | Line 33: | ||
=== Example: === | === Example: === | ||
<tt>'''PPMT(5.5%/12; 12; 12*2; 5000; 0; 0)'''</tt> | <tt>'''PPMT(5.5%/12; 12; 12*2; 5000; 0; 0)'''</tt> | ||
− | : returns <tt>'''-207.75'''</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 207.75 is repayment of capital. | + | : returns <tt>'''-207.75'''</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 207.75 is repayment of capital. |
=== Issues: === | === Issues: === | ||
− | * '''PPMT''' formats the result as currency if the cell has default formatting. It thus displays a real currency amount. The amount returned by '''PPMT''' 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). | + | * '''PPMT''' formats the result as currency if the cell has default formatting. It thus displays a real currency amount. The amount returned by '''PPMT''' 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 "payment on the principal for a given period". This seems to be wrong - it is the "payment on the principal" 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. | * Excel claims that this function calculates the "payment on the principal for a given period". This seems to be wrong - it is the "payment on the principal" 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 function|CUMIPMT]] | ||
* [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]] | * [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]] | ||
Line 48: | Line 53: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
− | [[Category: Documentation/Reference/Calc]] | + | [[Category: Documentation/Reference/Calc/Financial functions]] |
Latest revision as of 16:00, 30 January 2024
- Financial FunctionsDepreciation
- AMORDEGRCAMORLINCDBDDBSLNSYDVDBPayment Streams, Annuities, Loans
- CUMIPMTCUMIPMT_ADDCUMPRINCCUMPRINC ADDFVFVSCHEDULEIPMTIRRISPMTMIRRNPERNPVPMTPPMTPVRATERRIXIRRXNPVSecurities
-