An IRR calculator solves for the discount rate at which a series of cash flows has a net present value of exactly zero. That rate — the internal rate of return — is the compound annual growth rate an investment effectively earns, given when the money goes out and when it comes back. Unlike a simple return percentage, it takes timing seriously: money returned in year one is worth more than the same amount returned in year four, and IRR is the measure that prices that difference.
Arb Digital publishes this in the free tool library at arbsbuy.com. It is a different instrument from the live investment ROI calculator, which divides gain by cost and produces a ratio with no time weighting at all. This page solves a polynomial across an irregular, dated cash-flow series, reports every root it finds, and tells you honestly when there is more than one answer or none.
What This IRR Calculator Does
Paste a cash-flow series, one amount per line, with the initial outlay first. The calculator scans the entire plausible rate range, isolates every interval where net present value changes sign, and solves each one by bisection to high precision. The headline figure is the internal rate of return; the first grid figure is the NPV at that rate, which should be effectively zero and is displayed as a check rather than hidden.
If a line begins with a date, the whole series is treated as dated and solved on an actual-days basis — the calculation usually described as XIRR. That matters for anything that does not arrive on neat annual boundaries: a property deal, a staged investment, or a project with irregular milestone payments. Without dates, the series is treated as equally spaced periods.
The tool also reports MIRR, which resolves the reinvestment assumption built into ordinary IRR, and the NPV of the series at a hurdle rate you set. The sign-change count tells you immediately whether the series is well-behaved, because a series with a single sign change has exactly one internal rate of return and a series with more may have several.
How to Use It
- Enter period 0 first. That is normally the initial outlay and normally negative. A series with no negative value has no rate that can bring it to zero.
- Enter one cash flow per period thereafter, including zeros for periods with no movement. Skipping an empty period compresses the timeline and inflates the result.
- Add dates if the intervals are uneven. Write each line as a date, a comma and an amount. Either every line has a date or none does.
- Set the finance and reinvestment rates for MIRR. The finance rate is what funding the outflows costs you; the reinvestment rate is what returned cash realistically earns.
- Set your hurdle rate and read the NPV at that rate. NPV answers the accept-or-reject question more reliably than IRR does, and the two together are more informative than either alone.
The Formula / How It's Calculated
Net present value discounts every cash flow back to today: NPV = Σ CFt ÷ (1 + r)t. The internal rate of return is the value of r that makes that sum zero. There is no algebraic solution for a general series, so it has to be found numerically.
Take the default series: −50,000 followed by 12,000, 15,000, 18,000 and 21,000. At a 10 percent discount rate the NPV is +1,172.73, so 10 percent is too low — a positive NPV means the flows are worth more than the outlay and the true break-even rate is higher. The solver narrows the interval by repeated bisection and converges on 10.9829 percent, at which the NPV is zero to six decimal places. That zero is displayed in the grid as a verification, because a solver that reports a rate without showing the residual is asking to be trusted rather than checked.
MIRR uses a different construction. All positive flows are compounded forward to the final period at the reinvestment rate, all negative flows are discounted back to today at the finance rate, and the growth rate between the two totals is taken over n periods: MIRR = (FV of positives ÷ −PV of negatives)1/n − 1. With both rates at 8 percent, the positives compound to 73,052.54 against an outlay of 50,000, giving (73,052.54 ÷ 50,000)1/4 − 1 = 9.94 percent — below the IRR, because the IRR quietly assumed the interim cash was reinvested at 10.98 percent rather than 8.
Multiple IRRs, No IRR, and Why This Tool Says So
Because NPV is a polynomial in the discount factor, it can cross zero more than once. Descartes' rule of signs gives the ceiling: a series can have at most as many positive roots as it has sign changes in its cash flows. A conventional project — one outflow followed by inflows — has exactly one sign change and therefore exactly one internal rate of return, which is why the measure works well most of the time.
Non-conventional series are common enough to matter. A mine or a well requires a large closure cost at the end, producing outflow, inflows, outflow. A property project with a mid-life refurbishment does the same. Those series can produce two or more rates at which NPV is zero, and every one of them is mathematically correct. Reporting a single figure from such a series is not a rounding issue; it is a wrong answer presented with false confidence, which is exactly the failure this tool is built to avoid. When it finds several roots it lists them all and says the internal rate of return is ambiguous.
The opposite case is a series with no real solution — for example one that never turns positive, or whose NPV stays the same sign across the entire searched range. Rather than return the nearest plausible number, the calculator says no rate solves the series. In both situations the correct move is to fall back on net present value at an explicit discount rate, which is always single-valued: that is what the NPV calculator is for, and it is why the hurdle-rate NPV appears in the grid here.
The Reinvestment Assumption Hidden Inside IRR
The most consequential property of IRR is one that its definition does not advertise. Discounting every future cash flow at the same rate r is mathematically equivalent to assuming that interim cash received is reinvested at r until the end of the project. For a project returning 11 percent that is a mild assumption. For a project returning 45 percent it is usually fantasy, because opportunities returning 45 percent are not sitting idle waiting to absorb the proceeds.
This is why high-IRR projects tend to look better on paper than they turn out to be, and why the distortion grows with the size of the interim cash flows and the length of the project. MIRR was designed precisely to fix it: by letting you state the reinvestment rate explicitly, it replaces the implicit assumption with a stated one. In the default example the gap is about one percentage point; on a longer project with a high IRR it can be many.
A second structural quirk is that IRR is blind to scale. A project returning 40 percent on 10,000 has a higher IRR than one returning 15 percent on 2,000,000, but it creates far less value. IRR is a rate, and rates cannot be compared without knowing what they apply to. When two projects are mutually exclusive and differ in size or timing, NPV at a consistent discount rate — obtained from the WACC calculator and applied through the DCF calculator — ranks them correctly and IRR does not. The Securities and Exchange Commission's investor glossary entry on net present value and its companion entry on the internal rate of return set out both concepts in plain terms.
Dated Cash Flows and Why the Day Count Matters
Standard IRR assumes every period is the same length. Real investments rarely oblige. A deposit paid in January, a second instalment in April, a distribution in November and an exit the following June are four cash flows across intervals of very different length, and treating them as four equal periods distorts the answer substantially.
Entering dates switches the calculation to an actual-days basis. Each flow is discounted by (1 + r) raised to the power of days-since-the-first-flow divided by 365, so the exponent reflects real elapsed time rather than a period index. The resulting rate is a genuine annual effective rate and is directly comparable between deals of different shapes — which is the whole reason the dated variant exists.
Two practical notes. First, the rate is annualised even if the whole series spans four months, so a short, successful deal can produce a spectacular-looking annual rate that would be impossible to repeat continuously; read it as an annualised rate, not an expectation. Second, if you enter dates for some lines and not others, the tool falls back to periodic mode rather than guessing, because a half-dated series has no unambiguous interpretation. For simple compounding questions with no irregular flows, the compound interest calculator is a more direct instrument.
Using IRR on Marketing and Operating Investments
IRR is normally taught with capital projects in mind, but it applies to any spending that costs money now and returns money over time, which includes a great deal of ordinary business investment.
Content and search investment is the clearest example. Money is spent over several months before meaningful traffic arrives, and the returns then persist for years, which is exactly the shape IRR handles well and a simple return-on-spend ratio handles badly. The same is true of equipment purchases, new premises, a hiring programme with a long ramp, or a product line that needs tooling before it sells.
Three cautions apply when you do this. Use incremental cash flows, not accounting profit — the flows discounted here must be actual money in and out, which is what the free cash flow calculator produces. Include every outflow, including the internal time cost that never appears on an invoice. And be honest about the terminal period: assuming returns continue indefinitely inflates the rate dramatically, so cap the horizon at a period you would actually defend. If the investment is debt-funded, the business loan calculator gives the financing cost that the hurdle rate needs to clear.
Arb Digital builds long-term growth programmes with the cost profile and the return horizon set out clearly, so you can appraise them the same way you appraise anything else.
Web Growth Services Talk to Arb DigitalCommon Mistakes to Avoid
- Omitting empty periods — a period with no cash flow still needs a zero line, or the timeline compresses and the rate is overstated.
- Ignoring a multiple-root warning — a series with several sign changes can have several valid rates, and picking one of them is not a decision, it is a coin toss.
- Comparing IRRs across different project sizes — a rate says nothing about scale, so a high percentage on a small outlay can create less value than a modest one on a large outlay.
- Believing the reinvestment assumption — ordinary IRR assumes interim cash earns the IRR itself, which is why MIRR exists and why the two figures diverge.
- Using accounting profit as the cash flow — depreciation, accruals and non-cash charges must be stripped out before a series is discounted.
Related Free Tools From Arb Digital
Pair this with the NPV calculator for the single-valued alternative, the WACC calculator for a defensible hurdle rate, the DCF calculator for full valuation work, the free cash flow calculator for building the series itself, the investment ROI calculator for a quick untimed ratio, and the compound interest calculator for straightforward growth questions. The full free online tools hub lists everything else.
Frequently Asked Questions
It is the discount rate at which the net present value of a series of cash flows equals zero. In effect it is the compound annual rate the investment earns, taking full account of when each amount is paid or received.
There is no algebraic solution for a general series, so it is found numerically. This tool scans the whole rate range for intervals where net present value changes sign, then narrows each one by bisection until the NPV is effectively zero.
Yes. A series with more than one sign change — outflow, inflows, then a closure cost, for example — can cross zero at several rates, and each is mathematically valid. This calculator reports every root it finds rather than presenting one as the answer.
Some series never bring net present value to zero anywhere in the searched range. The tool says so instead of returning a plausible-looking number, and the correct fallback is net present value at an explicit discount rate, which is always single-valued.
Ordinary IRR implicitly assumes interim cash is reinvested at the IRR itself. MIRR replaces that with rates you state: positive flows are compounded forward at a reinvestment rate and negative flows discounted back at a finance rate, so the assumption is explicit.
It is the same calculation on actual dates rather than equal periods, discounting each flow by the days elapsed divided by 365. Use it whenever the intervals are uneven, which is normal for property deals and staged investments.
NPV ranks mutually exclusive projects correctly because it measures value created in currency. IRR is a rate and is blind to scale, so it can prefer a small high-rate project over a large one that creates far more value.
This calculator performs numerical arithmetic on figures you supply and is provided for general information only. It is not investment, accounting or financial advice, and past or projected cash flows are not a guarantee of future results. Consider speaking to a qualified professional about your own circumstances.
