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


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

Excel function: N/A


next up previous contents index
Next: ACCRINTM Up: A. Function Reference Previous: ABS   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003