# Financial Functions and Formulas in Excel

Microsoft Excel comes with many built-in financial functions. This page lists **all of the financial formulas that are available**, including those in the Analysis ToolPak. There is extensive help for each of the functions, including examples of how the formula can be used. To see a list of all the financial functions in Excel, go to Insert > Function to open the insert function wizard. Select the Financial category, choose a function, and then click on the Help button/link. Another approach is to press F1 in Excel to open the Help window, then type "**financial functions**" into the Answer Wizard.

See also: Financial Modeling with Excel Spreadsheets

## Financial Formulas - by Category

For convenience, I've listed all of the Excel Financial functions, with a * next those that are only available after installing the Analysis ToolPak (To install, go to Tools > Add-ins > and select Analysis ToolPak).

### Depreciation Formulas

**DB**- Fixed-**D**eclining**B**alance (see Depreciation Calculator)**DDB**-**D**ouble-**D**eclining**B**alance**SLN**-**S**traight-**L**ine**D**epreciation**SYD**-**S**um-of-**Y**ears'**D**igits**VDB**-**V**ariable**D**eclining**B**alance- *
**AMORLINC**- (for the French accounting system) Depreciation for each accounting period - *
**AMORDEGRC**- (for the French accounting system) Uses a depreciation coefficient

### Formulas for Interest, Cash Flow, Investments, Annuities

- *
**CUMIPMT**-**C**umulative**I**nterest**P**ay**m**e**n**t - *
**CUMPRINC**-**C**umulative**Princ**ipal - *
**EFFECT**-**Effect**ive annual interest rate **FV**-**F**uture**V**alue of an investment (see Compound Interest Formula)- *
**FVSCHEDULE**-**F**uture**V**alue with a variable rate **IPMT**-**I**nterest**P**ay**m**e**n**t for an investment or loan**IRR**-**I**nternal**R**ate of**R**eturn**ISPMT**-**I**nterest**P**ay**m**e**n**t during a**S**pecific period (for compatibility with Lotus)**MIRR**-**M**odified**I**nternal**R**ate of**R**eturn**NPER**-**N**umber of**Per**iods for an investment or loan**NPV**-**N**et**P**resent**V**alue formula (see NPV Calculator)**PMT**- Periodic**P**ay**m**e**n**t for an annuity**PPMT**-**P**ay**m**e**n**t on the**P**rincipal for an annuity or loan**PV**-**P**resent**V**alue of an investment**RATE**- Interest**rate**per period- *
**XIRR**-**I**nternal**R**ate of**R**eturn (not necessarily periodic) (see the Investment Tracker for an example use) - *
**XNPV**-**N**et**P**resent**V**alue (not necessarily periodic)

Download the Simple Loan Calculator to see how to use the PMT, NPER, PV, and RATE functions.

### Functions for Coupons

- *
**COUPDAYBS**-**Day**s from the**B**eginning of the Coupon period to the**S**ettlement date - *
**COUPDAYS**-**Day**s in the coupon period that contains the**S**ettlement date - *
**COUPDAYSNC**-**Day**s from the**S**ettlement date to the**N**ext**C**oupon date - *
**COUPNCD**-**N**ext**C**oupon**D**ate after the settlement date - *
**COUPPCD**-**P**revious**C**oupon**D**ate before the settlement date - *
**COUPNUM**-**Num**ber of coupons between the settlement and maturity date

### Finance Formulas for Securities

- *
**ACCRINT**-**Accr**ued**Int**erest - *
**ACCRINTM**-**Accr**ued**Int**erest at**M**aturity - *
**DISC**-**Disc**ount rate - *
**DURATION**- Annual**Duration** - *
**INTRATE**-**Int**erest**rate**for a fully invested security - *
**MDURATION**-**M**acauley modified**duration**(with an assumed par value of $100) - *
**NOMINAL**- Annual**nominal**interest rate - *
**ODDFPRICE**-**Price**per $100 face value with an**Odd****F**irst period - *
**ODDFYIELD**-**Yield**with an**Odd****F**irst period - *
**ODDLPRICE**-**Price**per $100 face value with an**Odd****L**ast period - *
**ODDLYIELD**-**Yield**with an**Odd****L**ast period - *
**PRICE**-**Price**per $100 face value - *
**PRICEDISC**-**Price**per $100 face value of a**Disc**ounted security - *
**PRICEMAT**-**Price**per $100 face value of a security that pays interest at**Mat**urity - *
**RECEIVED**- Amount**received**at maturity for a fully invested security - *
**YIELD**-**Yield**on a security that pays periodic interest - *
**YIELDDISC**- Annual**yield**for a**disc**ounted security (Treasury bill) - *
**YIELDMAT**- Annual**yield**of a security that pays interest at**mat**urity

### Formulas for Dollar Price Conversions

- *
**DOLLARDE**- Converts a**dollar**price from a Fraction to a**De**cimal number - *
**DOLLARFR**- Converts a**dollar**price from a Decimal number to a**Fr**action

### Treasury Bill Functions

- *
**TBILLEQ**- Bond-**eq**uivalent yield for a**T**reasury**Bill** - *
**TBILLPRICE**-**Price**per $100 face value for a**T**reasury**Bill** - *
**TBILLYIELD**-**Yield**for a**T**reasury**Bill**

**Disclaimer**: This article is meant for educational purposes only.