The Complete Guide to Internal Rate of Return (IRR) in the Real World
The internal rate of return is the most quoted number in project finance after NPV itself. IRR is the discount rate at which a project’s NPV equals zero — the break-even cost of capital. Managers love it because it expresses attractiveness as a single percentage: "this project returns 18%." Private equity markets entire funds on IRR.
Yet IRR is also the most misused metric in corporate finance. It misranks projects of different scale, can exist multiple times or not at all, and quietly assumes reinvestment at implausible rates. This guide explains what IRR really measures, how to solve it, and when to distrust it in favor of NPV.
01What Is IRR?
IRR answers: "what constant annual return does this project earn on the money still invested in it?" Mathematically, it is the rate r* that satisfies NPV = 0 — the point where the NPV profile crosses the horizontal axis. At discount rates below the IRR the project creates value; above it, value is destroyed.
Because IRR is defined implicitly, it is found by iteration — trial and error, or a bisection algorithm like the one in our NPV & IRR calculator. Spreadsheets solve it instantly, but every solver inherits the same mathematical quirks described below, so automated answers deserve the same skepticism as manual ones.
Formula
Σt=0n CFt / (1 + IRR)t = 0
IRR: the rate that sets NPV to zero
02The IRR Decision Rule
For a conventional project — cash outflow first, inflows after — the rule is simple: accept if IRR exceeds the hurdle rate, reject if it falls below. A project with an 18% IRR against a 12% cost of capital clears the bar with room to spare, exactly as an NPV-positive verdict would demand.
For mutually exclusive alternatives, the naive "pick the highest IRR" fails. A small project can post a spectacular IRR on trivial dollars while a large project posts a modest IRR on enormous dollars — the latter may create ten times more NPV. Wealth depends on dollars, not percentages, so when rankings conflict, NPV decides.
Scale beats percentage
Project A: invest $1, receive $1.50 next year — IRR 50%, NPV $0.32 at 15%. Project B: invest $10,000, receive $12,000 next year — IRR 20%, NPV $435 at 15%. A’s IRR is 2.5× higher; B creates 1,360× more value. Choosing by IRR alone would be a costly mistake.
03The Multiple-IRR Problem
IRR is a root of a polynomial, and polynomials can have several roots. Whenever cash flows change sign more than once — outflow, inflow, then a large final outflow, as in mining reclamation, nuclear decommissioning, or staged lending — multiple IRRs can exist, and the spreadsheet may happily return one of them without warning.
The practical defense is to always examine the NPV profile: plot NPV across discount rates and see how many times it crosses zero. If more than once, IRR is ambiguous by construction and the decision must rest on NPV at the relevant cost of capital. Our NPV Profile visual tool demonstrates exactly this behavior.
04The Reinvestment Assumption & MIRR
IRR implicitly assumes interim cash flows are reinvested at the IRR itself. A project with 40% IRR is presumed to recycle its early proceeds at 40% — rarely realistic when comparable opportunities yield 12%. This inflates the apparent attractiveness of projects with early cash flows.
The modified IRR (MIRR) fixes this by stating the reinvestment rate explicitly: all inflows are compounded forward to the final year at the reinvestment rate, all outflows discounted to today at the financing rate, and MIRR is the rate connecting them. MIRR is unique — no multiple-root problem — and typically more honest. When IRR and MIRR diverge significantly, the project’s early cash flows are doing the flattering.
Formula
MIRR = ( FVinflows at r_{reinvest} / PVoutflows at r_{finance} )1/n − 1
Modified IRR with explicit reinvestment rate
05IRR in Practice
IRR thrives where cash flow patterns are conventional and communication matters more than precision. Fund managers report IRRs because investors understand percentages; development projects screen by IRR against sector hurdle rates; real estate deals compare cash-on-cash IRRs across properties.
The professional synthesis is straightforward: compute both NPV and IRR. IRR communicates intensity, NPV confirms wealth. If they disagree on ranking, NPV wins — and the disagreement itself is diagnostic, usually revealing scale or timing effects worth understanding before committing capital.
- IRR communicates well; NPV decides well.
- Check the NPV profile for sign changes and multiple crossings.
- Compare IRR against MIRR to expose reinvestment flattery.
- Never rank mutually exclusive projects by IRR alone.
06IRR vs NPV — Resolving the Disagreements
When IRR and NPV rank two mutually exclusive projects differently, the argument is never random — it always traces to one of two hidden wedges. The first is scale: IRR is a percentage and cannot see size, so a 60% IRR on $10,000 will out-rank an 18% IRR on $10 million, even though the second creates vastly more wealth. The second is timing: IRR implicitly compounds early cash flows at the IRR itself, so projects that front-load their inflows get flattered whenever the IRR exceeds the realistic reinvestment rate.
The resolution protocol is worth memorizing. Compute both measures. If they agree, proceed. If they disagree, ask which wedge explains it — compare project sizes (scale) or run MIRR (timing). Then let NPV make the final call, because shareholders spend dollars, not percentages. Treated this way, a disagreement stops being a nuisance and becomes free diagnostics about what is really driving each project’s shine.
Scale beats percentage
Project A: invest 10,000, receive 16,000 in one year → IRR 60%, NPV 4,545 at 10%. Project B: invest 10,000,000, receive 12,000,000 in one year → IRR 20%, NPV 909,091. Ranked by IRR, A looks like a superstar; ranked by wealth created, B is two hundred times more valuable. Any protocol that picks A because 60 > 20 has confused a ratio with a result.
Key Takeaways
- IRR is the discount rate where NPV = 0 — the project’s break-even return.
- Accept when IRR > hurdle rate (for conventional cash flows).
- Multiple sign changes can create multiple IRRs — always inspect the NPV profile.
- IRR assumes reinvestment at itself; MIRR states a realistic rate and is unique.
- Disagreements with NPV trace to scale or timing — diagnose, then let NPV decide.