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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
(-> alphabetic order)
Line 5: Line 5:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: AMORDEGRC function|'''AMORDEGRC''']]
 
|[[Documentation/How_Tos/Calc: AMORDEGRC function|'''AMORDEGRC''']]
−
|Calculates the amount of depreciation for a settlement period as degressive amortization. Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here.
+
|Calculates the amount of 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''']]
−
|Calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered.
+
|Calculates the amount of depreciation for a settlement period as linear amortization.
  
 
|-valign="top"
 
|-valign="top"
Line 20: Line 20:
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]
+
|[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']]
−
|Calculates the amount received that is paid for a fixed-interest security at a given point in time.
+
|Returns the number of days in the current interest period in which the settlement date falls.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PV function|'''PV''']]
+
|[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']]
−
|Returns the present value of an investment resulting from a series of regular payments.
+
|Returns the number of days from the settlement date until the next interest date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: SYD function|'''SYD''']]
+
|[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']]
−
|Returns the arithmetic-declining depreciation rate.
+
|Returns the number of days from the first day of interest payment on a security until the settlement date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
+
|[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']]
−
|Calculates the allowance (discount) of a security as a percentage.
+
|Returns the date of the first interest date after the settlement date. Format the result as a date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
+
|[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]
−
|Calculates the duration of a fixed interest security in years.
+
|Returns the number of coupons (interest payments) between the settlement date and the maturity date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
+
|[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']]
−
|Returns the net annual interest rate for a nominal interest rate.
+
|Returns the date of the interest date prior to the settlement date. Format the result as a date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
+
|[[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']]
−
|Calculates the effective annual rate of interest on the basis of the nominal interest rate and the number of interest payments per annum.
+
|Calculates the cumulative interest payments, that is, the total interest, for an investment based on a constant interest rate.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DDB function|'''DDB''']]
+
|[[Documentation/How_Tos/Calc: CUMIPMT_ADD function|'''CUMIPMT_ADD''']]
−
|Returns the depreciation of an asset for a specified period using the arithmetic-declining method.
+
|Calculates the accumulated interest for a period.
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: DB function|'''DB''']]
+
−
|Returns the depreciation of an asset for a specified period using the double-declining balance method.
+
−
 
+
−
|-valign="top"
+
−
|[[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).
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: ISPMT function|'''ISPMT''']]
+
−
|Calculates the level of interest for unchanged amortization installments.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: PPMT function|'''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.
+
  
 
|-valign="top"
 
|-valign="top"
Line 76: Line 60:
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']]
+
|[[Documentation/How_Tos/Calc: DB function|'''DB''']]
−
|Calculates the cumulative interest payments, that is, the total interest, for an investment based on a constant interest rate.
+
|Returns the depreciation of an asset for a specified period using the double-declining balance method.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CUMIPMT_ADD function|'''CUMIPMT_ADD''']]
+
|[[Documentation/How_Tos/Calc: DDB function|'''DDB''']]
−
|Calculates the accumulated interest for a period.
+
|Returns the depreciation of an asset for a specified period using the arithmetic-declining method.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PRICE function|'''PRICE''']]
+
|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
−
|Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield.
+
|Calculates the allowance (discount) of a security as a percentage.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PRICEDISC function|'''PRICEDISC''']]
+
|[[Documentation/How_Tos/Calc: DOLLARDE function|'''DOLLARDE''']]
−
|Calculates the price per 100 currency units of par value of a non-interest- bearing security.
+
|Converts a quotation that has been given as a decimal fraction into a decimal number.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PRICEMAT function|'''PRICEMAT''']]
+
|[[Documentation/How_Tos/Calc: DOLLARFR function|'''DOLLARFR''']]
−
|Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date.
+
|Converts a quotation that has been given as a decimal number into a mixed decimal fraction.
  
 
|-valign="top"
 
|-valign="top"
Line 100: Line 84:
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: SLN function|'''SLN''']]
+
|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
−
|Returns the straight-line depreciation of an asset for one period.The amount of the depreciation is constant during the depreciation period.
+
|Calculates the duration of a fixed interest security in years.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]
+
|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
−
|Calculates the modified Macauley duration of a fixed interest security in years.
+
|Returns the net annual interest rate for a nominal interest rate.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
+
|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
−
|Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of the project (the initial cash flow at time zero) from the returned value.
+
|Calculates the effective annual rate of interest on the basis of the nominal interest rate and the number of interest payments per annum.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NOMINAL function|'''NOMINAL''']]
+
|[[Documentation/How_Tos/Calc: FV function|'''FV''']]
−
|Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year.
+
|Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NOMINAL_ADD function|'''NOMINAL_ADD''']]
+
|[[Documentation/How_Tos/Calc: FVSCHEDULE function|'''FVSCHEDULE''']]
−
|Calculates the annual nominal rate of interest on the basis of the effective rate and the number of interest payments per annum.
+
|Calculates the accumulated value of the starting capital for a series of periodically varying interest rates.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DOLLARFR function|'''DOLLARFR''']]
+
|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
−
|Converts a quotation that has been given as a decimal number into a mixed decimal fraction.
+
|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.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DOLLARDE function|'''DOLLARDE''']]
+
|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
−
|Converts a quotation that has been given as a decimal fraction into a decimal number.
+
|Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
+
|[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]
−
|Calculates the modified internal rate of return of a series of investments.
+
|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).
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
+
|[[Documentation/How_Tos/Calc: ISPMT function|'''ISPMT''']]
−
|Calculates the yield of a security.
+
|Calculates the level of interest for unchanged amortization installments.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
+
|[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]
−
|Calculates the annual yield of a non-interest-bearing security.
+
|Calculates the modified Macauley duration of a fixed interest security in years.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]
+
|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
−
|Calculates the annual yield of a security, the interest of which is paid on the date of maturity.
+
|Calculates the modified internal rate of return of a series of investments.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PMT function|'''PMT''']]
+
|[[Documentation/How_Tos/Calc: NOMINAL function|'''NOMINAL''']]
−
|Returns the periodic payment for an annuity with constant interest rates.
+
|Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TBILLEQ function|'''TBILLEQ''']]
+
|[[Documentation/How_Tos/Calc: NOMINAL_ADD function|'''NOMINAL_ADD''']]
−
|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.
+
|Calculates the annual nominal rate of interest on the basis of the effective rate and the number of interest payments per annum.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TBILLPRICE function|'''TBILLPRICE''']]
+
|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
−
|Calculates the price of a treasury bill per 100 currency units.
+
|Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TBILLYIELD function|'''TBILLYIELD''']]
+
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
−
|Calculates the yield of a treasury bill.
+
|Returns the present value of an investment based on a series of periodic cash flows and a discount rate.
 +
 
 +
|-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"
Line 168: Line 160:
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: ODDLPRICE function|'''ODDLPRICE''']]
+
|[[Documentation/How_Tos/Calc: PMT function|'''PMT''']]
−
|Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly.
+
|Returns the periodic payment for an annuity with constant interest rates.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: ODDLYIELD function|'''ODDLYIELD''']]
+
|[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']]
−
|Calculates the yield of a security if the last interest date falls irregularly.
+
|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.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: VDB function|'''VDB''']]
+
|[[Documentation/How_Tos/Calc: PRICE function|'''PRICE''']]
−
|Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.
+
|Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]
+
|[[Documentation/How_Tos/Calc: PRICEDISC function|'''PRICEDISC''']]
−
|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 price per 100 currency units of par value of a non-interest- bearing security.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
+
|[[Documentation/How_Tos/Calc: PRICEMAT function|'''PRICEMAT''']]
−
|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.
+
|Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]
+
|[[Documentation/How_Tos/Calc: PV function|'''PV''']]
−
|Calculates the interest rate resulting from the profit (return) of an investment.
+
|Returns the present value of an investment resulting from a series of regular payments.
  
 
|-valign="top"
 
|-valign="top"
Line 196: Line 188:
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
+
|[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]
−
|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.
+
|Calculates the amount received that is paid for a fixed-interest security at a given point in time.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']]
+
|[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]
−
|Returns the date of the first interest date after the settlement date. Format the result as a date.
+
|Calculates the interest rate resulting from the profit (return) of an investment.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']]
+
|[[Documentation/How_Tos/Calc: SLN function|'''SLN''']]
−
|Returns the number of days in the current interest period in which the settlement date falls.
+
|Returns the straight-line depreciation of an asset for one period.The amount of the depreciation is constant during the depreciation period.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']]
+
|[[Documentation/How_Tos/Calc: TBILLEQ function|'''TBILLEQ''']]
−
|Returns the number of days from the settlement date until the next interest date.
+
|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.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']]
+
|[[Documentation/How_Tos/Calc: TBILLPRICE function|'''TBILLPRICE''']]
−
|Returns the number of days from the first day of interest payment on a security until the settlement date.
+
|Calculates the price of a treasury bill per 100 currency units.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']]
+
|[[Documentation/How_Tos/Calc: TBILLYIELD function|'''TBILLYIELD''']]
−
|Returns the date of the interest date prior to the settlement date. Format the result as a date.
+
|Calculates the yield of a treasury bill.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]
+
|[[Documentation/How_Tos/Calc: SYD function|'''SYD''']]
−
|Returns the number of coupons (interest payments) between the settlement date and the maturity date.
+
|Returns the arithmetic-declining depreciation rate.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
+
|[[Documentation/How_Tos/Calc: VDB function|'''VDB''']]
−
|Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.
+
|Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FV function|'''FV''']]
+
|[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]
−
|Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).
+
|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.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FVSCHEDULE function|'''FVSCHEDULE''']]
+
|[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
−
|Calculates the accumulated value of the starting capital for a series of periodically varying interest rates.
+
|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.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
+
|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
−
|Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
+
|Calculates the yield of a security.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
 +
|Calculates the annual yield of a non-interest-bearing security.
 +
 
 +
|-valign="top"
 +
|[[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.
 
|}
 
|}
 
<br style="clear:both;" />
 
<br style="clear:both;" />

Revision as of 06:43, 16 March 2008

Financial Functions

The Financial functions provide common business calculations.

AMORDEGRC Calculates the amount of depreciation for a settlement period as degressive amortization.
AMORLINC Calculates the amount of depreciation for a settlement period as linear amortization.
ACCRINT Calculates the accrued interest of a security in the case of periodic payments.
ACCRINTM Calculates the accrued interest of a security in the case of one-off payment at the settlement date.
COUPDAYS Returns the number of days in the current interest period in which the settlement date falls.
COUPDAYSNC Returns the number of days from the settlement date until the next interest date.
COUPDAYBS Returns the number of days from the first day of interest payment on a security until the settlement date.
COUPNCD Returns the date of the first interest date after the settlement date. Format the result as a date.
COUPNUM Returns the number of coupons (interest payments) between the settlement date and the maturity date.
COUPPCD Returns the date of the interest date prior to the settlement date. Format the result as a date.
CUMIPMT Calculates the cumulative interest payments, that is, the total interest, for an investment based on a constant interest rate.
CUMIPMT_ADD Calculates the accumulated interest for a period.
CUMPRINC Returns the cumulative interest paid for an investment period with a constant interest rate.
CUMPRINC_ADD Calculates the cumulative redemption of a loan in a period.
DB Returns the depreciation of an asset for a specified period using the double-declining balance method.
DDB Returns the depreciation of an asset for a specified period using the arithmetic-declining 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.
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.
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.
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 straight-line depreciation of an asset for one period.The amount of the depreciation is constant during the depreciation period.
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.
SYD Returns the arithmetic-declining depreciation rate.
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.


See also

Functions listed by category

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Financial_functions&oldid=70367"
Personal tools