ACCRINT function


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.



ACCRINT( issuefirst_interestsettlementrateparfrequency[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.