English: The Strategy Analysis Graph shows the...Financial functions perform many of the commonly used financial calculations, such as the calculation of yield, interest rates, investment valuations and asset depreciation.

In the tables below, the financial functions have been grouped into categories, to help you to find the function you need.

FunctionCategoryDescription
ACCRINTInterest RateReturns the accrued interest for a security that pays periodic interest
ACCRINTMInterest RateReturns the accrued interest for a security that pays interest at maturity
AMORDEGRCAsset DepreciationReturns the depreciation for each accounting period by using a depreciation coefficient
AMORLINCAsset DepreciationReturns the depreciation for each accounting period
COUPDAYBSDuration FunctionReturns the number of days from the beginning of the coupon period to the settlement date
COUPDAYSDuration FunctionReturns the number of days in the coupon period that contains the settlement date
COUPDAYSNCDuration FunctionReturns the number of days from the settlement date to the next coupon date
COUPNCDDuration FunctionReturns the next coupon date after the settlement date
COUPNUMDuration FunctionReturns the number of coupons payable between the settlement date and maturity date
COUPPCDDuration FunctionReturns the previous coupon date before the settlement date
CUMIPMTPayment FunctionReturns the cumulative interest paid between two periods
CUMPRINCPayment FunctionReturns the cumulative principal paid on a loan between two periods
DBAsset DepreciationReturns the depreciation of an asset for a specified period by using the fixed-declining balance method
DDBAsset DepreciationReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
DISCPrice FunctionReturns the discount rate for a security
DOLLARDEDollar ConversionConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
DOLLARFRDollar ConversionConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
DURATIONDuration FunctionReturns the annual duration of a security with periodic interest payments
EFFECTInterest RateReturns the effective annual interest rate
FVInvestment ValueReturns the future value of an investment
FVSCHEDULEInvestment ValueReturns the future value of an initial principal after applying a series of compound interest rates
INTRATEInterest RateReturns the interest rate for a fully invested security
IPMTPayment FunctionReturns the interest payment for an investment for a given period
IRRInternal Rate of ReturnReturns the internal rate of return for a series of cash flows
ISPMTPayment FunctionCalculates the interest paid during a specific period of an investment
MDURATIONDuration FunctionReturns the Macauley modified duration for a security with an assumed par value of $100
MIRRInternal Rate of ReturnReturns the internal rate of return where positive and negative cash flows are financed at different rates
NOMINALInterest RateReturns the annual nominal interest rate
NPERDuration FunctionReturns the number of periods for an investment
NPVInvestment ValueReturns the net present value of an investment based on a series of periodic cash flows and a discount rate
ODDFPRICEPrice FunctionReturns the price per $100 face value of a security with an odd first period
ODDFYIELDYield FunctionReturns the yield of a security with an odd first period
ODDLPRICEPrice FunctionReturns the price per $100 face value of a security with an odd last period
ODDLYIELDYield FunctionReturns the yield of a security with an odd last period
PDURATIONDuration FunctionReturns the number of periods required by an investment to reach a specified value (New in Excel 2013)
PMTPayment FunctionReturns the periodic payment for an annuity
PPMTPayment FunctionReturns the payment on the principal for an investment for a given period
PRICEPrice FunctionReturns the price per $100 face value of a security that pays periodic interest
PRICEDISCPrice FunctionReturns the price per $100 face value of a discounted security
PRICEMATPrice FunctionReturns the price per $100 face value of a security that pays interest at maturity
PVInvestment ValueReturns the present value of an investment
RATEInterest RateReturns the interest rate per period of an annuity
RECEIVEDInvestment ValueReturns the amount received at maturity for a fully invested security
RRIInterest RateReturns an equivalent interest rate for the growth of an investment (New in Excel 2013)
SLNAsset DepreciationReturns the straight-line depreciation of an asset for one period
SYDAsset DepreciationReturns the sum-of-years' digits depreciation of an asset for a specified period
TBILLEQYield FunctionReturns the bond-equivalent yield for a Treasury bill
TBILLPRICEPrice FunctionReturns the price per $100 face value for a Treasury bill
TBILLYIELDYield FunctionReturns the yield for a Treasury bill
VDBAsset DepreciationReturns the depreciation of an asset for a specified or partial period by using a declining balance method
XIRRInternal Rate of ReturnReturns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPVInvestment ValueReturns the net present value for a schedule of cash flows that is not necessarily periodic
YIELDYield FunctionReturns the yield on a security that pays periodic interest
YIELDDISCYield FunctionReturns the annual yield for a discounted security; for example, a Treasury bill
YIELDMATYield FunctionReturns the annual yield of a security that pays interest at maturity