Internal Rate of Return Explained with Worked Examples

The internal rate of return is the discount rate that makes the net present value zero: . A project is attractive if its IRR exceeds the required rate of return.

Write 2x or 2*x to multiply, ^ for powers, and ; between simultaneous equations. You can also type factor, expand, derivative of, integrate … from a to b, limit … as x->0 or 15% of 80.

Try an example

Before you start

This page is easier if you are comfortable with:

What Internal rate of return means

Cash flows : we need , i.e. , which gives IRR (check: ). For now and in a year, IRR . For : , so , IRR .

The equation is a polynomial in , generally solved numerically (bisection, the secant method, Newton–Raphson). Projects with alternating signs of cash flows can have several IRRs, or none, so NPV is the safer criterion (net present value). For a loan the IRR of the borrower's flows is the true cost of borrowing (loan repayment).

For two cash flows the IRR is (the effective annual rate type growth rate); the annuity case needs the annuity factor. The same root-finding idea gives the yield of a bond (bond price).

What is it used for?

The IRR is the discount rate at which an investment exactly breaks even.

How to use internal rate of return

  1. Write the NPV as a function of .
  2. Find with NPV (numerically if needed).
  3. Compare with the required rate.
  4. Check for multiple sign changes.

Graph

NPV of −1000, 500, 500, 500 crosses zero at the IRR ≈ 23.4%IRR = 23.38%00.050.10.150.20.250.30.350.40.450.5-300-200-1000100200300400500NPV of −1000, 500, 500, 500 crosses zero at the IRR ≈ 23.4%rate rNPVNPV(r)Graph with x from 0 to 0.5 and y from -300 to 520. Shows the curve NPV(r); point IRR = 23.38% at (0.2338, 0).

The root of the curve is the internal rate of return.

Worked examples

These examples are worked by hand, step by step, so you can compare your own working.

Example 1: one-year project

Find the IRR of −100 now and 110 in a year.

Worked example
Answer
10%10\%
  1. Formula

Example 2: two-year project

Find the IRR of −1000, 0, 1210.

Worked example
Answer
10%10\%
  1. (1+r)²

Example 3: level payments

Check that IRR ≈ 23.38% gives NPV ≈ 0 for −1000, 500, 500, 500.

Worked example
Answer
≈1000\approx1000
  1. Present value of payments

Special cases

A few situations come up again and again. Knowing them saves time and helps you spot answers that cannot be right.

−100 now, 110 in a year

IRR = 10%

110/(1 + r) = 100.

−1000, 600, 600

IRR ≈ 13.07%

NPV = 0 at r = 0.1307.

NPV at 10%

41.32 > 0

IRR above 10%.

NPV at 15%

−24.57 < 0

IRR below 15%.

Word problems

The internal rate of return is the discount rate r at which NPV = 0. Accept a project if IRR exceeds the required return. It is usually found by interpolation or root-finding.

Simple IRR

−100 now, +110 in a year. Find the IRR.

  1. 110/(1 + r) = 100
  2. r0.1
  3. Check: ✓10%.

Bracketing

For −1000, 600, 600 find NPV at 10% and 15%.

  1. 10%41.32
  2. 15%−24.57
  3. Check: sign change, so IRR between 10% and 15% ✓41.32 and −24.57.

Interpolation Higher

Linearly interpolate the IRR between 10% and 15%.

  1. 10 + 5 × 41.32/(41.32 + 2.12)
  2. Check: ≈ 13.14% (true 13.07%) ✓≈ 13.1%.

Verification Higher

Check NPV at r = 0.1307.

  1. 600/1.1307 + 600/1.1307²
  2. Check: ≈ 1000 ✓≈ 1000.

Common mistakes

IRR = average return

mean of returns ✗

solve NPV = 0 ✓

IRR accounts for timing.

Using IRR with sign changes more than once

one IRR ✗

may be several or none ✓

Multiple IRRs possible.

Comparing IRR to NPV directly

highest IRR always best ✗

size matters; use NPV ✓

Scale differs.

Linear interpolation exact

interpolation gives the IRR ✗

it is an estimate ✓

NPV is convex in r.

Exam tips

  1. NPV(IRR) = 0.
  2. Bracket then refine.
  3. IRR > hurdle: accept.
  4. Check sign changes.
  5. Use a calculator solver.

Practice questions

Try each one on paper, then open the answer. Use the solver above to see the full working.

1. IRR: −200 now, 220 in a year (%) Foundation

10

2. IRR: −50 now, 60 in a year (%) Foundation

20

3. NPV at 10% for −1000, 600, 600 Foundation

41.32

4. NPV at 15% for −1000, 600, 600 Higher

-24.57

5. NPV at 13% for −1000, 600, 600 Higher

0.86

6. NPV at 14% for −1000, 600, 600 Higher

-12

Practice generator

Unlimited fresh questions with instant marking. Choose a level, work it out on paper, then type your answer.

Solve: …

Key terms

Internal rate of return
r with NPV = 0.
Hurdle rate
Required return.
Bracket
Interval with a sign change.
Interpolation
Estimate between two values.
Cash flow
Money in or out.
Multiple IRR
More than one root.

Frequently asked questions

What is the IRR?

The rate making NPV zero.

How do I find it?

Solve NPV(r) = 0 numerically.

When do I accept?

When IRR exceeds the required return.

Can there be several IRRs?

Yes, if flows change sign repeatedly.

Which page covers NPV?

net present value.

Which page covers the secant method?

secant method.

More in Finance and actuarial maths and the formula sheets.