Skip to main content

Internal rate of return (IRR)

IRR Calculator: Internal Rate of Return & Capital Efficiency Model

Calculate Internal Rate of Return.

01

Cash flows

$

Positive amounts are treated as an outflow (IRR convention). You can enter a positive number; it is converted automatically.

By year

Year 1
$
Year 2
$
Year 3
$
Year 4
$
Year 5
$

Positive = inflows (dividends, sale proceeds); negative = additional outflows or costs.

02

Hurdle & MIRR

%

Minimum acceptable return (default 8%)

IRRHigh return
33.40%

Internal rate of return

+25.40%

Vs hurdle

NPV @ hurdle

+$11,483

Net return

$19,000

Outflow

$10,000

Inflow

$29,000

Sensitivity

If the final cash flow is 10% lower:

31.97%

IRR vs base: 1.43%

IRR Strategy 2026: Why Timing is Everything

Master the Internal Rate of Return and understand why cash flow timing matters more than total profit in investment evaluation.

Strategic IRR Insights

Exit Velocity Matters

A faster "flip" in real estate significantly boosts IRR even if total profit is lower.
Receiving $150K in Year 4 vs. Year 5 can increase IRR by 2-3%, demonstrating why timing beats total return.

The Reinvestment Assumption

IRR assumes positive cash flows are reinvested at the IRR itself, which is often unrealistic.
MIRR uses a realistic reinvestment rate (e.g., 5%), making it more conservative and professional.

Hurdle Rates in 2026

With T-Bills paying 4.5% and S&P 500 yielding 8-10%, a 5% IRR deal is sub-optimal.
Your hurdle rate should reflect risk-free rate + risk premium, don't accept low returns when alternatives exist.

NPV as Validation

Always check NPV at your hurdle rate as a second layer of validation.
A positive NPV confirms the investment creates value, even if IRR is close to your hurdle rate.

Multiple IRR Detection

Cash flows that change signs multiple times can have multiple IRRs.
The calculator warns you, use MIRR instead for a single, unambiguous answer.

Time Value of Money Reality

A dollar received today is worth significantly more than a dollar received in Year 5.
IRR captures this through discounting, making it superior to simple ROI calculations.

IRR Calculator: Internal Rate of Return

Calculate the Internal Rate of Return (IRR) for any investment. Compare your deal against 2026 hurdle rates and model real-world MIRR outcomes.

How the Math Works

IRR is the discount rate r that sets the Net Present Value of all cash flows to zero. The calculator solves this equation numerically using the Newton-Raphson iterative method, since there is no closed-form algebraic solution for r when cash flows span multiple periods.
NPV=โˆ‘t=0nCFt(1+r)t=0\text{NPV} = \sum_{t=0}^{n} \frac{CF_t}{(1+r)^t} = 0

where CFt is the cash flow at time t (negative for outflows, positive for inflows), n is the total number of periods, and r is the IRR. A positive CF0 followed by negative flows, or sign changes more than once, can produce multiple valid r values, the calculator warns you and suggests MIRR instead.

  • Newton-Raphson Iteration:
    Starting from an initial guess, the algorithm refines r by evaluating NPV and its derivative at each step until the result is effectively zero (within floating-point tolerance).
  • MIRR Formula:
    MIRR=(FVpositivePVnegative)1/nโˆ’1\text{MIRR} = \left(\frac{FV_{\text{positive}}}{PV_{\text{negative}}}\right)^{1/n} - 1
    Positive cash flows are compounded forward at the reinvestment rate; negative flows are discounted back at the financing rate. This yields a single, unambiguous answer.
  • NPV at Hurdle Rate:
    The calculator also evaluates NPV using your hurdle rate as the discount rate. A positive NPV confirms the investment exceeds your minimum return threshold; a negative NPV means it falls short.
  • Worked Example:
    Invest $100,000 (CF0 = โˆ’100,000) and receive $30,000 per year for 5 years. IRR โ‰ˆ 15.2%, the rate at which the present value of those five inflows equals $100,000.

How to Use This Calculator

Enter your initial investment as a negative cash flow in Year 0, then add annual cash flows for each subsequent year including any interim distributions and the final exit value. Set your hurdle rate (minimum acceptable return) and configure MIRR rates for a more conservative analysis. The calculator returns IRR, MIRR, NPV, hurdle rate spread, and a sensitivity analysis showing downside risk.
  • Initial Investment (Year 0):
    Enter the upfront cost as a negative number. This is your cash outflow at the start of the investment.
  • Annual Cash Flows:
    Enter expected cash flow for each year. Use positive numbers for inflows (distributions, revenue) and negative numbers for additional investments. Add or remove years as needed.
  • Hurdle Rate:
    Your minimum acceptable return. The calculator compares IRR against this benchmark and shows the spread. Common benchmarks: risk-free rate plus a risk premium, or your weighted average cost of capital (WACC).
  • MIRR Rates:
    Enter a financing rate (cost of capital for outflows) and a reinvestment rate (realistic return on positive cash flows). MIRR eliminates the unrealistic reinvestment assumption of standard IRR.

Understanding Internal Rate of Return (IRR)

What is IRR?

IRR is the annualized discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. It represents the true annual growth rate of an investment, accounting for the timing of all cash inflows and outflows.
  • Formula:
    Find r such that
    0=โˆ‘t=0nCFt(1+r)t0 = \sum_{t=0}^{n} \frac{CF_t}{(1+r)^t}
    where CF_t is cash flow at time t
  • Calculation Method:
    Uses Newton-Raphson iterative method to solve for the discount rate numerically
  • Key Difference from ROI:
    IRR accounts for timing, a dollar today is worth more than a dollar in 5 years
  • Use Cases:
    Private equity, venture capital, real estate flips, project finance, and any investment with multiple cash flows over time

Why IRR Matters for Investment Decisions

IRR provides a single percentage that allows you to compare investments of different sizes and durations. It answers: "What is the true annual growth rate of this complex investment?"
  • Standardization:
    Allows comparison of investments with different cash flow patterns and time horizons
  • Time Value of Money:
    Properly discounts future cash flows, recognizing that money today is worth more than money tomorrow
  • Decision Rule:
    If IRR > Hurdle Rate, the investment is value accretive. If IRR < Hurdle Rate, it's sub-optimal.
  • Industry Standard:
    IRR is the primary metric used by private equity firms, VCs, and real estate investors for deal evaluation

IRR vs. MIRR: The Reinvestment Assumption Problem

The IRR Reinvestment Assumption

IRR assumes that all positive cash flows are reinvested at the IRR itself. This is often unrealistic, if you have a 20% IRR deal, you probably can't reinvest interim cash flows at 20%.
  • The Problem:
    IRR can be "optimistic" because it assumes reinvestment at the same high rate
  • Real-World Reality:
    Positive cash flows are typically reinvested at a lower, more realistic rate (e.g., 5% in a savings account or index fund)
  • Impact:
    This makes IRR appear higher than the actual return you'll achieve
  • Example:
    A 15% IRR might only be a 12% MIRR when using a 5% reinvestment rate

MIRR is the professional's choice for 2026 investment analysis because it uses realistic reinvestment assumptions.

Modified IRR (MIRR) Calculation

MIRR uses two rates: a financing rate for negative cash flows (your cost of capital) and a reinvestment rate for positive cash flows (realistic return on reinvested cash).
  • Financing Rate:
    Applied to negative cash flows (outflows). Typically your hurdle rate or cost of capital
  • Reinvestment Rate:
    Applied to positive cash flows (inflows). A realistic rate like 5% for savings or 7% for index funds
  • Calculation:
    MIRR=(FVย ofย positiveย flowsPVย ofย negativeย flows)1/nโˆ’1\text{MIRR} = \left(\frac{\text{FV of positive flows}}{\text{PV of negative flows}}\right)^{1/n} - 1
  • Advantage:
    Provides a single, unambiguous answer even when multiple IRRs exist

Hurdle Rates and 2026 Investment Benchmarks

Understanding Hurdle Rates

A hurdle rate is your minimum acceptable return. It should reflect the risk-free rate plus a risk premium based on your investment's risk profile.
  • 2026 Risk-Free Rate:
    10-year Treasury yield: ~4.5%. This is the baseline for "risk-free" returns
  • Market Benchmark:
    S&P 500 historical average: ~8-10% (inflation-adjusted). This is a common hurdle rate for equity investments
  • Risk Premium:
    Add 2-5% for higher-risk investments (venture capital, real estate development, etc.)
  • Decision Rule:
    If IRR < Hurdle Rate, the investment is sub-optimal, you could do better with a passive index fund

The Hurdle Rate Spread

The "Hurdle Rate Spread" shows how much your IRR exceeds (or falls short of) your benchmark. This quickly tells you if the deal is worth pursuing.
  • Positive Spread:
    IRR > Hurdle Rate = "Value Accretive." The investment creates value above your minimum threshold
  • Negative Spread:
    IRR < Hurdle Rate = "Sub-Optimal Allocation." Consider alternatives like index funds
  • Large Positive Spread:
    IRR > 20% = "High-Efficiency Venture." Exceptional returns, but verify assumptions
  • Use Case:
    Quickly screen deals: if spread is negative, the deal likely isn't worth your time

Cash Flow Timing and Exit Velocity

Why Timing Matters More Than Total Profit

IRR is highly sensitive to the timing of cash flows. A dollar received today is worth significantly more than a dollar received in Year 5 due to the time value of money.
  • Example:
    Receiving $150K in Year 4 vs. Year 5 can increase IRR by 2-3 percentage points, even with the same total profit
  • Real Estate Flips:
    Faster flips (6 months vs. 12 months) dramatically boost IRR, even if total profit is slightly lower
  • Venture Capital:
    Earlier exits (Year 3 vs. Year 5) significantly improve IRR, making "exit velocity" a key metric
  • Strategy:
    Optimize for IRR, not just total return. Faster cash flow realization creates more value

Sensitivity Analysis and Risk Assessment

The calculator shows how IRR changes if your final exit value is 10% lower than expected. This helps you understand the risk of the investment.
  • Purpose:
    Tests the sensitivity of IRR to exit assumptions, which are often uncertain
  • Interpretation:
    If a 10% reduction causes IRR to drop below your hurdle rate, the deal is sensitive to exit value
  • Risk Management:
    Use sensitivity analysis to stress-test your assumptions and understand downside scenarios
  • Decision Making:
    If IRR is barely above hurdle rate and highly sensitive, consider the deal risky

IRR Calculator FAQ

What is IRR and how is it different from ROI?

IRR (Internal Rate of Return) is the annualized discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. Unlike ROI, which is a simple percentage, IRR accounts for the timing of cash flows, a dollar received today is worth more than a dollar received in 5 years. IRR is the standard metric for evaluating investments with multiple cash flows over time, especially in private equity, venture capital, and real estate.

Why does my investment have multiple IRRs?

Multiple IRRs can occur when cash flows change signs more than once (e.g., initial investment โ†’ positive returns โ†’ additional investment โ†’ final exit). This creates multiple discount rates where NPV equals zero. The calculator warns you if this is possible. In such cases, MIRR (Modified IRR) is more reliable because it assumes a single financing rate and reinvestment rate, eliminating the ambiguity.

What is MIRR and why is it better than IRR?

MIRR (Modified IRR) addresses IRR's unrealistic assumption that positive cash flows are reinvested at the IRR itself. MIRR uses a financing rate (your cost of capital) for negative flows and a reinvestment rate (realistic return on reinvested cash) for positive flows. This makes MIRR more conservative and realistic for 2026 investment analysis. MIRR is the professional's choice when evaluating deals with irregular cash flows.

What is a "Hurdle Rate" and why does it matter?

A Hurdle Rate is your minimum acceptable return. In 2026, this might be the S&P 500 yield (~8-10%) or the 10-year Treasury rate (~4.5%) plus a risk premium. If your IRR exceeds the hurdle rate, the investment is "value accretive." If it's below, it's "sub-optimal allocation", you could do better with a passive index fund. The calculator shows the "Hurdle Rate Spread" to quickly assess whether the deal beats your benchmark.

How does the timing of cash flows affect IRR?

Timing is critical for IRR. A dollar received in Year 1 is worth significantly more than a dollar received in Year 5 due to the time value of money. For example, receiving a $100,000 exit in Year 4 vs. Year 5 can increase IRR by 2-3 percentage points, even with the same total profit. This is why "exit velocity" matters, faster flips in real estate or earlier exits in venture capital dramatically boost IRR.

What does a negative IRR mean?

A negative IRR means the investment loses money even when accounting for the time value of money. This is labeled as "Capital Eroder" in the calculator. A negative IRR indicates that the present value of outflows exceeds the present value of inflows, making it a poor investment. You should avoid deals with negative IRRs unless there are strategic non-financial benefits.

How does the sensitivity analysis work?

The Sensitivity Analysis shows how IRR changes if your final exit value is 10% lower than expected. This helps you understand the risk of the investment. If a 10% reduction in exit value causes IRR to drop below your hurdle rate, the deal is sensitive to exit assumptions. This is particularly important for real estate flips and venture capital exits where final values are uncertain.

Financial Estimation Note

General Projections: Results are mathematical estimates based on the rates and formulas currently loaded for this tool, including year-specific tax data where noted. They are intended for high-level planning only.

No Advice Provided: This site does not provide financial, tax, or legal advice. Using this tool does not create a client-advisor relationship with CalcRegistry.

Confirm Numbers: Financial laws change frequently. Please verify all results with a qualified professional (CPA, Financial Planner, or Lawyer) before making significant financial decisions.

ยฉ 2026 CalcRegistry Reference Last Formula Sync: May 2026Free Online Utility Tools