Cheatography

# Excel Built in Financial Functions Cheat Sheet (DRAFT) by [deleted]

Use these funtions to calculate financial values

This is a draft cheat sheet. It is a work in progress and is not finished yet.

### Excel Built-in Financial Functions (A-M)

 Function Desc­rip­tion ACCR­INT Returns the accrued interest for a security that pays periodic interest ACCR­INTM Returns the accrued interest for a security that pays interest at maturity AMORDEGRC Returns the deprec­iation for each accounting period by using a deprec­iation coeffi­cient AMOR­LINC Returns the deprec­iation for each accounting period COUP­DAYBS Returns the number of days from the beginning of the coupon period to the settlement date COUP­DAYS Returns the number of days in the coupon period that contains the settlement date COUP­DAY­SNC Returns the number of days from the settlement date to the next coupon date COUPNCD Returns the next coupon date after the settlement date COUP­NUM Returns the number of coupons payable between the settlement date and maturity date COUP­PCD Returns the previous coupon date before the settlement date CUMI­PMT Returns the cumulative interest paid between two periods CUMP­RINC Returns the cumulative principal paid on a loan between two periods DB Returns the deprec­iation of an asset for a specified period by using the fixed-­dec­lining balance method DDB Returns the deprec­iation of an asset for a specified period by using the double­-de­clining balance method or some other method that you specify DISC Returns the discount rate for a security DOLL­ARDE Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number DOLL­ARFR Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction DURATION Returns the annual duration of a security with periodic interest payments EFFECT Returns the effective annual interest rate FV Returns the future value of an investment FVSC­HEDULE Returns the future value of an initial principal after applying a series of compound interest rates INTR­ATE Returns the interest rate for a fully invested security IPMT Returns the interest payment for an investment for a given period IRR Returns the internal rate of return for a series of cash flows ISPMT Calculates the interest paid during a specific period of an investment MDUR­ATION 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

### Excel Built-in Financial Functions (N-Z)

 Function Desc­rip­tion NOMI­NAL Returns the annual nominal interest rate NPER Returns the number of periods for an investment NPV Returns the net present value of an investment based on a series of periodic cash flows and a discount 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 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 PMT Returns the periodic payment for an annuity PPMT Returns the payment on the principal for an investment for a given 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 PV Returns the present value of an investment RATE Returns the interest rate per period of an annuity RECE­IVED Returns the amount received at maturity for a fully invested security SLN Returns the straig­ht-line deprec­iation of an asset for one period SYD Returns the sum-of­-years’ digits deprec­iation of an asset for a specified period TBIL­LEQ Returns the bond-e­qui­valent yield for a Treasury bill TBIL­LPR­ICE Returns the price per \$100 face value for a Treasury bill TBILLYIELD Returns the yield for a Treasury bill VDB Returns the deprec­iation of an asset for a specified or partial period by using a declining balance method XIRR Returns the internal rate of return for a schedule of cash flows that is not necess­arily periodic XNPV Returns the net present value for a schedule of cash flows that is not necess­arily periodic YIELD Returns the yield on a security that pays periodic interest YIELDDISC Returns the annual yield for a discounted security; for example, a Treasury bill YIELDMAT Returns the annual yield of a security that pays interest at maturity