Spread Formula Reference
Financial Functions
Formula Overview > Functions in a Formula > Categories of Functions > Financial Functions

The functions that relate to financial calculations such as interest calculations are:

ACCRINT ACCRINTM AMORDEGRC AMORLINC
COUPDAYS COUPDAYBS COUPDAYSNC COUPNCD
COUPNUM COUPPCD CUMIPMT CUMPRINC
DB DDB DISC DOLLAR
DOLLARDE DOLLARFR DURATION EFFECT
EURO EUROCONVERT FV FVSCHEDULE
INTRATE IPMT IRR ISPMT
MDURATION MIRR NOMINAL NPER
NPV ODDFPRICE ODDFYIELD ODDLPRICE
ODDLYIELD PDURATION PMT PPMT
PRICE PRICEDISC PRICEMAT PV
RATE RECEIVED RRI SLN
SYD TBILLEQ TBILLPRICE TBILLYIELD
VDB XIRR XNPV YIELD
YIELDDISC YIELDMAT    

For the financial functions that use it, refer to Day Count Basis.

Return to the list of Categories of Functions.

For the arguments of some of these functions and for the results of some of these functions, money paid out is represented by negative numbers and money you receive is represented by positive numbers. How the currency values are displayed depends upon how you set up the cell type and the format settings.