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

Description
This function 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.

Parameters
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

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