Quick reference
What IRR measures and how to interpret it
IRR is the discount rate at which the NPV of all cash flows (initial investment plus all future inflows and outflows) equals exactly zero. It represents the break-even rate of return — the rate at which the present value of future returns exactly equals the cost of the investment.
If a project has an IRR of 18% and the required return (hurdle rate) is 12%, the project is worth undertaking — it generates 6 percentage points more return than the minimum required. If the IRR is 9% and the hurdle rate is 12%, the project destroys value and should be rejected.
IRR is expressed as an annual percentage, making it immediately comparable to other returns: bond yields, equity market returns, cost of debt, and alternative investment opportunities. This comparability is its primary advantage over NPV, which produces a euro amount rather than a percentage.
In private equity, IRR is the standard performance metric. A fund that buys a company for 10.000.000, receives 2.000.000 in dividends over 5 years and sells for 25.000.000 at year 5 has achieved a specific IRR on that investment. PE fund IRRs of 20 to 30% are considered strong performance; below 15% is often considered disappointing relative to the risk taken.
IRR assumes that all interim cash flows are reinvested at the IRR rate itself — an assumption that is often unrealistic for high-IRR investments. This reinvestment assumption is IRR's main theoretical weakness and can cause it to overstate the true return. The Modified Internal Rate of Return (MIRR) corrects for this by assuming reinvestment at a more realistic rate.
The IRR equation
Worked examples
Solve for r where: -100.000 + 30.000/(1+r) + 50.000/(1+r)^2 + 60.000/(1+r)^3 = 0. By iteration: at r=20%: NPV = -100.000 + 25.000 + 34.722 + 34.722 = -5.556 (negative — rate too high). At r=15%: NPV = -100.000 + 26.087 + 37.807 + 39.460 = +3.354 (positive — rate too low). IRR is between 15% and 20% — approximately 18 to 19%. If the hurdle rate is 12%, this project is acceptable. If it is 20%, it is borderline.
Cash flows: Year 0: -500.000. Years 1-7: +22.000. Year 7 additional: +620.000 (total year 7: 642.000). IRR found by iteration at approximately 7,8%. If the investor requires 8% return for this level of risk, the IRR of 7,8% indicates the investment does not quite meet the required return. Small adjustments — negotiating a lower purchase price or achieving higher rent — would push IRR above the hurdle rate.
This illustrates the scale problem with IRR. Project A has a spectacular 50% IRR but creates only 36.364 of value. Project B creates 90.909 of value at a lower 20% IRR. If you can only choose one and have the capital, Project B creates more value. IRR should not be used to choose between mutually exclusive projects of different scale — NPV is the correct metric in this case.
IRR Calculator
Enter your investment amount and cash flows for each period to calculate the internal rate of return.
Typical IRR targets by investment type
| Investment Type | Typical IRR Target | Notes |
|---|---|---|
| Listed equity market | 7 to 10% | Long-run historical average — no target, just outcome |
| Real estate (residential) | 5 to 10% | Depends heavily on leverage and location |
| Commercial real estate | 8 to 15% | Higher risk, typically higher return |
| Infrastructure | 6 to 9% | Low risk, long duration, regulated returns |
| Private equity (buyout) | 20 to 30% | Target for well-performing buyout funds |
| Venture capital | 25 to 40% | High failure rate — requires high target on winners |
| Corporate capex (mature) | 15 to 20% | Typical hurdle rate for corporate investment |
Common mistakes with IRR
Methodology
IRR found by iterative numerical methods (Newton-Raphson or bisection). No closed-form algebraic solution exists for most IRR problems. Spreadsheet functions (Excel XIRR for irregular cash flows, IRR for regular periodic flows) are the standard calculation tool. Typical IRR ranges are illustrative market observations, not guaranteed returns.
IRR does not account for the absolute size of the investment or risk differences between projects. Always use alongside NPV analysis and qualitative risk assessment. For very long-duration projects, IRR becomes more sensitive to terminal value assumptions and should be stress-tested.
Calculate IRR for your investment
Enter your initial investment and cash flows to calculate the internal rate of return and compare it to your required return.
Frequently asked questions
Formula based on standard mathematical and financial methods. Results are for informational purposes. Last reviewed May 2026. Version 1.