Difference between revisions of "Documentation/How Tos/Calc: Financial functions"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(47 intermediate revisions by 6 users not shown)
Line 1: Line 1:
−
==Financial Functions==
+
{{DISPLAYTITLE: Financial Functions}}
−
The Financial functions provide common business calculations.
+
{{Documentation/CalcFunc FinancialTOC
 +
|ShowPrevPage={{{ShowPrevPage}}}
 +
|PrevPage={{{PrevPage}}}
 +
|ShowNextPage={{{ShowNextPage}}}
 +
|NextPage={{{NextPage}}}
 +
|bookid=CalcFunctions
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div>
 +
|ShowParttitle=block
 +
|parttitle=[[Documentation/How_Tos/Calc:_Financial_functions|<div style="font-size: 140%;">Financial Functions]]
 +
|ShowPrevPart=block
 +
|PrevPart=Documentation/How_Tos/Calc:_Date_%26_Time_functions
 +
|ShowNextPart=block
 +
|NextPart=Documentation/How_Tos/Calc:_Information_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
}}__NOTOC__
 +
[[File:open.jpg]]
  
−
''(Note to translators: some of these function descriptions may be rewritten for improved clarity.)''
+
==<big>Financial functions</big>==
 +
The Financial functions provide common business calculations.
  
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
Line 41: Line 57:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']]
 
|[[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']]
−
|Returns the total interest paid on a loan in specified periods.
+
|Returns the total interest paid on a loan in specified periodic payments.
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: CUMIPMT_ADD function|'''CUMIPMT_ADD''']]
 
|[[Documentation/How_Tos/Calc: CUMIPMT_ADD function|'''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.
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: CUMPRINC function|'''CUMPRINC''']]
 
|[[Documentation/How_Tos/Calc: CUMPRINC function|'''CUMPRINC''']]
−
|Returns the total capital repaid on a loan in specified periods.  
+
|Returns the total capital repaid on a loan in specified periodic payments.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: CUMPRINC_ADD function|'''CUMPRINC_ADD''']]
 
|[[Documentation/How_Tos/Calc: CUMPRINC_ADD function|'''CUMPRINC_ADD''']]
−
|Returns the total capital repaid on a loan in specified periods.
+
|Returns the total capital repaid on a loan in specified periodic payments.  
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
+
−
|Returns the effective compounded interest rate given a nominal interest rate.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
+
−
|Returns the effective compounded interest rate given a nominal interest rate.  
+
  
 
|-valign="top"
 
|-valign="top"
Line 73: Line 81:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
 
|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
−
|Returns the interest paid in a period for a fixed rate loan.  
+
|Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity.
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]
 
|[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]
−
|Calculates the internal rate of return for an investment. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income).
+
|Calculates the internal rate of return of a series of cash flows.
  
 
|-valign="top"
 
|-valign="top"
Line 85: Line 93:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
 
|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
−
|Calculates the modified internal rate of return of a series of investments.
+
|Returns the modified internal rate of return of a series of cash flows.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
 
|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
−
|Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
+
|Returns the number of payment periods for an annuity.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
 
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
−
|Returns the net present value of an investment given cash payments and a discount rate.
+
|Returns the net present value of an investment with regular cash payments.
  
 
|-valign="top"
 
|-valign="top"
Line 101: Line 109:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']]
 
|[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']]
−
|Returns the capital repaid in a period for a fixed rate loan.
+
|Returns the portion of the periodic payment which is repaid capital for a fixed rate loan or annuity.  
  
 
|-valign="top"
 
|-valign="top"
Line 109: Line 117:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: RATE function|'''RATE''']]
 
|[[Documentation/How_Tos/Calc: RATE function|'''RATE''']]
−
|Returns the constant interest rate per period of an annuity.
+
|Calculates the interest rate for an annuity.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]
 
|[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]
−
|Calculates the interest rate resulting from the profit (return) of an investment.
+
|Returns an equivalent interest rate when an investment increases in value.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]
 
|[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]
−
|Calculates the internal rate of return for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.
+
|Calculates the internal rate of return of a series of irregular cash flows.  
  
 
|-valign="top"
 
|-valign="top"
Line 136: Line 144:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
 
|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
−
|Calculates the allowance (discount) of a security as a percentage.
+
|Returns the discount rate of a security.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: DURATION function|'''DURATION''']]
 
|[[Documentation/How_Tos/Calc: DURATION function|'''DURATION''']]
−
|Calculates the number of periods required by an investment to attain the desired value.
+
|Returns the number of periods needed for an investment to reach a certain value.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
 
|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
−
|Calculates the duration of a fixed interest security in years.
+
|Returns the Macaulay duration of a security.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
 +
|Returns the effective compounded interest rate given a nominal interest rate.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
 +
|Returns the effective compounded interest rate given a nominal interest rate.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
 
|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
−
|Returns the equivalent annual interest rate for an item bought at one price and sold at another.  
+
|Returns the equivalent annual interest rate for an investment bought at one price and sold at another.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]
 
|[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]
−
|Calculates the modified Macauley duration of a fixed interest security in years.
+
|Returns the modified Macaulay duration of a security.
  
 
|-valign="top"
 
|-valign="top"
Line 164: Line 180:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: ODDFPRICE function|'''ODDFPRICE''']]
 
|[[Documentation/How_Tos/Calc: ODDFPRICE function|'''ODDFPRICE''']]
−
|Returns the value of a security per 100 currency units of face value, where the time to the first interest payment is not a whole period.
+
|Returns the value of a security per 100 currency units of face value, where the time to the first  
 +
interest payment is not a whole period.  
  
 
|-valign="top"
 
|-valign="top"
Line 172: Line 189:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: ODDLPRICE function|'''ODDLPRICE''']]
 
|[[Documentation/How_Tos/Calc: ODDLPRICE function|'''ODDLPRICE''']]
−
|Returns the value of a security per 100 currency units of face value, where the last interest payment is not a whole period.
+
|Returns the value of a security per 100 currency units of face value, where the last interest payment  
 +
is not a whole period.
  
 
|-valign="top"
 
|-valign="top"
Line 180: Line 198:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: PRICE function|'''PRICE''']]
 
|[[Documentation/How_Tos/Calc: PRICE function|'''PRICE''']]
−
|Calculates a quoted price for an interest-bearing security.
+
|Calculates a quoted price for an interest paying security, per 100 currency units par value.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: PRICEDISC function|'''PRICEDISC''']]
 
|[[Documentation/How_Tos/Calc: PRICEDISC function|'''PRICEDISC''']]
−
|Calculates the price of a non-interest-bearing security.
+
|Calculates a price for a non-interest paying discounted bond.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: PRICEMAT function|'''PRICEMAT''']]
 
|[[Documentation/How_Tos/Calc: PRICEMAT function|'''PRICEMAT''']]
−
|Calculates the price of a security that pays interest at maturity.
+
|Calculates a price (per 100 currency units par value) for a bond that pays interest on maturity.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]
 
|[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]
−
|Calculates the amount received that is paid for a fixed-interest security at a given point in time.
+
|Calculates the amount received at maturity for a zero coupon bond.  
  
 
|-valign="top"
 
|-valign="top"
Line 208: Line 226:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
 
|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
−
|Calculates the yield of a security.
+
|Calculates the yield for an interest paying security.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
 
|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
−
|Calculates the annual yield of a non-interest-bearing security.
+
|Calculates the yield for a non-interest paying discounted bond.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]
 
|[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]
−
|Calculates the annual yield of a security, the interest of which is paid on the date of maturity.
+
|Calculates the yield for a bond that pays interest on maturity.  
 
   
 
   
 
|-valign="top"
 
|-valign="top"
Line 239: Line 257:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]
 
|[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]
−
|Returns the number of coupons (interest payments) between the settlement date and maturity.  
+
|Returns the number of coupons (interest payments) between the settlement  
 +
date and maturity.  
  
 
|-valign="top"
 
|-valign="top"
Line 259: Line 278:
 
<!-- why on earth is this necessary? -->
 
<!-- why on earth is this necessary? -->
  
−
==See also==
+
{{SeeAlso|EN|
−
'''[[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]'''
+
* [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]
 +
* [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]]
 +
 
 +
* [[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: Date & Time functions#Financial date systems|'''Financial date systems''']]
 
  
−
'''[[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]'''
+
[[nl:Documentation/nl/How_Tos/Calc:_Financiële_functies]]
 +
[[Category: Documentation/Reference/Calc]]

Latest revision as of 16:14, 1 February 2024

Open.jpg

Financial functions

The Financial functions provide common business calculations.

Depreciation
AMORDEGRC Returns depreciation for a period using degressive depreciation (French system).
AMORLINC Returns depreciation for a period using linear depreciation (French system).
DB Returns the depreciation of an asset for a given year using the fixed rate declining-balance method.
DDB Returns the depreciation of an asset for a given year using the double (or other factor) declining-balance method.
SLN Returns the depreciation of an asset in a single period using the straight-line depreciation method.
SYD Returns the depreciation of an asset for a given year using the sum-of-years'-digits method.
VDB Returns the depreciation of an asset for a given year using a variable declining-balance method.
Payment Streams, Annuities, Loans
CUMIPMT Returns the total interest paid on a loan in specified periodic payments.
CUMIPMT_ADD Returns the total interest paid on a loan in specified periodic payments.
CUMPRINC Returns the total capital repaid on a loan in specified periodic payments.
CUMPRINC_ADD Returns the total capital repaid on a loan in specified periodic payments.
FV Returns the future value of an initial sum with a subsequent stream of payments.
FVSCHEDULE Returns the future value of an initial sum, with changing future interest rates.
IPMT Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity.
IRR Calculates the internal rate of return of a series of cash flows.
ISPMT Returns the interest paid in a period for a fixed rate loan.
MIRR Returns the modified internal rate of return of a series of cash flows.
NPER Returns the number of payment periods for an annuity.
NPV Returns the net present value of an investment with regular cash payments.
PMT Returns the payment per period for a fixed rate loan.
PPMT Returns the portion of the periodic payment which is repaid capital for a fixed rate loan or annuity.
PV Returns the present value of a stream of future payments with a final lump sum.
RATE Calculates the interest rate for an annuity.
RRI Returns an equivalent interest rate when an investment increases in value.
XIRR Calculates the internal rate of return of a series of irregular cash flows.
XNPV Returns the net present value of an investment with irregular cash payments.
Securities
ACCRINT Calculates the accrued interest for a security with periodic interest payments.
ACCRINTM Calculates the accrued interest for a security that pays at maturity.
DISC Returns the discount rate of a security.
DURATION Returns the number of periods needed for an investment to reach a certain value.
DURATION_ADD Returns the Macaulay duration of a security.
EFFECTIVE Returns the effective compounded interest rate given a nominal interest rate.
EFFECT_ADD Returns the effective compounded interest rate given a nominal interest rate.
INTRATE Returns the equivalent annual interest rate for an investment bought at one price and sold at another.
MDURATION Returns the modified Macaulay duration of a security.
NOMINAL Returns a nominal interest rate given the effective compounded interest rate.
NOMINAL_ADD Returns a nominal interest rate given the effective compounded interest rate.
ODDFPRICE Returns the value of a security per 100 currency units of face value, where the time to the first

interest payment is not a whole period.

ODDFYIELD Returns the yield of a security, where the time to the first interest payment is not a whole period.
ODDLPRICE Returns the value of a security per 100 currency units of face value, where the last interest payment

is not a whole period.

ODDLYIELD Returns the yield of a security, where the last interest payment is not a whole period.
PRICE Calculates a quoted price for an interest paying security, per 100 currency units par value.
PRICEDISC Calculates a price for a non-interest paying discounted bond.
PRICEMAT Calculates a price (per 100 currency units par value) for a bond that pays interest on maturity.
RECEIVED Calculates the amount received at maturity for a zero coupon bond.
TBILLEQ Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
TBILLPRICE Returns the issue price for a US Treasury bill, per $100 par value, given a discount rate.
TBILLYIELD Returns the yield for a US Treasury bill.
YIELD Calculates the yield for an interest paying security.
YIELDDISC Calculates the yield for a non-interest paying discounted bond.
YIELDMAT Calculates the yield for a bond that pays interest on maturity.
Coupons
COUPDAYBS Returns the number of days between the coupon date preceding the settlement, and the settlement date.
COUPDAYS Returns the number of days in the coupon period that contains the settlement date.
COUPDAYSNC Returns the number of days between the settlement date and the next coupon date.
COUPNCD Returns the coupon date next after the settlement date.
COUPNUM Returns the number of coupons (interest payments) between the settlement

date and maturity.

COUPPCD Returns the coupon (interest payment) date which precedes the settlement date.
Miscellaneous
DOLLARDE Converts a fractional number representation of a number into a decimal number.
DOLLARFR Converts a decimal number into a fractional representation of that number.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Financial_functions&oldid=259959"
Views
Personal tools
Navigation
Tools
In other languages