What Is IRR (Internal Rate of Return)?
Internal Rate of Return (IRR) is the discount rate that makes the net present value (NPV) of all cash flows from an investment equal to zero. In simpler terms, it is the annualized rate of return that an investment is expected to generate. IRR accounts for both the magnitude and timing of cash flows, making it more sophisticated than simple ROI.
IRR is the standard metric for evaluating capital investments, real estate deals, private equity, and any investment with multiple cash flows over time. An investment is generally considered attractive when its IRR exceeds the investor's required rate of return (hurdle rate).
If IRR > Hurdle Rate: Accept the investment. If IRR < Hurdle Rate: Reject the investment. A typical hurdle rate for businesses is 10-15%. For private equity, 20-25% IRR is often the minimum target.
IRR Concept and Approximation
- 1Total Cash Returned = ($28,000 × 5) + $20,000 = $160,000
- 2Simple ROI = ($160,000 - $100,000) / $100,000 = 60%
- 3Payback Period = $100,000 / $28,000 = 3.6 years
- 4Profit Multiple = $160,000 / $100,000 = 1.6x
- 5Estimated IRR ≈ 16-18% (iterative calculation needed for exact)
IRR Benchmarks by Investment Type
| Investment Type | Target IRR | Minimum IRR | Risk Level |
|---|---|---|---|
| Public Stocks (Passive) | 8-12% | 7% | Moderate |
| Real Estate (Rental) | 10-18% | 8% | Moderate-High |
| Real Estate (Development) | 18-25% | 15% | High |
| Private Equity | 20-30% | 15% | High |
| Venture Capital | 25-40% | 20% | Very High |
| Small Business Acquisition | 20-35% | 15% | High |
How to Evaluate an Investment Using IRR
- IRR assumes cash flows are reinvested at the IRR itself (which may be unrealistic for very high IRRs)
- Modified IRR (MIRR) addresses this by assuming reinvestment at the cost of capital
- Multiple IRRs can exist when cash flows change sign more than once
- IRR does not account for project size: a smaller project with higher IRR may create less total value
- Use IRR alongside NPV for complete investment analysis
IRR has known limitations: it assumes reinvestment at the IRR rate, does not reflect project scale, and can produce multiple solutions for non-conventional cash flows. Always use IRR in conjunction with NPV (Net Present Value) and payback period for well-rounded investment analysis.
IRR in Private Equity and Venture Capital
Internal Rate of Return (IRR) is the standard performance metric for private equity, venture capital, and real estate funds. Fund managers report IRR as their primary performance number because it accounts for the timing of cash flows, which is critical in these illiquid asset classes. A private equity fund that deploys capital over 3 years and returns it over years 5-8 has very different economics than one that deploys and returns capital in the same year — IRR captures this difference, while simple ROI does not. Top-quartile private equity funds target 20-25%+ IRR. Venture capital funds targeting 10-20x returns on winners within a 7-10 year fund life often generate portfolio IRRs of 20-35% for the best funds, after accounting for losers.
The IRR assumes that interim cash flows are reinvested at the IRR itself — a significant limitation called the 'reinvestment rate assumption.' In practice, if a fund generates $1M in distributions early that you reinvest at only 10% (not the fund's 25% IRR), your actual return is lower than the stated IRR implies. This is why Modified IRR (MIRR) was developed: it explicitly specifies a reinvestment rate for interim cash flows (typically the cost of capital) and a finance rate for negative cash flows. MIRR is considered more realistic than IRR and is often used in corporate capital budgeting alongside traditional IRR analysis.
IRR vs. NPV: Which Should You Use?
Both IRR and Net Present Value (NPV) are used for investment decision-making, but they can conflict. NPV gives the absolute dollar value created by a project discounted to today (a positive NPV means value is created; negative NPV destroys value). IRR gives the percentage return — the discount rate at which the project's NPV equals zero. For a single project, NPV and IRR lead to the same accept/reject decision: accept if NPV > 0 (which is equivalent to IRR > hurdle rate). However, when comparing mutually exclusive projects (you can only choose one), NPV is theoretically superior because it measures absolute value creation, while IRR can be misleading for projects of different scale or duration.
Excel's IRR function makes calculation straightforward: list all cash flows in a column (negative values for investments/costs, positive for returns), then use =IRR(range, guess). Example: =IRR(B2:B10, 0.1) where B2 is -$100,000 (initial investment) and B3:B10 are annual returns. For multiple investment tranches, use XIRR(values, dates, guess) which handles irregular cash flow timing. If IRR does not converge (common with non-standard cash flow patterns), try different initial guesses or check for multiple IRR values.
