# Excel IRR Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/excel/irr-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 IRR function calculates the internal rate of return for a series of cash flows, helping assess investment profitability over time. ```excel =IRR(values, [guess]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the IRR you need in plain EnglishGenerate Formula Need more than a single IRR formula? Try our free [AI for Excel](https://betteranalyst.com/excel-ai) — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat. ## Parameters **`values`**:\ An array or a reference to a range of cells that contain the cash flows for which you want to calculate the internal rate of return. This range must contain at least one negative value (representing an investment) and one positive value (representing returns). **`guess`**:\ An optional numeric value that you can provide as an estimate for what the internal rate of return might be. If omitted, Excel uses 0.1 (or 10%) as the default guess. ## What is an IRR Formula in Excel? The *IRR* (Internal Rate of Return) function in Excel is a financial tool that helps you calculate the rate of return on an investment based on a series of cash flows that occur at regular intervals. It determines the interest rate at which the net present value (NPV) of the cash flows equals zero, making it a crucial metric for evaluating the profitability of investments. In simpler terms, the IRR function helps you assess the potential return on investment, allowing you to make informed financial decisions. ## A Practical Example Imagine you are evaluating a project that requires an initial investment and generates cash flows over the next few years. Here’s a simplified cash flow table for the project: ### Cash Flow Data Table: | Year | Cash Flow | | - | - | | 0 | -1000 | | 1 | 300 | | 2 | 400 | | 3 | 500 | | 4 | 600 | You want to find the internal rate of return for this investment. ## IRR Formula To calculate the IRR for the cash flows, you would use the IRR formula as follows: ```excel =IRR(B2:B6) ``` ### Breakdown of the Formula: - **B2:B6**: This is the range of cash flows, including the initial investment (negative value) and the subsequent cash inflows. ## Result of the Formula When you apply the formula, Excel calculates the internal rate of return for the given cash flows. The output would be: | Internal Rate of Return | | - | | 14.87% | This indicates that the project is expected to yield an annual return of approximately 14.87%. ## Why Use IRR? The IRR function is particularly useful for evaluating the profitability of investments and comparing different projects. It allows you to determine whether an investment meets your required rate of return and helps in making strategic financial decisions. ## Key Takeaways: - **IRR**: Calculates the internal rate of return for a series of cash flows. - **Investment Evaluation**: Helps assess the profitability of projects and investments. - **Common Use Cases**: Ideal for capital budgeting, project finance, and investment analysis. Understanding how to use the IRR function can significantly enhance your financial analysis capabilities in Excel, enabling you to evaluate investment opportunities effectively. Happy calculating! ## Example use case You have a table where Column A contains the years of an investment (e.g., Year 0, Year 1, Year 2, etc.) and Column B contains the corresponding cash flows for each year (including initial investment as a negative value). You can use the IRR function to calculate the internal rate of return for the investment over the specified period. This helps in evaluating the profitability of the investment and making informed decisions about whether to proceed with or adjust the investment strategy based on expected returns. **Beyond the IRR function:** Better Analyst is a full [Excel AI](https://betteranalyst.com/excel-ai) that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free [AI Excel assistant](https://betteranalyst.com/excel-ai) that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required. Don't have a spreadsheet yet? Use our free [AI spreadsheet generator](https://betteranalyst.com/ai-excel-spreadsheet-generator) to turn a text prompt into a downloadable Excel file — a full [AI Excel sheet maker](https://betteranalyst.com/ai-excel-spreadsheet-generator) that builds headers, columns, and formulas from your description. ## Need more help with Excel formulas? Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Excel how-to guides - [How To Remove Blank Rows In Excel](https://betteranalyst.com/excel/how-to-remove-blank-rows-in-excel) - [How To Remove Duplicates In Excel](https://betteranalyst.com/excel/how-to-remove-duplicates-in-excel) - [How To Separate Names In Excel](https://betteranalyst.com/excel/how-to-separate-names-in-excel) - [How To Sort In Excel](https://betteranalyst.com/excel/how-to-sort-in-excel) - [How To Split Cells In Excel](https://betteranalyst.com/excel/how-to-split-cells-in-excel) - [How To Strikethrough In Excel](https://betteranalyst.com/excel/how-to-strikethrough-in-excel) - [How To Subtract In Excel](https://betteranalyst.com/excel/how-to-subtract-in-excel) - [How To Transpose Data In Excel](https://betteranalyst.com/excel/how-to-transpose-data-in-excel) ## Explore all Excel formulas Browse our complete library of Excel 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.