Difference between revisions of "Documentation/How Tos/Calc: Financial functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also) |
(transferred descriptions) |
||
Line 5: | Line 5: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: ACCRINT function|'''ACCRINT''']] | |[[Documentation/How_Tos/Calc: ACCRINT function|'''ACCRINT''']] | ||
− | |Calculates the accrued interest | + | |Calculates the accrued interest for a security with periodic interest payments. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: ACCRINTM function|'''ACCRINTM''']] | |[[Documentation/How_Tos/Calc: ACCRINTM function|'''ACCRINTM''']] | ||
− | |Calculates the accrued interest | + | |Calculates the accrued interest for a security that pays at maturity. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: AMORDEGRC function|'''AMORDEGRC''']] | |[[Documentation/How_Tos/Calc: AMORDEGRC function|'''AMORDEGRC''']] | ||
− | | | + | |Returns depreciation for a settlement period as degressive amortization. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: AMORLINC function|'''AMORLINC''']] | |[[Documentation/How_Tos/Calc: AMORLINC function|'''AMORLINC''']] | ||
− | | | + | |Returns depreciation for a settlement period as linear amortization. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']] | |[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']] | ||
− | |Returns the number of days | + | |Returns the number of days between the coupon date preceding the settlement, and the settlement date. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']] | |[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']] | ||
− | |Returns the number of days in the | + | |Returns the number of days in the coupon period that contains the settlement date. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']] | |[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']] | ||
− | |Returns the number of days | + | |Returns the number of days between the settlement date and the next coupon date. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']] | |[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']] | ||
− | |Returns the date | + | |Returns the coupon date next after the settlement date. |
|-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 | + | |Returns the number of coupons (interest payments) between the settlement date and maturity. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']] | |[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']] | ||
− | |Returns the | + | |Returns the coupon (interest payment) date which precedes the settlement date. |
|-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. |
|-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. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: CUMPRINC function|'''CUMPRINC''']] | |[[Documentation/How_Tos/Calc: CUMPRINC function|'''CUMPRINC''']] | ||
− | |Returns the | + | |Returns the total capital repaid on a loan in specified periods. |
|-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. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: DB function|'''DB''']] | |[[Documentation/How_Tos/Calc: DB function|'''DB''']] | ||
− | |Returns the depreciation of an asset for a given year using the fixed rate declining-balance method. | + | |Returns the depreciation of an asset for a given year using the fixed rate declining-balance method. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: DDB function|'''DDB''']] | |[[Documentation/How_Tos/Calc: DDB function|'''DDB''']] | ||
− | |Returns the depreciation of an asset for a given year using the double (or | + | |Returns the depreciation of an asset for a given year using the double (or other factor) declining-balance method. |
|-valign="top" | |-valign="top" | ||
Line 142: | Line 142: | ||
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']] | |[[Documentation/How_Tos/Calc: NPV function|'''NPV''']] | ||
|Returns the present value of an investment based on a series of periodic cash flows and a discount rate. | |Returns the present value of an investment based on a series of periodic cash flows and a discount rate. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
Line 158: | Line 150: | ||
|[[Documentation/How_Tos/Calc: ODDFYIELD function|'''ODDFYIELD''']] | |[[Documentation/How_Tos/Calc: ODDFYIELD function|'''ODDFYIELD''']] | ||
|Calculates the yield of a security if the first interest date falls irregularly. | |Calculates the yield of a security if the first interest date falls irregularly. | ||
+ | |||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: ODDLPRICE function|'''ODDLPRICE''']] | ||
+ | |Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly. | ||
+ | |||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: ODDLYIELD function|'''ODDLYIELD''']] | ||
+ | |Calculates the yield of a security if the last interest date falls irregularly. | ||
|-valign="top" | |-valign="top" |
Revision as of 11:12, 27 July 2008
Financial Functions
The Financial functions provide common business calculations.
ACCRINT | Calculates the accrued interest for a security with periodic interest payments. |
ACCRINTM | Calculates the accrued interest for a security that pays at maturity. |
AMORDEGRC | Returns depreciation for a settlement period as degressive amortization. |
AMORLINC | Returns depreciation for a settlement period as linear amortization. |
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. |
CUMIPMT | Returns the total interest paid on a loan in specified periods. |
CUMIPMT_ADD | Returns the total interest paid on a loan in specified periods. |
CUMPRINC | Returns the total capital repaid on a loan in specified periods. |
CUMPRINC_ADD | Returns the total capital repaid on a loan in specified periods. |
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. |
DISC | Calculates the allowance (discount) of a security as a percentage. |
DOLLARDE | Converts a quotation that has been given as a decimal fraction into a decimal number. |
DOLLARFR | Converts a quotation that has been given as a decimal number into a mixed decimal fraction. |
DURATION | Calculates the number of periods required by an investment to attain the desired value. |
DURATION_ADD | Calculates the duration of a fixed interest security in years. |
EFFECTIVE | Returns the net annual interest rate for a nominal interest rate. |
EFFECT_ADD | Calculates the effective annual rate of interest on the basis of the nominal interest rate and the number of interest payments per annum. |
FV | Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value). |
FVSCHEDULE | Calculates the accumulated value of the starting capital for a series of periodically varying interest rates. |
INTRATE | Calculates the annual interest rate that results when a security (or other item) is purchased at an investment value and sold at a redemption value. No interest is paid. |
IPMT | Calculates the periodic amortizement for an investment with regular payments and a constant interest rate. |
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). |
ISPMT | Calculates the level of interest for unchanged amortization installments. |
MDURATION | Calculates the modified Macauley duration of a fixed interest security in years. |
MIRR | Calculates the modified internal rate of return of a series of investments. |
NOMINAL | Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year. |
NOMINAL_ADD | Calculates the annual nominal rate of interest on the basis of the effective rate and the number of interest payments per annum. |
NPER | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
NPV | Returns the present value of an investment based on a series of periodic cash flows and a discount rate. |
ODDFPRICE | Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly. |
ODDFYIELD | Calculates the yield of a security if the first interest date falls irregularly. |
ODDLPRICE | Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly. |
ODDLYIELD | Calculates the yield of a security if the last interest date falls irregularly. |
PMT | Returns the periodic payment for an annuity with constant interest rates. |
PPMT | Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate. |
PRICE | Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield. |
PRICEDISC | Calculates the price per 100 currency units of par value of a non-interest- bearing security. |
PRICEMAT | Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date. |
PV | Returns the present value of an investment resulting from a series of regular payments. |
RATE | Returns the constant interest rate per period of an annuity. |
RECEIVED | Calculates the amount received that is paid for a fixed-interest security at a given point in time. |
RRI | Calculates the interest rate resulting from the profit (return) of an investment. |
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. |
TBILLEQ | Calculates the annual return on a treasury bill (). A treasury bill is purchased on the settlement date and sold at the full par value on the maturity date, that must fall within the same year. A discount is deducted from the purchase price. |
TBILLPRICE | Calculates the price of a treasury bill per 100 currency units. |
TBILLYIELD | Calculates the yield of a treasury bill. |
VDB | Returns the depreciation of an asset for a specified or partial period using a variable declining balance method. |
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. |
XNPV | Calculates the capital value (net present value)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. |
YIELD | Calculates the yield of a security. |
YIELDDISC | Calculates the annual yield of a non-interest-bearing security. |
YIELDMAT | Calculates the annual yield of a security, the interest of which is paid on the date of maturity. |