Finance

IRR Calculator

Calculate the internal rate of return (IRR) for investments. Find the discount rate that makes the net present value of all cash flows equal to zero.

$
%
Cash flows by year
$
$
$
$
$
Internal rate of return (IRR)
19.71%
Initial investment
$100,000
Total cash flows
$175,000
Total return
$75,000
IRR
19.71%
Hurdle rate
10%
Multiple on investment
1.75x

IRR exceeds the hurdle rate — this investment meets return requirements.

NPV at different discount rates (IRR is where NPV = 0)

What is internal rate of return (IRR)?

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 other words, it's the annualized rate of return an investment is expected to generate over its lifetime. IRR is one of the most widely used metrics in capital budgeting and investment analysis.

The concept is powerful because it distills a complex series of cash flows into a single percentage that can be easily compared against a required rate of return or alternative investments. When evaluating whether to proceed with a project, you compare the IRR to your hurdle rate (minimum acceptable return).

The IRR formula

The IRR is found by solving this equation for the rate (r) that makes NPV equal zero:

0=C0+C1(1+r)1+C2(1+r)2++Cn(1+r)n0 = -C_0 + \frac{C_1}{(1+r)^1} + \frac{C_2}{(1+r)^2} + \ldots + \frac{C_n}{(1+r)^n}

Where:

  • C0C_0 = Initial investment (outflow)
  • CtC_t = Cash flow at time t
  • rr = Internal rate of return
  • nn = Number of periods

There's no algebraic solution for IRR — it must be calculated iteratively using numerical methods like Newton-Raphson or trial and error.

Example calculation

Consider a $100,000 investment with the following cash flows:

YearCash flow
0-$100,000
1$25,000
2$30,000
3$35,000
4$40,000
5$45,000

The IRR for this investment is approximately 16.8%. This means if you discount all cash flows at 16.8%, the NPV would be exactly zero.

How to interpret IRR

IRR vs hurdle rateInterpretationDecision
IRR > Hurdle rateExceeds minimum returnAccept project
IRR = Hurdle rateMeets minimum returnIndifferent
IRR < Hurdle rateBelow minimum returnReject project

The hurdle rate is typically the company's weighted average cost of capital (WACC) or the investor's required rate of return. For venture capital investments, hurdle rates of 20-30% are common due to the high risk involved.

IRR benchmarks by investment type

Investment typeTypical target IRR
Government bonds3-5%
Corporate bonds5-8%
Real estate10-15%
Private equity15-25%
Venture capital25-35%+
Early-stage startups40%+

IRR vs NPV: When to use each

Both metrics are valuable but serve different purposes:

Use NPV when:

  • Comparing mutually exclusive projects of different sizes
  • You want to know the absolute value created
  • Cash flows are non-conventional (multiple sign changes)

Use IRR when:

  • Comparing projects as a rate of return
  • Communicating with investors who think in percentages
  • You need a quick measure of investment efficiency

A common best practice is to use both metrics together. If they give conflicting signals, NPV is generally preferred.

Modified internal rate of return (MIRR)

Traditional IRR assumes interim cash flows are reinvested at the IRR itself, which may be unrealistic for high-return projects. MIRR addresses this by:

  1. Assuming positive cash flows are reinvested at a realistic rate (like WACC)
  2. Assuming negative cash flows are financed at a financing rate
MIRR=(FVpositivePVnegative)1/n1MIRR = \left(\frac{FV_{positive}}{PV_{negative}}\right)^{1/n} - 1

MIRR typically gives more conservative (lower) results than IRR and is considered more realistic.

Limitations of IRR

Multiple IRR problem

When cash flows change signs more than once (positive, then negative, then positive again), multiple mathematical solutions exist. For example, a project requiring additional investment partway through can have two or more valid IRRs.

Reinvestment assumption

IRR assumes all intermediate cash flows can be reinvested at the IRR rate. For a project with 40% IRR, this assumption may be unrealistic.

Scale ignorance

IRR doesn't account for project size. A 50% return on $10,000 is less valuable than a 20% return on $1,000,000 in absolute terms.

Timing differences

Two projects with identical IRRs but different cash flow timing may have very different NPVs, especially in varying interest rate environments.

Practical applications

Corporate investment decisions

Companies use IRR to evaluate:

  • Equipment purchases
  • Facility expansions
  • New product development
  • Acquisitions

Private equity and venture capital

IRR is the standard metric for measuring fund performance and individual deal returns.

Real estate investing

Property investors calculate IRR including purchase price, rental income, operating expenses, and eventual sale proceeds.

Project ranking

When capital is limited, IRR helps rank projects by their efficiency in generating returns.

Tips for using IRR effectively

  1. Always calculate NPV alongside IRR — IRR alone can be misleading
  2. Set realistic hurdle rates — Account for project-specific risks
  3. Consider MIRR for unusual cash flows — More realistic reinvestment assumptions
  4. Watch for multiple IRRs — Flag projects with unconventional cash flow patterns
  5. Compare like with like — IRR is most useful for comparing similar-sized projects
  6. Use sensitivity analysis — Test how IRR changes with different assumptions