O'Reilly logo

Excel 2003: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Other Financial Functions

Excel includes dozens more financial functions as part of the Analysis ToolPak add-in (Section 7.2.4). Most of these are used by people like stock brokers, bond traders, and chief financial officers, who regularly depend on the functions' ability to deal with complex financial transaction procedures. Table 9-1 provides a quick overview.

Tip

For more info on non-Excel-specific investing, depreciation, and financial concepts, check out http://beginnersinvest.about.com/od/investinglessons/.

Table 9-1. Specialized Financial Functions

Function

Description

ACCRINT( )

Returns the accrued interest for a security that pays periodic interest.

ACCRINTM( )

Returns the accrued interest for a security that pays interest at maturity.

AMORDEGRC( )

Returns the depreciation for each accounting period.

COUPDAYBS( )

Returns the number of days from the beginning of the coupon period to the settlement date.

COUPDAYS( )

Returns the number of days in the coupon period that contains the settlement date.

COUPDAYSNC( )

Returns the number of days from the settlement date to the next coupon date.

COUPNCD( )

Returns the next coupon date after the settlement date.

COUPNUM( )

Returns the number of coupons payable between the settlement date and maturity date.

COUPPCD( )

Returns the previous coupon date before the settlement date.

DISC( )

Returns the discount rate for a security.

DURATION( )

Returns the annual duration of a security with periodic ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required