Financial Functions

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

Functions
COUPDAYS	COUPDAYBS	COUPDAYSNC	COUPNCD
COUPNUM	COUPPCD	CUMIPMT	CUMPRINC
DB	DDB	DISC	DOLLAR
DOLLARDE	DOLLARFR	DURATION	EFFECT
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.

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.