Spread Formula Reference
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 PMT PPMT PRICE
PRICEDISC PRICEMAT PV RATE
RECEIVED 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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options