Syntax:

=ACCRINT( issue_date, first_interest_date, settlement_date, rate, par, frequency, [basis], [calculation_method] )

Parameters:

Issue_date:

• The security was issued on this day.

First_interest_date:

• The day on which the first interest payment will be made.

Settlement_date:

• The security’s settlement date.

Rate:

• The security’s yearly coupon rate.

Par:

• The security’s par value. If this argument is left blank, the ACCRINT function will presume the par is set to $1,000.

Frequency:

• The frequency with which the security’s interest payments are made. It can be any of the values listed below:

Basis:

• Optional. It is the sort of day count to utilise when computing the security’s interest. If this option is not specified, the basis is assumed to be set to 0.

calculation_method:

Optional. It is either of the following values:

Returns:

• The ACCRINT function outputs a number.

Applies To:

• Worksheet function in Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007 (WS)

Type of Function:

• Worksheet function (WS