Ø @ACCRINT(I, Ft, S, R, P, F[, B]) -
Accrued interest for a security that pays periodic interest.
Ø @ACCRINTM(I, S, R, P[, B]) -
Accrued interest for a security that pays interest at maturity.
Ø @COUPDAYBS(S, M, F[, B]) -
The number of days between the beginning of the coupon period to the settlement date.
Ø @COUPDAYS(S, M, F[, B]) -
The number of days in the coupon period that the settlement date is in.
Ø @COUPDAYSNC(S, M, F[, B]) -
The number of days between the settlement date and the next coupon date.
Ø @COUPNCD(S, M, F[, B]) -
The next coupon date after the settlement date.
Ø @COUPNUM(S, M, F[, B]) -
The number of coupon payments between the settlement date and maturity date.
Ø @COUPPCD(S, M, F[, B]) -
The previous (most recent) coupon date before the settlement date.
Ø @CTERM(R, FV, PV) -
The number of compounding periods for an investment.
Ø @CUMIPMT(R, NP, PV, S, E, T) -
The cumulative interest on a loan between start period S and end period E.
Ø @CUMPRINC(R, NP, PV, S, E, T) -
The cumulative principal paid on a loan between start period S and end period E.
Ø @DB(C, S, L, P[, M]) -
Fixed-declining depreciation allowance.
Ø @DDB(C, S, L, N) -
Double-declining depreciation allowance.
Ø @DISC(S, M, P, R[, B]) -
The discount rate for a security.
Ø @DOLLARDE(FD, F) -
Converts a dollar amount expressed as a fraction form into a decimal form.
Ø @DOLLARFR(DD, F) -
Converts a dollar amount expressed as a decimal form into a fraction form.
Ø @DURATION(S, M, R, Y, F[, B]) -
The Macauley duration of a security assuming $100 face value.
Ø @EFFECT(NR, NP) -
Returns the effective annual interest rate.
Ø @FV(P, R, N) -
Future value of an annuity.
Ø @FVSCHEDULE(P, S) -
The future value of an initial investment after compounding a series of interest rates.
Ø @INTRATE(S, M, I, R[, B]) -
The interest rate for a fully invested security.
Ø @IPMT(R, P, NP, PV, FV[, T]) -
The interest payment for a specific period for an investment based on periodic, constant payments and a constant interest rate.
Ø @IRR(G, F) -
The internal rate of return on an investment. (See also @XIRR and @MIRR.)
Ø @MDURATION(S, M, R, Y, F[, B]) -
The modified Macauley duration of a security assuming $100 face value.
Ø @MIRR(CF, FR, RR) -
The modified internal rate of return for a series of periodic cash flows.
Ø @NOMINAL(ER, NP) -
The nominal annual interest rate.
Ø @ODDFPRICE(S, M, I, FC, R, Y, RD, F[, B]) -
The price per $100 face value of a security with an odd (short or long) first period.
Ø @ODDFYIELD(S, M, I, FC, R, PR, RD, F[, B]) -
The yield per of a security with an odd (short or long) first period.
Ø @PMT(PV, R, N) -
The periodic payment for a loan.
Ø @PPMT(R, P, NP, PV, FV, T) -
The payment on the principal for a specific period for an investment based on periodic, constant payments and a constant interest rate.
Ø @PRICE(S, M, R, Y, RD, F[, B]) -
The price per $100 face value of a security that pays periodic interest.
Ø @PRICEDISC(S, M, D, RD[, B]) -
The price per $100 face value of a discounted security.
Ø @PRICEMAT(S, M, I, R, Y[, B]) -
The price per $100 face value of a security that pays interest at maturity.
Ø @PV(P, R, N) -
The present value of an annuity
Ø @RATE(FV, PV, N) -
The interest rate required to reach future value FV.
Ø @RECEIVED(S, M, I, D, [, B]) -
The amount received at maturity for a fully vested security.
Ø @SLN(C, S, L) -
The straight-line depreciation allowance.
Ø @SYD(C, S, L, N) -
The ``sum-of-years-digits"" depreciation allowance.
Ø @TBILLEQ(S, M, D) -
The bond-equivalent yield (BEY) for a Treasury Bill.
Ø @TBILLYIELD(S, M, D) -
The yield on a Treasury bill.
Ø @TERM(P, R, FV) -
The number of payment periods for an investment.
Ø @VDB(C, S, L, S, E) -
Fixed-declining depreciation allowance between two periods.
Ø @XIRR(G, V, D) -
Internal rate of return for a series of cash flows with variable intervals.
Ø @XNPV(R, V, D) -
Returns the net present value for a series of cash flows with variable intervals.
Ø @YIELD(S, M, R, PR, RD, F[, B]) -
Yield of a security that pays periodic interest.
Ø @YIELDMAT(S, M, I, R, PR[, B]) -
Annual yield of a security which pays interest at maturity.