# Google Sheets INTRATE Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/intrate-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 INTRATE function calculates the interest rate for a fully invested security based on its redemption value, purchase price, and term. ``` INTRATE(buy_date, sell_date, buy_price, sell_price, [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 INTRATE you need in plain EnglishGenerate Formula ## Parameters **`buy_date`**:\ The date when the investment was purchased. This should be entered in a date format recognized by Google Sheets. **`sell_date`**:\ The date when the investment was sold. This should also be entered in a date format recognized by Google Sheets. **`buy_price`**:\ The price at which the investment was purchased. This should be a numeric value representing the cost per unit of the investment. **`sell_price`**:\ The price at which the investment was sold. This should be a numeric value representing the selling price per unit of the investment. **`[day_count_convention]`**:\ (Optional) A numeric value that specifies the day count convention to use for the calculation. If omitted, the default convention is used. ## What is an INTRATE? The *INTRATE* function in Google Sheets is a financial function used to calculate the interest rate for a fully invested security based on the settlement date, maturity date, and the face value of the security. This function is particularly useful for investors and financial analysts who need to determine the yield on a bond or other fixed-income investment. In simpler terms, INTRATE helps you find out how much interest you will earn on a security over a specific period. ## A Practical Example Imagine you are analyzing a bond investment with the following details: ### Bond Details: | Settlement Date | Maturity Date | Face Value | Discount Price | | - | - | - | - | | 2023-01-01 | 2024-01-01 | 1000 | 950 | You want to calculate the interest rate for this bond investment. ## INTRATE Formula To achieve this, you would use the INTRATE function as follows: ``` =INTRATE(A2, B2, C2, D2) ``` In this formula: - `A2` is the cell containing the Settlement Date (2023-01-01). - `B2` is the cell containing the Maturity Date (2024-01-01). - `C2` is the cell containing the Face Value (1000). - `D2` is the cell containing the Discount Price (950). ## Result of the Formula When you apply the INTRATE formula to the Bond Details, the output would be the interest rate calculated based on the provided information. ### Example Output: If you input the values as specified, the formula would return an interest rate of approximately 0.0526 or 5.26%. ## Why Use INTRATE? INTRATE is beneficial because it provides a straightforward way to calculate the yield on investments, allowing investors to make informed decisions. It simplifies the process of determining the profitability of a bond or similar security, which is crucial for effective financial planning. ## Key Takeaways: - **INTRATE**: A financial function that calculates the interest rate of a fully invested security. - **Investment Analysis**: Useful for evaluating the yield on bonds and fixed-income securities. - **Simplifies Calculations**: Eliminates the need for complex manual calculations, making it easier to assess investment opportunities. - **Common Use Cases**: Ideal for financial analysts, investors, and anyone involved in managing fixed-income portfolios. INTRATE is an essential function for anyone working with investments in Google Sheets, providing a powerful way to enhance financial analysis and decision-making. Happy investing! ## Example use case You have a table with loan details in Column A (loan amount) and Column B (interest paid). Use the INTRATE formula to calculate the interest rate for each loan, enabling quick assessment of loan profitability and comparison across different loans. ## 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 Freeze A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-a-row-in-google-sheets) - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-in-google-sheets) - [How To Lock A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-a-row-in-google-sheets) - [How To Lock Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-cells-in-google-sheets) - [How To Make A Copy Of An Google Sheets Sheet](https://betteranalyst.com/google-sheets/how-to-make-a-copy-of-an-google-sheets-sheet) ## 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.