Microsoft Office Tutorials and References
In Depth Information
CHAPTER 6 Financial Functions
6
CHAPTER
Financial Functions
Financial Functions Overview
Financial functions can be used to calculate house mortgage payments, annuities,
accrued interest, and just about any other financial calculation for which you may
need to calculate future, present, or past values. Excel has more than 50 financial
functions that can operate independently or can be combined with other functions
for a more customized situation. The financial functions are also accompanied by
descriptions of the syntax. This helps in understanding the function as a whole.
Because most of these functions are used with cell referencing in the workbooks,
you can refer to the CD and put numbers, dates, and rates in the corresponding
cells and the formula calculates the outcome for you. You should take note that
when creating functions to return date results, you may have to format the result
in a date format. If the return is in digit format, simply change the cell format
from the Format menu.
The following functions are discussed in this chapter.
ACCRINT
DDB
MIRR
PV
RATE
ACCRINTM
DISC
NOMINAL
AMORDEGRC
DOLLARDE
NPER
RECEIVED
SLN
AMORLINC
DOLLARFR
NPV
ODDFPRIC E
COUPDAYBS
DURATION
SYD
TBILLEQ
COUPDAYS
EFFECT
ODDFYIELD
COUPDAYSNC
FV
ODDLPRICE
TBILLPRICE
TBILLYIELD
COUPNCD
FVSCHEDULE
ODDLYIELD
COUPNUM
INTRATE
PMT
VDB
XIRR
COUPPCD
IPMT
PPMT
CUMIPMT
IRR
PRICE
XNPV
YIELD
CUMPRINC
ISPMT
PRICEDISC
DB
MDURATION
PRICEMAT
YIELDDISC
YIELDMAT
Search JabSto ::




Custom Search