Calculate internal rate of return from an investment's cash flows
IRR (Internal Rate of Return) is the discount rate at which an investment's NPV equals exactly zero — in other words, the annualized rate of return the investment is expected to generate. It's used alongside NPV to evaluate whether a project's expected return clears a company's cost of capital or an investor's required return.
IRR is the rate r that solves: 0 = −Initial Investment + Σ [Cash Flow_t / (1 + r)^t]
| Calculation | Expression | Result |
|---|---|---|
| $100k investment | 3 years of $40k cash flows | IRR ≈ 9.7% |
| $50k investment | $20k/yr for 4 years | IRR ≈ 21.9% |
There's no universal 'good' number — a good IRR is simply one that exceeds your cost of capital (WACC) or required rate of return for that level of risk. A 15% IRR might be excellent for a low-risk project but underwhelming for a high-risk venture investment.
With more than one future cash flow, the IRR equation becomes a higher-degree polynomial with no general algebraic solution — it has to be solved numerically, by testing rates until the one that makes NPV exactly zero is found.
Yes — if the cash flows change sign more than once (for example, an initial cost, followed by profits, followed by another large cost), the NPV-vs-rate curve can cross zero more than once, producing multiple mathematically valid IRRs. NPV is generally more reliable for these non-conventional cash flow patterns.
Not necessarily — IRR is a percentage and doesn't account for the scale of the investment. A small project with a very high IRR might create far less total value than a large project with a moderate IRR. NPV is usually a better metric for comparing investments of different sizes.
IRR is the rate of return an investment is actually expected to generate. A hurdle rate is the minimum acceptable return a company or investor requires (often set equal to WACC) — a project clears the bar when its IRR exceeds the hurdle rate.