IRR Calculator

IRR Calculator
Finance · Investment Analysis

IRR Calculator

Year 0
Year 1
Please enter at least two cash flows, including one negative (investment) and one positive (return) value, for IRR to be solvable.
Internal Rate of Return (IRR)
—
Total Invested
—
Total Returned
—
Net Profit
—
NPV Check at IRR
—
Disclaimer: This calculator estimates the Internal Rate of Return using an iterative numerical method on the series of cash flows you enter. It assumes cash flows occur at regular annual intervals and does not account for taxes, fees, inflation, or reinvestment assumptions. It is provided for general educational and planning purposes only and is not financial advice.

IRR Calculator: How to Find the True Rate of Return on Any Investment

Quick answer: An IRR calculator finds the discount rate that makes the net present value (NPV) of a series of cash flows equal to zero, giving you a single percentage that represents an investment’s expected annual return. Compare that percentage to your cost of capital or hurdle rate — if the IRR is higher, the investment is generally considered worth pursuing.

Comparing two investments with different cash flow timing is genuinely hard to do in your head — a project that pays back quickly but modestly can be worth more or less than one that pays slowly but big, depending entirely on the time value of money. That’s the exact problem an IRR calculator solves. Internal rate of return (IRR) compresses an entire stream of uneven cash flows into one comparable percentage, which is why it’s one of the most widely used metrics in corporate finance, real estate, and personal investment analysis. Below we break down the formula, how it relates to NPV, and several fully worked examples.

What IRR Actually Measures

The Internal Rate of Return is the discount rate that makes the net present value of a project’s cash flows equal exactly zero — in other words, the rate at which the present value of future cash inflows equals the initial cash outflow. Once you’ve calculated it, the IRR is typically compared against a company’s hurdle rate or cost of capital: if the IRR is greater than or equal to that benchmark, the investment is generally accepted as worthwhile, and if it falls below, it’s typically rejected.

The IRR Formula

IRR is derived from the net present value (NPV) formula, set equal to zero:

0 = NPV = Σ [CFₜ / (1 + IRR)ᵗ] − C₀

Where:

  • CFₜ = cash flow at time period t
  • IRR = the internal rate of return (the value being solved for)
  • t = the time period (year 1, year 2, etc.)
  • C₀ = the initial investment (a negative cash flow at time 0)

Unlike most formulas in this guide, IRR usually can’t be isolated algebraically for more than two cash flow periods — it has to be solved through an iterative process, trying different discount rates until NPV lands on zero. In practice, this is done using the IRR or XIRR function in spreadsheet software, a financial calculator, or “Goal Seek” style tools, since these iterative methods for finding the internal rate of return are the standard approach in corporate finance analysis.

Worked Example #1: A Simple Two-Year Project

You invest $10,000 today and receive $6,000 at the end of year 1 and $6,000 at the end of year 2. What’s the IRR?

Setting NPV to zero:

0 = −10,000 + 6,000/(1+r)¹ + 6,000/(1+r)²

Solving iteratively (testing discount rates), r ≈ 13.1% satisfies this equation, meaning this project has an IRR of roughly 13.1%.

Worked Example #2: A Five-Year Investment Project

A company is asked to invest $250,000, expecting to receive $100,000 in year one and growing by $50,000 each subsequent year for four more years (so $100,000, $150,000, $200,000, $250,000, $300,000 across years 1–5).

Running these cash flows through an IRR calculation produces an internal rate of return that can then be compared to the company’s cost of capital to decide whether the project clears the bar for approval — this is exactly the kind of multi-year, growing cash flow scenario IRR is best suited for, since a simple average return wouldn’t account for how much later that later, larger cash flow arrives relative to the initial outlay.

Worked Example #3: Comparing Against a Hurdle Rate

Suppose a $100,000 investment is expected to generate $40,000, $50,000, and $60,000 over the next three years, and the company’s cost of capital is 16%.

Calculating IRR on these cash flows produces a result of approximately 21.65%. Since 21.65% is greater than the 16% cost of capital, the project clears the hurdle rate and would typically be accepted under IRR-based decision rules — a real example that mirrors exactly how finance teams use IRR calculators to make accept/reject calls on capital projects.

IRR vs. NPV: Which Should You Trust?

IRR and NPV usually agree on whether a single project is worth pursuing, but they can disagree when ranking multiple mutually exclusive projects, particularly when projects differ significantly in scale or cash flow timing. In those cases, most finance professionals treat NPV as the more reliable decision-making tool, since it directly measures dollar value created rather than a percentage rate, while IRR remains useful because it produces an intuitive, comparable percentage that’s easier to communicate and benchmark against a hurdle rate.

Step-by-Step: How to Use an IRR Calculator

  1. Enter your initial investment as a negative cash flow at time 0.
  2. Enter each subsequent period’s expected cash flow, whether that’s monthly, quarterly, or annual.
  3. Let the calculator iterate to find the discount rate at which NPV equals zero — this is your IRR.
  4. Compare the IRR to your hurdle rate or cost of capital to decide whether the investment meets your return threshold.
  5. Cross-check with NPV, especially when comparing multiple projects of different sizes, since IRR alone can be misleading for ranking purposes.

Common Mistakes People Make

  • Assuming a higher IRR always means a better investment, without accounting for project scale — a small project with a huge IRR might create far less total value than a large project with a modest IRR.
  • Ignoring the reinvestment rate assumption — IRR implicitly assumes interim cash flows are reinvested at the IRR itself, which can be unrealistic for very high IRRs; MIRR (modified internal rate of return) is often used to correct for this.
  • Applying IRR to cash flow patterns with multiple sign changes (money going in and out repeatedly), which can produce multiple mathematically valid IRRs and make the result meaningless without further analysis.
  • Comparing IRRs across projects with very different time horizons without adjusting for how long capital is tied up.
  • Skipping the hurdle rate comparison entirely and treating any positive IRR as automatically good, when it should be judged against your actual cost of capital.

Frequently Asked Questions

What is a good IRR?

There’s no universal “good” IRR — it depends entirely on your cost of capital or hurdle rate; an IRR is generally considered attractive when it exceeds that benchmark by a meaningful margin to account for risk.

What’s the difference between IRR and ROI?

ROI (return on investment) measures total return without regard to timing, while IRR accounts for the time value of money by discounting cash flows based on when they occur, making IRR more useful for comparing investments with different cash flow schedules.

Can IRR be negative?

Yes, a negative IRR means the investment is expected to lose money overall, since the discount rate needed to bring NPV to zero would have to be negative given the projected cash outflows exceed inflows.

Why do I get more than one IRR for the same project?

Multiple IRRs can occur when a project’s cash flows change sign more than once (for example, a large cash outflow partway through the project), since the NPV equation can cross zero at more than one discount rate in that situation.

How is IRR different from NPV?

NPV expresses an investment’s value in actual dollars at a chosen discount rate, while IRR expresses it as a percentage rate — NPV is generally considered the more reliable metric for ranking projects, while IRR is more intuitive for comparing against a hurdle rate.

Related Calculators

Conclusion

An IRR calculator turns a messy stream of uneven cash flows into a single, comparable percentage by finding the exact discount rate where the investment breaks even in present-value terms. That makes IRR one of the most useful tools available for deciding whether a project clears your cost of capital, but as the examples above show, it works best alongside NPV rather than in isolation — especially when you’re ranking multiple projects of very different sizes. Run your own cash flows through the calculator, then check the resulting IRR against your actual hurdle rate before making a final call.