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 ...

Get Excel 2000 in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.