Skip to content

IRR Calculator (Internal Rate of Return)

Calculate the annualized compound return rate for any cash flow schedule, examine the full NPV sensitivity profile, and benchmark against corporate hurdle rates.

Internal Rate of Return (IRR) Calculator

Presets:
$
%
PeriodExpected Cash Flow ($)Action

What is the Internal Rate of Return (IRR)?

The Internal Rate of Return (IRR) is a fundamental capital budgeting metric used across corporate finance, private equity, and real estate to measure the expected annualized percentage yield of an investment. Unlike Net Present Value (NPV), which delivers an absolute dollar amount of value added, IRR expresses return as an intuitive percentage yield.

Formally, IRR is the precise discount rate ($r$) that equates the present value of future cash inflows to the initial cash outlay, reducing the project's net present value to zero:

0 = ∑t=1n [ CFt / (1 + IRR)t ] − CF0Because this is an nth-degree polynomial with no closed-form algebraic solution for n > 2, calculating IRR requires numerical approximation algorithms (such as the Newton-Raphson method or binary bisection).

How to Use IRR in Capital Budgeting

In corporate decision-making, the decision rule for a standalone project evaluated with IRR is:

  • IRR > Hurdle Rate (WACC): Accept the project. The investment is expected to generate a higher return rate than what capital costs to acquire.
  • IRR = Hurdle Rate: Indifferent. The project covers the cost of capital and breaks even.
  • IRR < Hurdle Rate: Reject the project. The returns fall short of capital costs, destroying economic value relative to alternative investments.

Real-World Industry Use Cases

1. Private Equity (LBO Returns)

PE sponsors target 20%–25% IRR thresholds over 5-year holding periods to justify leverage and equity risk.

2. Venture Capital Portfolios

Venture funds evaluate seed and Series A deals targeting 30%+ portfolio IRRs to compensate for high startup mortality rates.

3. Real Estate Flipping

Commercial developers benchmark project IRR against local cap rates and construction financing interest rates.

4. Capital Rationing

Treasury teams rank independent divisions by IRR to allocate limited annual capital expenditure budgets.

Critical Limitations of IRR (When NPV is Superior)

While IRR is intuitive, corporate finance theory identifies three severe mathematical pitfalls where IRR can lead to flawed decisions:

1. The Reinvestment Rate Dilemma

IRR mathematically assumes that all interim cash distributions can be reinvested into other opportunities at the project's own IRR rate for the remainder of the timeline. If an exceptional venture has an IRR of 50%, assuming future cash flows can also achieve 50% is unrealistic. NPV, by comparison, assumes reinvestment at the actual cost of capital (WACC), which is far more realistic.

2. Scale Insensitivity (The Dollar Wealth Trap)

IRR measures percentage efficiency, not total dollar wealth creation:

  • Project A: Invest $1,000 to receive $2,000 in one year → IRR = 100% (NPV at 10% = +$818).
  • Project B: Invest $1,000,000 to receive $1,400,000 in one year → IRR = 40% (NPV at 10% = +$272,727).

Relying solely on IRR would cause an executive to choose Project A, forfeiting over $270,000 of shareholder wealth. For mutually exclusive projects, NPV always takes precedence over IRR.

Frequently Asked Questions

Q1What is the Internal Rate of Return (IRR)?
The Internal Rate of Return (IRR) is the annualized effective compound return rate earned on an investment. Mathematically, it is the discount rate that sets the Net Present Value (NPV) of all cash inflows and outflows to exactly zero: NPV(IRR) = 0.
Q2How do I interpret the IRR result against corporate hurdle rates?
Compare the calculated IRR against your minimum required rate of return (hurdle rate or WACC). If the IRR > Hurdle Rate, the project generates higher returns than your cost of capital and is generally acceptable. If IRR < Hurdle Rate, the project should be rejected.
Q3What is the reinvestment rate assumption flaw in IRR?
Standard IRR implicitly assumes all intermediate cash inflows can be reinvested at the project's own IRR rate until maturity. For high-IRR projects (e.g., 40%), this assumption is usually unrealistic in practice. In contrast, NPV conservatively assumes reinvestment at the actual cost of capital (WACC).
Q4Why does the calculator warn about 'multiple IRRs'?
When a project has non-conventional cash flows where signs switch more than once (e.g., Outflow → Inflow → Outflow for major mid-life overhaul), Descartes' Rule of Signs dictates there can be multiple mathematical discount rates where NPV = 0. In such cases, standard IRR is ambiguous, and you should rely on Net Present Value (NPV) or Modified IRR (MIRR).
Q5Can an investment have a negative IRR?
Yes. If the total nominal sum of all future cash inflows is less than the initial investment outlay, the IRR is negative, meaning the project cannot even return the principal invested, regardless of the discount rate.
Q6How does IRR differ from Modified Internal Rate of Return (MIRR)?
Modified IRR (MIRR) resolves IRR's reinvestment flaw by explicitly compounding intermediate cash inflows at the cost of capital (WACC) to the terminal date, and discounting financing outflows at the cost of debt. This produces a single, conservative percentage return.