Google Sheets ACCRINT Function: Syntax, Examples & Tips

issue:
The date when the security is issued.

first_payment:
The date of the first interest payment.

settlement:
The date when the security is purchased.

rate:
The annual interest rate of the security.

redemption:
The redemption value per $100 face value of the security.

frequency:
The number of interest payments per year (1 for annual, 2 for semiannual, 4 for quarterly).

[day_count_convention]:
(Optional) The method used to calculate the number of days between dates (0 for US (NASD) 30/360, 1 for actual/actual, 2 for actual/360, 3 for actual/365, 4 for European 30/360).

What is an ACCRINT?

The ACCRINT function in Google Sheets is a financial function used to calculate the accrued interest for a security that pays interest at irregular intervals. This function is particularly useful for investors and financial analysts who need to determine the interest earned on bonds or other fixed-income securities between interest payment dates.

In simpler terms, ACCRINT helps you figure out how much interest has accumulated on a bond since the last interest payment was made.

A Practical Example

Imagine you are managing a portfolio of bonds with the following details:

Bond Details:

You want to calculate the accrued interest for each bond as of a specific date, say 2022-06-01.

ACCRINT Formula

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

=ACCRINT(BondDetails!B2, BondDetails!C2, TODAY(), BondDetails!D2, BondDetails!E2, BondDetails!F2)

In this formula:

• BondDetails!B2 is the cell containing the Issue Date of the bond.
• BondDetails!C2 is the cell containing the First Interest Date.
• TODAY() is the current date or the date for which you want to calculate the accrued interest.
• BondDetails!D2 is the cell containing the annual interest rate.
• BondDetails!E2 is the cell containing the par value of the bond.
• BondDetails!F2 is the cell containing the frequency of interest payments per year.

Result of the Formula

When you apply the ACCRINT formula to the Bond Details, the output would look like this:

This means that as of 2022-06-01, Bond 1 has accrued $12.50 in interest, while Bond 2 has accrued $20.00.

Why Use ACCRINT?

ACCRINT is beneficial because it provides a straightforward way to calculate accrued interest for bonds, which is essential for accurate financial reporting and investment analysis. It helps investors understand how much interest they have earned on their investments at any given time, allowing for better decision-making.

Key Takeaways:

• ACCRINT: A financial function that calculates accrued interest for securities with irregular interest payments.
• Useful for Investors: Essential for managing bond portfolios and understanding interest earnings.
• Simplifies Calculations: Eliminates the need for complex manual calculations of accrued interest.
• Common Use Cases: Ideal for bond valuation, investment analysis, and financial reporting.

ACCRINT is an essential function for anyone working with fixed-income securities, providing a powerful way to enhance financial analysis and reporting capabilities.

Happy investing!