Key Takeaways
- IRR is the discount rate that makes NPV equal to zero
- If IRR exceeds your hurdle rate, the investment may be worthwhile
- Higher IRR indicates potentially better returns, but consider project scale
- IRR assumes reinvestment at the same rate - consider MIRR for realistic analysis
- Always use NPV alongside IRR for investment decisions
What is Internal Rate of Return (IRR)?
The 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 other words, IRR is the rate at which an investment breaks even in terms of NPV. It represents the expected compound annual rate of return that will be earned on a project or investment.
IRR is widely used in capital budgeting to evaluate the attractiveness of investments. When the IRR exceeds the required rate of return (hurdle rate), the investment is considered acceptable. The higher the IRR, the more desirable the investment.
0 = CF0 + CF1/(1+r) + CF2/(1+r)2 + ... + CFn/(1+r)n
How to Interpret IRR
IRR vs. Hurdle Rate
- IRR > Hurdle Rate: Accept the investment (returns exceed requirements)
- IRR = Hurdle Rate: Breakeven (returns exactly meet requirements)
- IRR < Hurdle Rate: Reject the investment (returns fall short)
Comparing Multiple Projects
When comparing mutually exclusive projects, the one with the highest IRR isn't always the best choice. Consider project size, duration, and NPV alongside IRR. A smaller project with higher IRR might generate less total value than a larger project with lower IRR.
Pro Tip: Use NPV and IRR Together
While IRR gives a percentage return that's easy to communicate, NPV tells you the actual dollar value created. For mutually exclusive projects, NPV is generally more reliable. Use IRR to screen projects (must meet hurdle rate) and NPV to rank them.
IRR vs. NPV: Key Differences
Use NPV when:
- Projects have significantly different sizes
- Cash flow patterns are unconventional
- You need absolute dollar values
Use IRR when:
- Comparing similar-sized projects
- Communicating with stakeholders (percentage is intuitive)
- Setting minimum return requirements
Calculating IRR
IRR cannot be solved algebraically for most real-world cash flow patterns. It requires iterative numerical methods:
Bracketing (Bisection) Method
This calculator scans a wide range of discount rates for a sign change in NPV, then narrows each bracket by bisection until NPV is effectively zero. Unlike a plain Newton-Raphson search, this stays reliable for negative IRRs. If several IRRs exist, the one closest to 0% is shown; if none exists, it says so.
Manual Approximation
For simple cases, you can approximate IRR by trying different discount rates until NPV approaches zero. Most spreadsheet applications have built-in IRR functions that automate this process.
Example: Business Expansion
Initial investment: $50,000
Year 1 cash flow: $15,000
Year 2 cash flow: $18,000
Year 3 cash flow: $20,000
Year 4 cash flow: $15,000
Hurdle rate: 12%
IRR = 18.6%
Since 18.6% > 12% hurdle rate, accept the investment.
Limitations of IRR
Multiple IRRs
When cash flows change sign more than once (e.g., initial outflow, inflows, then another outflow), multiple IRRs may exist. This makes interpretation difficult. In such cases, use Modified IRR (MIRR) or rely on NPV.
Reinvestment Assumption
IRR assumes that intermediate cash flows are reinvested at the IRR itself. This may be unrealistic for projects with very high IRRs. NPV's assumption of reinvestment at the discount rate is often more reasonable.
Scale Blindness
IRR doesn't account for the scale of investment. A $1,000 project with 50% IRR might be less valuable than a $1,000,000 project with 20% IRR. Always consider absolute returns alongside percentages.
Mutually Exclusive Projects
When choosing between mutually exclusive projects of different sizes or durations, IRR can give misleading rankings. NPV is generally more reliable for such comparisons.
Modified Internal Rate of Return (MIRR)
MIRR addresses some IRR limitations by assuming:
- Positive cash flows are reinvested at the firm's cost of capital
- Negative cash flows are financed at the firm's financing cost
MIRR always produces a unique solution and often provides a more realistic measure of investment attractiveness.
IRR in Different Contexts
Real Estate Investments
IRR is popular in real estate for evaluating property investments. It captures purchase costs, rental income, operating expenses, and eventual sale proceeds to give an annualized return measure.
Private Equity and Venture Capital
PE and VC firms commonly report IRR to limited partners. However, the timing of cash flows significantly affects IRR, and early distributions can inflate IRR even if absolute returns are modest.
Corporate Capital Budgeting
Corporations use IRR alongside NPV to evaluate capital projects. Projects must typically exceed the company's hurdle rate (often WACC plus a risk premium) to be approved.
IRR Benchmarks by Investment Type
IRR targets vary significantly by asset class and risk profile. Use these benchmarks to gauge whether your project's IRR is competitive.
| Investment Type | Typical IRR Target | Notes |
|---|---|---|
| Real estate (buy and hold) | 8–15% | Includes appreciation + rental income |
| Real estate (flipping) | 20–50% | Shorter duration, higher risk |
| Private equity | 20–30%+ | Institutional target |
| Venture capital | 30–50%+ | Compensates for high failure rate |
| Stock market (S&P 500) | 10% avg | Historical benchmark |
| Corporate projects (hurdle rate) | 10–20% | Depends on company WACC |
IRR vs NPV vs MIRR: Comparison
Choosing the right metric depends on your decision context. Here is how the most common investment return measures compare.
| Metric | What it measures | When to use | Limitation |
|---|---|---|---|
| IRR | % return on investment | Comparing investments of similar size | Misleading for scale differences |
| NPV | Dollar value added | Absolute wealth creation | Depends on chosen discount rate |
| MIRR | Modified IRR assuming reinvestment | Accounts for reinvestment rate | Less commonly known |
| Payback period | Time to recoup investment | Quick cash flow check | Ignores time value of money |
IRR Calculation Example
Step-by-Step IRR Example
Initial investment (Year 0): −$100,000
Year 1 cash flow: $30,000
Year 2 cash flow: $40,000
Year 3 cash flow: $50,000
Year 4 cash flow: $20,000
IRR ≈ 24.7%
At a 24.7% discount rate, the net present value of all cash flows equals zero. This means the investment returns the equivalent of 24.7% compound annual growth — compared to a typical 10–15% hurdle rate, this project would be accepted.
More IRR Questions Answered
What is a good IRR for an investment?
What is the difference between IRR and NPV?
How is IRR calculated?
=IRR() functions use iterative solvers and should agree on well-behaved cash flows.