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