# Excel: Financial Functions

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