Free Financial Tool

    IRR Calculator with MIRR & Hurdle Rate Comparison

    Calculate Internal Rate of Return (IRR) and Modified IRR (MIRR) for your investments. Compare against your hurdle rate and make data-driven investment decisions.

    By Valuefy TeamCFA, Finance AnalystsLast Updated: January 20266 min read

    Try an example:

    Investment Details
    Enter your initial investment and expected cash flows
    PeriodCash Flow

    Use positive values for inflows (returns) and negative for additional outflows.

    Rate Assumptions
    Configure hurdle rate and MIRR assumptions
    Your IRR Results

    Enter your investment details and cash flows to see your IRR calculation.

    What Is Internal Rate of Return and Why Does It Matter?

    Internal Rate of Return (IRR) is the discount rate that makes the Net Present Value (NPV) of all cash flows from an investment equal to zero. In simpler terms, IRR represents the annualized rate of return an investment is expected to generate. According to the CFA Institute, IRR is one of the most widely used metrics in capital budgeting because it provides a single percentage that can be directly compared against a firm's cost of capital or hurdle rate.

    The power of IRR lies in its consideration of the time value of money. Unlike simple ROI calculations, IRR accounts for when cash flows occur, not just their total amounts. An investment that returns money sooner will have a higher IRR than one with the same total return but delayed cash flows. This makes IRR particularly valuable for comparing projects with different timelines and cash flow patterns. Per Investopedia, the IRR rule states that if a project's IRR exceeds the required rate of return (hurdle rate), the project should be accepted.

    However, IRR has important limitations that sophisticated investors understand. The metric assumes that all intermediate cash flows can be reinvested at the IRR itself, which may be unrealistic for high-return projects. For comprehensive investment analysis, combine IRR with Net Present Value (NPV) for absolute dollar returns and Return on Investment (ROI) for simple percentage comparisons. Together, these metrics provide a complete picture of investment performance.

    How Do You Calculate IRR Step by Step?

    NPV = 0 = -Initial Investment + Sum of [Cash Flow(t) / (1 + IRR)^t]

    The IRR is the rate that makes this equation true. Since there's no closed-form solution, iterative numerical methods are used.

    The Iterative Method

    Our calculator uses the Newton-Raphson method with a bisection fallback for reliability:

    Step 1: Initial Guess

    Start with an initial estimate (typically 10%). The algorithm will refine this through successive iterations.

    Step 2: Calculate NPV

    Compute the NPV using the current guess for IRR. If NPV is positive, the true IRR is higher; if negative, the true IRR is lower.

    Step 3: Refine the Estimate

    Use Newton-Raphson to calculate a better estimate based on the NPV and its derivative. The formula adjusts the rate proportionally to how far NPV is from zero.

    Step 4: Convergence

    Repeat until NPV is sufficiently close to zero (within a small tolerance like 0.0001). The final rate is the IRR. If Newton-Raphson fails, bisection method provides a fallback.

    MIRR Formula

    MIRR = [(FV of positive flows at reinvestment rate) / (PV of negative flows at finance rate)]^(1/n) - 1

    MIRR separates the financing rate (for negative cash flows) from the reinvestment rate (for positive cash flows), providing a more realistic return estimate. The finance rate typically reflects your cost of borrowing, while the reinvestment rate reflects achievable returns on intermediate cash flows.

    IRR vs. NPV vs. ROI: Which Metric Should You Use?

    Each metric answers a different question about investment performance. Understanding when to use each helps make better capital allocation decisions.

    IRR (Internal Rate of Return)

    • Annualized percentage return
    • Accounts for cash flow timing
    • Compare against hurdle rate
    • Assumes reinvestment at IRR

    NPV (Net Present Value)

    • Absolute dollar value created
    • Uses specified discount rate
    • Shows wealth creation magnitude
    • Calculate NPV

    ROI (Return on Investment)

    • Simple total return percentage
    • Easy to calculate and understand
    • Ignores time value of money
    • Calculate ROI

    Payback Period

    • Time to recover investment
    • Simple risk assessment tool
    • Ignores returns after payback
    • Calculate Payback

    When to Use Each Metric

    Use IRR when comparing projects with different scales and wanting a percentage return that accounts for timing. IRR is ideal for ranking investment opportunities against your weighted average cost of capital.

    Use NPV when making accept/reject decisions on individual projects and wanting to know absolute dollar value created. NPV is the gold standard for capital budgeting decisions.

    Use ROI for quick, simple comparisons when timing differences are minimal. ROI is best for marketing campaigns and short-term investments.

    What Does IRR Look Like in Real Investment Scenarios?

    Private Equity Investment

    A private equity fund invests $10 million in a portfolio company. Over 5 years, they implement operational improvements and receive the following cash flows: Year 1-2: $0 (reinvesting), Year 3: $2M dividend, Year 4: $3M dividend, Year 5: $18M exit.

    Initial Investment: -$10,000,000
    Year 1: $0 | Year 2: $0 | Year 3: $2,000,000
    Year 4: $3,000,000 | Year 5: $18,000,000
    IRR = 22.8%

    The 22.8% IRR exceeds the typical PE hurdle rate of 15-20%, making this a successful investment. The backend-loaded cash flows are typical for PE deals where value creation takes time.

    Real Estate Development

    A developer purchases land for $2M and invests $5M in construction over 2 years. In Year 3, they begin selling units, generating $3M. Year 4 generates $6M in sales, and the remaining units sell in Year 5 for $4M.

    Year 0: -$2,000,000 (land)
    Year 1: -$3,000,000 (construction)
    Year 2: -$2,000,000 (construction)
    Year 3: $3,000,000 | Year 4: $6,000,000 | Year 5: $4,000,000
    IRR = 15.4%

    The 15.4% IRR reflects the capital intensity of development projects. With phased construction costs, MIRR might provide a more accurate picture if the developer's financing rate differs from potential reinvestment returns.

    Capital Equipment Project

    A manufacturing company invests $500,000 in new equipment that reduces production costs. The annual savings are $150,000 for 5 years, after which the equipment has a $50,000 salvage value.

    Initial Investment: -$500,000
    Years 1-4: $150,000 each
    Year 5: $200,000 (savings + salvage)
    IRR = 18.0%

    The 18% IRR well exceeds a typical corporate WACC of 8-12%, making this a value-creating project. The steady annual cash flows make IRR reliable here, but net present value would show the absolute dollar benefit to shareholders.

    What Are the Limitations of IRR Analysis?

    While IRR is a powerful investment analysis tool, understanding its limitations helps avoid common decision-making pitfalls.

    Reinvestment Rate Assumption

    IRR assumes all intermediate cash flows can be reinvested at the IRR itself. For a project with 30% IRR, this is often unrealistic. MIRR addresses this by using a specified reinvestment rate that reflects actual market opportunities.

    Multiple IRRs Problem

    Non-conventional cash flows (multiple sign changes) can produce multiple mathematically valid IRRs or no solution at all. If you invest, receive returns, then invest more, the IRR equation may have multiple roots, making interpretation difficult.

    Scale Ignorance

    A $1,000 investment with 50% IRR creates less wealth than a $1,000,000 investment with 20% IRR. IRR doesn't account for investment size. Always consider NPV alongside IRR to understand absolute value creation.

    Mutually Exclusive Projects

    When choosing between mutually exclusive projects of different scales or durations, the project with higher IRR isn't always the best choice. A lower-IRR project might create more shareholder value in absolute terms.

    Timing Sensitivity

    IRR is highly sensitive to the timing of cash flows. Small changes in when cash is received can significantly impact the calculated rate. Ensure cash flow timing estimates are realistic and include sensitivity analysis for important decisions.

    Key Takeaways

    For more guidance, visit the Real Estate tools hub and the Valuefy blog.

    Pair this tool with the Dividend Yield Calculator and the DSCR Calculator to cross-check inputs. For strategic context, read our 12-month exit checklist and explore the Real Estate & Investment tools hub.

    IRR is the discount rate that makes NPV equal to zero, representing the annualized return of an investment while accounting for the time value of money.

    Accept investments when IRR exceeds your hurdle rate (cost of capital plus risk premium). The hurdle rate should reflect both your financing costs and required risk compensation.

    Use MIRR for non-conventional cash flows or when you want more realistic reinvestment assumptions. MIRR typically produces lower but more achievable return estimates.

    Combine IRR with NPV and ROI for comprehensive analysis. IRR shows percentage return, NPV shows absolute value creation, and ROI provides simple total return comparison.

    Target IRR benchmarks vary by investment type: 25%+ for venture capital, 15-25% for private equity, 12-20% for real estate development, and 10-15% for corporate capital projects.

    Frequently Asked Questions

    Considering selling your business?

    Get a professional valuation of your company in minutes. Our AI-powered analysis provides DCF valuation, market comparables, and actionable insights.