Multiple IRRs: Why IRR Can Have More Than One Answer (and What to Use Instead)

Quick Answer

Multiple IRRs means one set of cash flows can produce more than one IRR value that satisfies the equation “NPV = 0.” This can happen when your cash flows change sign more than once.

In practical terms: if you invest money (negative), then receive cash (positive), then invest again later (negative), the math can allow multiple IRR solutions. The IRR you get may depend on the software, initial guess, or numerical method.

What “Multiple IRRs” Means (in Plain English)

IRR (internal rate of return) is defined as the discount rate that makes the net present value (NPV) of cash flows equal to zero. Conceptually, you have a series of cash flows:

• Initial investment (usually negative)
• Cash flows during the hold (often positive)
• Exit proceeds at sale/refinance (positive)

IRR is the interest rate that makes those flows “balance out” when discounted to the present. If the cash flows behave nicely—one big negative at the start followed by positives—IRR often behaves nicely too.

But if your cash flow series has a more complex pattern—especially when it switches between negative and positive multiple times—then IRR can become ambiguous. The same cash flow series can produce multiple discount rates that make NPV equal to zero.

This is not a “bug” in IRR calculators. It’s a property of the math. The calculator is solving an equation, and sometimes that equation has multiple solutions.

Why Multiple IRRs Happen: Sign Changes Are the Trigger

The most practical way to understand the cause is the idea of sign changes. A sign change occurs when your cash flow sequence goes from negative to positive, or positive to negative.

The simple case (usually one IRR)

A typical “normal” investment looks like this:

• Year 0: -$100,000 (you invest)
• Years 1–9: +$8,000 per year (cash flow)
• Year 10: +$140,000 (cash flow + sale proceeds)

This sequence changes sign once: negative to positive. In many such cases, IRR tends to be unique and stable.

The problematic case (multiple IRRs possible)

Now consider a pattern like:

• Year 0: -$100,000 (buy / down payment)
• Years 1–2: +$10,000 per year (cash flow)
• Year 3: -$60,000 (major renovation / capital call)
• Years 4–6: +$18,000 per year (higher cash flow after improvements)
• Year 7: +$160,000 (sale proceeds)

This sequence changes sign at least twice: negative → positive → negative → positive. With two or more sign changes, the IRR equation can have more than one valid solution.

Why sign changes create multiple solutions (intuition)

IRR is effectively asking: “At what rate does the discounted value of positive cash flows equal the discounted value of negative cash flows?” When you have multiple negative “investments” separated by positive cash flows, the balance between those components can work out at more than one rate. Different rates can make the present values equal in different ways.

How to Detect Multiple IRRs (Fast)

1) The sign-change test (the quickest check)

Write your cash flows in order and mark them as + or −. Count how many times the sign flips as you move through time.

• 0 sign changes: usually not a meaningful IRR (e.g., all negative or all positive).
• 1 sign change: IRR often unique and stable (not guaranteed, but common).
• 2+ sign changes: multiple IRRs are possible; be careful.

2) The “IRR looks too good to be true” test

Sometimes multiple IRRs show up as a suspiciously high or weird IRR number that doesn’t match your intuition about the deal. If IRR says 60% but the deal feels mediocre, the metric might be unstable (or assumptions are wrong). Treat that as a red flag and check the cash flow signs.

3) The software mismatch test

If one spreadsheet gives a different IRR than another tool for the same cash flows, it can be because:

• Different numerical methods or initial guesses
• Timing assumptions (annual vs monthly vs irregular dates)
• Multiple valid roots (multiple IRRs)

If you see inconsistent IRR outputs across tools, don’t “pick the one you like.” That inconsistency is a signal to switch to NPV/MIRR and report more context.

4) Plot NPV vs discount rate (the clearest diagnostic)

If you plot NPV at different discount rates (for example 0%, 5%, 10%, 20%, 40%), you can see how many times NPV crosses zero. Each zero-crossing corresponds to an IRR solution. Multiple crossings can mean multiple IRRs.

You don’t need fancy math: even a simple table of NPV at several rates can reveal if NPV changes sign multiple times.

Examples: Where Multiple IRRs Show Up in Real Life

Example 1: Renovation-heavy real estate deal (capital call mid-hold)

You buy, collect some cash flow, then do a major renovation or tenant improvement that requires new capital. That creates a second negative cash flow. After the renovation, cash flow improves and you sell later.

This “invest → receive → invest → receive” pattern is the classic multiple-IRR setup. It doesn’t mean the deal is bad. It means IRR as a single metric may not summarize it cleanly.

Example 2: Cash-out refinance plus later reinvestment

Some deals distribute cash via refinance (a big positive flow), then later require a cash infusion for repairs, legal issues, or debt paydown (a negative flow). That creates more sign changes.

IRR can become highly sensitive to the refi timing and reinvestment timing. Two plausible timelines can produce very different IRRs even if the deal outcome feels similar.

Example 3: “Flip” projects with staged investments

Flips often involve multiple rounds of spending: purchase + rehab + holding costs. If you model holding cash flows and then later add a large rehab expense after some inflow, you can create multiple sign changes.

Many people avoid this by consolidating early costs into “initial investment,” but real life sometimes has phased spending and surprises.

Example 4: Private investments with capital calls

In private equity or venture, investors may invest, receive distributions, and later face capital calls. That can create multiple sign changes and multiple possible IRRs.

This is why sophisticated reporting often pairs IRR with TVPI/equity multiple and uses NPV at a hurdle rate.

Why IRR Becomes Unreliable When Multiple IRRs Exist

1) The “headline number” can be arbitrary

When multiple IRRs exist, a calculator may return one of them depending on how it searches for a solution. Two tools can both be correct while giving different answers. That means the IRR you present could be more about the tool than the deal.

2) IRR can reward unrealistic reinvestment assumptions

One common critique of IRR is that it can implicitly assume interim cash flows are reinvested at the IRR rate. When cash flows are irregular, this can become even less realistic. If the IRR is very high, it’s unlikely you can actually reinvest interim distributions at that same high rate.

3) IRR can hide bad cash flow risk

A deal can show an attractive IRR due to a strong exit, even if it has long periods of weak or negative cash flow. For real estate investors, survivability matters. If a property is cash flow negative for years, you need reserves. IRR alone doesn’t tell you that story.

4) IRR can mislead when timing is uncertain

Small changes in timing can move IRR a lot. If you have refinancing uncertainty, renovation delays, or unknown exit timing, an IRR estimate can create false precision.

What to Do Instead: Stable Alternatives to IRR

If you suspect multiple IRRs (or just want more robust reporting), use a combination of metrics that remain meaningful under irregular cash flows.

1) NPV (Net Present Value) at a chosen discount rate

NPV answers a simple question: “If my required return (hurdle rate) is X%, how much value does this deal create today?” Choose a discount rate that reflects your risk and alternatives (for example, your target return).

NPV has two major advantages:

• It is unique (no multiple answers for a given discount rate).
• It is decision-oriented: if NPV is positive at your hurdle rate, the deal clears your bar.

2) MIRR (Modified IRR)

MIRR modifies the reinvestment assumption by letting you choose: a finance rate (cost of capital) and a reinvestment rate for positive cash flows. This tends to produce a more stable, interpretable “annualized” return when cash flows are messy.

3) Equity multiple (also called MOIC / multiple on invested capital)

Equity multiple is:

It ignores timing (unlike IRR) but it is simple and hard to manipulate. When IRR is unstable, equity multiple keeps you grounded: it tells you “how many dollars back per dollar in.”

4) Total profit dollars (and worst-case dollars)

Always include dollar outcomes: total profit, total cash distributions, and worst-case outcomes under conservative scenarios. Percent metrics can look great even when the absolute outcome is small or the downside is severe.

5) Time-based measures: payback and break-even

For certain decisions, “How long until I get my money back?” is more actionable than a single IRR. Payback can also reveal survivability issues that IRR hides.

MIRR: A Practical Fix When IRR Breaks

MIRR (modified internal rate of return) exists for a reason: standard IRR can be confusing when reinvestment assumptions are unrealistic or when cash flows produce multiple sign changes.

What MIRR changes

Standard IRR effectively bakes in a reinvestment concept that can be hard to justify in the real world. MIRR makes the assumptions explicit:

• Finance rate: the rate you pay on capital (your borrowing cost or opportunity cost)
• Reinvestment rate: the rate you realistically earn on interim positive cash flows

Why MIRR is often more interpretable

If you assume reinvestment at a reasonable rate, MIRR becomes a cleaner “annualized return” summary that doesn’t swing wildly when cash flows change sign.

MIRR still depends on assumptions—but the assumptions are visible and adjustable, which is a feature.

When MIRR is especially useful

• Deals with capital calls or large mid-hold renovations
• Deals with refinancing events that return capital and change the cash flow pattern
• Comparing deals where timing differs but you want a single annualized summary

A Simple Reporting Framework (So Your Returns Stay Honest)

If you want return reporting that works even when IRR is unstable, use a small dashboard. Here’s a practical framework you can apply to real estate deals, syndications, and private investments.

1) Cash flow survivability (year 1 and worst-year)

• Year-1 cash flow (is it positive or negative?)
• Worst-year cash flow under a stress scenario (vacancy + repair + higher expenses)
• Reserve requirement (how much buffer you need to hold the deal)

2) Value creation at your hurdle rate (NPV)

Pick a hurdle rate that reflects your alternative opportunities and risk. Compute NPV at that rate. If NPV is barely positive, the deal is not robust.

3) Annualized summary (MIRR or IRR with warnings)

Report MIRR (or IRR if cash flows are normal and IRR is stable), and clearly state assumptions. If multiple sign changes exist, label IRR as “unstable” and lead with MIRR/NPV.

4) Total outcome (equity multiple + profit dollars)

Always show total cash returned, total cash invested, equity multiple, and profit dollars. This prevents the “high IRR, low dollars” trap.

5) Scenario band (conservative / base / optimistic)

If your conclusion flips easily with small changes in exit price or timeline, treat the deal as fragile and require a margin of safety.

Quick Checklist: Avoid Getting Tricked by IRR

• ✅ Write cash flows in order and count sign changes
• ✅ If sign changes ≥ 2, assume IRR may be unstable
• ✅ Compute NPV at your hurdle rate (unique and decision-focused)
• ✅ Report equity multiple and total profit dollars
• ✅ Consider MIRR with realistic reinvestment assumptions
• ✅ Stress-test exit price, timeline, and mid-hold capital needs
• ✅ Don’t compare levered returns to unlevered returns
• ✅ Don’t let one headline percentage replace risk analysis

Fast Stress Tests (The “IRR Honesty Tests”)

1) Mid-hold overrun test

Add a surprise negative cash flow mid-hold (extra repair, renovation overrun, vacancy period). Does IRR jump around or flip? Do you still like the deal on NPV and equity multiple?

2) Exit haircut test

Reduce the exit proceeds (lower sale price, higher selling costs, longer time to sell). If the deal only looks good with a perfect exit, the risk is higher than the headline IRR suggests.

3) Timing shift test

Push the exit out by one year. Push a renovation delay by six months. If IRR changes dramatically with small timing shifts, treat the result as fragile.

4) Reinvestment realism test (MIRR)

If IRR implies a very high annual rate, ask: “Can I realistically reinvest interim cash flows at that rate?” If not, MIRR (with a realistic reinvestment rate) is a better summary number.

Related links

Frequently Asked Questions

Bottom Line

Multiple IRRs are not a rare corner case—they show up whenever an investment has more than one round of capital going in or out. If cash flows change sign multiple times, IRR can have multiple valid answers and become a misleading headline number. The fix is not to “find the right IRR,” but to use better reporting: NPV at your hurdle rate, MIRR with realistic assumptions, equity multiple, profit dollars, and scenario tests. That framework stays honest when the real world gets messy.

Methodology and assumptions

Educational only. IRR behavior depends on cash flow timing, sign changes, and the numerical method used by tools. For irregular cash flows, report multiple metrics (NPV, MIRR, equity multiple, dollars) and run conservative scenarios.