Section 9.4. Other Financial Functions

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.