IRR Calculator with MIRR, NPV and the Multiple-IRR Warning

What IRR Is, and Why It Is Trickier Than It Looks

The internal rate of return, or IRR, is one of the most used measures in investment and business finance. It is defined as the discount rate at which the net present value of a project’s cash flows equals zero, in other words, the rate of return the project earns on the money tied up in it. If a project’s IRR is higher than your required return, your hurdle rate or cost of capital, the project earns more than it costs you to fund and is worth doing; if it is lower, it is not. This single-number verdict is why IRR is so popular for comparing opportunities.

Unlike a simple return, IRR accounts for the timing of every cash flow. A rupee received in year one is worth more than a rupee received in year five, because you could reinvest the earlier one; IRR builds this time value in by discounting each flow. This makes it far more accurate than a crude total return for any investment where money comes in over several years, which is most real projects, from a factory that costs money now and earns it back over a decade, to a rental property, to a business venture.

But IRR has a hidden complexity that trips up even experienced users, and it is the reason a good calculator must be more sophisticated than it appears. There is no algebraic formula for IRR; you cannot rearrange the equation to solve for it directly. Instead it must be found numerically, by trying different rates until the NPV comes out to zero. This tool does that with a robust search that scans the full range of possible rates, rather than a single quick guess that can miss the answer or land on the wrong one.

More importantly, IRR can misbehave. When a project’s cash flows change sign more than once, an outflow, then inflows, then another large outflow, for example, there can be more than one rate at which NPV equals zero, meaning the project has multiple IRRs, none of which is uniquely correct. Most calculators silently return just the first one they find, giving you a plausible but meaningless number. This tool detects that situation and warns you, steering you to NPV or MIRR instead, which is exactly what a careful analyst would do.

MIRR, NPV, and When to Trust Which

IRR carries a second, subtler flaw beyond the multiple-answer problem, and understanding it is what separates a naive user from a sound one. The IRR calculation implicitly assumes that every positive cash flow the project throws off is reinvested at the IRR itself. For a project with a very high IRR, say 30 per cent, this assumes you can keep reinvesting the proceeds at 30 per cent, which is usually unrealistic; in reality you might only be able to reinvest them at your cost of capital or a market rate. This assumption inflates the IRR and can make a project look better than it truly is.

The modified internal rate of return, MIRR, fixes this. Instead of assuming reinvestment at the IRR, it lets you specify a realistic reinvestment rate, and it also handles the financing of outflows at a separate finance rate. It compounds all the inflows forward to the end of the project at your reinvestment rate, discounts the outflows back to the start, and computes the single rate that connects them. The result is always one unambiguous answer, even for the awkward cash-flow patterns where plain IRR gives several, and it reflects the return you would actually earn given how you can really reinvest. For most business decisions, MIRR is the more honest figure, which is why this tool computes it alongside IRR.

Net present value, NPV, sidesteps IRR’s problems altogether by answering a different and often better question: how much value, in rupees, does this project create today? It discounts every future cash flow back to the present at your hurdle rate and sums them, including the initial outlay. If the NPV is positive, the project earns more than your required return and creates value; if negative, it destroys value. NPV is the theoretically soundest single measure, because it gives an absolute rupee answer and never suffers the multiple-answer problem. The one thing it does not tell you is the rate of return, which is where IRR and MIRR come in.

So the practical rule is to use them together. Use NPV for the decision itself, does this project create value, and for its size, since a large NPV on a big project may beat a higher IRR on a tiny one, IRR being blind to scale. Use IRR for a quick, intuitive rate when the cash flows are conventional, one outflow followed by inflows, and MIRR when you want a realistic rate or when the cash flows are irregular and IRR is unreliable. Add the payback period for a simple sense of how long your money is at risk. This tool computes all of them, so you get the full capital-budgeting picture rather than a single figure that might mislead.

A final word on how these measures relate in practice. For a conventional project, one outflow followed by inflows, IRR, MIRR and NPV will usually agree on the go or no-go verdict, and the extra measures simply add confidence and nuance: MIRR tempers an optimistic IRR, payback flags how long your capital is exposed. It is when they disagree that the analysis earns its keep. If NPV says go but IRR is ambiguous, trust NPV. If IRR looks stellar but MIRR is far lower, the gap is telling you the IRR rests on a reinvestment assumption you cannot meet. Learning to read the disagreements, rather than seizing on whichever number is highest, is what turns these tools from a source of false comfort into a genuine aid to judgement.

How the Metrics Are Calculated

The tool computes the full set of capital-budgeting metrics from your cash flows, in four steps.

Step one: build the cash-flow series

It takes your initial investment as the year-zero outflow, a negative number, and each future cash flow you enter as the flow for that year, positive for an inflow, negative for a further outflow. This series is the input for every metric. Because you enter each year independently, the tool handles uneven cash flows, a large inflow one year and a small one the next, without assuming they are equal.

Step two: solve for the IRR numerically

Since IRR has no algebraic formula, the tool scans the net present value across a wide range of discount rates and finds every rate at which the NPV crosses zero, using bisection to pin each one down precisely. Scanning the whole range, rather than guessing once, is what lets it find the correct answer reliably and, crucially, detect when there is more than one, the multiple-IRR case, or none at all, in which case it tells you to use NPV instead.

This is a genuine advantage over the common approach of a single Newton-Raphson guess. That method starts from one estimate and iterates toward a nearby root, which is fast but has two weaknesses: if the starting guess is poor it can fail to converge or converge to the wrong root, and it returns only one answer, so it is blind to the existence of a second or third IRR. By scanning the entire plausible range first and then refining every crossing it finds, the tool trades a little speed for correctness and safety, which is the right trade for a decision this consequential. You get not just a number but the knowledge of whether that number is the whole story.

Step three: compute MIRR and NPV

It computes the modified IRR by compounding your positive cash flows forward to the end at your reinvestment rate and discounting the outflows to the start at the hurdle rate, then finding the single connecting rate, which is always unambiguous. It also computes the NPV at your hurdle rate, the rupee value the project creates, and compares the IRR against the hurdle to give a clear go or no-go verdict on whether the project clears your required return.

Step four: payback and the NPV profile

Finally it computes the payback period, how long until your cumulative cash flow turns positive, both on a simple basis and on a discounted basis that accounts for the time value of money, the discounted payback always being the longer and more honest of the two. It also draws the NPV profile, a chart of NPV against discount rate that crosses zero exactly at the IRR, making the relationship between the two visible at a glance.

IRR, MIRR and NPV Compared

These reference points explain the formulas and when each metric is the right one to trust.

The formulas

Which metric to trust

The go or no-go rule

Three Worked Examples From Real Decisions

Here are three decision-makers using the tool to judge a project properly.

Arun weighs a machine purchase in Pune

Arun runs a small manufacturing unit in Pune and is considering a machine costing one lakh that should generate about forty thousand a year for four years. On the tool he entered the outlay and the four inflows, with a hurdle rate of ten per cent, his cost of capital. The IRR came out comfortably above ten per cent, and the NPV at his hurdle was clearly positive, giving a firm go. The MIRR, using a realistic reinvestment rate, was a little lower than the IRR, as expected, but still above his hurdle.

Arun bought the machine confident that on every measure, IRR, MIRR and NPV, it cleared his bar and would create value, and the payback period told him his outlay was at risk for only a couple of years. What reassured him most was seeing the three metrics agree: for a conventional project like his, one outflow followed by steady inflows, IRR is well behaved and the numbers reinforce one another rather than conflict. Had the MIRR come out below his hurdle while the IRR sat above it, he would have known to trust the more conservative MIRR and think harder, but here the consistency across measures gave him a clean, confident decision.

Meera avoids the multiple-IRR trap in Mumbai

Meera, in Mumbai, was evaluating a project with an unusual pattern: a large outflow to start, strong inflows in the middle years, then a big clean-up cost at the end, so the cash flows changed sign twice. A basic calculator she had tried returned a single, healthy-looking IRR, and she nearly approved the project on it. On this tool, however, she got a warning that the cash flows produced more than one IRR, neither of them meaningful, and a clear instruction to rely on NPV and MIRR instead.

The NPV at her hurdle was in fact negative. Meera realised the earlier calculator had given her a dangerously misleading figure, and she rejected a project that the multiple-IRR trap had made look attractive. The episode taught her to be suspicious of any project with an end-of-life outflow, a decommissioning cost, a restoration liability, a final tax payment, because exactly those patterns create the second sign change that breaks IRR. She now checks the sign pattern of her cash flows before she even looks at the IRR, and leans on NPV as her primary decision metric whenever the pattern is anything but the simple outflow-then-inflows shape.

Rakesh compares rate against scale in Bengaluru

Rakesh, in Bengaluru, had two projects: a small one with a very high IRR and a large one with a more modest IRR but a much bigger NPV. Tempted by the higher rate, he was about to pick the small project, until the tool reminded him that IRR ignores scale. He computed the NPV of each and saw that the large project, despite its lower IRR, created far more total value in rupees. Rakesh chose the large project, understanding that a high percentage return on a small sum can be worth less than a solid return on a big one, and that NPV, not IRR, answers the question of how much value a project actually creates.

The lesson reshaped how he presented investments to his partners. Where he had once led with the headline IRR because it sounded impressive, he now leads with the NPV, the actual rupees of value created, and treats the IRR as a supporting efficiency figure. He had seen how easily a shiny percentage could tempt a decision-maker toward the smaller, less valuable option, and he built the NPV-first habit precisely to guard against it. For mutually exclusive choices, where picking one means forgoing the other, he understood that the money left on the table by chasing the higher rate is a real and avoidable cost.

Six Tips for Using IRR Well

Frequently Asked Questions on IRR

Related Calculators You May Find Useful