IRR Guide 2026: Internal Rate of Return Formula and Interpretation
Table of Contents
What IRR Actually Means
IRR is the discount rate that makes NPV equal zero — the project's breakeven return rate. If IRR exceeds your hurdle rate, accept.
There is no closed-form solution for most cash flows; calculators iterate to find it. Think of IRR as the annualized growth rate of the invested capital.
IRR is dollar-weighted: it measures your timing, not just the asset. Two investors in the same fund — one lump-sums at the bottom (IRR 15%), one buys monthly including the top (IRR 6%). Same fund, wildly different IRRs. Fund marketing quotes time-weighted returns (manager skill); your personal IRR is dollar-weighted (your timing). Never compare your IRR to a fund's advertised return — they're different sports.
Interim valuations distort private-market IRRs. A PE fund marking unsold companies optimistically can show 22% IRR on paper and realize 12% at exit — the IRR was real math on fantasy prices. Only DPI (distributions ÷ paid-in capital) measures cash actually returned. Always ask for DPI alongside IRR; a 25% IRR with 0.4× DPI is a story, not a return.
Worked Example: Rental Property at 18%
Investment: $50,000 down on a rental. Cash flows: $6,000/yr for 5 years, then sell — net proceeds $75,000 in year 5 (equity + appreciation).
- Year 0: −$50,000
- Years 1-4: +$6,000
- Year 5: +$6,000 + $75,000 = $81,000
- IRR ≈ 18.2%
At an 8% hurdle rate, this project clears easily. Note the sale proceeds dominate — IRR is highly sensitive to exit assumptions, so stress-test them.
Test IRR on a flip: $50,000 in, net $65,000 out 18 months later. IRR = (65/50)12/18 − 1 = 19.1%. Impressive — until you note it's $15,000 absolute for 18 months of work, risk, and illiquidity. Always pair IRR with dollar profit and hours invested: a 19% IRR on $50,000 is $15,000; a 12% IRR on $500,000 is $90,000+. Percentages flatter small projects; dollars pay bills.
Stress the exit, because IRR's optimism lives there. If the rental example's sale proceeds come in 10% light ($67,500 instead of $75,000), the 18.2% IRR slides toward ~14% — still acceptable, but a third of the headline return evaporated on one assumption. Model three exits (base, −10%, −20%) before committing capital. If the −20% case breaks your hurdle, the project is an exit bet, not an investment.
IRR Pitfalls
- Multiple IRRs: Cash flows that change sign more than once (e.g., mining with cleanup costs) can produce multiple IRRs — use NPV instead.
- Reinvestment assumption: IRR assumes interim cash flows reinvest at the IRR itself — unrealistic at 30%+ IRRs. MIRR fixes this with explicit reinvestment rates.
- Scale blindness: A 50% IRR on $1,000 ($500 profit) loses to a 15% IRR on $1M ($150,000 profit). Pair IRR with NPV.
- Timing games: IRR rewards early cash flows heavily — it can favor quick flips over durable value.
The reinvestment assumption is where IRR quietly lies. A project distributing $70,000/year on $100,000 invested might flash a 40% IRR — but that math assumes you reinvest every distribution at 40% too. In the real world you reinvest at 8% in an index fund, making true wealth creation closer to an 18% MIRR. IRR assumes you're a genius reinvestor; MIRR assumes you're human. For comparing projects, the human number is the honest one.
Multiple IRRs arise mechanically: cash flows of −$100,000, +$250,000, −$150,000 (cleanup costs) change sign twice, so up to two IRRs exist (Descartes' rule of signs). Your software may report 5% or 35% — both mathematically "correct," both useless for decisions. Mining, oil, and phased developments hit this constantly. When signs flip more than once, abandon IRR entirely and decide on NPV at your hurdle rate.
MIRR: The Fix
Example: Same rental, finance rate 6%, reinvestment 8% → MIRR ≈ 14.1% vs IRR 18.2%. MIRR's honest reinvestment assumption makes it the better comparative metric — most spreadsheet IRR functions have an MIRR sibling.
Use XIRR for real-life timing. Invest $50,000 on January 1, add $10,000 on July 1, end the year at $68,000 — XIRR (in Excel/Sheets) uses exact dates instead of pretending flows land on year-ends. With irregular contributions, plain IRR can misstate results by full percentage points; XIRR is the honest number. Any personal performance tracking with mid-year deposits should use XIRR, full stop.
Watch for PE IRR gaming: funds juice IRR 2-4% using subscription credit lines — calling your capital late and distributing early — without adding a dollar of investment value. The IRR looks stellar; DPI reveals the trick. When comparing funds, rank by DPI and MIRR, never by headline IRR alone. An IRR that can be engineered with a credit facility is a marketing metric, not a performance metric.
Frequently Asked Questions
Context-dependent: 8-12% for stabilized real estate, 15-25% for value-add projects, 20%+ for venture. Always compare against your hurdle rate, not absolute levels.
ROI is total return ignoring timing; IRR annualizes it. 100% ROI over 10 years is ~7.2% IRR — timing changes everything.
Yes — when total cash inflows never recover the investment. A −5% IRR means you lose about 5% per year.
It annualizes irregular cash flows into one comparable number and rewards fast capital return — though critics note it can incentivize short-termism.
Trial and error: compute NPV at two rates bracketing zero, then interpolate. Or use the approximation: IRR ≈ (total profit ÷ investment) ÷ years, adjusted for timing.