Learn =ACCRINT() function – How to use and examples and

What is use of ACCRINT() function for?

The ACCRINT() function in Microsoft Excel is used to calculate the amount of accrued interest for a security with an irregular coupon schedule. It takes into account the issue date, first interest date, settlement date, interest rate, face value, and coupon frequency to calculate the amount of accrued interest.

ACCRINT() is a function in Microsoft Excel that returns the accrued interest for a security that pays periodic interest. Learn Functions of Excel to become a Master.

How to use =ACCRINT() formula?

To use the ACCRINT() function in Excel, the syntax is as follows:

Here’s how to use it:

Syntax: ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])

Parameters:

  • issue – This is the date when the security was issued. It should be entered in the format “mm/dd/yyyy”.
  • first_interest – This is the date when the first interest payment is due. It should be entered in the format “mm/dd/yyyy”.
  • settlement – This is the date when the security is settled or the date on which you want to calculate the accrued interest. It should be entered in the format “mm/dd/yyyy”.
  • rate – This is the annual interest rate for the security.
  • par – This is the face value of the security.
  • frequency – This is the number of coupon payments per year.
  • [basis] – (Optional) This is the type of day counting method to use. It can be either 0 (for 30/360 US method), 1 (for actual/actual method), 2 (for actual/360 method), or 3 (for actual/365 method). If this parameter is omitted, the default value is 0.
  • [calc_method] – (Optional) This is an optional parameter that specifies whether to use the US (NASD) 30/360 day count convention or actual/actual day count convention. If this parameter is omitted, the default value is 0.
  • When using the function, make sure to enter the parameters in the correct order and format, as described above, to get the correct result.

Example of ACCRINT() function with an explanation:

Example 1: =ACCRINT("01/01/2022", "01/15/2022", "03/15/2022", 0.05, 100, 2) Explanation: In this example, the security has an issue date of “01/01/2022”, a first interest date of “01/15/2022”, a settlement date of “03/15/2022”, an interest rate of 0.05, a face value of 100, and a frequency of 2 coupon payments per year.

The function returns the amount of accrued interest for the security for the period between the first interest date and the settlement date. The calculation is based on the interest rate, face value, frequency, and the days elapsed between the first interest date and the settlement date.

In this case, the result of the formula is 2.5, which means that the security has accrued interest of 2.5 for the period between “01/15/2022” and “03/15/2022”.

Example 2: =ACCRINT("01/01/2022", "01/15/2022", "03/15/2022", 0.05, 100, 2, 1) Explanation: This example is the same as the previous one, but with the added parameter “1” for the basis, which specifies the actual/actual day count method. The result will be the same as the previous example, but calculated using the actual/actual day count method.

Example 3: =ACCRINT("01/01/2022", "02/15/2022", "03/15/2022", 0.05, 100, 2) Explanation: In this example, the first interest date is “02/15/2022” instead of “01/15/2022”. The function returns the amount of accrued interest for the security for the period between the first interest date and the settlement date.

In this case, the result of the formula is 2.0833, which means that the security has accrued interest of 2.0833 for the period between “02/15/2022” and “03/15/2022”.

Example 4: =ACCRINT("01/01/2022", "01/01/2022", "03/15/2022", 0.05, 100, 2) Explanation: In this example, the first interest date is the same as the issue date “01/01/2022”. The function returns the amount of accrued interest for the security for the period between the first interest date and the settlement date.

In this case, the result of the formula is 5, which means that the security has accrued interest of 5 for the period between “01/01/2022” and “03/15/2022”.

Example 5: =ACCRINT("01/01/2022", "01/15/2022", "01/31/2022", 0.05, 100, 2) Explanation: In this example, the settlement date is “01/31/2022”, which is before the first interest date of “01/15/2022”. The function returns an error in this case as the settlement date cannot be earlier than the first interest date.

ACCRINT() Similar functions:

  1. COUPNCD(): returns the next coupon date after the settlement date
  2. ACCRINTM(): calculates the accrued interest for a security with a constant coupon rate
  3. COUPDAYBS(): calculates the number of days from the beginning of the coupon period to the settlement date
  4. COUPDAYS(): calculates the number of days in the coupon period that contains the settlement date
  5. COUPNUM(): calculates the number of coupons payable between the settlement date and the maturity date
  6. COUPPCD(): returns the previous coupon date before the settlement date

Here are some commonly asked questions about the ACCRINT() function

What is the purpose of the ACCRINT() function in Excel?

The ACCRINT() function is used to calculate the amount of interest that has accrued on a security between the issue date and a specified settlement date.

What is a security in the context of the ACCRINT() function?

A security can refer to any type of financial instrument, such as a bond, stock, or other investment product, that pays periodic interest to the holder.

What is the settlement date in the ACCRINT() function?

The settlement date is the date on which the security is settled or the date on which you want to calculate the accrued interest.

What is the frequency in the ACCRINT() function?

The frequency is the number of coupon payments per year for the security.

What is the basis in the ACCRINT() function?

The basis is the type of day counting method used in the calculation. It can be either 0 (for 30/360 US method), 1 (for actual/actual method), 2 (for actual/360 method), or 3 (for actual/365 method).

Learn More about MS Excel Functions

esyExcel

Gavesh S. is the founder and owner of EsyExcel.com. He has been a Microsoft Excel Expert since early 2012. With experience explained thousand of queries for companies including Microsoft and top other financial institutions. Theres is most uses of Business Analysis, People Management, Automation, Performance Reporting, Strategic Analysis, Project Management, Managing Programs, Account Management etc.  In 2021 he found EsyExcel.com to share his experiences with other who’s is looking to learn MS Excel. He is currently working on a book about working in the Learn Excel, expanding his skill set beyond the Excel Learning niche.