description:
Let’s suppose you are the original buyer of a bond and you buy that bond after the issue date, the bond will have earned some interest during that time. The ACCRINT function returns this accrued interest. |
syntax:
ACCRINT( issue, first_interest, settlement, rate, par, frequency, [basis] ) |
required arguments:
issue | Security’s issue date. |
first_interest | Security’s first interest date. |
settlement | Security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. The ACCRINT function calculates the interest that would have been earned between the issue date and the settlement date. |
rate | Security’s annual coupon rate. |
par | Security’s par value. If you omit par, ACCRINT uses $1,000. |
frequency | The number of coupon payments per year. |
optional arguments:
[basis] | The type of day count basis to use. You use 0 for U.S. bonds. |