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

Learn More about MS Excel Functions

• How to Calculate Percentage in Excel
• How to Remove Duplicates in Excel: A Step-by-Step Guide
• Mastering the ATAN Function in Excel: Tips and Tricks
• Mastering Excel: A Step-by-Step Guide on How to Filter Two Columns Using Advanced Filter Function
• Excel is not calculating formulas: What to do when your formulas don’t work
• Compare of ACCRINT & YIELD Functions – When to Use Each one
• Real-World Applications of Excel’s ACCRINT Function
• Mastering the ACCRINT Function in Excel: Tips and Tricks for Efficient Accrued Interest Calculations
• A Beginner’s Guide to AVERAGEIF Formula in Excel
• Learn VBA DIR Function – An Easy Explanation with Examples
• Learn =AVERAGEA() function – How to use with examples
• Learn =AVERAGE() function How to use with examples
• Learn =AVEDEV() Function – How to use with examples
• Learn =ATAN2() function – How to use with example
• Learn =ATAN() function – How to use with examples