Menu
EXCEL ACCRINT FUNCTION
Excel ACCRINT Function Introduction
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.
Description of Excel ACCRINT Function
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:
| Value | Explanation |
|---|---|
| 1 | Annual payments |
| 2 | Semi-annual payments |
| 4 | Quarterly 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.
| Value | Explanation |
|---|---|
| 0 | US (NASD) 30/360 |
| 1 | Actual/Actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
calculation_method:
Optional. It is either of the following values:
| Value | Explanation |
|---|---|
| 0 | Calculates the accrued interest from first_interest_date to settlement_date |
| 1 | Calculates 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
Step By Step Guide of ACCRINT Function
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 NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
