IRR Calculator Guide: Internal Rate of Return Explained (2026)

What Is IRR (Internal Rate of Return)?

IRR is the annualized discount rate that makes the net present value of all cash flows from an investment equal to zero. Think of it as the effective annual return an investment is expected to generate over its holding period.

The decision rule is straightforward: if an investment’s IRR exceeds your required rate of return (your hurdle rate or cost of capital), the investment creates value and is worth pursuing. If it falls short, it destroys value.

According to a McKinsey survey of corporate finance executives, IRR is the most commonly used capital budgeting metric in large organizations — used by more than 75% of CFOs when evaluating major investment decisions. In private equity and real estate, it is essentially the universal standard for communicating fund performance.

The IRR Formula (Conceptually)

IRR solves for the rate r in the NPV equation set to zero:

0 = CF₀ + CF₁/(1+r) + CF₂/(1+r)² + … + CFₙ/(1+r)ⁿ

Where CF₀ is the initial investment (typically negative), and CF₁ through CFₙ are the subsequent cash flows. There is no closed-form algebraic solution — IRR must be solved iteratively, which is why calculators and spreadsheets are essential.

IRR Benchmarks by Investment Type

What counts as a “good” IRR varies dramatically by asset class, risk level, and fund vintage. Here are the typical targets used by institutional investors:

According to Cambridge Associates’ 2024 Private Equity Benchmark Report, the median net IRR for US buyout funds (2015–2020 vintage years) was approximately 18.4%. Top-quartile funds exceeded 25% net IRR. CBRE’s 2025 Global Real Estate Investor Intentions Survey found that 67% of institutional real estate investors require a minimum 12% IRR for value-add strategies.

IRR vs MOIC: Two Ways to Measure Private Equity Returns

Professional investors never look at IRR alone. They pair it with MOIC — Multiple on Invested Capital — because the two metrics capture different dimensions of performance.

The relationship between MOIC, IRR, and holding period is fixed by math. Here’s a quick reference table:

A 3.0× MOIC sounds the same in every pitch deck. But whether it represents a 44% IRR or a 17% IRR depends entirely on how long the capital was deployed. This is why PE LPs scrutinize both metrics — and why rushed exits (inflating IRR) are not always in investors’ best interests.

How to Calculate IRR Manually (Newton-Raphson Approximation)

Because IRR has no closed-form solution, it must be solved iteratively. The Newton-Raphson method is the standard algorithm used by Excel, financial calculators, and our IRR calculator.

Here is the step-by-step process:

1. List all cash flows including the initial investment as a negative number (e.g., –$100,000 at year 0).
2. Start with an initial guess for the IRR, typically 10%.
3. Calculate NPV at your guess rate. If NPV is positive, your true IRR is higher than the guess. If negative, it’s lower.
4. Adjust the rate using the derivative of the NPV function and recalculate.
5. Repeat until NPV is sufficiently close to zero (typically within $0.01).

In Excel, the function is simply =IRR(values, [guess]) where values is the range of cash flows starting with the initial investment. Most iterations converge in 20 or fewer steps.

For quick manual approximation: pick two discount rates where one gives a positive NPV and one gives a negative NPV, then interpolate linearly. This is called the linear interpolation methodand typically gets you within 0.5–1% of the true IRR.

IRR vs NPV: Which Should You Use?

This is one of the most debated questions in corporate finance. The CFA Institute’s curriculum notes that NPV is theoretically superior as the primary capital budgeting tool, but IRR remains more widely used in practice.

The practical answer: use both. NPV for capital allocation decisions (it never misleads on which project creates more value). IRR for communicating returns to investors and comparing to hurdle rates.

5 Limitations of IRR You Need to Know

1. The Reinvestment Rate Problem

Standard IRR assumes that all intermediate cash flows are reinvested at the same IRR. For a 40% IRR investment, this implies finding additional 40% opportunities to reinvest interim proceeds — which is rarely realistic. This overstates true wealth creation for high-return projects. MIRR (Modified IRR) fixes this by specifying a separate, realistic reinvestment rate.

2. Ignores Investment Size

A 50% IRR on $1,000 generates $500 in profit. A 20% IRR on $10,000,000 generates $2,000,000 in profit. IRR says the first is “better.” NPV correctly identifies the second as more valuable. Always pair IRR with absolute dollar return metrics (NPV or MOIC).

3. Multiple IRR Solutions

If a project’s cash flows change sign more than once (common in mining, real estate development, or projects requiring major capex mid-life), there can be multiple valid IRR solutions. For example, a project might have both a 10% IRR and a 40% IRR depending on which root the algorithm finds. NPV does not have this problem.

4. Timing Manipulation

Because IRR rewards speed, fund managers can inflate IRR by returning capital quickly — even if total returns are lower. A fund that returns 2.0× in 2 years has a 41% IRR. A fund that returns 3.5× in 7 years has a 19% IRR. The second fund created significantly more wealth, but IRR alone would favor the first. This is why MOIC and DPI (Distributions to Paid-In Capital) are essential complements.

5. Does Not Account for Opportunity Cost Scale

IRR cannot tell you whether to invest more capital at a lower return or less capital at a higher return. A VC fund might show 35% gross IRR, but if it only deployed $50M, the total value creation is limited. NPV and absolute return metrics capture what IRR misses.

IRR in Private Equity: How Funds Report Performance

Private equity funds report two versions of IRR: gross IRR (before management fees and carried interest) and net IRR(after fees). The difference is substantial — typically 3–8 percentage points depending on fee structure.

A standard PE fee structure of “2 and 20” (2% management fee, 20% carried interest with an 8% preferred return hurdle) can reduce gross IRR of 25% down to net IRR of approximately 17–19%. According to Preqin’s 2025 Global Private Equity Report, the median net IRR for all PE fund strategies over the 2010–2020 vintage period was approximately 15.2%.

Investors should always ask whether quoted IRR figures are gross or net. Many fund marketers lead with gross IRR, which can be misleading for LP return expectations.

IRR in Real Estate: A Practical Example

Here is a straightforward real estate IRR calculation for a rental property:

Running these cash flows through an IRR calculator (or Excel’s =IRR() function) yields approximately 14.2% IRR. This falls in the core-plus real estate range — reasonable for a stabilized rental property in a major market.

CBRE Research notes that average unleveraged cap rates for US multifamily assets in major markets ran approximately 4.5–5.5% in 2024–2025. With leverage and rent growth assumptions, levered IRRs in the 12–16% range are achievable for well-executed acquisitions.

Frequently Asked Questions

What is IRR (Internal Rate of Return)?

IRR is the annualized 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 effective annual return an investment is expected to generate. If IRR exceeds your required return (hurdle rate), the investment creates value. If it falls short, it destroys value. IRR is the most commonly used return metric in private equity, venture capital, and real estate.

What is a good IRR?

A “good” IRR depends entirely on the asset class and risk profile. Top-quartile buyout PE funds target 20–25%+ net IRR. Venture capital funds target 25–35%+ gross IRR to achieve top-quartile status. Real estate core strategies target 8–12% IRR; opportunistic real estate targets 18–25%+. Infrastructure funds typically target 10–15%. Always compare IRR to the hurdle rate for the specific investment — a 15% IRR is excellent for core real estate but mediocre for VC.

What is the difference between IRR and NPV?

NPV (Net Present Value) measures the absolute dollar value an investment adds after discounting cash flows at your required rate. IRR is the percentage rate at which NPV equals zero. NPV tells you how much value is created in dollars; IRR tells you the percentage return. NPV is theoretically superior for capital allocation because it accounts for investment scale. IRR can mislead when comparing projects of different sizes — a 50% IRR on a $1,000 investment creates far less value than a 20% IRR on $10 million.

What is Modified IRR (MIRR) and why is it better?

MIRR (Modified Internal Rate of Return) addresses two major weaknesses of standard IRR: the reinvestment rate assumption and multiple IRR solutions. Standard IRR assumes interim cash flows are reinvested at the same IRR, which is often unrealistic for high-IRR investments. MIRR lets you specify a realistic reinvestment rate (typically your cost of capital or WACC). For a project with a 35% IRR and a 10% reinvestment rate, MIRR will be significantly lower — giving a more conservative and accurate picture of actual returns.

Why is IRR misleading for comparing projects of different sizes?

IRR expresses return as a percentage and ignores the scale of investment entirely. A 50% IRR on a $10,000 investment generates $5,000 in profit. A 20% IRR on a $1,000,000 investment generates $200,000. If you had to choose, the larger project creates 40× more value despite its lower IRR. This is why sophisticated investors use both IRR and MOIC together, and why NPV is often preferred for capital budgeting decisions involving projects of different scales.

What is MOIC and how does it relate to IRR?

MOIC (Multiple on Invested Capital) measures total value returned divided by total capital invested, expressed as a multiple (e.g., 3.0×). Unlike IRR, MOIC ignores the time dimension. A 3.0× MOIC achieved over 3 years is approximately a 44% IRR; the same 3.0× over 5 years is approximately a 25% IRR; over 7 years it drops to approximately 17% IRR. Private equity uses both metrics: MOIC captures magnitude of return, IRR captures speed. Top-tier PE firms typically target 3.0×+ MOIC and 20%+ IRR.