=IRR(values, [guess])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single IRR formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
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.
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.
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:
| 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.
To calculate the IRR for the cash flows, you would use the IRR formula as follows:
=IRR(B2:B6)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%.
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.
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!
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 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 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 to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.