Functions in English | Functions in French | Description of Function |
---|
ACCRINT | INTERET.ACC | Returns the accrued interest for a security that pays periodic interest. |
ACCRINTM | INTERET.ACC.MAT | Returns the accrued interest for a security that pays interest at maturity. |
AMORDEGRC | AMORDEGRC | Returns the depreciation for each accounting period by using a depreciation coefficient. |
AMORLINC | AMORLINC | Returns the depreciation for each accounting period. |
COUPDAYBS | NB.JOURS.COUPON.PREC | Returns the number of days from the beginning of the coupon period to the settlement date. |
COUPDAYS | NB.JOURS.COUPONS | Returns the number of days in the coupon period that contains the settlement date. |
COUPDAYSNC | NB.JOURS.COUPON.SUIV | Returns the number of days from the settlement date to the next coupon date. |
COUPNCD | DATE.COUPON.SUIV | Returns the next coupon date after the settlement date. |
COUPNUM | NB.COUPONS | Returns the number of coupons payable between the settlement date and maturity date. |
COUPPCD | DATE.COUPON.PREC | Returns the previous coupon date before the settlement date. |
CUMIPMT | CUMUL.INTER | Returns the cumulative interest paid between two periods. |
CUMPRINC | CUMUL.PRINCPER | Returns the cumulative principal paid on a loan between two periods. |
DB | DB | Returns the depreciation of an asset for a specified period by using the fixed-declining balance method. |
DDB | DDB | Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify. |
DISC | TAUX.ESCOMPTE | Returns the discount rate for a security. |
DOLLARDE | PRIX.DEC | Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. |
DOLLARFR | PRIX.FRAC | Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction. |
DURATION | DUREE | Returns the annual duration of a security with periodic interest payments. |
Functions in English | Functions in French | Description of Function |
---|
EFFECT | TAUX.EFFECTIF | Returns the effective annual interest rate. |
FV | VC | Returns the future value of an investment. |
FVSCHEDULE | VC.PAIEMENTS | Returns the future value of an initial principal after applying a series of compound interest rates. |
INTRATE | TAUX.INTERET | Returns the interest rate for a fully invested security. |
IPMT | INTPER | Returns the interest payment for an investment for a given period. |
IRR | TRI | Returns the internal rate of return for a series of cash flows. |
ISPMT | ISPMT | Calculates the interest paid during a specific period of an investment. |
MDURATION | DUREE.MODIFIEE | Returns the Macauley modified duration for a security with an assumed par value of $100. |
MIRR | TRIM | Returns the internal rate of return where positive and negative cash flows are financed at different rates. |
NOMINAL | TAUX.NOMINAL | Returns the annual nominal interest rate. |
NPER | NPM | Returns the number of periods for an investment. |
NPV | VAN | Returns the net present value of an investment based on a series of periodic cash flows and a discount rate. |
ODDFPRICE | PRIX.PCOUPON.IRREG | Returns the price per $100 face value of a security with an odd first period. |
ODDFYIELD | REND.PCOUPON.IRREG | Returns the yield of a security with an odd first period. |
ODDLPRICE | PRIX.DCOUPON.IRREG | Returns the price per $100 face value of a security with an odd last period. |
ODDLYIELD | REND.DCOUPON.IRREG | Returns the yield of a security with an odd last period. |
PDURATION | PDUREE | Returns the number of periods required by an investment to reach a specified value (2013). |
PMT | VPM | Returns the periodic payment for an annuity. |
PPMT | PRINCPER | Returns the payment on the principal for an investment for a given period. |
PRICE | PRIX.TITRE | Returns the price per $100 face value of a security that pays periodic interest. |
PRICEDISC | VALEUR.ENCAISSEMENT | Returns the price per $100 face value of a discounted security. |
PRICEMAT | PRIX.TITRE.ECHEANCE | Returns the price per $100 face value of a security that pays interest at maturity. |
PV | VA | Returns the present value of an investment. |
RATE | TAUX | Returns the interest rate per period of an annuity. |
RECEIVED | VALEUR.NOMINALE | Returns the amount received at maturity for a fully invested security. |
RRI | TAUX.INT.EQUIV | Returns an equivalent interest rate for the growth of an investment (2013). |
SLN | AMORLIN | Returns the straight-line depreciation of an asset for one period. |
SYD | SYD | Returns the sum-of-years' digits depreciation of an asset for a specified period. |
TBILLEQ | TAUX.ESCOMPTE.R | Returns the bond-equivalent yield for a Treasury bill. |
TBILLPRICE | PRIX.BON.TRESOR | Returns the price per $100 face value for a Treasury bill. |
TBILLYIELD | RENDEMENT.BON.TRESOR | Returns the yield for a Treasury bill. |
VDB | VDB | Returns the depreciation of an asset for a specified or partial period by using a declining balance method. |
XIRR | TRI.PAIEMENTS | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. |
XNPV | VAN.PAIEMENTS | Returns the net present value for a schedule of cash flows that is not necessarily periodic. |
YIELD | RENDEMENT.TITRE | Returns the yield on a security that pays periodic interest. |
YIELDDISC | RENDEMENT.SIMPLE | Returns the annual yield for a discounted security; for example, a Treasury bill. |
YIELDMAT | RENDEMENT.TITRE.ECHEANCE | Returns the annual yield of a security that pays interest at maturity. |