Calculator explainer

    IRR Calculator Explained: Internal Rate of Return Formula & Example

    IRR is the annualized return implied by a project's cash flows. Compare IRR to your hurdle rate: if IRR exceeds the hurdle, the project typically clears your return requirement (but always check NPV for scale and timing).

    Formula in plain language

    IRR is the rate r that makes the sum of discounted cash flows equal to zero — the same r you would solve iteratively in the NPV formula when NPV = 0.

    0 = Σ [ CFₜ ÷ (1 + IRR)ᵗ ]

    Worked example

    Store expansion cash flows

    • Year 0: −$120,000 investment.
    • Years 1–4: $35,000, $40,000, $45,000, $50,000.
    • Solver finds the rate where NPV = 0 (≈ 14.56%).
    • Sanity check: at a 17.4% discount rate, NPV ≈ −$7,034, which confirms 17.4% is above the true IRR.

    IRR ≈ 14.56%. At a 15% hurdle, NPV is negative, so the expansion does not clear that return threshold; verify with NPV at your actual cost of capital.

    Try the calculator

    Open full tool

    Internal Rate of Return (IRR) Calculator

    Templates

    Save and load common input configurations

    No templates saved yet

    Save your current inputs as a template to reuse later

    IRR Calculator

    Calculate the Internal Rate of Return (IRR) for a series of cash flows

    IRR Results

    Internal Rate of Return
    0.0%

    Interpretation:

    The Internal Rate of Return (IRR) of 0.0% represents the annualized effective compounded return rate that makes the net present value of all cash flows equal to zero.

    • Decision rule: If the IRR is greater than the required rate of return (hurdle rate), the investment may be considered profitable.
    • Comparison: The higher the IRR, the more desirable the investment is likely to be relative to alternatives with lower IRRs.
    • Limitations: IRR assumes reinvestment of interim cash flows at the same rate, which may not be realistic. Consider using Modified IRR (MIRR) for a more accurate assessment.

    Need shareable exports for lenders?

    Pro saves scenarios and exports PDF and Excel built for bankers and buyers.

    MBACalc Pro from $19/mo

    Frequently asked questions

    What is a good IRR for a small business acquisition?

    Many searchers target 20%+ equity IRR after debt service, but acceptable IRR depends on risk, leverage, and hold period. Always pair IRR with payback and NPV.

    Why can IRR be misleading?

    Multiple IRRs can exist with alternating cash flows. IRR also ignores project size — a small high-IRR project may create less value than a large moderate-IRR project.

    How is IRR different from ROI?

    ROI is a simple return on cost over one period. IRR annualizes irregular multi-year cash flows and accounts for timing.