Google Sheets ACCRINTM Function: Syntax, Examples & Tips

issue:
The date when the security is issued. This is a required parameter.

maturity:
The date when the security matures. This is a required parameter.

rate:
The annual interest rate of the security. This is a required parameter.

redemption:
The redemption value per $100 face value of the security. This is an optional parameter, and if omitted, it defaults to 100.

day_count_convention:
The day count convention to use for the calculation. This is an optional parameter, and if omitted, it defaults to 0 (US (NASD) 30/360).

What is an ACCRINTM?

The ACCRINTM function in Google Sheets is a financial function used to calculate the accrued interest for a security that pays interest at maturity. This function is particularly useful for bond investors who need to determine the interest that has accumulated on a bond since its last interest payment date until its maturity date.

In simpler terms, ACCRINTM helps you find out how much interest a bond has earned over a specific period, even if the interest is not paid out until the bond matures.

A Practical Example

Imagine you are tracking a bond investment with the following details:

Bond Details:

You want to calculate the accrued interest for this bond as of a specific date, say 2023-01-01.

ACCRINTM Formula

To achieve this, you would use the ACCRINTM function as follows:

=ACCRINTM(IssueDate, MaturityDate, AnnualInterestRate, FaceValue, 0, 0, 1)

In this formula:

• IssueDate is the date when the bond was issued (2020-01-01).
• MaturityDate is the date when the bond matures (2025-01-01).
• AnnualInterestRate is the bond's annual interest rate (5%).
• FaceValue is the bond's face value (1000).
• The next two 0s represent the optional parameters for the first interest payment date and the frequency of interest payments (0 means no payments).
• 1 indicates that the interest is paid annually.

Result of the Formula

When you apply the ACCRINTM formula to the bond details, the output would give you the accrued interest as of 2023-01-01.

Accrued Interest Calculation:

Assuming the formula returns a value of 150, this means that as of January 1, 2023, the bond has accrued $150 in interest.

Why Use ACCRINTM?

ACCRINTM is beneficial because it allows bond investors to easily calculate the interest earned on their investments without needing to manually track each interest payment. This function simplifies the process of determining the value of a bond investment over time, especially for those who may not be familiar with complex financial calculations.

Key Takeaways:

• ACCRINTM: A financial function that calculates accrued interest for a bond until its maturity date.
• Simplifies Interest Calculations: Eliminates the need for manual tracking of interest payments.
• Useful for Investors: Ideal for bond investors looking to assess the value of their investments over time.
• Common Use Cases: Suitable for financial analysis, investment tracking, and portfolio management.

ACCRINTM is an essential function for anyone involved in bond investments, providing a straightforward way to enhance financial analysis and reporting capabilities.

Happy investing!