IRR Calculator
Calculate Internal Rate of Return to evaluate investment profitability
IRR vs NPV Comparison
IRR (Internal Rate of Return)
- • Expressed as a percentage
- • Rate where NPV equals zero
- • Easy to compare across projects
- • May have multiple solutions
NPV (Net Present Value)
- • Expressed in dollars
- • Uses your required return rate
- • Shows actual value created
- • Always has a unique solution
How to Use This IRR Calculator
- Enter your initial investment amount (the upfront cost of the project or asset)
- Add expected cash flows for each year (positive numbers for returns, negative for additional costs)
- Use the '+ Add Year' button to extend the projection beyond 5 years if needed
- Enter your required rate of return (hurdle rate) for comparison
- Click 'Calculate IRR' to see your internal rate of return and NPV at your hurdle rate
Example: Invest $100,000 in equipment that generates $30,000/year for 5 years. IRR = 15.2%. If your hurdle rate is 10%, this investment exceeds your minimum requirement by 5.2 percentage points.
Tip: IRR assumes reinvestment at the IRR rate. For more conservative analysis, also calculate NPV using a realistic reinvestment rate.
Why Use a IRR Calculator?
IRR provides a single percentage that represents an investment's return, making it easy to compare opportunities of different sizes and durations.
- Evaluate whether a business expansion project meets your required return threshold
- Compare returns across multiple investment opportunities with different cash flow patterns
- Determine if buying equipment vs. leasing provides better returns
- Assess real estate investment opportunities against alternative investments
- Analyze the true return of acquiring a business based on projected cash flows
- Evaluate whether to accept a project when capital is limited
Understanding Your Results
Compare your IRR against your hurdle rate (cost of capital or minimum acceptable return) to make investment decisions.
| Result | Meaning | Action |
|---|---|---|
| IRR < Required Return | Investment underperforms | Reject the investment unless strategic value outweighs financial return. |
| IRR = Required Return | Break-even scenario | Investment barely meets minimums. Consider risk before proceeding. |
| IRR 1-5% above Required Return | Acceptable investment | Meets criteria but limited margin for error. Assess risks carefully. |
| IRR 5%+ above Required Return | Strong investment | Attractive opportunity. Consider scaling up if possible. |
Meaning: Investment underperforms
Action: Reject the investment unless strategic value outweighs financial return.
Meaning: Break-even scenario
Action: Investment barely meets minimums. Consider risk before proceeding.
Meaning: Acceptable investment
Action: Meets criteria but limited margin for error. Assess risks carefully.
Meaning: Strong investment
Action: Attractive opportunity. Consider scaling up if possible.
Note: Always use NPV alongside IRR. A smaller project with higher IRR might add less total value than a larger project with lower IRR.
About IRR Calculator
Formula
0 = CF₀ + CF₁/(1+IRR) + CF₂/(1+IRR)² + ... + CFₙ/(1+IRR)ⁿ Solve for the rate (IRR) that makes the sum of discounted cash flows equal zero. This requires iterative methods like Newton-Raphson since there's no closed-form solution.
Current Standards: Typical corporate hurdle rates range from 8-15% depending on industry risk. Real estate investors often target 15-25%. Venture capital expects 25-35%+ due to high failure rates.
Frequently Asked Questions
What's the difference between IRR and ROI?
ROI (Return on Investment) is simple: (Gain - Cost) / Cost. It ignores timing. IRR accounts for when cash flows occur, recognizing that $1,000 received today is worth more than $1,000 in five years. For short-term investments, they're similar. For multi-year projects, IRR provides a more accurate picture.
When might IRR give misleading results?
IRR can be problematic when: 1) Cash flows alternate between positive and negative (may have multiple IRRs), 2) Comparing projects of very different sizes (a 50% IRR on $1,000 creates less value than 15% on $1 million), 3) When the IRR is very high (reinvestment assumption becomes unrealistic).
What is Modified IRR (MIRR) and when should I use it?
MIRR assumes positive cash flows are reinvested at your cost of capital rather than the IRR itself. This is more realistic, especially for high-IRR projects. Use MIRR when the calculated IRR seems unrealistically high or when comparing projects with very different return profiles.
How do I determine my hurdle rate?
Start with your weighted average cost of capital (WACC), typically 8-12% for established businesses. Add a risk premium for uncertainty: low-risk projects (+1-3%), medium-risk (+4-6%), high-risk (+7-10%+). Individual investors often use their expected stock market return (7-10%) as a baseline.
Should I always choose the investment with the highest IRR?
Not necessarily. IRR doesn't account for investment size. A project with 30% IRR returning $10,000 total creates less value than a 15% IRR project returning $100,000. When capital is limited, rank by IRR. When capital is available, maximize total NPV across all acceptable projects.