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*

Grey Trout Software

02 March 2003