IRR Calculator

Calculate Internal Rate of Return (IRR) for investment projects with multiple cash flows

Investment Details

Enter as positive number (will be treated as negative)

Year 1
Year 2
Year 3
Year 4
Year 5
Internal Rate of Return
25.75%
✓ Positive return

Investment Analysis

Total Cash In$200,000.00
Net Profit$100,000.00
NPV @ 10%$48,032.61
Payback Period3 years

IRR Interpretation

• IRR > 15%: Excellent investment

• IRR 10-15%: Good investment

• IRR 5-10%: Moderate investment

• IRR < 5%: Consider alternatives

Understanding Internal Rate of Return (IRR)

The Internal Rate of Return (IRR) is the discount rate that makes the net present value (NPV) of all cash flows equal to zero. It represents the annualized rate of return on an investment and is one of the most widely used metrics in capital budgeting and investment analysis.

The IRR Formula

0 = CF₀ + CF₁/(1+IRR)¹ + CF₂/(1+IRR)² + ... + CFₙ/(1+IRR)ⁿ

Where CF = Cash Flow, and IRR is the rate that makes this equation equal zero

IRR cannot be solved algebraically for most cases—it requires iterative calculation (trial and error) or numerical methods like Newton-Raphson. This calculator uses binary search to find the IRR efficiently.

IRR Decision Rule

Accept if: IRR > Hurdle Rate (Required Return)

Reject if: IRR < Hurdle Rate

Your hurdle rate is typically your cost of capital (WACC) or the return you could earn on alternative investments. If a project's IRR exceeds this rate, it creates value for shareholders.

IRR Benchmarks by Investment Type

Real Estate Investments

  • • Core properties: 6-9%
  • • Value-add: 12-18%
  • • Opportunistic: 18-25%+
  • • Development: 20-30%+

Private Equity/VC

  • • Buyout funds: 15-25%
  • • Growth equity: 20-30%
  • • Venture capital: 25-35%+
  • • Angel investing: 30-50%+

Corporate Projects

  • • Equipment replacement: 10-15%
  • • Expansion projects: 15-20%
  • • New product launch: 20-30%
  • • R&D investments: 25%+

Small Business

  • • Franchise: 15-25%
  • • Restaurant: 20-30%
  • • E-commerce: 25-40%
  • • Service business: 30-50%

IRR vs NPV: When to Use Each

ScenarioUse IRRUse NPV
Comparing similar-sized projects✓ Good✓ Good
Different project sizes✗ Misleading✓ Better
Mutually exclusive projects⚠ Caution✓ Preferred
Communicating to stakeholders✓ Intuitive⚠ Less intuitive

Step-by-Step IRR Example

Example: Equipment Purchase

Initial Investment: $100,000

Cash Flows: Year 1: $30,000 | Year 2: $35,000 | Year 3: $40,000 | Year 4: $45,000

Total Cash In: $150,000

Net Profit: $50,000

IRR = 17.8%

If your cost of capital is 10%, this project creates value (IRR 17.8% > 10% hurdle rate). The NPV at 10% would be approximately $19,000.

Limitations of IRR

1

Reinvestment Assumption

IRR assumes cash flows are reinvested at the IRR rate, which may be unrealistic for high IRRs.

2

Multiple IRRs

Projects with alternating positive/negative cash flows can have multiple IRRs, making interpretation difficult.

3

Scale Ignored

A $10,000 project with 50% IRR creates less value than a $1M project with 20% IRR.

4

Timing Differences

Comparing projects with different durations can be misleading without adjusting for time.

Modified IRR (MIRR)

MIRR addresses the reinvestment assumption by using a more realistic reinvestment rate (typically cost of capital). It provides a more conservative and often more accurate measure of project profitability. MIRR is calculated as:

MIRR = (FV of positive CFs / PV of negative CFs)^(1/n) - 1

Best Practice: Use Multiple Metrics

Don't rely on IRR alone. Use it alongside NPV, payback period, profitability index, and MIRR for comprehensive investment analysis. Each metric provides different insights into project viability.