Financial functions reference

To get detailed information about a function, click its name in the first column.

Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.

Function	Description
ACCRINT function	Returns the accrued interest for a security that pays periodic interest
ACCRINTM function	Returns the accrued interest for a security that pays interest at maturity
AMORDEGRC function	Returns the depreciation for each accounting period by using a depreciation coefficient
AMORLINC function	Returns the depreciation for each accounting period
COUPDAYBS function	Returns the number of days from the beginning of the coupon period to the settlement date
COUPDAYS function	Returns the number of days in the coupon period that contains the settlement date
COUPDAYSNC function	Returns the number of days from the settlement date to the next coupon date
COUPNCD function	Returns the next coupon date after the settlement date
COUPNUM function	Returns the number of coupons payable between the settlement date and maturity date
COUPPCD function	Returns the previous coupon date before the settlement date
CUMIPMT function	Returns the cumulative interest paid between two periods
CUMPRINC function	Returns the cumulative principal paid on a loan between two periods
DB function	Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
DDB function	Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
DISC function	Returns the discount rate for a security
DOLLARDE function	Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
DOLLARFR function	Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
DURATION function	Returns the annual duration of a security with periodic interest payments
EFFECT function	Returns the effective annual interest rate
FV function	Returns the future value of an investment
FVSCHEDULE function	Returns the future value of an initial principal after applying a series of compound interest rates
INTRATE function	Returns the interest rate for a fully invested security
IPMT function	Returns the interest payment for an investment for a given period
IRR function	Returns the internal rate of return for a series of cash flows
ISPMT function	Calculates the interest paid during a specific period of an investment
MDURATION function	Returns the Macauley modified duration for a security with an assumed par value of $100
MIRR function	Returns the internal rate of return where positive and negative cash flows are financed at different rates
NOMINAL function	Returns the annual nominal interest rate
NPER function	Returns the number of periods for an investment
NPV function	Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
ODDFPRICE function	Returns the price per $100 face value of a security with an odd first period
ODDFYIELD function	Returns the yield of a security with an odd first period
ODDLPRICE function	Returns the price per $100 face value of a security with an odd last period
ODDLYIELD function	Returns the yield of a security with an odd last period
PDURATION function	Returns the number of periods required by an investment to reach a specified value
PMT function	Returns the periodic payment for an annuity
PPMT function	Returns the payment on the principal for an investment for a given period
PRICE function	Returns the price per $100 face value of a security that pays periodic interest
PRICEDISC function	Returns the price per $100 face value of a discounted security
PRICEMAT function	Returns the price per $100 face value of a security that pays interest at maturity
PV function	Returns the present value of an investment
RATE function	Returns the interest rate per period of an annuity
RECEIVED function	Returns the amount received at maturity for a fully invested security
RRI function	Returns an equivalent interest rate for the growth of an investment
SLN function	Returns the straight-line depreciation of an asset for one period
SYD function	Returns the sum-of-years' digits depreciation of an asset for a specified period
TBILLEQ function	Returns the bond-equivalent yield for a Treasury bill
TBILLPRICE function	Returns the price per $100 face value for a Treasury bill
TBILLYIELD function	Returns the yield for a Treasury bill
VDB function	Returns the depreciation of an asset for a specified or partial period by using a declining balance method
XIRR function	Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPV function	Returns the net present value for a schedule of cash flows that is not necessarily periodic
YIELD function	Returns the yield on a security that pays periodic interest
YIELDDISC function	Returns the annual yield for a discounted security; for example, a Treasury bill
YIELDMAT function	Returns the annual yield of a security that pays interest at maturity

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

See Also

Excel functions (by category)

Excel functions (alphabetical)