Function
|
Name
|
Description
|
ACCRINT(issue, firstInterest, settlement, rate, par, frequency, basis, calcMethod) |
ACCRINT |
Returns the accrued interest for a security that pays periodic interest. |
ACCRINTM(issue, settlement, rate, par, basis) |
ACCRINTM |
Returns the accrued interest for a security that pays interest at maturity. |
AMORDEGRC(cost, datePurchased, firstPeriod, salvage, period, rate, basis) |
AMORDEGRC |
Returns the depreciation for each accounting period by using a depreciation coefficient. |
AMORLINC(cost, datePurchased, firstPeriod, salvage, period, rate, basis) |
AMORLINC |
Returns the depreciation for each accounting period. |
COUPDAYBS(settlement, maturity, frequency, basis) |
COUPDAYBS |
Returns the number of days from the beginning of the coupon period to the settlement date. |
COUPDAYS(settlement, maturity, frequency, basis) |
COUPDAYS |
Returns the number of days in the coupon period that contains the settlement date. |
COUPDAYSNC(settlement, maturity, frequency, basis) |
COUPDAYSNC |
Returns the number of days from the settlement date to the next coupon date. |
COUPNCD(settlement, maturity, frequency, basis) |
COUPNCD |
Returns the next coupon date after the settlement date. |
COUPNUM(settlement, maturity, frequency, basis) |
COUPNUM |
Returns the number of coupons payable between the settlement date and maturity date. |
COUPPCD(settlement, maturity, frequency, basis) |
COUPPCD |
Returns the previous coupon date before the settlement date. |
CUMIPMT(rate, nper, pv, startPeriod, endPeriod, typ) |
CUMIPMT |
Returns the cumulative interest paid between two periods. |
CUMPRINC(rate, nper, pv, startPeriod, endPeriod, typ) |
CUMPRINC |
Returns the cumulative principal paid on a loan between two periods. |
DB(cost, salvage, life, period, month) |
DB |
Returns the depreciation of an asset for a specified period by using the fixed-declining balance method. |
DDB(cost, salvage, life, period, factor) |
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. |
DISC(settlement, maturity, pr, redemption, basis) |
DISC |
Returns the discount rate for a security. |
DOLLARDE(fractionalDollar, fraction) |
DOLLARDE |
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. |
DOLLARFR(decimalDollar, fraction) |
DOLLARFR |
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction. |
DURATION(settlement, maturity, coupon, yld, frequency, basis) |
DURATION |
Returns the annual duration of a security with periodic interest payments. |
EFFECT(nominalRate, npery) |
EFFECT |
Returns the effective annual interest rate. |
FV(rate, nper, pmt, pv, typ) |
FV |
Returns the future value of an investment. |
FVSCHEDULE(principal, schedule) |
FVSCHEDULE |
Returns the future value of an initial principal after applying a series of compound interest rates. |
INTRATE(settlement, maturity, investment, redemption, basis) |
INTRATE |
Returns the interest rate for a fully invested security. |
IPMT(rate, per, nper, pv, fv, typ) |
IPMT |
Returns the interest payment for an investment for a given period. |
IRR(values, guess) |
IRR |
Returns the internal rate of return for a series of cash flows. |
ISPMT(rate, per, nper, pv) |
ISPMT |
Calculates the interest paid during a specific period of an investment. |
MDURATION(settlement, maturity, coupon, yld, frequency, basis) |
MDURATION |
Returns the Macauley modified duration for a security with an assumed par value of $100. |
MIRR(values, financeRate, reinvestRate) |
MIRR |
Returns the internal rate of return where positive and negative cash flows are financed at different rates. |
NOMINAL(effectRate, npery) |
NOMINAL |
Returns the annual nominal interest rate. |
NPER(rate, pmt, pv, fv, typ) |
NPER |
Returns the number of periods for an investment. |
NPV(rate, values) |
NPV |
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate. |
PMT(rate, nper, pv, fv, typ) |
PMT |
Returns the periodic payment for an annuity. |
PPMT(rate, per, nper, pv, fv, typ) |
PPMT |
Returns the payment on the principal for an investment for a given period. |
PRICE(settlement, maturity, rate, yld, redemption, frequency, basis) |
PRICE |
Returns the price per $100 face value of a security that pays periodic interest. |
PRICEDISC(settlement, maturity, discount, redemption, basis) |
PRICEDISC |
Returns the price per $100 face value of a discounted security. |
PRICEMAT(settlement, maturity, issue, rate, yld, basis) |
PRICEMAT |
Returns the price per $100 face value of a security that pays interest at maturity. |
PV(rate, nper, pmt, fv, typ) |
PV |
Returns the present value of an investment. |
RATE(nper, pmt, pv, fv, typ, guess) |
RATE |
Returns the interest rate per period of an annuity. |
RECEIVED(settlement, maturity, investment, discount, basis) |
RATE |
Returns the amount received at maturity for a fully invested security. |
SLN(cost, salvage, life) |
SLN |
Returns the straight-line depreciation of an asset for one period. |
SYD(cost, salvage, life, per) |
SYD |
Returns the sum-of-years’ digits depreciation of an asset for a specified period. |
TBILLEQ(settlement, maturity, discount) |
TBILLEQ |
Returns the bond-equivalent yield for a Treasury bill. |
TBILLPRICE(settlement, maturity, discount) |
TBILLPRICE |
Returns the price per $100 face value for a Treasury bill. |
TBILLYIELD(settlement, maturity, pr) |
TBILLYIELD |
Returns the yield for a Treasury bill. |
VDB(cost, salvage, life, startPeriod, endPeriod, factor) |
VDB |
Returns the depreciation of an asset for a specified or partial period by using a declining balance method. |
XIRR(values, dates, guess) |
XIRR |
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. |
XNPV(rate, values, dates) |
XIRR |
Returns the net present value for a schedule of cash flows that is not necessarily periodic. |
YIELD(settlement, maturity, rate, pr, redemption, frequency, basis) |
YIELD |
Returns the yield on a security that pays periodic interest. |
YIELDDISC(settlement, maturity, pr, redemption, basis) |
YIELDDISC |
Returns the annual yield for a discounted security; for example, a Treasury bill. |
YIELDMAT(settlement, maturity, issue, rate, pr, basis) |
YIELDMAT |
Returns the annual yield of a security that pays interest at maturity. |