next up previous contents index
Next: ACCRINTM Up: A Function Reference Previous: ABS

ACCRINT

 

Syntax: @ACCRINT(I, Ft, S, R, P, F [, B])

I = The issue date.
Ft = The first interest date.
S = The settlement date.
R = The annual coupon rate.
P = The par value of the security.
F = The number of coupon payments per year (frequency).
B = (Optional) The day count basis to be used:

0 or omitted 30/360
1 Actual/actual
2 Actual/360
3 Actual/365

@ACCRINT returns the accrued interest for a security that pays periodic interest. Accrued interest is the amount the buyer must compensate the seller for the portion of the next coupon interest payment the seller has earned but will not receive from the issuer.

Example:

@ACCRINT(A1, A2, A3, A4, A5, A6, A7) = 35.3611, where A1=02/01/93, A2=08/01/93, A3=06/15/93, A4=0.095, A5=1000, A6=2, and A7=0


next up previous contents index
Next: ACCRINTM Up: A Function Reference Previous: ABS

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999