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 a buyer must compensate a 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:

 

 

 

Examples

 

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.