Internal Rate of Return Analysis
Internal Rate of Return (IRR) is the discount rate that makes the Net Present Value of a series of cash flows equal to zero. Conceptually, IRR is the annual compound return an investment generates if held to maturity. For a project with -$100M upfront and $130M in 3 years, the IRR is the rate r where 130/(1+r)^3 = 100, which solves to ~9.1%. IRR is the standard 'go/no-go' metric for capital projects and is the universal yardstick in private equity (PE funds report 'gross IRR' and 'net IRR' as their primary performance metric). The decision rule: invest if IRR > hurdle rate (typically WACC or required return). IRR is intuitive and dimensionless โ easy to compare across projects of different sizes โ which is why it dominates capital budgeting despite its known mathematical flaws.
The Trap
The trap is using IRR alone for project comparison. IRR has three classic flaws: (1) it assumes intermediate cash flows are reinvested at the IRR (often unrealistic โ Modified IRR fixes this), (2) projects with non-conventional cash flows (sign changes) can have multiple IRRs (mathematical artifact), and (3) IRR favors small high-return projects over large lower-return projects with bigger absolute NPV. A project with 50% IRR on $1M investment looks better than 25% IRR on $50M โ but the latter creates much more value. Always pair IRR with NPV: IRR for ranking, NPV for sizing.
What to Do
Use a structured framework: (1) Compute IRR via Excel's IRR function or numerical solver. (2) Compare to hurdle rate (typically WACC + risk premium for project-specific risk). (3) Compute Modified IRR (MIRR) which assumes reinvestment at WACC โ usually 200-500 bps lower than IRR and more realistic. (4) Always report NPV alongside IRR โ high-IRR small projects can beat hurdle but barely move the needle. (5) For portfolio-level decisions (e.g., PE fund), use Money Multiple (MoM) alongside IRR โ IRR rewards quick exits, MoM rewards absolute return.
Formula
In Practice
Private equity funds report IRR as their headline performance metric. Top-quartile PE funds (1995-2015 vintages) generated net IRRs of 18-25% โ meaningfully above public market equivalents. But IRR can mislead: a fund that flips an investment in 18 months at 1.5x money returns ~30% IRR; a fund that holds for 6 years and exits at 3x money returns ~20% IRR. The first looks better on IRR, but the second creates more absolute wealth. Sophisticated LPs (limited partners) increasingly look at TVPI (Total Value to Paid-In) and DPI (Distributions to Paid-In) alongside IRR specifically because IRR can be 'gamed' by fast small exits. The IRR-vs-MoM tradeoff is the most important nuance in PE performance evaluation.
Pro Tips
- 01
Always compute Modified IRR (MIRR) alongside IRR. MIRR explicitly assumes intermediate cash flows are reinvested at WACC (or a 'safe rate') rather than at IRR โ closer to reality. The MIRR-vs-IRR gap is biggest for high-IRR projects with long timelines: a 30% IRR project might have 18% MIRR. MIRR is the more honest number.
- 02
For PE/VC, IRR rewards speed. A 2x return in 1 year is 100% IRR; same 2x in 3 years is ~26% IRR. This creates incentive to exit fast even when holding longer would create more absolute value. LPs increasingly demand both IRR and DPI/TVPI to balance the picture.
- 03
Beware of IRR on projects with negative late-stage cash flows (e.g., decommissioning costs at end of mining project). Sign changes in the cash flow stream can produce multiple IRRs โ sometimes 2 or 3 valid mathematical solutions. Use NPV in those cases; IRR loses meaning.
Myth vs Reality
Myth
โHigher IRR is always betterโ
Reality
Higher IRR is better only when comparing equal-sized investments with similar risk and timing profiles. A 40% IRR on $500K is worse than a 22% IRR on $50M for a company that can afford either. NPV is the correct rank for capital allocation; IRR is the correct yardstick for unit return.
Myth
โIRR represents the annual return you'll earnโ
Reality
Only true if you can reinvest intermediate cash flows at the IRR โ which is usually impossible for high-IRR projects (you can't find more 30% IRR opportunities to redeploy into). Real realized return is closer to MIRR. IRR is a project-property number, not a portfolio-return number.
Try it
Run the numbers.
Pressure-test the concept against your own knowledge โ answer the challenge or try the live scenario.
Knowledge Check
Project A: -$10M upfront, +$15M in Year 3. IRR = ~14.5%. Project B: -$100M upfront, +$140M in Year 3. IRR = ~11.9%. WACC = 8%. Which should the company prefer if it has the capital for either?
Industry benchmarks
Is your number good?
Calibrate against real-world tiers. Use these ranges as targets โ not absolutes.
Hurdle Rate / Required IRR by Project Type
Standard corporate hurdle rates by project risk tierMaintenance Capex (low risk)
WACC + 0-2%
Growth Capex (medium risk)
WACC + 3-5%
New Market Entry (higher risk)
WACC + 6-10%
Greenfield / R&D (high risk)
WACC + 10-20%
Venture / Speculative
30%+ IRR target
Source: Brealey, Myers, Allen โ Principles of Corporate Finance
Real-world cases
Companies that lived this.
Verified narratives with the numbers that prove (or break) the concept.
Private Equity Industry
1995-2020 vintages
PE funds report net IRR as their primary performance metric. Top-quartile buyout funds (1995-2015 vintages) generated net IRRs of 18-25%, meaningfully above public market equivalents. But the industry has gradually moved to triangulating IRR with TVPI and DPI because IRR can be optimized by fast small exits at the expense of holding for larger absolute returns. KKR, Blackstone, and Apollo all now report multiple metrics to LPs. The shift reflects mathematical maturity: IRR is necessary but insufficient.
Top-Quartile PE Net IRR
18-25%
Median PE Net IRR
12-15%
Public Market Equivalent
9-11%
Metrics Now Reported
IRR + TVPI + DPI
IRR is the language of capital allocation but is incomplete. The industry's evolution toward multi-metric reporting reflects the recognition that IRR can be gamed and doesn't capture absolute value creation. Always pair IRR with money multiple.
Hypothetical: Manufacturing Capex Decision
2023
A manufacturer faced two capex options: Project A (automation upgrade) costing $8M with 32% IRR over 5 years and $4M NPV. Project B (new production line) costing $40M with 18% IRR over 8 years and $14M NPV. WACC was 9%. The CFO initially leaned to Project A based on IRR. After NPV-based reframing, the team approved Project B because absolute value creation was 3.5x higher. Project A was approved subsequently from operating cash flow without competing for the same capital pool.
Project A IRR / NPV
32% / $4M
Project B IRR / NPV
18% / $14M
Initial Lean (IRR-only)
Project A
Final Decision (NPV)
Both, B prioritized
When projects compete for the same capital pool, NPV is the correct ranking criterion. IRR is the screening tool (does it clear the hurdle?), NPV is the sizing tool (how much value does it create?). Many companies make the IRR-only mistake and systematically underinvest in larger value-creating projects.
Related concepts
Keep connecting.
The concepts that orbit this one โ each one sharpens the others.
Beyond the concept
Turn Internal Rate of Return Analysis into a live operating decision.
Use this concept as the framing layer, then move into a diagnostic if it maps directly to a current bottleneck.
Typical response time: 24h ยท No retainer required
Turn Internal Rate of Return Analysis into a live operating decision.
Use Internal Rate of Return Analysis as the framing layer, then move into diagnostics or advisory if this maps directly to a current business bottleneck.