What Is Internal Rate of Return?
Internal rate of return is the discount rate at which the sum of all future cash flows, when discounted to today's value, equals your initial investment. At this rate, the net present value of the project becomes zero. Mathematically, IRR solves for the interest rate r that balances your starting outlay against all subsequent inflows and outflows.
Practically, IRR represents the annualized percentage gain (or loss) your capital will achieve if you commit it to the project and all projected cash flows materialise as expected. A project with an IRR of 15% means your money grows at 15% per year on average. If your required rate of return—the minimum acceptable return for the risk involved—is 12%, then an IRR of 15% signals the project clears that hurdle and may deserve funding.
Unlike accounting profit, which can be distorted by depreciation schedules and tax timing, IRR reflects actual cash movement. This makes it particularly useful for comparing investments with different timelines, initial costs, and cash flow patterns.
The IRR Formula
IRR emerges from the net present value equation. We set NPV equal to zero and solve for the discount rate r. The formula accounts for each year's net cash flow, discounted back to the present:
0 = −C₀ + C₁/(1 + r) + C₂/(1 + r)² + C₃/(1 + r)³ + … + Cₙ/(1 + r)ⁿ
C₀— Initial investment (entered as a positive number, representing your cash outlay at time zero)Cᵢ— Net cash flow in year i (positive for income, negative for costs or outflows)r— Internal rate of return—the discount rate we are solving forn— Total number of periods (years) over which cash flows occur
How to Use the Calculator
Enter your initial investment as a positive number in the first field. This represents the lump sum you spend at the project's start. Then input the net cash flow for each subsequent year—the difference between money earned and money spent that year. Positive values represent net gains; negative values represent net costs.
The calculator automatically solves for IRR by testing values of r until the equation balances. If the project generates a schedule of returns that cannot be reduced to a single IRR (rare cases with multiple sign changes in cash flows), the tool will indicate this.
You can extend the analysis beyond three years—additional year fields appear as needed, up to 30 years. Real-time updates show your IRR as you refine each cash flow estimate, helping you stress-test assumptions instantly.
Common Pitfalls When Interpreting IRR
IRR is powerful but easily misapplied. Watch for these traps:
- Reinvestment assumption may not hold — IRR assumes all interim cash flows are reinvested at the IRR rate itself. In reality, you might reinvest at a lower rate. Modified IRR (MIRR) corrects this by allowing you to specify a realistic reinvestment rate, often giving a more conservative picture.
- Size and timing differences obscure comparisons — Two projects with the same IRR but different scales and timelines may have vastly different dollar impacts. A small project with 20% IRR might generate less total wealth than a larger project with 12% IRR. Always pair IRR analysis with net present value for full clarity.
- Negative cash flows mid-stream create multiple solutions — If your cash flows change sign more than once (negative, then positive, then negative again), the equation may have multiple IRR solutions or none. Check your cash flow assumptions and consider whether the project structure is realistic.
- IRR ignores your cost of capital — A project with a 15% IRR looks attractive in isolation, but if your cost of capital is 18%, it destroys value. Always compare IRR against your required return or weighted average cost of capital before committing funds.
IRR vs. Modified Internal Rate of Return (MIRR)
While IRR assumes interim cash flows reinvest at the project's own rate, modified internal rate of return (MIRR) imposes a separate reinvestment rate. This is more realistic: if your project generates $10,000 in year two, you probably invest it at your firm's cost of capital—say 10%—not at the project's 20% IRR.
MIRR typically yields a lower, more conservative figure than IRR. It penalises projects that lean heavily on optimistic reinvestment assumptions. For rigorous capital budgeting, especially in competitive industries, MIRR often provides a sounder basis for decision-making than IRR alone. Use both metrics in tandem: IRR for intuitive comparison, MIRR for realistic valuation.