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 fixed-declining balance method. |
DB(cost, salvage, life, period, [month]) |

DDB |
Returns the depreciation of an asset for a specified period by using the double-declining 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 straight-line depreciation of an asset for one period. |
SLN(cost, salvage, life) |

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

TBILLEQ |
Returns the bond-equivalent 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]) |