Section 9.4. Other Financial Functions

9.4. 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 interest payments.

FVSCHEDULE( )

Returns the future value of an initial principal after applying a series of compound interest rates.

INTRATE( )

Returns the interest rate for a fully invested security.

MDURATION( )

Returns the Macauley modified duration for a security with an assumed par value of $100.

MIRR( )

Returns the internal rate of return where positive and negative cash flows are financed at different rates.

NOMINAL( )

Returns the annual nominal interest rate.

ODDFPRICE( )

Returns the price per $100 face value of a security with an odd first period.

ODDFYIELD( )

Returns the yield of a security with an odd first period.

ODDLPRICE( )

Returns the price per $100 face value of a security with an odd last period.

ODDLYIELD( )

Returns the yield of a security with an odd last period.

PRICE( )

Returns the price per $100 face value of a security that pays periodic interest.

PRICEDISC( )

Returns the price per $100 face value of a discounted security.

PRICEMAT( )

Returns the price per $100 face value of a security that pays interest at maturity.

RECEIVED( )

Returns the amount received at maturity for a fully invested security.

TBILLEQ( )

Returns the bond-equivalent yield for a Treasury bill.

TBILLPRICE( )

Returns the price per $100 face value for a Treasury bill.

TBILLYIELD( )

Returns the yield for a Treasury bill.

VDB( )

Returns the depreciation of an asset for a specified or partial period using a declining balance method.

YIELD( )

Returns the yield on a security that pays periodic interest.

YIELDDISC( )

Returns the annual yield for a discounted security, like a Treasury bill.

YIELDMAT( )

Returns the annual yield of a security that pays interest at maturity.




Excel. The Missing Manual
Excel 2010: The Missing Manual
ISBN: 1449382355
EAN: 2147483647
Year: 2003
Pages: 185

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net