# Google Sheets ACCRINT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/accrint-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The ACCRINT function calculates the accrued interest for a security that pays periodic interest, based on specified parameters. ``` ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the ACCRINT you need in plain EnglishGenerate Formula ## Parameters **`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: | BondID | IssueDate | FirstInterestDate | Rate | ParValue | Frequency | | - | - | - | - | - | - | | 1 | 2022-01-01 | 2022-07-01 | 5% | 1000 | 2 | | 2 | 2021-03-01 | 2021-09-01 | 4% | 2000 | 1 | 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: | BondID | Accrued Interest | | - | - | | 1 | 12.50 | | 2 | 20.00 | 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! ## Example use case You have a table with bond details, including issue date, maturity date, and coupon rate. Use the ACCRINT formula to calculate the accrued interest for each bond based on the current date, helping you assess the investment's value and cash flow. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Remove Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-duplicates-in-google-sheets) - [How To Separate Names In Google Sheets](https://betteranalyst.com/google-sheets/how-to-separate-names-in-google-sheets) - [How To Sort In Google Sheets](https://betteranalyst.com/google-sheets/how-to-sort-in-google-sheets) - [How To Split Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-split-cells-in-google-sheets) - [How To Strikethrough In Google Sheets](https://betteranalyst.com/google-sheets/how-to-strikethrough-in-google-sheets) - [How To Subtract In Google Sheets](https://betteranalyst.com/google-sheets/how-to-subtract-in-google-sheets) - [How To Transpose Data In Google Sheets](https://betteranalyst.com/google-sheets/how-to-transpose-data-in-google-sheets) - [How To Unhide Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-columns-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.