List of Excel Financial Functions with Syntax and Arguments

This reference table lists all officially documented Financial Functions. It is based on the Excel Help documentation and linked in each row when clicking on the function name. Export the table and/or display additional columns via the symbols to the top right of the table. Please report errors or inconsistencies via the comment function at the bottom of this page. Also check the main table with List of all Excel Functions.

#Excel FunctionDescriptionSyntax with ArgumentsSyntax onlyArguments only
1ACCRINTReturns the accrued interest for a security that pays periodic interest=ACCRINT(issueissue [required]: The security's issue date., first_interestfirst_interest [required]: The security's first interest date., settlementsettlement [required]: The security's settlement date., raterate [required]: The security's annual coupon rate., parpar [required]: The security's par value., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.], [calc_methodcalc_method [optional]: A logical value that specifies the way to calculate the total accrued interest when the date of settlement is later than the date of first_interest.])=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
  • issue (required): The security's issue date.
  • first_interest (required): The security's first interest date.
  • settlement (required): The security's settlement date.
  • rate (required): The security's annual coupon rate.
  • par (required): The security's par value.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
  • calc_method (optional): A logical value that specifies the way to calculate the total accrued interest when the date of settlement is later than the date of first_interest.
2ACCRINTMReturns the accrued interest for a security that pays interest at maturity=ACCRINTM(issueissue [required]: The security's issue date., settlementsettlement [required]: The security's maturity date., raterate [required]: The security's annual coupon rate., parpar [required]: The security's par value., [basisbasis [optional]: The type of day count basis to use.])=ACCRINTM(issue, settlement, rate, par, [basis])
  • issue (required): The security's issue date.
  • settlement (required): The security's maturity date.
  • rate (required): The security's annual coupon rate.
  • par (required): The security's par value.
  • basis (optional): The type of day count basis to use.
3AMORDEGRCReturns the depreciation for each accounting period=AMORDEGRC(costcost [required]: The cost of the asset., date_purchaseddate_purchased [required]: The date of the purchase of the asset., first_periodfirst_period [required]: The date of the end of the first period., salvagesalvage [required]: The salvage value at the end of the life of the asset., periodperiod [required]: The period., raterate [required]: The rate of depreciation., [basisbasis [optional]: The year basis to be used.])=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
  • cost (required): The cost of the asset.
  • date_purchased (required): The date of the purchase of the asset.
  • first_period (required): The date of the end of the first period.
  • salvage (required): The salvage value at the end of the life of the asset.
  • period (required): The period.
  • rate (required): The rate of depreciation.
  • basis (optional): The year basis to be used.
4AMORLINCReturns the depreciation for each accounting period=AMORLINC(costcost [required]: The cost of the asset., date_purchaseddate_purchased [required]: The date of the purchase of the asset., first_periodfirst_period [required]: The date of the end of the first period., salvagesalvage [required]: The salvage value at the end of the life of the asset., periodperiod [required]: The period., raterate [required]: The rate of depreciation., [basisbasis [optional]: The year basis to be used.])=AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])
  • cost (required): The cost of the asset.
  • date_purchased (required): The date of the purchase of the asset.
  • first_period (required): The date of the end of the first period.
  • salvage (required): The salvage value at the end of the life of the asset.
  • period (required): The period.
  • rate (required): The rate of depreciation.
  • basis (optional): The year basis to be used.
5COUPDAYBSReturns the number of days from the beginning of a coupon period until its settlement date=COUPDAYBS(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=COUPDAYBS(settlement, maturity, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
6COUPDAYSReturns the number of days in the coupon period that contains the settlement date=COUPDAYS(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=COUPDAYS(settlement, maturity, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
7COUPDAYSNCReturns the number of days from the settlement date to the next coupon date=COUPDAYSNC(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=COUPDAYSNC(settlement, maturity, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
8COUPNCDReturns a number that represents the next coupon date after the settlement date=COUPNCD(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=COUPNCD(settlement, maturity, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
9COUPNUMReturns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon=COUPNUM(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=COUPNUM(settlement, maturity, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
10COUPPCDReturns a number that represents the previous coupon date before the settlement date=COUPPCD(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=COUPPCD(settlement, maturity, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
11CUMIPMTReturns the cumulative interest paid on a loan between start_period and end_period=CUMIPMT(raterate [required]: The interest rate., npernper [required]: The total number of payment periods., pvpv [required]: The present value., start_periodstart_period [required]: The first period in the calculation., end_periodend_period [required]: The last period in the calculation., typetype [required]: The timing of the payment.)=CUMIPMT(rate, nper, pv, start_period, end_period, type)
  • rate (required): The interest rate.
  • nper (required): The total number of payment periods.
  • pv (required): The present value.
  • start_period (required): The first period in the calculation.
  • end_period (required): The last period in the calculation.
  • type (required): The timing of the payment.
12CUMPRINCReturns the cumulative principal paid on a loan between start_period and end_period=CUMPRINC(raterate [required]: The interest rate., npernper [required]: The total number of payment periods., pvpv [required]: The present value., start_periodstart_period [required]: The first period in the calculation., end_periodend_period [required]: The last period in the calculation., typetype [required]: The timing of the payment.)=CUMPRINC(rate, nper, pv, start_period, end_period, type)
  • rate (required): The interest rate.
  • nper (required): The total number of payment periods.
  • pv (required): The present value.
  • start_period (required): The first period in the calculation.
  • end_period (required): The last period in the calculation.
  • type (required): The timing of the payment.
13DBReturns the depreciation of an asset for a specified period using the fixed-declining balance method=DB(costcost [required]: The initial cost of the asset., salvagesalvage [required]: The value at the end of the depreciation (sometimes called the salvage value of the asset)., lifelife [required]: The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset)., periodperiod [required]: The period for which you want to calculate the depreciation., [monthmonth [optional]: The number of months in the first year.])=DB(cost, salvage, life, period, [month])
  • cost (required): The initial cost of the asset.
  • salvage (required): The value at the end of the depreciation (sometimes called the salvage value of the asset).
  • life (required): The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
  • period (required): The period for which you want to calculate the depreciation.
  • month (optional): The number of months in the first year.
14DDBReturns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify=DDB(costcost [required]: The initial cost of the asset., salvagesalvage [required]: The value at the end of the depreciation (sometimes called the salvage value of the asset)., lifelife [required]: The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset)., periodperiod [required]: The period for which you want to calculate the depreciation., [factorfactor [optional]: The rate at which the balance declines.])=DDB(cost, salvage, life, period, [factor])
  • cost (required): The initial cost of the asset.
  • salvage (required): The value at the end of the depreciation (sometimes called the salvage value of the asset).
  • life (required): The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
  • period (required): The period for which you want to calculate the depreciation.
  • factor (optional): The rate at which the balance declines.
15DISCReturns the discount rate for a security=DISC(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., prpr [required]: The security's price per $100 face value., redemptionredemption [required]: The security's redemption value per $100 face value., [basisbasis [optional]: The type of day count basis to use.])=DISC(settlement, maturity, pr, redemption, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • pr (required): The security's price per $100 face value.
  • redemption (required): The security's redemption value per $100 face value.
  • basis (optional): The type of day count basis to use.
16DOLLARDEConverts a dollar price expressed as an integer part and a fraction part, such as 1=DOLLARDE(fractional_dollarfractional_dollar [required]: A number expressed as an integer part and a fraction part, separated by a decimal symbol., fractionfraction [required]: The integer to use in the denominator of the fraction.)=DOLLARDE(fractional_dollar, fraction)
  • fractional_dollar (required): A number expressed as an integer part and a fraction part, separated by a decimal symbol.
  • fraction (required): The integer to use in the denominator of the fraction.
17DOLLARFRConverts decimal numbers to fractional dollar numbers, such as securities prices=DOLLARFR(decimal_dollardecimal_dollar [required]: A decimal number., fractionfraction [required]: The integer to use in the denominator of a fraction.)=DOLLARFR(decimal_dollar, fraction)
  • decimal_dollar (required): A decimal number.
  • fraction (required): The integer to use in the denominator of a fraction.
18DURATIONReturns the Macauley duration for an assumed par value of $100. =DURATION(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., couponcoupon [required]: The security's annual coupon rate., yldyld [required]: The security's annual yield., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=DURATION(settlement, maturity, coupon, yld, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • coupon (required): The security's annual coupon rate.
  • yld (required): The security's annual yield.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
19EFFECTReturns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year=EFFECT(nominal_ratenominal_rate [required]: The nominal interest rate., nperynpery [required]: The number of compounding periods per year.)=EFFECT(nominal_rate, npery)
  • nominal_rate (required): The nominal interest rate.
  • npery (required): The number of compounding periods per year.
20FVCalculates the future value of an investment based on a constant interest rate. =FV(raterate [required]: The interest rate per period., npernper [required]: The total number of payment periods in an annuity., pmtpmt [required]: The payment made each period; it cannot change over the life of the annuity., [pvpv [optional]: The present value, or the lump-sum amount that a series of future payments is worth right now.], [typetype [optional]: The number 0 or 1 and indicates when payments are due.])=FV(rate, nper, pmt, [pv], [type])
  • rate (required): The interest rate per period.
  • nper (required): The total number of payment periods in an annuity.
  • pmt (required): The payment made each period; it cannot change over the life of the annuity.
  • pv (optional): The present value, or the lump-sum amount that a series of future payments is worth right now.
  • type (optional): The number 0 or 1 and indicates when payments are due.
21FVSCHEDULEReturns the future value of an initial principal after applying a series of compound interest rates=FVSCHEDULE(principalprincipal [required]: The present value., scheduleschedule [required]: An array of interest rates to apply.)=FVSCHEDULE(principal, schedule)
  • principal (required): The present value.
  • schedule (required): An array of interest rates to apply.
22INTRATEReturns the interest rate for a fully invested security=INTRATE(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., investmentinvestment [required]: The amount invested in the security., redemptionredemption [required]: The amount to be received at maturity., [basisbasis [optional]: The type of day count basis to use.])=INTRATE(settlement, maturity, investment, redemption, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • investment (required): The amount invested in the security.
  • redemption (required): The amount to be received at maturity.
  • basis (optional): The type of day count basis to use.
23IPMTReturns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate=IPMT(raterate [required]: The interest rate per period., perper [required]: The period for which you want to find the interest and must be in the range 1 to nper., npernper [required]: The total number of payment periods in an annuity., pvpv [required]: The present value, or the lump-sum amount that a series of future payments is worth right now., [fvfv [optional]: The future value, or a cash balance you want to attain after the last payment is made.], [typetype [optional]: The number 0 or 1 and indicates when payments are due.])=IPMT(rate, per, nper, pv, [fv], [type])
  • rate (required): The interest rate per period.
  • nper (required): The total number of payment periods in an annuity.
  • per (required): The period for which you want to find the interest and must be in the range 1 to nper.
  • pv (required): The present value, or the lump-sum amount that a series of future payments is worth right now.
  • fv (optional): The future value, or a cash balance you want to attain after the last payment is made.
  • type (optional): The number 0 or 1 and indicates when payments are due.
24IRRReturns the internal rate of return for a series of cash flows represented by the numbers in values=IRR(valuesvalues [required]: An array or a reference to cells that contain numbers for which you want to calculate the internal rate of return., [guessguess [optional]: A number that you guess is close to the result of IRR.])=IRR(values, [guess])
  • values (required): An array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.
  • guess (optional): A number that you guess is close to the result of IRR.
25ISPMTCalculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments=ISPMT(raterate [required]: The interest rate for the investment., perper [required]: The period for which you want to find the interest, and must be between 1 and Nper., npernper [required]: The total number of payment periods for the investment., pvpv [required]: The present value of the investment. For a loan, Pv is the loan amount.)=ISPMT(rate, per, nper, pv)
  • rate (required): The interest rate for the investment.
  • nper (required): The total number of payment periods for the investment.
  • per (required): The period for which you want to find the interest, and must be between 1 and Nper.
  • pv (required): The present value of the investment. For a loan, Pv is the loan amount.
26MDURATIONReturns the modified Macauley duration for a security with an assumed par value of $100=MDURATION(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., couponcoupon [required]: The security's annual coupon rate., yldyld [required]: The security's annual yield., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=MDURATION(settlement, maturity, coupon, yld, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • coupon (required): The security's annual coupon rate.
  • yld (required): The security's annual yield.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
27MIRRReturns the modified internal rate of return for a series of periodic cash flows=MIRR(valuesvalues [required]: An array or a reference to cells that contain numbers., finance_ratefinance_rate [required]: The interest rate you pay on the money used in the cash flows., reinvest_ratereinvest_rate [required]: The interest rate you receive on the cash flows as you reinvest them.)=MIRR(values, finance_rate, reinvest_rate)
  • values (required): An array or a reference to cells that contain numbers.
  • finance_rate (required): The interest rate you pay on the money used in the cash flows.
  • reinvest_rate (required): The interest rate you receive on the cash flows as you reinvest them.
28NOMINALReturns the nominal annual interest rate, given the effective rate and the number of compounding periods per year=NOMINAL(effect_rateeffect_rate [required]: The effective interest rate., nperynpery [required]: The number of compounding periods per year.)=NOMINAL(effect_rate, npery)
  • effect_rate (required): The effective interest rate.
  • npery (required): The number of compounding periods per year.
29NPERReturns the number of periods for an investment based on periodic, constant payments and a constant interest rate=NPER(raterate [required]: The interest rate per period., pmtpmt [required]: The payment made each period; it cannot change over the life of the annuity., pvpv [required]: The present value, or the lump-sum amount that a series of future payments is worth right now., [fvfv [optional]: The future value, or a cash balance you want to attain after the last payment is made.], [typetype [optional]: The number 0 or 1 and indicates when payments are due.])=NPER(rate, pmt, pv, [fv], [type])
  • rate (required): The interest rate per period.
  • pmt (required): The payment made each period; it cannot change over the life of the annuity.
  • pv (required): The present value, or the lump-sum amount that a series of future payments is worth right now.
  • fv (optional): The future value, or a cash balance you want to attain after the last payment is made.
  • type (optional): The number 0 or 1 and indicates when payments are due.
30NPVCalculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values)=NPV(raterate [required]: The rate of discount over the length of one period., value1value1 [required]: First arguments representing the payments and income., [value2value2 [optional]: Additional arguments representing the payments and income.], ...)=NPV(rate, value1, [value2], ...)
  • rate (required): The rate of discount over the length of one period.
  • value1 (required): First arguments representing the payments and income.
  • value2 (optional): Additional arguments representing the payments and income.
31ODDFPRICEReturns the price per $100 face value of a security having an odd (short or long) first period=ODDFPRICE(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., issueissue [required]: The security's issue date., first_couponfirst_coupon [required]: The security's first coupon date., raterate [required]: The security's interest rate., yldyld [required]: The security's annual yield., redemptionredemption [required]: The security's redemption value per $100 face value., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • issue (required): The security's issue date.
  • first_coupon (required): The security's first coupon date.
  • rate (required): The security's interest rate.
  • yld (required): The security's annual yield.
  • redemption (required): The security's redemption value per $100 face value.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
32ODDFYIELDReturns the yield of a security that has an odd (short or long) first period=ODDFYIELD(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., issueissue [required]: The security's issue date., first_couponfirst_coupon [required]: The security's first coupon date., raterate [required]: The security's interest rate., prpr [required]: The security's price., redemptionredemption [required]: The security's redemption value per $100 face value., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • issue (required): The security's issue date.
  • first_coupon (required): The security's first coupon date.
  • rate (required): The security's interest rate.
  • pr (required): The security's price.
  • redemption (required): The security's redemption value per $100 face value.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
33ODDLPRICEReturns the price per $100 face value of a security having an odd (short or long) last coupon period=ODDLPRICE(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., last_interestlast_interest [required]: The security's last coupon date., raterate [required]: The security's interest rate., yldyld [required]: The security's annual yield., redemptionredemption [required]: The security's redemption value per $100 face value., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • last_interest (required): The security's last coupon date.
  • rate (required): The security's interest rate.
  • yld (required): The security's annual yield.
  • redemption (required): The security's redemption value per $100 face value.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
34ODDLYIELDReturns the yield of a security that has an odd (short or long) last period=ODDLYIELD(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., last_interestlast_interest [required]: The security's last coupon date., raterate [required]: The security's interest rate

, prpr [required]: The security's price., redemptionredemption [required]: The security's redemption value per $100 face value., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])
=ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • last_interest (required): The security's last coupon date.
  • rate (required): The security's interest rate

  • pr (required): The security's price.
  • redemption (required): The security's redemption value per $100 face value.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
35PDURATIONReturns the number of periods required by an investment to reach a specified value=PDURATION(raterate [required]: Rate is the interest rate per period., pvpv [required]: Pv is the present value of the investment., fvfv [required]: Fv is the desired future value of the investment.)=PDURATION(rate, pv, fv)
  • rate (required): Rate is the interest rate per period.
  • pv (required): Pv is the present value of the investment.
  • fv (required): Fv is the desired future value of the investment.
36PMTCalculates the payment for a loan based on constant payments and a constant interest rate=PMT(raterate [required]: The interest rate for the loan., npernper [required]: The total number of payments for the loan., pvpv [required]: The present value, or the total amount that a series of future payments is worth now; also known as the principal., [fvfv [optional]: The future value, or a cash balance you want to attain after the last payment is made.], [typetype [optional]: The number 0 (zero) or 1 and indicates when payments are due.])=PMT(rate, nper, pv, [fv], [type])
  • rate (required): The interest rate for the loan.
  • nper (required): The total number of payments for the loan.
  • pv (required): The present value, or the total amount that a series of future payments is worth now; also known as the principal.
  • fv (optional): The future value, or a cash balance you want to attain after the last payment is made.
  • type (optional): The number 0 (zero) or 1 and indicates when payments are due.
37PPMTReturns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate=PPMT(raterate [required]: The interest rate per period., perper [required]: Specifies the period and must be in the range 1 to nper., npernper [required]: The total number of payment periods in an annuity., pvpv [required]: The total amount that a series of future payments is worth now., [fvfv [optional]: The future value, or a cash balance you want to attain after the last payment is made.], [typetype [optional]: The number 0 or 1 and indicates when payments are due.])=PPMT(rate, per, nper, pv, [fv], [type])
  • rate (required): The interest rate per period.
  • nper (required): The total number of payment periods in an annuity.
  • per (required): Specifies the period and must be in the range 1 to nper.
  • pv (required): The total amount that a series of future payments is worth now.
  • fv (optional): The future value, or a cash balance you want to attain after the last payment is made.
  • type (optional): The number 0 or 1 and indicates when payments are due.
38PRICEReturns the price per $100 face value of a security that pays periodic interest=PRICE(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., raterate [required]: The security's annual coupon rate., yldyld [required]: The security's annual yield., redemptionredemption [required]: The security's redemption value per $100 face value., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • rate (required): The security's annual coupon rate.
  • yld (required): The security's annual yield.
  • redemption (required): The security's redemption value per $100 face value.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
39PRICEDISCReturns the price per $100 face value of a discounted security=PRICEDISC(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., discountdiscount [required]: The security's discount rate., redemptionredemption [required]: The security's redemption value per $100 face value., [basisbasis [optional]: The type of day count basis to use.])=PRICEDISC(settlement, maturity, discount, redemption, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • discount (required): The security's discount rate.
  • redemption (required): The security's redemption value per $100 face value.
  • basis (optional): The type of day count basis to use.
40PRICEMATReturns the price per $100 face value of a security that pays interest at maturity=PRICEMAT(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., issueissue [required]: The security's issue date, expressed as a serial date number., raterate [required]: The security's interest rate at date of issue., yldyld [required]: The security's annual yield., [basisbasis [optional]: The type of day count basis to use.])=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • issue (required): The security's issue date, expressed as a serial date number.
  • rate (required): The security's interest rate at date of issue.
  • yld (required): The security's annual yield.
  • basis (optional): The type of day count basis to use.
41PVCalculates the present value of a loan or an investment, based on a constant interest rate=PV(raterate [required]: The interest rate per period., npernper [required]: The total number of payment periods in an annuity., pmtpmt [required]: The payment made each period and cannot change over the life of the annuity., [fvfv [optional]: The future value, or a cash balance you want to attain after the last payment is made.], [typetype [optional]: The number 0 or 1 and indicates when payments are due.])=PV(rate, nper, pmt, [fv], [type])
  • rate (required): The interest rate per period.
  • nper (required): The total number of payment periods in an annuity.
  • pmt (required): The payment made each period and cannot change over the life of the annuity.
  • fv (optional): The future value, or a cash balance you want to attain after the last payment is made.
  • type (optional): The number 0 or 1 and indicates when payments are due.
42RATEReturns the interest rate per period of an annuity=RATE(npernper [required]: The total number of payment periods in an annuity., pmtpmt [required]: The payment made each period and cannot change over the life of the annuity., pvpv [required]: The present value ??? the total amount that a series of future payments is worth now., [fvfv [optional]: The future value, or a cash balance you want to attain after the last payment is made.], [typetype [optional]: The number 0 or 1 and indicates when payments are due.], [guessguess [optional]: Your guess for what the rate will be.])=RATE(nper, pmt, pv, [fv], [type], [guess])
  • nper (required): The total number of payment periods in an annuity.
  • pmt (required): The payment made each period and cannot change over the life of the annuity.
  • pv (required): The present value ??? the total amount that a series of future payments is worth now.
  • fv (optional): The future value, or a cash balance you want to attain after the last payment is made.
  • type (optional): The number 0 or 1 and indicates when payments are due.
  • guess (optional): Your guess for what the rate will be.
43RECEIVEDReturns the amount received at maturity for a fully invested security=RECEIVED(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., investmentinvestment [required]: The amount invested in the security., discountdiscount [required]: The security's discount rate., [basisbasis [optional]: The type of day count basis to use.])=RECEIVED(settlement, maturity, investment, discount, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • investment (required): The amount invested in the security.
  • discount (required): The security's discount rate.
  • basis (optional): The type of day count basis to use.
44RRIReturns an equivalent interest rate for the growth of an investment=RRI(npernper [required]: Nper is the number of periods for the investment., pvpv [required]: Pv is the present value of the investment., fvfv [required]: Fv is the future value of the investment.)=RRI(nper, pv, fv)
  • nper (required): Nper is the number of periods for the investment.
  • pv (required): Pv is the present value of the investment.
  • fv (required): Fv is the future value of the investment.
45SLNReturns the straight-line depreciation of an asset for one period=SLN(costcost [required]: The initial cost of the asset., salvagesalvage [required]: The value at the end of the depreciation (sometimes called the salvage value of the asset)., lifelife [required]: The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).)=SLN(cost, salvage, life)
  • cost (required): The initial cost of the asset.
  • salvage (required): The value at the end of the depreciation (sometimes called the salvage value of the asset).
  • life (required): The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
46SYDReturns the sum-of-years' digits depreciation of an asset for a specified period=SYD(costcost [required]: The initial cost of the asset., salvagesalvage [required]: The value at the end of the depreciation (sometimes called the salvage value of the asset)., lifelife [required]: The number of periods over which the asset is depreciated (sometimes called the useful life of the asset)., perper [required]: The period and must use the same units as life.)=SYD(cost, salvage, life, per)
  • cost (required): The initial cost of the asset.
  • salvage (required): The value at the end of the depreciation (sometimes called the salvage value of the asset).
  • life (required): The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
  • per (required): The period and must use the same units as life.
47TBILLEQReturns the bond-equivalent yield for a Treasury bill=TBILLEQ(settlementsettlement [required]: The Treasury bill's settlement date., maturitymaturity [required]: The Treasury bill's maturity date., discountdiscount [required]: The Treasury bill's discount rate.)=TBILLEQ(settlement, maturity, discount)
  • settlement (required): The Treasury bill's settlement date.
  • maturity (required): The Treasury bill's maturity date.
  • discount (required): The Treasury bill's discount rate.
48TBILLPRICEReturns the price per $100 face value for a Treasury bill=TBILLPRICE(settlementsettlement [required]: The Treasury bill's settlement date., maturitymaturity [required]: The Treasury bill's maturity date., discountdiscount [required]: The Treasury bill's discount rate.)=TBILLPRICE(settlement, maturity, discount)
  • settlement (required): The Treasury bill's settlement date.
  • maturity (required): The Treasury bill's maturity date.
  • discount (required): The Treasury bill's discount rate.
49TBILLYIELDReturns the yield for a Treasury bill=TBILLYIELD(settlementsettlement [required]: The Treasury bill's settlement date., maturitymaturity [required]: The Treasury bill's maturity date., prpr [required]: The Treasury bill's price per $100 face value.)=TBILLYIELD(settlement, maturity, pr)
  • settlement (required): The Treasury bill's settlement date.
  • maturity (required): The Treasury bill's maturity date.
  • pr (required): The Treasury bill's price per $100 face value.
50VDBReturns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify=VDB(costcost [required]: The initial cost of the asset., salvagesalvage [required]: The value at the end of the depreciation (sometimes called the salvage value of the asset)., lifelife [required]: The number of periods over which the asset is depreciated (sometimes called the useful life of the asset)., start_periodstart_period [required]: The starting period for which you want to calculate the depreciation., end_periodend_period [required]: The ending period for which you want to calculate the depreciation., [factorfactor [optional]: The rate at which the balance declines.], [no_switchno_switch [optional]: A logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.])=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
  • cost (required): The initial cost of the asset.
  • salvage (required): The value at the end of the depreciation (sometimes called the salvage value of the asset).
  • life (required): The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
  • start_period (required): The starting period for which you want to calculate the depreciation.
  • end_period (required): The ending period for which you want to calculate the depreciation.
  • factor (optional): The rate at which the balance declines.
  • no_switch (optional): A logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.
51XIRRReturns the internal rate of return for a schedule of cash flows that is not necessarily periodic=XIRR(valuesvalues [required]: A series of cash flows that corresponds to a schedule of payments in dates., datesdates [required]: A schedule of payment dates that corresponds to the cash flow payments., [guessguess [optional]: A number that you guess is close to the result of XIRR.])=XIRR(values, dates, [guess])
  • values (required): A series of cash flows that corresponds to a schedule of payments in dates.
  • dates (required): A schedule of payment dates that corresponds to the cash flow payments.
  • guess (optional): A number that you guess is close to the result of XIRR.
52XNPVReturns the net present value for a schedule of cash flows that is not necessarily periodic=XNPV(raterate [required]: The discount rate to apply to the cash flows., valuesvalues [required]: A series of cash flows that corresponds to a schedule of payments in dates., datesdates [required]: A schedule of payment dates that corresponds to the cash flow payments.)=XNPV(rate, values, dates)
  • rate (required): The discount rate to apply to the cash flows.
  • values (required): A series of cash flows that corresponds to a schedule of payments in dates.
  • dates (required): A schedule of payment dates that corresponds to the cash flow payments.
53YIELDReturns the yield on a security that pays periodic interest=YIELD(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., raterate [required]: The security's annual coupon rate., prpr [required]: The security's price per $100 face value., redemptionredemption [required]: The security's redemption value per $100 face value., frequencyfrequency [required]: The number of coupon payments per year., [basisbasis [optional]: The type of day count basis to use.])=YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • rate (required): The security's annual coupon rate.
  • pr (required): The security's price per $100 face value.
  • redemption (required): The security's redemption value per $100 face value.
  • frequency (required): The number of coupon payments per year.
  • basis (optional): The type of day count basis to use.
54YIELDDISCReturns the annual yield for a discounted security=YIELDDISC(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., prpr [required]: The security's price per $100 face value., redemptionredemption [required]: The security's redemption value per $100 face value., [basisbasis [optional]: The type of day count basis to use.])=YIELDDISC(settlement, maturity, pr, redemption, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • pr (required): The security's price per $100 face value.
  • redemption (required): The security's redemption value per $100 face value.
  • basis (optional): The type of day count basis to use.
55YIELDMATReturns the annual yield of a security that pays interest at maturity=YIELDMAT(settlementsettlement [required]: The security's settlement date., maturitymaturity [required]: The security's maturity date., issueissue [required]: The security's issue date, expressed as a serial date number., raterate [required]: The security's interest rate at date of issue., prpr [required]: The security's price per $100 face value., [basisbasis [optional]: The type of day count basis to use.])=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])
  • settlement (required): The security's settlement date.
  • maturity (required): The security's maturity date.
  • issue (required): The security's issue date, expressed as a serial date number.
  • rate (required): The security's interest rate at date of issue.
  • pr (required): The security's price per $100 face value.
  • basis (optional): The type of day count basis to use.

 

1 Comments for '(Excel) - List of Excel Financial Functions with Syntax and Arguments'   

 
Email me replies   

Comment #1 by svendb7 Jul 20, 2021 at 12:36 pm  Reply

Great reference article. Thanks!

Please kindly review and accept Terms of Use and Cookie & Policy Policy