The ACCRINT function calculates the accrued interest for a security that pays periodic interest.
Formula in cell C9:
Excel Function Syntax
issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) Arguments
issue Required. The security's issue date.
first_interest Required. The security's first interest date.
settlement Required. The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
rate Required. The security's annual coupon rate.
par Required. The security's par value. Default value is $1,000.
frequency Required. The number of coupon payments per year.
[basis] Optional. The type of day count basis to use.
Day count basis
0 (default value) US (NASD) 30/360
4 European 30/360
[calc_method] Optional. A logical value that specifies the way to calculate the total accrued interest when the date of settlement is later than the date of first_interest.
TRUE Returns the total accrued interest from issue to settlement.
FALSE Returns the accrued interest from first_interest to settlement. Default value.
Use the DATE function to enter dates in the ACCRINT function. For example, DATE(2018,1,1).
How to use the DATE function
The ACCRINT function function is one of many functions in the 'Financial' category.