FR/Documentation/Calc: Fonctions financieres Financial functions
From Apache OpenOffice Wiki
Fonctions financières
Les fonctions financièrent fournissent des fonctions de calcul habituelles dans le monde financier.
Amortissement | |
AMORDEGRC | Renvoie le montant de l'amortissement pour une période comptable en utilisant un amortissement dégressif (système français). |
AMORLINC | Renvoie le montant de l'amortissement pour une période comptable en utilisant un amortissement linéaire (système français). |
DB | Renvoie l'amortissement d'un actif pour une année donnée suivant la méthode de l'amortissement dégressif à taux double. |
DDB | Renvoie l'amortissement d'un actif pour une année donnée suivant la méthode de l'amortissement dégressif à taux double ou d'autres facteurs. |
AMORLIN | Renvoie l'amortissement d'un actif pour une période unique suivant la méthode d'amortissement constant. |
SYD | Renvoie l'amortissement d'un actif pour une période donnée en utilisant la méthode de réduction du montant de l'amortissement d'une période à l'autre d'un montant constant. |
VDB | Renvoie l'amortissement d'un actif pour une période donnée suivant la méthode de l'amortissement dégressif à taux variable. |
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
Derivation of Financial Formulas
Functions listed alphabetically, Functions listed by category