IRR Calculator & Investment Guide
Everything you need to know about calculating the Internal Rate of Return. Evaluate project profitability, compare investment opportunities, and make data-driven financial decisions.
Your Step-by-Step IRR Evaluation Roadmap
Calculating the Internal Rate of Return is a cornerstone of capital budgeting. Follow this structured roadmap to accurately assess the viability of any business project or investment.
The IRR Calculation Process
Five essential phases to determine investment viability
Identify the Initial Investment
Determine the total upfront capital required. This is your Period 0 cash outflow and is represented as a negative value in your financial model.
Estimate Future Cash Flows
Project the net cash inflows the investment will generate for each subsequent period. Be conservative and account for operating costs, taxes, and working capital changes.
Determine the Project Lifespan
Establish the total number of periods (n) over which the cash flows will occur, including any terminal value, salvage value, or exit proceeds at the end of the project.
Apply the IRR Formula or Tool
Use our calculator, spreadsheet software (like Excel’s =IRR() function), or a financial calculator to find the specific discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero.
Compare Against the Hurdle Rate
Evaluate the calculated IRR against your company’s Weighted Average Cost of Capital (WACC) or minimum acceptable rate of return. If IRR > Hurdle Rate, the investment creates value.
IRR Interpretation Checklist
How to read your results and make a decision
Key Financial Benchmarks & Concepts
A summary of the primary metrics, typical hurdle rates, and conceptual differences to guide your investment analysis.
| Metric / Concept | Description | Typical Benchmark / Rule |
|---|---|---|
| Internal Rate of Return (IRR) | The discount rate that makes the NPV of all cash flows equal to zero. | Must exceed the Hurdle Rate / WACC |
| Net Present Value (NPV) | The total present value of all future cash flows minus the initial investment. | NPV > £0 indicates a value-adding project |
| Hurdle Rate | The minimum acceptable rate of return set by management or investors. | Often 8% – 15%, depending on risk profile |
| Private Equity Target | Typical return expectations for leveraged buyouts or venture capital. | 20% – 30%+ IRR |
| Real Estate Development | Expected return for property development or value-add real estate projects. | 15% – 20% IRR |
| Modified IRR (MIRR) | Assumes reinvestment at the cost of capital, solving the multiple-IRR problem. | Provides a more conservative, realistic yield |
IRR Calculator FAQ
Answers to the most frequently asked questions about calculating and interpreting the Internal Rate of Return.
A ‘good’ IRR depends entirely on the industry, risk profile, and the company’s cost of capital. Generally, an IRR of 15% or higher is considered strong for private equity or real estate, while a 10% IRR might be acceptable for lower-risk, stable corporate projects. The fundamental rule is that the IRR must exceed your specific hurdle rate.
NPV (Net Present Value) calculates the absolute monetary value of an investment’s profitability in today’s currency, using a predetermined discount rate. IRR (Internal Rate of Return) calculates the percentage rate of return that makes the NPV exactly zero. Financial theorists generally prefer NPV for evaluating mutually exclusive projects of different sizes, as IRR can be misleading in those scenarios.
Yes, an IRR can be negative. This occurs when the total cumulative cash inflows over the life of the project are less than the initial cash outflow. A negative IRR indicates that the investment destroys value and yields an overall financial loss.
IRR has a few key limitations: it assumes all interim cash flows are reinvested at the same IRR rate (which is often unrealistically high), it can produce multiple valid IRRs for projects with alternating positive and negative cash flows, and it does not account for the absolute scale of the investment (a 50% IRR on £1,000 is less valuable than a 15% IRR on £1,000,000).