Excel’s financial functions are invaluable tools for a wide range of financial analyses, from personal finance to corporate finance. Here are some key areas where you can effectively apply these functions:
Personal Finance
- Loan and Mortgage Calculations: Retirement Planning: Budgeting and Forecasting:
Business Finance
- Investment Analysis: Loan and Debt Management: Financial Modelling:
Real Estate
- Property Investment Analysis:
Other Applications
- Accounting: Insurance’s, Risk Management:
By understanding and effectively applying these financial functions, you can make informed financial decisions, optimize your investments, and achieve your financial goals.
| Function | Version | Purpose | Arguments |
|---|---|---|---|
| ACCRINT | Excel 2003 | Get accrued interest periodic | id fd sd rate par freq basis calc |
| ACCRINTM | Excel 2003 | Get accrued interest at maturity | id sd rate par basis |
| AMORDEGRC | Excel 2003 | Depreciation for accounting period coefficient | cost purchase first salvage period rate basis |
| AMORLINC | Excel 2003 | Depreciation for accounting period | cost purchase first salvage period rate basis |
| COUPDAYBS | Excel 2003 | Get days from coupon period to settlement date | settlement maturity frequency basis |
| COUPDAYS | Excel 2003 | Get days in coupon period incl settlement date | settlement maturity frequency basis |
| COUPDAYSNC | Excel 2003 | Get days from settlement date to next coupon date | settlement maturity frequency basis |
| COUPNCD | Excel 2003 | Get next coupon date after settlement date | settlement maturity frequency basis |
| COUPNUM | Excel 2003 | Get number of coupons payable | settlement maturity frequency basis |
| COUPPCD | Excel 2003 | Get previous coupon date before settlement date | settlement maturity frequency basis |
| CUMIPMT | Excel 2003 | Get cumulative interest paid on a loan | rate nper pv start_period end_period type |
| CUMPRINC | Excel 2003 | Get cumulative principal paid on a loan | rate nper pv start_period end_period type |
| DB | Excel 2003 | Depreciation – fixed-declining balance | cost salvage life period month |
| DDB | Excel 2003 | Depreciation – double-declining | cost salvage life period factor |
| DISC | Excel 2003 | Get discount rate for a security | settlement maturity pr redemption basis |
| DOLLARDE | Excel 2003 | Convert dollar price as fraction to decimal | fractional_dollar fraction |
| DOLLARFR | Excel 2003 | Convert price to fractional notation | decimal_dollar fraction |
| DURATION | Excel 2003 | Get annual duration with periodic interest | settlement maturity coupon yld freq basis |
| EFFECT | Excel 2003 | Get effective annual interest rate | nominal_rate npery |
| FV | Excel 2003 | Get the future value of an investment | rate nper pmt pv type |
| FVSCHEDULE | Excel 2003 | Get future value of principal compound interest | principal schedule |
| INTRATE | Excel 2003 | Get interest rate for fully invested security | settlement maturity investment redemption basis |
| IPMT | Excel 2003 | Get interest in given period | rate per nper pv fv type |
| IRR | Excel 2003 | Calculate internal rate of return | values guess |
| ISPMT | Excel 2003 | Get interest paid for specific period | rate per nper pv |
| MDURATION | Excel 2003 | Get Macauley modified duration par value of $100 | settlement maturity coupon yld freq basis |
| MIRR | Excel 2003 | Calculate modified internal rate of return | values finance_rate reinvest_rate |
| NOMINAL | Excel 2003 | Get annual nominal interest rate | effect_rate npery |
| NPER | Excel 2003 | Get number of periods for loan or investment | rate pmt pv fv type |
| NPV | Excel 2003 | Calculate net present value | rate value1 value2 … |
| ODDFPRICE | Excel 2003 | Get price per $100 odd first period | sd md id fd rate yld redem freq basis |
| ODDFYIELD | Excel 2003 | Get yield security with odd first period | sd md id fd rate pr redem freq basis |
| ODDLPRICE | Excel 2003 | Get price per $100 face value with odd last period | sd md id rate yld redem freq basis |
| ODDLYIELD | Excel 2003 | Get yield of security with odd last period | sd md ld rate pr redem freq basis |
| PDURATION | Excel 2013 | Get periods required to reach given value | rate pv fv |
| PMT | Excel 2003 | Get the periodic payment for a loan | rate nper pv fv type |
| PPMT | Excel 2003 | Get principal payment in given period | rate per nper pv fv type |
| PRICE | Excel 2003 | Get price per $100 face value – periodic interest | sd md rate yld redemption frequency basis |
| PRICEDISC | Excel 2003 | Get price per $100 discounted security | sd md discount redemption basis |
| PRICEMAT | Excel 2003 | Get price per $100 interest at maturity | sd md id rate yld basis |
| PV | Excel 2003 | Get the present value of an investment | rate nper pmt fv type |
| RATE | Excel 2003 | Get the interest rate per period of an annuity | nper pmt pv fv type guess |
| RECEIVED | Excel 2003 | Get amount received at maturity | settlement maturity investment discount basis |
| RRI | Excel 2013 | Get equivalent interest rate for growth | nper pv fv |
| SLN | Excel 2003 | Depreciation – straight-line | cost salvage life |
| SYD | Excel 2003 | Depreciation – sum-of-years | cost salvage life period |
| TBILLEQ | Excel 2003 | Get bond-equivalent yield for a Treasury bill | settlement maturity discount |
| TBILLPRICE | Excel 2003 | Get price per $100 Treasury bill | settlement maturity discount |
| TBILLYIELD | Excel 2003 | Get yield for a Treasury bill | settlement maturity price |
| VDB | Excel 2003 | Depreciation – double-declining variable | cost salvage life start end factor no_switch |
| XIRR | Excel 2003 | Calculate internal rate of return for irregular cash flows | values dates guess |
| XNPV | Excel 2003 | Calculate net present value for irregular cash flows | rate values dates |
| YIELD | Excel 2003 | Get yield for security that pays periodic interest | sd md rate pr redemption frequency basis |
| YIELDDISC | Excel 2003 | Get annual yield for discounted security | sd md pr redemption basis |
| YIELDMAT | Excel 2003 | Get annual yield of security interest at maturity | sd md id rate pr basis |