ACCRINT function

The ACCRINT function in Excel is used to calculate the accrued interest on a security that pays periodic interest. This function can be helpful when you need to determine how much interest has accumulated on a bond or other financial instrument since the last payment date.

Syntax

The syntax for the ACCRINT function is as follows:

Arguments

Here are the arguments for the ACCRINT function:

ArgumentDescription
issueThe security’s issue date.
first_interestThe first interest payment date after the issue date.
settlementThe date you want to calculate the accrued interest up to.
rateThe annual coupon rate of the security.
parThe security’s face value or par value.
frequencyThe number of interest payments per year (typically 1, 2, or 4).
[basis](Optional) The day count basis to use for calculations. If omitted, Excel uses the default basis (actual/actual).

How to Use

Here’s how to use the ACCRINT function with multiple examples:

Example 1: Calculate accrued interest for a bond.

In this example, the bond was issued on January 1, 2023, the first interest payment date is July 1, 2023, and the settlement date is October 1, 2023. The coupon rate is 5%, the face value is $1,000, and interest is paid semi-annually (2 times a year).

Example 2: Calculate accrued interest with a different day count basis.

In this example, we specify a day count basis of 1, which represents the 30/360 basis. This affects how Excel calculates the accrued interest.

Example 3: Calculate accrued interest with omitted optional basis.

In this example, the optional basis argument is omitted, and Excel uses the default basis for the calculation.

Remember that the ACCRINT function is a useful tool for financial analysts and investors to determine the interest accrued on bonds and other financial instruments. It considers various factors such as issue date, interest payment dates, settlement date, and coupon rate, allowing you to make precise interest calculations for your financial analysis.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.