# Google Sheets ACCRINTM Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/accrintm-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 ACCRINTM function calculates the accrued interest for a security that pays interest at maturity, based on specified parameters. ``` ACCRINTM(issue, maturity, rate, [redemption], [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 ACCRINTM you need in plain EnglishGenerate Formula ## Parameters **`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: | BondID | FaceValue | AnnualInterestRate | IssueDate | MaturityDate | | - | - | - | - | - | | 1 | 1000 | 5% | 2020-01-01 | 2025-01-01 | 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 `0`s 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! ## Example use case You have a table with bond details including issue date, maturity date, and interest rate. Use ACCRINTM to calculate the accrued interest for each bond as of a specific date, enabling accurate financial reporting and investment analysis without manual calculations. ## 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 - [Google Sheets Conditional Formatting](https://betteranalyst.com/google-sheets/google-sheets-conditional-formatting) - [How To Add A Column In Google Sheets](https://betteranalyst.com/google-sheets/how-to-add-a-column-in-google-sheets) - [How To Alphabetize In Google Sheets](https://betteranalyst.com/google-sheets/how-to-alphabetize-in-google-sheets) - [How To Autofit In Google Sheets](https://betteranalyst.com/google-sheets/how-to-autofit-in-google-sheets) - [How To Calculate Percentage In Google Sheets](https://betteranalyst.com/google-sheets/how-to-calculate-percentage-in-google-sheets) - [How To Combine Two Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-combine-two-columns-in-google-sheets) - [How To Copy Formula In Google Sheets](https://betteranalyst.com/google-sheets/how-to-copy-formula-in-google-sheets) - [How To Count Unique Values In Google Sheets](https://betteranalyst.com/google-sheets/how-to-count-unique-values-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.