ACCRINTM function

ACCRINTM function calculates the accrued interest for a security with a fixed maturity date, based on a specified interest rate. It is useful for financial analysis and investment management.

Syntax

ACCRINTM(issue, settlement, rate, par, basis)

Arguments

Arguments are used in the following way:

issueThe issue date of the security.
settlementThe settlement date when the security was acquired.
rateThe annual interest rate of the security.
parThe par value of the security (face value).
basisThe day count basis to use for calculations. It specifies how days are counted. (Optional)

How to Use

To use the ACCRINTM function, follow these steps:

1. Enter the issue date, settlement date, annual interest rate, par value, and optionally, the day count basis in your Excel worksheet.

2. Use the ACCRINTM function to calculate accrued interest based on the provided information.

3. The function will return the accrued interest amount for the security.

Examples

Let’s look at some examples of how to use the ACCRINTM function:

This formula calculates the accrued interest for a security issued on January 1, 2023, and settled on July 1, 2023, with an annual interest rate of 5% and a par value of $1000. It uses the basis of 0, meaning it uses the US (NASD) 30/360 day count basis.

This formula is similar to the previous one but uses a basis of 1, which corresponds to the actual/actual day count basis.

These examples demonstrate how to use the ACCRINTM function to calculate accrued interest under different day count bases.

Additional Information

If you need more detailed information about Excel functions, you can refer to the official Excel documentation.

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