Buzz
For complex calculations in areas like stocks, assets, loans, and more, Excel provides a range of powerful functions. Through this article, you will discover the most common financial functions in Excel.
Compilation of Excel financial functions
Financial functions in Excel
Download and install Excel 2013
1. ACCRINT Function: Returns the accrued interest for securities with periodic interest payments
2. ACCRINTM Function: Returns the accrued interest for securities with interest at maturity
3. AMORDEGRC Function: Returns depreciation for each accounting period using the depreciation coefficient
4. AMORLINC Function: Returns depreciation for each accounting period
5. COUPDAYBS Function: Returns the number of days from the start of the interest period to the payment date
6. COUPDAYS Function: Returns the number of days in the interest period containing the payment date
7. COUPDAYSNC Function: Returns the number of days from the payment date to the next coupon date
8. COUPNCD Function: Returns the next coupon date after the payment date
9. COUPNUM Function: Returns the number of coupons payable between the settlement date and maturity date
10. COUPPCD Function: Returns the previous coupon date before the payment date
11. CUMIPMT Function: Returns the cumulative interest paid between two periods
12. CUMPRINC Function: Returns the cumulative principal paid for a loan between two periods
13. DB Function: Returns the depreciation of an asset for a specific period using the fixed declining balance method
14. DDB Function: Returns the depreciation of an asset for a specified time period using the double-declining balance method or another method you specify
15. DISC Function: Returns the discount rate for a security
16. DOLLARDE Function: Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
17. DOLLARFR Function: Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
18. DURATION Function: Returns the annual duration of a security with periodic interest payments
19. EFFECT Function: Returns the effective annual interest rate
20. FV Function: Returns the future value of an investment
21. FVSCHEDULE Function: Returns the future value of the initial principal after applying a series of compound interest rates
22. INTRATE Function: Returns the interest rate for a fully invested security
23. IPMT Function: Returns the interest payment for an investment for a given period
24. IRR Function: Returns the internal rate of return for a series of cash flows
25. ISPMT Function: Calculates the interest paid during a specified period of an investment
26. MDURATION Function: Returns the Macaulay modified duration for a security with an assumed $100 par value.
27. MIRR Function: Returns the modified internal rate of return where positive and negative cash flows are financed at different rates
28. NOMINAL Function: Returns the nominal annual interest rate
29. NPER Function: Returns the number of periods for an investment
30. NPV Function: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
31. ODDFPRICE Function: Returns the price per $100 face value of a security with an odd first period
32. ODDFYIELD Function: Returns the yield of a security with an odd first period
33. ODDLPRICE Function: Returns the price per $100 face value of a security with an odd last period
34. ODDLYIELD Function: Returns the yield of a security with an odd last period
35. PDURATION Function: Returns the number of periods required by an investment to reach a specified value
36. PMT Function: Returns the periodic payment for an annuity
37. PPMT Function: Returns the amount of principal payment for an investment for a specified period
38. PRICE Function: Returns the price per $100 face value of a security with periodic interest payments
39. PRICEDISC Function: Returns the price per $100 face value of a discounted security
40. PRICEMAT Function: Returns the price per $100 face value of a security that pays interest at maturity
41. PV Function: 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 at maturity for fully invested securities
44. RRI Function: Returns an equivalent interest rate for the growth of an investment
45. SLN Function: Returns the straight-line depreciation of an asset for a given period
46. SYD Function: Returns the annual total depreciation of an asset for a specified period
47. TBILLEQ Function: Returns the equivalent bond yield for a Treasury bill
48. TBILLPRICE Function: Returns the price per $100 face value for a Treasury bill
49. TBILLYIELD Function: Returns the yield for a Treasury bill
50. VDB Function: Returns the depreciation of an asset for a specified period or partial period using the double declining balance method
51. XIRR Function: Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
52. XNPV Function: Returns the net present value for a schedule of cash flows that is not necessarily periodic
53. YIELD Function: Returns the yield on a security that pays periodic interest
54. YIELDDISC Function: Returns the annual yield for a discounted security; for example, a Treasury bill
55. YIELDMAT Function: Returns the annual yield for a security that pays interest at maturity
Here, Mytour has compiled various financial functions in Excel to provide you with a comprehensive overview and help you efficiently utilize these functions in spreadsheet calculations. Additionally, you can refer to other calculation functions in Excel introduced by Mytour in previous tutorials.
