Excel Spreadsheets Functions: Financial

6137494695 
Tips and Ideas on Excel 
Tips and Ideas on Macros 
This page is offered to you as reference Click here for more on the interesting Excel spreadsheets functions of financial category 
Excel Lesson 24D of 24: Excel Spreadsheets Financial Functions (53)Here is the list of the 53 functions of the financial category. Follow the links below to discover formulas using 4 of them. 

Importance  Functions  What it Does 
Specialized  FV  Returns the future value of an investment 
Specialized  NPER  Returns the number of periods for an investment 
Specialized  PMT  Returns the periodic payment for an annuity 
Specialized  RATE  Returns the interest rate per period of an annuity 
Specialized  ACCRINT  Returns the accrued interest for a security that pays periodic interest 
Specialized  ACCRINTM  Returns the accrued interest for a security that pays interest at maturity 
Specialized  AMORDEGRC  Returns the depreciation for each accounting period by using a depreciation coefficient 
Specialized  AMORLINC  Returns the depreciation for each accounting period 
Specialized  COUPDAYBS  Returns the number of days from the beginning of the coupon period to the settlement date 
Specialized  COUPDAYS  Returns the number of days in the coupon period that contains the settlement date 
Specialized  COUPDAYSNC  Returns the number of days from the settlement date to the next coupon date 
Specialized  COUPNCD  Returns the next coupon date after the settlement date 
Specialized  COUPNUM  Returns the number of coupons payable between the settlement date and maturity date 
Specialized  COUPPCD  Returns the previous coupon date before the settlement date 
Specialized  CUMIPMT  Returns the cumulative interest paid between two periods 
Specialized  CUMPRINC  Returns the cumulative principal paid on a loan between two periods 
Specialized  DB  Returns the depreciation of an asset for a specified period using the fixeddeclining balance method 
Specialized  DDB  Returns the depreciation of an asset for a specified period using the doubledeclining balance method or some other method you specify 
Specialized  DISC  Returns the discount rate for a security 
Specialized  DOLLARDE  Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number 
Specialized  DOLLARFR  Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction 
Specialized  DURATION  Returns the annual duration of a security with periodic interest payments 
Specialized  EFFECT  Returns the effective annual interest rate 
Specialized  FVSCHEDULE  Returns the future value of an initial principal after applying a series of compound interest rates 
Specialized  INTRATE  Returns the interest rate for a fully invested security 
Specialized  IPMT  Returns the interest payment for an investment for a given period 
Specialized  IRR  Returns the internal rate of return for a series of cash flows 
Specialized  ISPMT  Returns the interest paid during a specific period of an investment 
Specialized  MDURATION  Returns the Macauley modified duration for a security with an assumed par value of $100 
Specialized  MIRR  Returns the internal rate of return where positive and negative cash flows are financed at different rates 
Specialized  NOMINAL  Returns the annual nominal interest rate 
Specialized  NPV  Returns the net present value of an investment based on a series of periodic cash flows and a discount rate 
Specialized  ODDFPRICE  Returns the price per $100 face value of a security with an odd first period 
Specialized  ODDFYIELD  Returns the yield of a security with an odd first period 
Specialized  ODDLPRICE  Returns the price per $100 face value of a security with an odd last period 
Specialized  ODDLYIELD  Returns the yield of a security with an odd last period 
Specialized  PPMT  Returns the payment on the principal for an investment for a given period 
Specialized  PRICE  Returns the price per $100 face value of a security that pays periodic interest 
Specialized  PRICEDISC  Returns the price per $100 face value of a discounted security 
Specialized  PRICEMAT  Returns the price per $100 face value of a security that pays interest at maturity 
Specialized  PV  Returns the present value of an investment 
Specialized  RECEIVED  Returns the amount received at maturity for a fully invested security 
Specialized  SLN  Returns the straightline depreciation of an asset for one period 
Specialized  SYD  Returns the sumofyears' digits depreciation of an asset for a specified period 
Specialized  TBILLEQ  Returns the bondequivalent yield for a Treasury bill 
Specialized  TBILLPRICE  Returns the price per $100 face value for a Treasury bill 
Specialized  TBILLYIELD  Returns the yield for a Treasury bill 
Specialized  VDB  Returns the depreciation of an asset for a specified or partial period using a declining balance method 
Specialized  XIRR  Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic 
Specialized  XNPV  Returns the net present value for a schedule of cash flows that is not necessarily periodic 
Specialized  YIELD  Returns the yield on a security that pays periodic interest 
Specialized  YIELDDISC  Returns the annual yield for a discounted security for example, a Treasury bill 
Specialized  YIELDMAT  Returns the annual yield of a security that pays interest at maturity 
Next Chapter: Information Functions in Excel 
Excel Table of Contents 
Discover Even More in 50 Excel spreadsheets 

6137494695 
Tips and Ideas on Excel 
Tips and Ideas on Macros 
Excel Spreadsheets Functions: Financial