Excel functions
Every Excel function (476), organized by category. Arguments in [brackets] are optional.
Formula Explainer · Paste any formula and see it broken down step by step. Free.
Try itFinancial (55)
=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])Returns the accrued interest for a security that pays periodic interest.
=ACCRINTM(issue, settlement, rate, par, [basis])Returns the accrued interest for a security that pays interest at maturity.
=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])Returns the depreciation for each accounting period by using a depreciation coefficient.
=AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])Returns the depreciation for each accounting period.
=COUPDAYBS(settlement, maturity, frequency, [basis])Returns the number of days from the beginning of the coupon period to the settlement date.
=COUPDAYS(settlement, maturity, frequency, [basis])Returns the number of days in the coupon period that contains the settlement date.
=COUPDAYSNC(settlement, maturity, frequency, [basis])Returns the number of days from the settlement date to the next coupon date.
=COUPNCD(settlement, maturity, frequency, [basis])Returns the next coupon date after the settlement date.
=COUPNUM(settlement, maturity, frequency, [basis])Returns the number of coupons payable between the settlement date and maturity date.
=COUPPCD(settlement, maturity, frequency, [basis])Returns the previous coupon date before the settlement date.
=CUMIPMT(rate, nper, pv, start_period, end_period, type)Returns the cumulative interest paid between two periods.
=CUMPRINC(rate, nper, pv, start_period, end_period, type)Returns the cumulative principal paid on a loan between two periods.
=DB(cost, salvage, life, period, [month])Returns the depreciation of an asset for a specified period by using the fixed-declining balance method.
=DDB(cost, salvage, life, period, [factor])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(settlement, maturity, pr, redemption, [basis])Returns the discount rate for a security.
=DOLLARDE(fractional_dollar, fraction)Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.
=DOLLARFR(decimal_dollar, fraction)Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
=DURATION(settlement, maturity, coupon, yld, frequency, [basis])Returns the annual duration of a security with periodic interest payments.
=EFFECT(nominal_rate, npery)Returns the effective annual interest rate.
=FV(rate, nper, pmt, [pv], [type])Returns the future value of an investment.
=FVSCHEDULE(principal, schedule)Returns the future value of an initial principal after applying a series of compound interest rates.
=INTRATE(settlement, maturity, investment, redemption, [basis])Returns the interest rate for a fully invested security.
=IPMT(rate, per, nper, pv, [fv], [type])Returns the interest payment for an investment for a given period.
=IRR(values, [guess])Returns the internal rate of return for a series of cash flows.
=ISPMT(rate, per, nper, pv)Calculates the interest paid during a specific period of an investment.
=MDURATION(settlement, maturity, coupon, yld, frequency, [basis])Returns the Macauley modified duration for a security with an assumed par value of $100.
=MIRR(values, finance_rate, reinvest_rate)Returns the internal rate of return where positive and negative cash flows are financed at different rates.
=NOMINAL(effect_rate, npery)Returns the annual nominal interest rate.
=NPER(rate, pmt, pv, [fv], [type])Returns the number of periods for an investment.
=NPV(rate, value1, [value2], ...)Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.
=ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])Returns the price per $100 face value of a security with an odd first period.
=ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])Returns the yield of a security with an odd first period.
=ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis])Returns the price per $100 face value of a security with an odd last period.
=ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])Returns the yield of a security with an odd last period.
=PDURATION(rate, pv, fv)Returns the number of periods required by an investment to reach a specified value.
=PMT(rate, nper, pv, [fv], [type])Returns the periodic payment for an annuity.
=PPMT(rate, per, nper, pv, [fv], [type])Returns the payment on the principal for an investment for a given period.
=PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])Returns the price per $100 face value of a security that pays periodic interest.
=PRICEDISC(settlement, maturity, discount, redemption, [basis])Returns the price per $100 face value of a discounted security.
=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])Returns the price per $100 face value of a security that pays interest at maturity.
=PV(rate, nper, pmt, [fv], [type])Returns the present value of an investment.
=RATE(nper, pmt, pv, [fv], [type], [guess])Returns the interest rate per period of an annuity.
=RECEIVED(settlement, maturity, investment, discount, [basis])Returns the amount received at maturity for a fully invested security.
=RRI(nper, pv, fv)Returns an equivalent interest rate for the growth of an investment.
=SLN(cost, salvage, life)Returns the straight-line depreciation of an asset for one period.
=SYD(cost, salvage, life, per)Returns the sum-of-years' digits depreciation of an asset for a specified period.
=TBILLEQ(settlement, maturity, discount)Returns the bond-equivalent yield for a Treasury bill.
=TBILLPRICE(settlement, maturity, discount)Returns the price per $100 face value for a Treasury bill.
=TBILLYIELD(settlement, maturity, pr)Returns the yield for a Treasury bill.
=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])Returns the depreciation of an asset for a specified or partial period by using a declining balance method.
=XIRR(values, dates, [guess])Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
=XNPV(rate, values, dates)Returns the net present value for a schedule of cash flows that is not necessarily periodic.
=YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])Returns the yield on a security that pays periodic interest.
=YIELDDISC(settlement, maturity, pr, redemption, [basis])Returns the annual yield for a discounted security; for example, a Treasury bill.
=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])Returns the annual yield of a security that pays interest at maturity.