The Excel financial functions are used to organize and analyze financial data. These Excel financial functions can calculate interest rate, duration, price, days, depreciation, yield and much more.
Complete List of Excel Financial Functions (A to Z)
All Excel financial functions are mentioned below in alphabetical order:
| Function | Description |
| ACCRINT Function | Accrued interest for a security that pays interest periodically. |
| ACCRINTM Function | Accrued interest for a security that pays interest at maturity (one time only). |
| AMORLINC Function | Depreciation of an asset for each accounting period. |
| COUPDAYBS Function | Number of days from the beginning of the coupon period until the settlement date. |
| COUPDAYS Function | Number of days in the coupon period that contains the settlement date. |
| COUPDAYSNC Function | Number of days from the settlement date to the next coupon date. |
| COUPNCD Function | Next coupon date after the settlement date. |
| COUPNUM Function | Number of coupons payable between the settlement date and maturity date. |
| COUPPCD Function | Previous coupon date before the settlement date. |
| CUMIPMT Function | Cumulative interest paid between two specified periods. |
| CUMPRINC Function | Cumulative principal paid on a loan between two specified periods. |
| DB Function | Depreciation of asset for a specified period by using the fixed declining balance method. |
| DDB Function | Depreciation of asset for a specified period by using the double declining balance method or any other specified method. |
| DISC Function | Discount rate for the security. |
| DOLLARDE Function | Dollar price expressed as a fraction into decimal. |
| DOLLARFR Function | Dollar price expressed as a decimal into fraction. |
| DURATION Function | Macauley duration of the security with periodic interest payments. |
| EFFECT Function | Effective annual interest rate from nominal interest rate and number of periods. |
| FV Function | Future Value (FV) of the investment based on payments, interest rate and periods. |
| FVSCHEDULE Function | Future Value of an investment based on a series of compound interest rates. |
| INTRATE Function | Interest payment for the investment based on payments and interest rate. |
| IPMT Function | Interest rate for the fully invested security. |
| IPSPMT Function | Interest paid or received for the specific period of the investment. |
| IRR Function | Internal Rate of Return (IRR) for the series of cash flows. |
| MDURATION Function | Macauley modified duration for a security with an assumed par value of $100. |
| MIRR Function | Modified Internal Rate of Return (MIRR) for the series of periodic cash flows. |
| NOMINAL Function | Annual nominal interest rate based on effective rate and number of periods. |
| NPER Function | Number of periods for the investment based on periods, payments and interest rate. |
| NPV Function | Net Present Value (NPV) of the investment based on the series of cash flows and discount rate. |
| ODDFPRICE Function | Price per $100 face value of a security with an odd first period. |
| ODDFYIELD Function | Yield of the security with an odd first period. |
| ODDLPRICE Function | Price per $100 face value of the security with an odd last period. |
| ODDLYIELD Function | Yield of the security with an odd last period. |
| PBILLYIELD Function | Yield for a treasury bill. |
| PDURATION Function | Number of periods required by the investment to reach a specified value. |
| PMT Function | Periodic payment for the loan based on constant payments and interest rate. |
| PPMT Function | Principal payment of an investment for a specific period based on periodic, constant payments and fixed interest rate. |
| PRICE Function | Price per $100 face value of the security that pays periodic interest. |
| PRICEDISC Function | Price per $100 face value of the discounted security. |
| PRICEMAT Function | Price per $100 face value of the security that pays interest at maturity. |
| PV Function | Present Value (PV) of the investment based on a constant interest rate. |
| RATE Function | Interest rate per period of an annuity. |
| RECEIVED Function | Amount received at maturity for the fully invested security. |
| RRI Function | Equivalent interest rate for the growth of the investment. |
| SLN Function | Straight line depreciation of the asset for one period. |
| STOCKHISTORY Function | Historical data of a financial instrument and loads as an array. |
| SYD Function | Sum-of-years’ depreciation of the asset for a given period. |
| TBILLEQ Function | Bond-equivalent yield for a treasury bill. |
| TBILLPRICE Function | Price per $100 face value for a treasury bill. |
| VDB Function | Depreciation of the asset for any specified period, using the double declining balance method or other specified method. |
| XIRR Function | Internal Rate of Return (IRR) for a schedule of cash flows that occur at irregular intervals. |
| XNPV Function | Net Present Value (NPV) for a schedule of cash flows that occur at irregular intervals. |
| YIELD Function | Yield on a security that pays periodic interest. |
| YIELDDISC Function | Annual yield for the discounted security. |
| YIELDMAT Function | Annual yield of the security that pays interest at maturity. |