Next: 7.11.8 Date and Time
Up: 7.11 Quick-Reference Guide to
Previous: 7.11.6 Digital Logic Functions
- @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 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.
- @NPV(R, CF) -
- The present value of a series of future cash
flows at given the rate R and the cash flow
CF range.
- @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.
- @ODDLPRICE(S, M, LC, R, Y, RD, F[, B]) -
- The price per $100
face value of a security with an odd (short or long)
last period.
- @ODDLYIELD(S, M, LC, 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.
- @TBILLPRICE(S, M, D) -
- The price per $100 face value 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.
- @YIELDDISC(S, M, PR, RD[, B]) -
- The annual yield for a
discounted security.
- @YIELDMAT(S, M, I, R, PR[, B]) -
- Annual yield of a security
which pays interest at maturity.
Next: 7.11.8 Date and Time
Up: 7.11 Quick-Reference Guide to
Previous: 7.11.6 Digital Logic Functions
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999