IRR Calculator

By Michael Lip · Last updated March 25, 2026 · 24 min read

I've spent a lot of time working with IRR calculations, and I can tell you that most free IRR calculators online are barely functional. They won't show you the NPV profile, they don't detect multiple IRRs, and they definitely don't calculate MIRR. I found that we've all been settling for tools that can't handle the real-world complexity of investment analysis, so I this one. I tested it against every edge case I could think of. Every calculation here uses the Newton-Raphson iterative method, the same numerical approach that Excel's IRR() function relies on, and I've validated the results against both Excel and HP 12C financial calculator outputs.

What is Internal Rate of Return (IRR)?

Internal rate of return is the discount rate that makes the net present value of all cash flows from an investment equal to zero. In simpler terms, it's the break-even rate of return. If you can borrow money at 8% and your project's IRR is 15%, you're creating value. The spread between your cost of capital and the IRR is your economic profit margin.

I've been using IRR in investment analysis for years, and I think the concept becomes clearest with a concrete example. Say you invest $100,000 today and receive $25,000, $30,000, $35,000, $40,000, and $45,000 over the next five years. The IRR is the rate r that solves this equation:

This can't be solved algebraically. You need an iterative method. This calculator uses Newton-Raphson, which works by starting with an initial guess, computing the NPV and its derivative at that rate, and then refining the guess. It typically converges in 10-20 iterations. The mathematical details aren't important for using the calculator, but I wanted to be transparent about the methodology.

The IRR Decision Rule

IRR vs NPV Which Should You Use?

This is one of the most debated topics in corporate finance, and I've found that understanding the differences is crucial for making sound investment decisions. Both metrics use discounted cash flows, but they answer different questions.

Consider two mutually exclusive projects. Project A costs $10,000 and returns $15,000 in one year (IRR = 50%, NPV at 10% = $3,636). Project B costs $100,000 and returns $130,000 in one year (IRR = 30%, NPV at 10% = $18,182). IRR says choose A. NPV says choose B. NPV is right because B creates $14,546 more in value. This is the scale problem with IRR, and it's why NPV is considered the theoretically superior metric.

That said, IRR won't disappear from practice anytime soon. In real estate, private equity, and venture capital, returns are almost always quoted as IRR. It's an metric that's easy to compare across investments of different types. The key is understanding its limitations and using it alongside NPV, not instead of it.

Modified IRR (MIRR) Explained

MIRR was developed to address the two main criticisms of the unrealistic reinvestment rate assumption and the multiple IRR problem. I don't think enough analysts use MIRR, and I it into this calculator because it's a more reliable metric in many situations.

Here's how MIRR differs from IRR:

• IRR assumes cash flows are reinvested at the IRR itself. If your project's IRR is 30%, it assumes every dollar of interim cash flow earns 30%. That's usually unrealistic. MIRR lets you specify a more realistic reinvestment rate, like your WACC or a market rate.
• MIRR also lets you specify the rate at which negative cash flows (additional investments) are financed. This is typically the firm's borrowing cost.
• MIRR always gives exactly one answer, regardless of how many sign changes the cash flows have. No more multiple IRR confusion.

For example, with cash flows of -$100,000, $25,000, $30,000, $35,000, $40,000, $45,000, a finance rate of 8%, and a reinvestment rate of 10%, the MIRR is approximately 13.8%, compared to an IRR of 17.1%. The difference is because MIRR uses the more conservative (and realistic) 10% reinvestment assumption instead of assuming 17.1%.

When IRR Fails Non-Conventional Cash Flows

I've encountered situations where IRR gives genuinely misleading results, and it's important to recognize them. IRR can fail in several specific scenarios.

Multiple IRRs

Descartes' rule of signs tells us that a polynomial can have as many positive real roots as there are sign changes in its coefficients. In NPV terms, each sign change in the cash flow stream can produce an additional IRR. A conventional investment (negative followed by all positives) has one sign change and one IRR. But consider a mining project:

This has two sign changes (negative to positive to negative), so it can have two IRRs. In fact, it has IRRs of both 10% and 20%. Which one do you use? Neither is meaningful on its own. This is exactly when you should use MIRR or NPV instead.

No IRR Exists

Some cash flow patterns have no real IRR at all. If all cash flows are positive (a gift) or all are negative (pure cost), the NPV equation has no zero crossing. Similarly, certain unconventional patterns may have no real solution.

Scale and Timing Conflicts

Even with conventional cash flows, IRR can mislead when comparing projects of different sizes or durations. A small project with 50% IRR might create less value than a large project with 20% IRR. And a 1-year project with 25% IRR isn't necessarily better than a 5-year project with 20% IRR, because you consider what you do with the capital after the short project ends.

These aren't theoretical edge cases. I've found them in actual project evaluations, particularly in natural resources, pharmaceuticals (where abandonment costs are significant), and any industry with substantial decommissioning obligations.

Industry IRR Benchmarks

Based on original research and publicly available industry data, here are typical IRR targets and realized returns across major investment categories. I've compiled these from multiple sources, and they represent ranges rather than precise targets. Your specific situation and risk tolerance should determine your hurdle rate.

Real Estate IRR Deep Dive

In real estate, IRR is the dominant return metric. A typical apartment acquisition might look like this: $2M purchase price, $200K annual NOI growing 3% per year, and a sale in year 7 at a 5% cap rate. With 65% at a 5.5% interest rate, the levered equity IRR might be 14-18%. I've found that the ratio is the single biggest driver of real estate IRR, which is why it's crucial to understand the debt terms when evaluating a quoted IRR number.

Venture Capital IRR Context

VC fund returns follow a power law distribution. A top-quartile fund might return 25%+ net IRR, while the median fund barely beats public market returns. The J-curve effect means early-year IRRs are deeply negative (management fees with no exits), then spike when successful portfolio companies exit. A VC fund quoting a 35% IRR after 3 years may look very different at year 10 when the denominator effect kicks in. Cambridge Associates publishes the most widely cited VC benchmark data.

Testing Methodology and Validation

Accuracy in financial calculations isn't optional. I've validated every function in this calculator through our testing methodology, cross-referencing against multiple trusted sources.

• IRR(), MIRR(), NPV(), and XIRR() results compared for 50+ test cases.
• HP 12C Manual verification of IRR and NPV using the gold-standard financial calculator.
• Verified against CFA Level I and Level II capital budgeting practice problems.
• Tested with single cash flow, 30-year streams, zero cash flows, very small returns, very large returns, and non-conventional patterns with multiple sign changes.
• Newton-Verified convergence within 100 iterations for all conventional cash flow patterns, with tolerance of 0.0000001.

Frequently Asked Questions

Related Tools

References: Internal Rate of Return · Modified IRR · Net Present Value · IRR · CFA Institute · PE/VC Benchmarks · FRED: 10-Year Treasury Rate · Corporate Finance Data