Special Functions

Error Functions

BETA Function

Beta function

BETAI Function

Incomplete beta function

ERF Function

Error function

ERFC Function

Complementary error function

ERFCE Function

Evaluates the exponentially scaled complementary error function

ERFE Function

Evaluates a scaled function related to ERFC(z)

LNBETA Function

Logarithmic beta function

Gamma Functions

GAMMA Function

Gamma function

LNGAMMA Function

Logarithmic gamma function

GAMMA Function

Incomplete gamma function

Bessel Functions with Real Order and Complex Argument

BESSI Function

Modified Bessel function of the first kind

BESSJ Function

Bessel function of the first kind

BESSK Function

Modified Bessel function of the second kind

BESSY Function

Bessel function of the second kind

BESSI_EXP Function

Evaluates the exponentially scaled modified Bessel function of the first kind of orders zero and one.

BESSK_EXP Function

Evaluates the exponentially scaled modified Bessel function of the third kind of orders zero and one.

Elliptical Integrals

ELE Function

Evaluates the complete elliptic integral of the second kind E(x).

ELK Function

Evaluates the complete elliptic integral of the kind K(x).

ELRF Function

Evaluates Carlson's elliptic integral of the first kind RF(x, y, z).

ELRD Function

Evaluates Carlson's elliptic integral of the second kind RD(x, y, z).

ELRJ Function

Evaluates Carlson's elliptic integral of the third kind RJ (x, y, z, r)

ELRC Function

Evaluates an elementary integral from which inverse circular functions, logarithms and inverse hyperbolic functions can be computed.

Fresnel Integrals

FRESNEL_COSINE Function

Evaluates the cosine Fresnel integral.

FRESNEL_SINE Function

Evaluates the sine Fresnel integral.

Airy Functions

AIRY_AI Function

Evaluates the Airy function.

AIRY_BI Function

Evaluates the Airy function of the second kind.

Hermite Functions

HERMITE Function

Evaluates Hermite polynomials.

Kelvin Functions

KELVIN_BER0 Function

Evaluates the Kelvin function of the first kind, ber, of order zero.

KELVIN_BEI0 Function

Evaluates the Kelvin function of the first kind, bei, of order zero.

KELVIN_KER0 Function

Evaluates the Kelvin function of the second kind, ker, of order zero.

KELVIN_KEI0 Function

Evaluates the Kelvin function of the second kind, kei, of order zero.

Legendre Functions

LEGENDRE Function

Evaluates the associated Legendre functions.

Basic Financial Functions

CUM_INTR Function

Evaluates the cumulative interest paid between two periods.

CUM_PRINC Function

Evaluates the cumulative principal paid between two periods.

DEPRECIATION_DB Function

Evaluates the depreciation of an asset using the fixed-declining balance method.

DEPRECIATION_DDB Function

Evaluates the depreciation of an asset using the double-declining balance method.

DEPRECIATION_SLN Function

Evaluates the depreciation of an asset using the straight-line method.

DEPRECIATION_SYD Function

Evaluates the depreciation of an asset using the sum-of-years digits method.

DEPRECIATION_VDB Function

Evaluates the depreciation of an asset for any given period using the variable-declining balance method.

DOLLAR_DECIMAL Function

Converts a fractional price to a decimal price.

DOLLAR_FRACTION Function

Converts a decimal price to a fractional price.

EFFECTIVE_RATE Function

Evaluates effective annual interest rate.

FUTURE_VALUE Function

Evaluates the future value of an investment.

FUTURE_VAL_SCHD Function

Evaluates the future value of an initial principal taking into consideration a schedule of compound interest rates.

INT_PAYMENT Function

Evaluates the interest payment for an investment for a given period.

INT_RATE_ANNUITY Function

Evaluates the interest rate per period of an annuity.

INT_RATE_RETURN Function

Evaluates the internal rate of return for a schedule of cash flows.

INT_RATE_SCHD Function

Evaluates the internal rate of return for a schedule of cash flows. It is not necessary that the cash flows be periodic.

MOD_INTERN_RATE Function

Evaluates the modified internal rate of return for a schedule of periodic cash flows.

NET_PRES_VALUE Function

Evaluates the net present value of a stream of unequal periodic cash flows, which are subject to a given discount rate.

NOMINAL_RATE Function

Evaluates the nominal annual interest rate.

NUM_PERIODS Function

Evaluates the number of periods for an investment for which periodic and constant payments are made and the interest rate is constant.

PAYMENT Function

Evaluates the periodic payment for an investment.

PRESENT_VALUE Function

Evaluates the net present value of a stream of equal periodic cash flows, which are subject to a given discount rate.

PRES_VAL_SCHD Function

Evaluates the present value for a schedule of cash flows. It is not necessary that the cash flows be periodic.

PRINC_PAYMENT Function

Evaluates the payment on the principal for a specified period.

Bond Functions

ACCR_INT_MAT Function

Evaluates the interest which has accrued on a security that pays interest at maturity.

ACCR_INT_PER Function

Evaluates the interest which has accrued on a security that pays interest periodically.

BOND_EQV_YIELD Function

Evaluates the bond-equivalent yield of a Treasury bill.

CONVEXITY Function

Evaluates the convexity for a security.

COUPON_DAYS Function

Evaluates the number of days in the coupon period containing the settlement date.

COUPON_NUM Function

Evaluates the number of coupons payable between the settlement date and the maturity date.

SETTLEMENT_DB Function

Evaluates the number of days starting with the beginning of the coupon period and ending with the settlement date.

COUPON_DNC Function

Evaluates the number of days starting with the settlement date and ending with the next coupon date.

DEPREC_AMORDEGRC Function

Evaluates the depreciation for each accounting period. During the evaluation of the function a depreciation coefficient based on the asset life is applied.

DEPREC_AMORLINC Function

Evaluates the depreciation for each accounting period.

DISCOUNT_PR Function

Evaluates the price of a security sold for less than its face value.

DISCOUNT_RT Function

Evaluates the interest rate implied when a security is sold for less than its value at maturity in lieu of interest payments.

DISCOUNT_YLD Function

Evaluates the annual yield of a discounted security.

DURATION Function

Evaluates the annual duration of a security, where the security has periodic interest payments.

INT_RATE_SEC Function

Evaluates the interest rate of a fully invested security.

DURATION_MAC Function

Evaluates the modified Macauley duration of a security.

COUPON_NCD Function

Evaluates the first coupon date which follows the settlement date.

COUPON_PCD Function

Evaluates the coupon date which immediately precedes the settlement date.

PRICE_PERIODIC Function

Evaluates the price, per $100 face value, of a security that pays periodic interest.

PRICE_MATURITY Function

Evaluates the price, per $100 face value, of a security that pays interest at maturity.

MATURITY_REC Function

Evaluates the amount one receives when a fully invested security reaches the maturity date.

TBILL_PRICE Function

Evaluates the price per $100 face value of a Treasury bill.

TBILL_YIELD Function

Evaluates the yield of a Treasury bill.

YEAR_FRACTION Function

Evaluates the fraction of a year represented by the number of whole days between two dates.

YIELD_MATURITY Function

Evaluates the annual yield of a security that pays interest at maturity.

YIELD_PERIODIC Function

Evaluates the yield of a security that pays periodic interest.