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

Investment Value Functions

Function Usefulness Power Complexity
FV
FVSCHEDULE
NPV
PV
RECEIVED
XNPV

Payment Functions

Function Usefulness Power Complexity
CUMIPMT
CUMPRINC
IPMT
ISPMT
PMT
PPMT

Interest Functions

Function Usefulness Power Complexity
ACCRINT
ACCRINTM
DISC
EFFECT
INTRATE
NOMINAL
RATE

IRR Functions

Function Usefulness Power Complexity
IRR
MIRR
XIRR

Depreciation Functions

Function Usefulness Power Complexity
AMORDEGRC
AMORLINC
DB
DDB
SLN
SYD
VDB

Bond Price Functions

Function Usefulness Power Complexity
ODDFPRICE
ODDLPRICE
PRICE
PRICEDISC
PRICEMAT
TBILLPRICE

Bond Yield Functions

Function Usefulness Power Complexity
ODDFYIELD
ODDLYIELD
TBILLEQ
TBILLYIELD
YIELD
YIELDDISC
YIELDMAT

Bond Duration Functions

Function Usefulness Power Complexity
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
DURATION
MDURATION
NPER

Dollar Conversion Functions

Function Usefulness Power Complexity
DOLLARDE
DOLLARFR
#1)
Using a Financial function:
Using a Financial Excel 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.