IRR Calculator (Internal Rate of Return)

Some investments are easier to compare as a rate than as a dollar value. This IRR calculator takes an upfront investment, a series of future cash flows, and an optional comparison rate. It then solves for the discount rate that would make the cash-flow NPV equal zero. In plain language, IRR is the annualized break-even return implied by the cash-flow pattern.

IRR is common in capital budgeting, private equity, real estate underwriting, equipment purchases, and project finance. It is related to, but not identical with, the NPV calculator. NPV asks how many dollars remain after applying a required return. IRR asks which return would make those dollars exactly balance. For a company-wide discount rate, use the WACC calculator. For equity-required return, use the CAPM calculator. For full company valuation, use the DCF calculator and review the enterprise value calculator.

How the calculator interprets your entries

Enter initial investment as a positive cost paid today. The code subtracts this amount at time zero. Then enter annual cash flows in the list. Positive numbers are inflows; negative numbers are later outflows, such as cleanup costs or reinvestment. The calculator uses the order of the rows as periods 1, 2, 3, and so on when solving IRR and calculating the comparison NPV.

The comparison rate is separate. It does not change the IRR. It discounts the same ordered cash-flow series to show NPV at your chosen hurdle rate. That is useful because a project can have an attractive IRR and still add too few dollars to matter, or a large project can have a modest IRR but a strong positive NPV.

Formula

IRR is the rate that sets net present value to zero:

$0 = -\text{initial investment} + \sum_{t=1}^{n}\frac{\text{cash flow}_{t}}{\left(1 + \text{IRR}\right)^{t}}$

For the comparison NPV, the calculator uses the hurdle rate you enter:

$\text{NPV at hurdle rate} = -\text{initial investment} + \sum_{t=1}^{n}\frac{\text{cash flow}_{t}}{\left(1 + r\right)^{t}}$

Because IRR appears inside several exponents, there is usually no simple algebraic rearrangement. This calculator searches rates from approximately negative 99.99% to 1,000%, finds a sign change in NPV, and then applies bisection for 80 narrowing steps. If there is no sign change in that range, it reports that IRR was not found.

Worked example using the default inputs

Suppose the initial investment is 12,000 dollars. The future cash flows are 4,000 dollars, 6,500 dollars, 3,000 dollars, and 2,000 dollars in that row order. The comparison rate is 10%. The undiscounted future cash flows total 15,500 dollars, and net cash before discounting is 3,500 dollars.

At the comparison rate, the NPV calculation is:

The present values sum to 12,628.24 dollars. After subtracting the 12,000 dollar initial investment, the comparison NPV is 628.24 dollars. The IRR search then looks for the discount rate where that NPV would fall exactly to zero. For this cash-flow series, the calculator reports about 12.71%.

That answer means the project breaks even at a 12.71% discount rate. Since the comparison rate is 10%, the output tone is positive and the comparison NPV is above zero. If the hurdle rate were higher than 12.71%, the same cash flows would fail the hurdle.

How IRR is used in capital budgeting

IRR is useful when decision makers think in rates. A project with a 20% IRR sounds more intuitive than saying it adds a specific present-value amount under one discount-rate assumption. Lenders, sponsors, and managers also use IRR to compare a project against a cost of capital or required return.

However, IRR should not be the only test. If two projects require different investment sizes, the one with lower IRR can still create more value. For example, a small add-on project may earn 40% but only add a few thousand dollars, while a larger expansion may earn 14% and add millions in NPV. When projects are mutually exclusive, the NPV rule is usually better for maximizing dollar value.

IRR also assumes interim cash flows can effectively be reinvested at the IRR. That may be aggressive for very high-return projects. Modified IRR can address that issue, but this calculator intentionally solves the standard IRR used in most capital-budgeting summaries.

Limitations and tips

Cash-flow signs matter. The most reliable IRR setup is one upfront cost followed by positive future inflows. If cash flows switch from positive to negative and back again, the math can produce multiple IRRs or no clear economic answer. In those cases, use NPV profiles and scenario analysis instead of relying on one rate.

Keep period spacing consistent. The calculator treats each list row as the next equal period. If your model is monthly, use monthly cash flows and interpret IRR as a per-period monthly rate unless you convert it. If your model is annual, keep every row annual.

Review the comparison NPV every time. A project that clears the hurdle rate by a small margin may be fragile if costs rise or revenue is delayed. Try lower cash flows, later receipts, and a higher hurdle rate to see whether the conclusion survives stress testing.

Sources

• CFA Institute, Capital Investments and Capital Allocation — capital budgeting criteria including NPV and IRR.