| 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. |