Excel financial functions
Financial functions in Excel, explained with live examples.
55 financial functions in Excel — 55 documented in depth so far, the rest indexed below and landing every week.
Documented financial functions
Syntax, examples, and the equivalent — ready now.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets
- COUPDAYSNCReturns the number of days from the settlement date to the next coupon dateFinancialGoogle Sheets
- COUPNCDReturns the next coupon date after the settlement dateFinancialGoogle Sheets
- COUPNUMReturns the number of coupons payable between the settlement date and maturity dateFinancialGoogle Sheets
- COUPPCDReturns the previous coupon date before the settlement dateFinancialGoogle Sheets
- CUMIPMTReturns the cumulative interest paid between two periodsFinancialGoogle Sheets
- CUMPRINCReturns the cumulative principal paid on a loan between two periodsFinancialGoogle Sheets
- DBReturns the depreciation of an asset for a specified period by using the fixed-declining balance methodFinancialGoogle Sheets
- DDBReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specifyFinancialGoogle Sheets
- DISCReturns the discount rate for a securityFinancialGoogle Sheets
- DOLLARDEConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal numberFinancialGoogle Sheets
- DOLLARFRConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fractionFinancialGoogle Sheets
- DURATIONReturns the annual duration of a security with periodic interest paymentsFinancialGoogle Sheets
- EFFECTReturns the effective annual interest rateFinancialGoogle Sheets
- FVReturns the future value of an investmentFinancialGoogle Sheets
- FVSCHEDULEReturns the future value of an initial principal after applying a series of compound interest ratesFinancialGoogle Sheets
- INTRATEReturns the interest rate for a fully invested securityFinancialGoogle Sheets
- IPMTReturns the interest payment for an investment for a given periodFinancialGoogle Sheets
- IRRReturns the internal rate of return for a series of cash flowsFinancialGoogle Sheets
- ISPMTCalculates the interest paid during a specific period of an investmentFinancialGoogle Sheets
- MDURATIONReturns the Macauley modified duration for a security with an assumed par value of $100FinancialGoogle Sheets
- MIRRReturns the internal rate of return where positive and negative cash flows are financed at different ratesFinancialGoogle Sheets
- NOMINALReturns the annual nominal interest rateFinancialGoogle Sheets
- NPERReturns the number of periods for an investmentFinancialGoogle Sheets
- NPVReturns the net present value of an investment based on a series of periodic cash flows and a discount rateFinancialGoogle Sheets
- ODDFPRICEReturns the price per $100 face value of a security with an odd first periodFinancialNo Google Sheets equivalent
- ODDFYIELDReturns the yield of a security with an odd first periodFinancialNo Google Sheets equivalent
- ODDLPRICEReturns the price per $100 face value of a security with an odd last periodFinancialNo Google Sheets equivalent
- ODDLYIELDReturns the yield of a security with an odd last periodFinancialNo Google Sheets equivalent
- PDURATIONReturns the number of periods required by an investment to reach a specified valueFinancialGoogle Sheets
- PMTReturns the periodic payment for an annuityFinancialGoogle Sheets
- PPMTReturns the payment on the principal for an investment for a given periodFinancialGoogle Sheets
- PRICEReturns the price per $100 face value of a security that pays periodic interestFinancialGoogle Sheets
- PRICEDISCReturns the price per $100 face value of a discounted securityFinancialGoogle Sheets
- PRICEMATReturns the price per $100 face value of a security that pays interest at maturityFinancialGoogle Sheets
- PVReturns the present value of an investmentFinancialGoogle Sheets
- RATEReturns the interest rate per period of an annuityFinancialGoogle Sheets
- RECEIVEDReturns the amount received at maturity for a fully invested securityFinancialGoogle Sheets
- RRIReturns an equivalent interest rate for the growth of an investmentFinancialGoogle Sheets
- SLNReturns the straight-line depreciation of an asset for one periodFinancialGoogle Sheets
- SYDReturns the sum-of-years' digits depreciation of an asset for a specified periodFinancialGoogle Sheets
- TBILLEQReturns the bond-equivalent yield for a Treasury billFinancialGoogle Sheets
- TBILLPRICEReturns the price per $100 face value for a Treasury billFinancialGoogle Sheets
- TBILLYIELDReturns the yield for a Treasury billFinancialGoogle Sheets
- VDBReturns the depreciation of an asset for a specified or partial period by using a declining balance methodFinancialGoogle Sheets
- XIRRReturns the internal rate of return for a schedule of cash flows that is not necessarily periodicFinancialGoogle Sheets
- XNPVReturns the net present value for a schedule of cash flows that is not necessarily periodicFinancialGoogle Sheets
- YIELDReturns the yield on a security that pays periodic interestFinancialGoogle Sheets
- YIELDDISCReturns the annual yield for a discounted security; for example, a Treasury billFinancialGoogle Sheets
- YIELDMATReturns the annual yield of a security that pays interest at maturityFinancialGoogle Sheets
More Excel function categories