IRR Calculator
Calculate the Internal Rate of Return (IRR) for capital budgeting and investment projects, with sign change analysis and Net Present Value convergence.
How It's Calculated
Formula
0 = \text{NPV} = \sum_{t=0}^{n} \frac{CF_t}{(1 + \text{IRR})^t} = -CF_0 + \sum_{t=1}^{n} \frac{CF_t}{(1 + \text{IRR})^t}The Internal Rate of Return (IRR) is a foundational metric in corporate finance, private equity, and capital budgeting. It represents the annualized compound discount rate that sets the Net Present Value (NPV) of all cash flows (initial outlays and subsequent returns) from an investment equal to zero. When evaluating projects, financial analysts compare the calculated IRR against the organization's cost of capital, weighted average cost of capital (WACC), or internal hurdle rate: projects with an IRR higher than the required rate of return are generally accepted because they add economic value.
According to Descartes' Rule of Signs, a polynomial equation can have as many positive real roots as there are sign variations between consecutive non-zero coefficients. In a conventional investment sequence—where an initial negative cash outflow (period 0) is followed solely by positive cash inflows—there is exactly one sign change. Under this single sign-change condition, a unique conventional internal rate of return is guaranteed to exist whenever the undiscounted sum of subsequent inflows exceeds the initial outlay.
Conversely, when a project experiences non-conventional cash flows—such as mid-cycle capital expenditures, environmental cleanup costs, decommissioning liabilities, or alternating periods of positive and negative cash flows—more than one sign change occurs. In these non-conventional scenarios, the NPV equation may yield multiple distinct internal rates of return (or no real rate of return at all), leading to conflicting or mathematically ambiguous investment signals. Per CalcSpectrum's strict V1 financial policy, this calculator identifies multiple sign changes and reports them as ambiguous rather than arbitrarily selecting a single mathematical root. For multi-sign-change cash flows, practitioners should rely on the Net Present Value (NPV) profile or the Modified Internal Rate of Return (MIRR).
Worked Examples
Conventional 3-Year Capital Project
- Initial outlay (period 0): $10,000 cash outflow (treated as -$10,000).
- Subsequent inflows: Year 1 = $3,000; Year 2 = $4,200; Year 3 = $6,800. Total subsequent cash flows = $14,000; Net cash flow = $4,000.
- Sign changes: Exactly 1 sign change (from -$10,000 at period 0 to +$3,000 at period 1), confirming a conventional cash-flow profile per Descartes' Rule of Signs.
- NPV formula setup: 0 = -$10,000 + $3,000 / (1 + r)^1 + $4,200 / (1 + r)^2 + $6,800 / (1 + r)^3.
- Solving for r using numerical bisection yields IRR ≈ 16.34%.
Break-Even Project with Exact Zero IRR
- Initial outlay: $10,000 cash outlay.
- Subsequent inflows: Year 1 = $4,000; Year 2 = $6,000. Total subsequent cash flows = $10,000; Net cash flow = $0.
- Sign changes: 1 sign change (from -$10,000 to +$4,000).
- At r = 0%: NPV = -$10,000 + $4,000 / (1.0)^1 + $6,000 / (1.0)^2 = -$10,000 + $10,000 = $0.00.
- Because Net Present Value is zero at a zero discount rate, the project's IRR is exactly 0.00%.
Non-Conventional Sequence with Multiple Sign Changes (Ambiguous IRR)
- Initial outlay: $100 cash outlay (period 0 = -$100).
- Subsequent cash flows: Year 1 = +$230 (inflow); Year 2 = -$132 (reinvestment/cleanup outflow).
- Sign changes: 2 sign changes (negative to positive, then positive to negative).
- Descartes' Rule of Signs indicates up to two positive real roots: NPV equals zero at both r = 10% and r = 20%.
- Under CalcSpectrum V1 policy, the status reports ambiguous multiple sign changes rather than selecting an arbitrary root.
Frequently Asked Questions
What is the difference between IRR and NPV?
Net Present Value (NPV) measures the absolute dollar value added to an organization by discounting all expected future cash flows at the firm's required cost of capital. Internal Rate of Return (IRR) is the percentage discount rate that drives NPV to exactly zero. While IRR provides an intuitive percentage return for comparing projects of differing sizes, NPV is generally preferred in corporate capital budgeting because it avoids reinvestment rate assumptions and scales directly with shareholder wealth.
What is Descartes' Rule of Signs, and why does it affect IRR?
Descartes' Rule of Signs states that the number of positive real roots of a polynomial cannot exceed the number of sign variations between successive non-zero coefficients. Because the NPV equation is a polynomial in (1 + r)^(-1), an investment sequence with one sign change (e.g. initial outflow followed by inflows) has at most one positive real IRR. When cash flows alternate between positive and negative more than once, multiple internal rates can exist, creating ambiguity.
Why does the calculator report 'Ambiguous' for some cash flows?
When cash flows change sign more than once (for example, when an initial outlay is followed by profits, but then requires a large environmental remediation or decommissioning outlay at the end), multiple mathematical discount rates can produce an NPV of zero. CalcSpectrum's V1 policy never guesses or selects an arbitrary root; it explicitly flags the sequence as ambiguous and recommends evaluating the full NPV profile or calculating the Modified Internal Rate of Return (MIRR).
Can an investment project have a negative IRR?
Yes. If the total undiscounted cash inflows over the project's life are less than the initial cash outlay (net cash flow is negative), the project loses money overall, and its internal rate of return will be negative (greater than -100% and less than 0%). A negative IRR indicates that the project fails to recover invested capital even before accounting for the time value of money.
What should I do if my cash flows have no sign changes?
If all cash flows are positive (e.g., pure grants, gifts, or revenues with no initial cost) or all cash flows are negative (e.g., pure expense outlays with no revenues), the cash flow profile never crosses zero. Mathematically, no discount rate can discount non-zero cash flows of a single sign to sum to zero, meaning no conventional IRR exists.