There are 53 financial functions varying in usefulness, power and potential complexity.

Function | Usefulness | Power | Complexity |
---|---|---|---|

ACCRINT | |||

ACCRINTM | |||

AMORDEGRC | |||

AMORLINC | |||

COUPDAYBS | |||

COUPDAYS | |||

COUPDAYSNC | |||

COUPNCD | |||

COUPNUM | |||

COUPPCD | |||

CUMIPMT | |||

CUMPRINC | |||

DB | |||

DDB | |||

DISC | |||

DOLLARDE | |||

DOLLARFR | |||

DURATION | |||

EFFECT | |||

FV | |||

FVSCHEDULE | |||

INTRATE | |||

IPMT | |||

IRR | |||

ISPMT | |||

MDURATION | |||

MIRR | |||

NOMINAL | |||

NPER | |||

NPV | |||

ODDFPRICE | |||

ODDFYIELD | |||

ODDLPRICE | |||

ODDLYIELD | |||

PMT | |||

PPMT | |||

PRICE | |||

PRICEDISC | |||

PRICEMAT | |||

PV | |||

RATE | |||

RECEIVED | |||

SLN | |||

SYD | |||

TBILLEQ | |||

TBILLPRICE | |||

TBILLYIELD | |||

VDB | |||

XIRR | |||

XNPV | |||

YIELD | |||

YIELDDISC | |||

YIELDMAT |

#### Interest Functions

#### Bond Price Functions

#### Bond Yield Functions

#### Bond Duration Functions

##### Using a Financial function:

### Summary

Excel's financial functions range from complex and obscure functions provided to assist sophisticated investors and financial professionals to more basic functions useful to an individual preparing a simple personal budget or home loan calculation.