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.
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 toolInternal 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
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.
Related tools
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.