Menu
In Excel for Windows this was easily accessible via the 'find function' and then the 'find all' tab appeared - but in Excel 2011 / Mac - can not find it?? Tks for yr help Peter V.
Related article
With these complex calculations related to the field of securities, assets, loans, ..., Excel supports a series of very powerful jaw. Through this article, you will know more financial functions in Excel are the most popular.
The financial functions in Excel
Download and install Excel 2013
1. ACCRINT function : Returns the accrued interest for securities pay interest periodically
2. Ham ACCRINTM Returns accrued interest for securities pay interest at maturity
3. Ham AMORDEGRC Returns the depreciation for each accounting period by using a depreciation coefficient
4. Ham AMORLINC Returns the depreciation for each accounting period
5. Ham COUPDAYBS Returns the number of days from the start of term to coupon payment date
6. Ham COUPDAYS Returns number of days in the coupon period that contains the settlement date
7. Ham COUPDAYSNC Returns the number of days from the settlement date to next coupon date
8. Ham COUPNCD Returns the next coupon date after the settlement date
9. Ham COUPNUM Returns votes may interest payments between settlement date and maturity date
10. Ham COUPPCD Returns the previous coupon date before the settlement date
11. Ham CUMIPMT Returns cumulative interest paid between two
12. Ham CUMPRINC Returns Cumulative funds are paid on a loan between two terms
13. Functions DB Returns the depreciation of an asset for a specified period using the fixed-declining method
14. DDB function Returns the depreciation of an asset for a period to be determined by using the double declining method or other method that you specify
15. DISC function returns the discount for a stock
16. Ham DOLLARDE Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal
17. Ham DOLLARFR Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as fractions
18. Ham DURATION Returns the annual duration of the securities pay interest periodically
19. The function EFFECT Returns the annual interest rate in effect
20. Ham FV Returns the future value of an investment
21. Ham FVSCHEDULE Returns the future value of the initial capital amount after applying a chain operating margin
22. Ham INTRATE Returns interest rate for investment securities are full
23. Ham IPMT Returns payment for an investment interest in a given period
24. IRR function returns the internal rate of return for cash flows chains
25. Ham ISPMT Count premium paid in a determined period of an investment
26. Ham MDURATION Returns interval amended by Macauley for securities with a par value assumes 100 USD.
27. Function MIRR Returns the internal rate of return at which the cash flow positive and negative are calculated at different rates
28. NOMINAL function returns the nominal annual interest rate
29. Functions NPER Returns the number of terms for an investment
30. Ham NPV Returns the net present value of an investment based on a series of periodic cash flows and a discount
31. Ham ODDFPRICE Returns per $ 100 face value of the stock with an odd first period
32. Ham ODDFYIELD Returns profits of a stock with an odd first period
![Function Financial In Excel For Mac Function Financial In Excel For Mac](/uploads/1/2/5/7/125718524/459214689.jpg)
![Microsoft excel for mac Microsoft excel for mac](/uploads/1/2/5/7/125718524/716156680.png)
33. Ham ODDLPRICE Returns per $ 100 face value of the stock with an odd last period
34. Ham ODDLYIELD Returns profits of a stock with an odd last period
35. Ham PDURATION Returns the number of terms required by an investment to attain a specified value
36. Ham PMT Returns periodic payment for an annuity
37. Functions PPMT Returns the payment on the capital for an investment for a given period
38. Ham PRICE Returns per $ 100 face value of a stock exchange periodic interest payment
39. Ham PRICEDISC Returns per $ 100 face value of a stock is discounted
40. Ham PRICEMAT Returns per $ 100 face value of a securities pay interest at maturity
41. Ham PV Returns the present value of an investment
42. RATE function Returns the interest rate per period of an annuity
43. RECEIVED function returns the amount received when due for the full investment securities
44. Ham RRI Returns an interest rate equivalent to the growth of an investment
45. SLN function Returns the depreciation of the assets are for a term
46. Function SYD Returns the total annual depreciation of an asset for a specified period
47. Ham TBILLEQ Returns bond yields horizontal exchange for Treasury bonds
48. Ham TBILLPRICE Returns per $ 100 face value of Treasury bonds
49. Ham TBILLYIELD Returns income for Treasury bonds
50. Ham VDB Returns the depreciation of an asset for a specified period or term part using declining method
51. Functions XIRR Returns the internal rate of return of a cash flow schedule is not necessarily periodic
52. Ham XNPV Returns net present a schedule of cash flow is not necessarily periodic
53. Ham YIELD Returns income on securities pay interest periodically
54. Ham YIELDDISC Returns annual income for discounted securities; for example, a Treasury bond
55. Ham YIELDMAT Returns annual income securities pay interest at maturity
Above, synthesized Taimienphi.vn financial functions in Excel to help you better overview and use these functions to work on spreadsheet calculations efficiently. Additionally, you may refer to the function in Excel calculation was introduced in the article Taimienphi.vn tips before.