# 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:

## 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.