Excel - ACCRINTM Function, Returns the accumulated interest for interest-bearing securities at maturity

Buzz

Ngày cập nhật gần nhất: 1/5/2026

Content

ACCRINTM Function in Excel

How to Use ACCRINTM Function in Excel - Illustrated Examples

If you're studying accounting, working in a bank..., using the ACCRINTM function is essential, helping you calculate the accumulated interest for interest-bearing securities at maturity. Let's review the ACCRINTM function syntax with Mytour below.

The ACCRINTM function in Excel returns the accumulated interest for interest-bearing securities at maturity. To better understand the syntax and usage of the ACCRINTM function, follow the examples below. You can use the ACCRINTM function in Excel on Office 2013, Office 2010, Office 2007, and Office 2003 versions.

ACCRINTM Function in Excel

How to Use ACCRINTM Function in Excel - Illustrated Examples

Syntax: ACCRINTM(issue, settlement, rate, par, [basis])

Where:

- Issue: The issuance date of the security.
- Settlement: The maturity date of the security.
- Rate: The annual interest rate of the security.
- Par: The face value of the security. If omitted, the ACCRINTM function defaults to $1,000.
- Basis: The day count basis to be used.

+ Basic = 0 or omitted: US (NASD) 30/360
+ Basic = 1: Actual/Actual
+ Basic = 2: Actual/360
+ Basic = 3: Actual/365
+ Basic = 4: European 30/360

Consider an Example:

For the spreadsheet below, the values entered correspond to the parameters of the function in Excel

Calculate the accumulated interest for interest-bearing securities at maturity. In cell C11, you enter the formula =ACCRINTM(C6,C7,C8,C9,C10), and you get the result as shown below.

Now you know how to use the ACCRINTM function to calculate accumulated interest for interest-bearing securities at maturity. This calculation function will help you quickly and accurately determine the cumulative interest value based on your actual data.

Frequently Asked Questions

What is the purpose of the ACCRINTM function in Excel?

The ACCRINTM function in Excel is used to calculate the accumulated interest for interest-bearing securities at maturity. This function is essential for accountants and bank professionals to ensure accurate financial reporting and analysis.

Can I use the ACCRINTM function in older versions of Excel?

Yes, the ACCRINTM function is compatible with older versions of Excel, including Office 2003, 2007, 2010, and 2013. This ensures that users across different platforms can effectively calculate accumulated interest for securities.

What are the key parameters required for the ACCRINTM function?

The ACCRINTM function requires several parameters: issue date, settlement date, annual interest rate, face value, and an optional basis for day count. Correctly entering these parameters is crucial for accurate interest calculations.

How do I calculate accumulated interest using the ACCRINTM function?

To calculate accumulated interest with the ACCRINTM function, enter the formula in a cell using the required parameters: =ACCRINTM(issue, settlement, rate, par, [basis]). This formula will return the accumulated interest based on the specified values.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]