Name 
Description 
Syntax 
ACCRINTM  Returns the accrued interest for a security that pays interest at maturity.
 ACCRINTM(issue, settlement, rate, par, [basis])

COUPDAYBS  Returns the number of days from the beginning of the coupon period to the settlement date.
 COUPDAYBS(settlement, maturity, frequency, [basis])

COUPNCD  Returns the next coupon date after the settlement date.  COUPNCD(settlement, maturity, frequency, [basis])

COUPNUM  Returns the number of coupons payable between the settlement date and maturity date.  COUPNUM(settlement, maturity, frequency, [basis])

COUPPCD  Returns the previous coupon date before the settlement date.  COUPPCD(settlement, maturity, frequency, [basis])

CUMIPMT  Calculates the cumulative interest paid between two specified periods.  CUMIPMT(rate, nper, pv, start_period, end_period, type)

CUMPRINC  Calculates the cumulative principal paid on a loan, between two specified periods.  CUMPRINC(rate, nper, pv, start_period, end_period, type)

DB  Returns the depreciation of an asset for a specified period by using the fixeddeclining balance method.  DB(cost, salvage, life, period, [month])

DDB  Returns the depreciation of an asset for a specified period by using the doubledeclining balance method or some other method that you specify.  DDB(cost, salvage, life, period, [factor])

DISC  Returns the discount rate for a security.  DISC(settlement, maturity, pr, redemption, [basis])

DOLLARDE  Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.  DOLLARDE(fractional_dollar, fraction)

DOLLARFR  Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.  DOLLARFR(decimal_dollar, fraction)

FVSCHEDULE  Returns the future value of an initial principal after applying a series of compound interest rates.  FVSCHEDULE(principal, schedule)

EFFECT  Returns the effective annual interest rate.  EFFECT(nominal_rate, npery)

FV  Calculates the future value of an investment with periodic constant payments and a constant interest rate.  FV(rate,nper,pmt,[pv],[type])

INTRATE  Returns the interest rate for a fully invested security.  INTRATE(settlement, maturity, investment, redemption, [basis])

IPMT  Calculates the interest payment for a given period of an investment, with periodic constant payments and a constant interest rate.  IPMT(rate, per, nper, pv, [fv], [type])

IRR  Calculates the internal rate of return for a series of cash flows.  IRR(values, [guess])

ISPMT  Calculates the interest paid during a specific period of an investment.  ISPMT(rate, per, nper, pv)

MIRR  Calculates the internal rate of return for a series of periodic cash flows, considering the cost of the investment and the interest on the reinvestment of cash.  MIRR(values, finance_rate, reinvest_rate)

NOMINAL  Returns the annual nominal interest rate.  NOMINAL(effect_rate, npery)

NPER  Returns the number of periods for an investment with periodic constant payments and a constant interest rate.  NPER(rate,pmt,pv,[fv],[type])

NPV  Calculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and income.  NPV(rate,value1,[value2],...)

PDURATION  Returns the number of periods required by an investment to reach a specified value.  PDURATION(rate, pv, fv)

PMT  Calculates the payments required to reduce a loan, from a supplied present value to a specified future value.  PMT(rate, nper, pv, [fv], [type])

PPMT  Calculates the payment on the principal for a given investment, with periodic constant payments and a constant interest rate.  PPMT(rate, per, nper, pv, [fv], [type])

PRICEDISC  Returns the price per $100 face value of a discounted security.  PRICEDISC(settlement, maturity, discount, redemption, [basis])

PV  Calculates the present value of an investment (i.e., the total amount that a series of future payments is worth now).  PV(rate, nper, pmt, [fv], [type])

RATE  Calculates the interest rate required to pay off a specified amount of a loan, or reach a target amount on an investment over a given period.  RATE(nper, pmt, pv, [fv], [type], [guess])

RECEIVED  Returns the amount received at maturity for a fully invested security.  RECEIVED(settlement, maturity, investment, discount, [basis])

RRI  Returns an equivalent interest rate for the growth of an investment.  RRI(nper, pv, fv)

SLN  Returns the straightline depreciation of an asset for one period.  SLN(cost, salvage, life)

SYD  Returns the sumofyears' digits depreciation of an asset for a specified period.  SYD(cost, salvage, life, per)

TBILLEQ  Returns the bondequivalent yield for a Treasury bill.  TBILLEQ(settlement, maturity, discount)

TBILLPRICE  Returns the price per $100 face value for a Treasury bill.  TBILLPRICE(settlement, maturity, discount)

TBILLYIELD  Returns the yield for a Treasury bill.  TBILLYIELD(settlement, maturity, pr)

VDB  Returns the depreciation of an asset for a specified or partial period by using a declining balance method  VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]).

YIELDDISC  YIELDDISC(settlement, maturity, pr, redemption, [basis])  Returns the annual yield for a discounted security; for example, a Treasury bill.

XNPV  Returns the net present value for a schedule of cash flows that is not necessarily periodic.  XNPV(rate, values, dates)

XIRR  Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.  XIRR(values, dates, [guess]) 