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.