EXCEL ACCRINT FUNCTION

The ACCRINT method in Excel File returns actual accumulated interest for a property that pays interest on a recurring basis.
The ACCRINT function is an Excel constructed function that is classified as a Financial Function. It may be used in Excel as a worksheet function (WS). The ACCRINT method is a worksheets function that may be used as part of a formula in a worksheet cell.

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:
ValueExplanation
1Annual payments
2Semi-annual payments
4Quarterly payments

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.
ValueExplanation
0US (NASD) 30/360
1Actual/Actual
2Actual/360
3Actual/365
4European 30/360
calculation_method:

Optional. It is either of the following values:

ValueExplanation
0Calculates the accrued interest from first_interest_date to settlement_date
1Calculates the accrued interest from issue_date to settlement_date

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
Example:

Let’s look at some Excel ACCRINT function examples and learn how to utilise the ACCRINT function in Microsoft Excel as a worksheet function:

=ACCRINT(B1,B2,B3,B4,B5,B6,B7,B8)

Result: 32.3630137

 

 

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now