next up previous contents index
Next: 7.11.8 Date and Time Up: 7.11 Quick-Reference Guide to Previous: 7.11.6 Digital Logic Functions

7.11.7 Financial 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 up previous contents index
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