Internal Rate of ReturnIRR

The internal rate of return is the discount rate at which the present value of an investment’s cash flows equals zero. It is a single annual return figure for investments with irregular cash flows, such as private funds or projects.

Two investments both turn $1,000 into $1,100 of cash — yet one is clearly better because you get your money back sooner. The internal rate of return captures that difference in a single annual percentage.

Category
Accounting, Tax and Operations
Reading time
4 min
Also called
Discounted cash flow return
Updated

IRR in plain words

HM Treasury defines IRR as the discount rate that makes the net present value of the cash outflows and inflows zero.1

Intuitively, it is the constant interest rate your money would have to earn to produce the same cash inflows.1

The SEC staff describes a private fund's IRR the same way: the rate that sets the NPV of all its cash flows to zero.2

How to find an IRR, step by step

  1. List cash flows

    Write outflows as negative and inflows as positive, by date.

  2. Check the shape

    IRR suits outflows first, then inflows.1

  3. Guess a rate

    Pick a trial discount rate.

  4. Discount and sum

    Compute NPV at that rate; the target is zero.1

  5. Adjust and repeat

    Raise the rate if NPV is positive, lower it if negative; a spreadsheet's IRR function does this.

  6. Cross-check with NPV

    IRR is not a reliable substitute for NPV.1

Worked examples

Example 1 — Even cash flows

IRR ≈ 13.07%

A hypothetical $1,000 investment pays $600 at the end of years 1 and 2.

Example 1 — Even cash flows — calculation
Try 13.07%600 ÷ 1.1307 = 530.66; 600 ÷ 1.1307² = 469.34
NPV−1,000 + 530.66 + 469.34 = 0
IRR≈ 13.07%

That rate returns an NPV of zero, which is the definition of IRR.1

Example 2 — Timing matters

Earlier cash ⇒ higher IRR

Hypothetical A pays 700 then 400; B pays 400 then 700, each on $1,000.

Example 2 — Timing matters — calculation
A: IRR≈ 7.28% (652.47 + 347.53 = 1,000)
B: IRR≈ 6.02% (377.28 + 622.72 = 1,000)
Total cashBoth 1,100

The timing of cash flows has a big effect on the IRR.1

Example 3 — Alternating flows

Use NPV instead

A hypothetical project's cash flows go −, +, −, + over four years.

Example 3 — Alternating flows — calculation
Sign changes3
Possible IRRsMore than one

When positive and negative cash flows alternate, the IRR is not uniquely determinate.1

IRR vs NPV

AspectIRRNPV
OutputA percentageA money amount
Needs a discount rateNo — it solves for oneYes
ScaleIgnores sizeReflects size
Alternating flowsCan give several answersAlways one answer

Where IRR is used

  • Private equity

    Funds with unpredictable cash flows.

  • Projects

    Comparing capital projects.

  • Your own account

    Measuring a return that includes your deposits and withdrawals.

  • Bonds

    Yield to Maturity is an IRR on a bond's cash flows.

Advantages and disadvantages

Advantages

  • One annual figure for irregular cash flows.
  • Reflects the timing of money in and out.
  • No discount rate is needed upfront.
  • Works well for private equity-style flows.

Disadvantages

  • Highly sensitive to timing.
  • Multiple answers with alternating flows.
  • Ignores the size of the investment.
  • Not a reliable replacement for NPV.

Going deeper

Read as far as you need. Each level builds on the one before it.

The break-even discount rate

Beginner

IRR is the rate that brings NPV to zero.1

Where it fits

Intermediate

The IRR method works better for investments with unpredictable cash flows such as private equity.3

Pitfalls

Advanced

When cash flows switch sign more than once, IRR may have more than one answer, so it is not a dependable substitute for NPV.1 The method has known drawbacks.3

Common mistakes

  1. Ranking by IRR alone

    A small project with a high IRR can create less value.

  2. Ignoring timing

    Early distributions inflate IRR.

  3. Mixing gross and net

    Compare IRRs before and after fees over the same periods.

  4. Trusting one answer

    Check sign changes in the cash flows.

Check your understanding

Test yourself before moving on. Each answer comes with an explanation.

Q1You invest $1,000 and get $1,210 after 2 years. What is the IRR?
Q2What happens to IRR if the same cash comes back earlier?

Key points to remember

  1. IRR is the discount rate that sets NPV to zero.
  2. It is one annual figure for irregular flows.
  3. Timing heavily affects it.
  4. Alternating flows can break it.
  5. Pair it with NPV.

Frequently asked questions

Is a higher IRR always better?

Not always; size, risk and duration matter too.

Can I calculate IRR in a spreadsheet?

Yes — IRR or XIRR functions do it from dated cash flows.

Is IRR the same as annual return?

Only when there is a single deposit and no further flows.

Further learning

Sources

This article is written in our own words. The sources below support the specific facts, rules and figures marked with a number in the text. Links open the original publisher’s page.

  1. GOV.UK (HM Treasury). Guidance note: the use of internal rates of return in PFI projects (opens in a new tab) Checked .
  2. U.S. Securities and Exchange Commission. Marketing Compliance – Frequently Asked Questions (opens in a new tab) Checked .
  3. CFA Institute. Using Brinson Attribution to Explain the Differences between Time-Weighted (TWR) and Money-Weighted (IRR) Returns (Digest Summary) (opens in a new tab) Checked .

Educational content, not financial advice. Examples use hypothetical prices and simplified costs; actual fees, margin rules and regulations vary by broker, market and country. We are not affiliated with any publisher linked above. Last reviewed . Report an error or request a source credit.