IRR Calculator: Internal Rate of Return Formula & Examples (2026)

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. If NPV asks “how much value does this investment create at a given discount rate,” IRR asks “at what discount rate does this investment break even in present-value terms?”

The practical interpretation is simpler: IRR is the annualized return an investment generates, accounting for the time value of money and the specific timing of every cash flow. A project with a 22% IRR is expected to return 22% per year on invested capital, compounded.

According to a 2023 survey by the Association for Financial Professionals, IRR is the primary capital budgeting metric used by 77% of U.S. corporations for evaluating major investments. NPV is the theoretical gold standard, but IRR wins in practice because it produces an intuitive percentage that non-finance executives can immediately benchmark against borrowing costs or required returns.

The IRR Decision Rule

The logic is straightforward:

• IRR > hurdle rate: Accept the project. It creates more value than its cost of capital.
• IRR < hurdle rate: Reject the project. It destroys value relative to alternatives.
• IRR = hurdle rate: Indifferent. The project earns exactly its cost of capital.

The hurdle rate is usually the company's weighted average cost of capital (WACC) plus a risk premium for the specific investment. A PwC survey found that the average corporate hurdle rate in the U.S. is approximately 10-12%, though this varies significantly by industry, firm size, and leverage.

How IRR Is Calculated: No Closed-Form Solution

This surprises most people. Unlike NPV, which you can compute directly, IRR has no algebraic formula. You cannot isolate it on one side of an equation. Instead, it is solved by trial-and-error iteration.

The process works like this: start with a guess (say, 10%). Compute the NPV of all cash flows at that rate. If NPV is positive, the actual IRR is higher, so raise your guess. If NPV is negative, lower it. Repeat until NPV equals zero (or close enough). This is essentially Newton's method— a root-finding algorithm that converges quickly when the initial guess is reasonable.

In practice, Excel's =IRR() function runs this iteration automatically, typically converging within 0.00001% accuracy after 20 iterations. Our IRR Calculator does the same thing instantly.

Step-by-Step Example: $100K Investment

Let's walk through a real calculation. You invest $100,000 today in a project that generates the following cash flows:

Total undiscounted cash inflows: $155,000 on a $100,000 investment. That's a 55% total return over 5 years. But raw totals ignore timing — a dollar in Year 5 is worth less than a dollar today.

To find IRR, we solve for r in the NPV equation:

0 = -100,000 + 20,000/(1+r) + 30,000/(1+r)² + 35,000/(1+r)³ + 40,000/(1+r)²³&sup4; + 30,000/(1+r)&sup5;

Running the iteration: at r = 15%, NPV ≈ +$3,200. At r = 17%, NPV ≈ -$1,400. The IRR sits between these — approximately 16.2%. If your hurdle rate is 12%, this project passes. If it's 18%, it doesn't.

Verify this yourself using our free IRR Calculator.

IRR Benchmarks by Investment Type

IRR means nothing without context. Here's what target IRRs look like across major investment categories:

Top 5 IRR Benchmarks You Need to Know

Bain & Company's 2024 Global Private Equity Report found that buyout fund managers target gross IRRs of 20-25%on individual deals to deliver net IRRs of 15-20% after the standard 2% management fee and 20% carried interest. The gap between gross and net matters — a fund showing 22% gross IRR might deliver only 16% to LPs.

Private Equity IRR in Detail

The private equity industry lives and dies by IRR. A few things worth knowing:

• Top-quartile buyout funds have historically delivered net IRRs above 20% over 10-year horizons, per Cambridge Associates data.
• Median buyout funds return 14-16% net — still strong, but the spread between top and bottom quartile is enormous (often 15+ percentage points).
• Hold period matters: short hold periods (2-3 years) inflate IRR mechanically. A 3x return in 2 years = 73% IRR. The same 3x return in 5 years = 25% IRR. This is why MOIC (multiple on invested capital) is always reported alongside IRR in PE.

Real Estate IRR: Why Leverage Dominates

Real estate investors almost always report leveredIRR (after debt financing). A property generating a 9% unlevered IRR might produce a 17% levered IRR with 65% LTV financing at 5.5% interest — because leverage amplifies equity returns when the asset return exceeds the borrowing cost.

The National Council of Real Estate Investment Fiduciaries (NCREIF) reported that value-add real estate strategies delivered average levered IRRs of 16.8% over the 10 years ending 2023. This makes 15-20% the standard target range for institutional value-add deals.

Venture Capital IRR

VC firms target higher IRRs because of the high failure rate of portfolio companies. If 60% of investments go to zero, the remaining 40% need to generate exceptional returns. The National Venture Capital Association's 2023 Yearbook shows top-quartile VC funds targeting 25-30% net IRR to LPs, with individual deal targets often in the 40-50%+ range to compensate for expected losses across the portfolio.

IRR vs NPV: When They Conflict

IRR and NPV almost always agree on accept/reject for a single project. The trouble starts when you compare mutually exclusive projects — where you can only choose one.

The Scale Problem

Consider two projects:

IRR says choose Project A. NPV says choose Project B. Who's right? NPV is right. Project B creates $95,000 of actual wealth versus $18,000 for Project A. IRR's 30% applies to a much smaller base — it's a rate, not a dollar amount. You can't deposit rates in a bank.

The timing problem is similar: IRR can favor projects that return cash early (boosting the annualized rate) even when a longer-duration project creates more total NPV at the same discount rate. For capital allocation decisions, NPV is the theoretically correct metric. IRR is a useful screening tool, not a ranking tool.

For a deep dive on NPV mechanics, see our NPV Calculator Guide.

Modified IRR (MIRR): Fixing IRR's Biggest Flaw

Standard IRR assumes that interim cash flows are reinvested at the IRR itself. That's fine if IRR is 10%. It's wildly unrealistic if IRR is 35% — you can't reinvest every cash flow at 35% in the real world.

Modified IRR (MIRR) fixes this by:

1. Discounting all negative cash flows back to Year 0 at the financing rate (cost of capital)
2. Compounding all positive cash flows forward to the final year at the reinvestment rate (typically WACC)
3. Computing the single rate that equates the two

Using the $100K example from earlier with a 10% reinvestment rate and 10% financing rate, MIRR comes out to approximately 13.8%versus the 16.2% IRR. The lower MIRR is more realistic — it doesn't assume you can park Year 1's $20,000 in something that also earns 16.2%.

MIRR also solves the multiple-IRR problem. Because it transforms all cash flows into a single terminal value and a single present-value outflow, the equation always has exactly one solution.

IRR Limitations: 4 Problems Every Analyst Should Know

1. Multiple IRRs with Sign-Changing Cash Flows

Descartes' rule of signs: the number of IRR solutions equals the number of times the cash flow series changes sign. Most investments start negative and turn positive — one sign change, one IRR. But projects with major cleanup costs at the end (oil wells, nuclear plants) go negative again, producing two IRRs or none. Use MIRR or NPV instead.

2. Ignores Project Scale

As shown above, IRR is a rate, not a dollar measure. It cannot tell you which of two projects creates more value in absolute terms. Always pair IRR with NPV or MOIC when comparing investments.

3. Unrealistic Reinvestment Assumption

Standard IRR assumes all interim cash flows are reinvested at the IRR rate. For high-IRR projects (25%+), this overstates expected performance. MIRR corrects this by letting you specify a realistic reinvestment rate.

4. IRR Ignores Duration

A 5-year project with 20% IRR and a 10-year project with 18% IRR are not directly comparable. The shorter project's IRR says nothing about what happens to the cash you receive in Years 6-10. Extended NPV analysis or equivalent annual annuity (EAA) methods handle this better.

IRR in Real Estate: A Practical View

Real estate is one of the heaviest users of IRR analysis. A typical underwriting model projects:

• Year 0: Equity check (e.g., $2M on a $10M property with 80% LTV)
• Years 1-5: Net cash flow after debt service (cash-on-cash returns)
• Year 5: Sale proceeds minus remaining loan balance (reversion)

The equity IRR is computed on those combined flows. Leverage dramatically affects the number. At 65% LTV and a 5% cap rate purchase, modest rent growth and a cap rate compression of 50 basis points at sale can push levered equity IRR from 10% to 18%+.

A 2024 CBRE survey of institutional real estate investors found that 85% of respondents use IRR as their primary return metric, with most requiring a minimum levered IRR of 12% for core deals and 18% for opportunistic ones. The “promote” or carried interest in real estate GP/LP structures is typically triggered above an 8% preferred return, making the 8% hurdle rate a common floor in deal analysis.

For related analysis, see our Payback Period Calculator Guide and our guide on reading an amortization schedule.

Frequently Asked Questions

What is internal rate of return (IRR)?

IRR is the discount rate that makes the net present value (NPV) of all cash flows from an investment equal to zero. In plain terms, it is the annualized return rate an investment generates. Accept a project if its IRR exceeds your required rate of return (hurdle rate or WACC).

What is a good IRR for a real estate investment?

Most real estate investors target a levered IRR of 15-20% for value-add deals and 8-12% for core stabilized properties. Private equity real estate funds typically target 18-22% net IRR for opportunistic strategies. Actual acceptable IRR depends on deal risk, leverage, and market conditions.

When does IRR conflict with NPV?

IRR and NPV conflict when comparing mutually exclusive projects of different sizes or different cash flow timing. IRR ignores project scale — a $1M project with 30% IRR creates less value than a $10M project with 20% IRR. When they conflict, always trust NPV. It measures actual dollar value created.

What is MIRR and why does it matter?

Modified IRR (MIRR) solves two key IRR flaws: the multiple-IRR problem and the unrealistic reinvestment assumption. MIRR assumes positive cash flows are reinvested at your cost of capital (not the IRR itself), which is far more realistic. MIRR is almost always lower than IRR but more accurate.

What IRR do private equity firms target?

Buyout PE funds typically target gross IRRs of 20-25% and net IRRs of 15-20% after fees. Top-quartile funds have historically delivered net IRRs above 20%. Venture capital funds target higher gross IRRs of 25-35% to account for the high failure rate of early-stage investments.

Can a project have multiple IRRs?

Yes. Any project with non-conventional cash flows — where the sign changes from positive to negative more than once — can produce multiple IRR solutions or no solution at all. This is called the multiple-IRR problem. MIRR or NPV analysis should be used instead in these cases.