Excel 2000 in a Nutshell

Chapter 12. Financial Functions

Microsoft Excel is most widely used to track and calculate financial information. Excel provides several different functions for making financial calculations easier. The difficulty with these functions is not in using them, but in determining which function produces the desired results. This chapter provides you with descriptions and examples of how and when to use each of the financial functions available in Excel. The “AT” represents those functions that exist only by loading the Analysis Toolpak. See Chapter 11 for details.

The following functions are covered in detail later in this chapter:

ACCRINT AT	EFFECT AT	PRICE AT
ACCRINTM AT	FV	PRICEDISC AT
AMORDEGRC AT	FVSCHEDULE AT	PRICEMAT AT
AMORLINC AT	INTRATE AT	PV AT
COUPDAYBS AT	IPMT	RATE
COUPDAYS AT	IRR	SLN
COUPDAYSNC AT	ISPMT	SYD
COUNCD AT	MDURATION AT	TBILLEQ AT
COUPNUM AT	MIRR	TBILLPRICE AT
COUPPCD AT	NOMINALAT	TBILLYIELD AT
CUMIPMT AT	NPER	VBD
CUMPRINC AT	NPV	XIRR AT
DB	ODDFPRICE AT	XNPV AT
DDB	ODDFYIELDAT	YIELDAT
DISC AT	ODDLPRICE AT	YIELDDISC AT
DOLLARDE AT	ODDLYIELD AT	YIELDMAT AT
DOLLARFR AT	PMT
DURATION AT	PPMT

Use these functions if you need to do the following:

• Calculate the depreciation of an asset

• Determine the amount of interest paid on an investment

• Figure out the current value of an investment

• Determine the amount of income (yield) on a security or a Treasury Bill

Understanding the Financial Jargon ...