Chapter 10

Chapter 10: IRR - What Rate of Return Does the Investment Generate?

Learning Objectives

By the end of this chapter, you should be able to:

explain what Internal Rate of Return (IRR) measures

understand the relationship between IRR and NPV

calculate IRR using Excel

interpret an IRR result

understand when IRR is useful

identify the limitations of IRR

recognise situations where IRR and NPV may conflict

use IRR appropriately when comparing investments

communicate an IRR result clearly in a case presentation

Why This Matters

In the previous chapter, we asked:

"How much value does this investment create?"

NPV answered that question.

Now we ask a different question:

"What rate of return does this investment generate?"

That is the purpose of Internal Rate of Return, or IRR.

IRR converts the financial performance of an investment into a percentage.

This makes it intuitive.

Instead of saying:

"This investment creates $2.4 million in NPV."

we can also say:

"This investment generates an estimated 18% internal rate of return."

That percentage can then be compared with the organization's required return, the cost of capital, or the returns available from other opportunities.

But IRR has some important limitations.

Understanding those limitations is what separates simply calculating IRR from using it well.

Discover Your Mad Skills Principle

IRR tells you the return. NPV tells you the value.

Both are useful.

But they answer different questions.

IRR:

What percentage return does this investment generate?

NPV:

How much value does this investment create?

Keep this distinction in mind throughout the chapter.

What Is IRR?

IRR stands for:

Internal Rate of Return

It is the discount rate that makes the NPV of an investment equal to zero.

In other words:

IRR is the rate of return at which the present value of the future cash flows exactly equals the initial investment.

This gives us a percentage measure of the investment's expected return.

If an investment has an IRR of:

18%

we can think of that as the investment's implied internal rate of return based on the projected cash flows.

The Relationship Between NPV and IRR

IRR is directly connected to NPV.

Remember:

NPV asks what value is created at a particular discount rate.

IRR asks:

"At what discount rate would NPV equal zero?"

This is an important relationship.

Imagine calculating NPV at different discount rates.

Discount Rate	NPV
5%	+$3.2M
10%	+$1.8M
15%	+$0.6M
18%	$0
20%	−$0.5M

The discount rate at which NPV becomes zero is approximately:

18%

Therefore:

IRR ≈ 18%

The Investment Decision Rule

For a conventional investment, a basic IRR rule is:

If IRR > required return → investment is financially attractive

If IRR < required return → investment is financially unattractive

For example:

IRR = 18%

Required return = 12%

The investment generates a return above the required return.

That generally supports proceeding.

Now consider:

IRR = 8%

Required return = 12%

The investment does not generate the return required by the organization.

That generally suggests rejecting the investment.

IRR and the Required Return

The required return is critical.

You cannot interpret IRR in isolation.

An IRR of 15% might look attractive.

But is it?

That depends.

If the organization's required return is:

15% looks attractive.

If the required return is:

20%

15% does not meet the organization's expectations.

Therefore, the important comparison is:

IRR vs. required return

not simply:

"Is the IRR a big number?"

A Simple Worked Example

Suppose a company invests:

$1,000,000

and expects to receive:

Year	Cash Flow
0	($1,000,000)
1	$400,000
2	$400,000
3	$400,000

The initial investment is negative because it represents money leaving the organization.

The future cash flows are positive because they represent expected returns.

IRR asks:

What discount rate makes the NPV of these cash flows equal to zero?

In this example, the IRR is approximately:

10.3%

That means the investment's implied internal rate of return is approximately 10.3%.

If the company's required return is 8%, the investment looks financially attractive.

If the required return is 12%, it does not.

Why IRR Is Appealing

IRR is popular because percentages are easy to understand.

Consider these two statements:

"The project generates an NPV of $1.8 million."

versus:

"The project generates an estimated 19% return."

Both are useful.

But the percentage can make comparisons intuitive.

For example:

Project A: 12% IRR

Project B: 19% IRR

At first glance, Project B appears more attractive.

But this is where we need to be careful.

IRR Does Not Tell the Whole Story

Imagine two projects.

Project A

Investment:

$1 million

IRR:

30%

NPV:

$200,000

Project B

Investment:

$10 million

IRR:

20%

NPV:

$3 million

Which project is better?

If you look only at IRR:

Project A wins.

But Project B creates substantially more value.

This illustrates one of the most important lessons in this chapter:

The highest percentage return does not necessarily create the most value.

This is why NPV remains extremely important.

IRR vs. NPV

Think of the two measures this way.

IRR

Measures:

Percentage return

Useful for:

communicating investment performance

comparing returns to a required return

quickly understanding the attractiveness of an investment

NPV

Measures:

Value created

Useful for:

evaluating value creation

comparing projects of different sizes

making capital allocation decisions

understanding the financial contribution of an investment

Neither should automatically replace the other.

They provide different information.

Coach's Lens

When teams tell me:

"This project has the highest IRR, so we're recommending it."

my next question is:

"What is the NPV?"

Then I ask:

"How large is the investment?"

This forces the team to distinguish between:

percentage return

and

value creation.

That distinction becomes especially important when comparing alternatives.

When IRR Is Useful

IRR is particularly useful when:

the case asks for a return percentage

you need to compare an investment's return with a required return

projects have similar scale and risk

you want another perspective alongside NPV

the investment has conventional cash flows

the timing of cash flows is important

IRR can be a very effective supporting metric.

It becomes less reliable when the cash-flow pattern becomes complicated.

Conventional Cash Flows

A conventional investment generally looks like this:

Initial investment → Future positive cash flows

For example:

−$5M → +$2M → +$2M → +$2M → +$2M

There is one initial cash outflow followed by positive cash inflows.

IRR generally behaves predictably in this situation.

But some investments have cash flows that change direction more than once.

For example:

−$5M → +$4M → +$3M → −$2M

This creates a more complicated situation.

There may be multiple IRRs.

That makes the metric much harder to interpret.

The Multiple IRR Problem

IRR calculations depend on the pattern of cash flows.

If cash flows change signs multiple times, there can potentially be more than one IRR.

This creates a major problem.

Which IRR should you use?

There may not be a simple answer.

In these circumstances, NPV is generally the more reliable decision measure.

This is one reason professional financial analysis does not simply say:

"Pick whichever project has the highest IRR."

Discover Your Mad Skills Principle

When IRR and NPV disagree, understand why before making the decision.

Don't blindly choose the percentage.

Ask:

Are the projects different sizes?

Do they have different timing?

Are the cash flows unusual?

Is the reinvestment assumption different?

Is there more than one IRR?

Does one project create substantially more absolute value?

The disagreement is information.

Use it to investigate the decision.

IRR in Excel

Excel provides two primary functions that are particularly useful for case work:

IRR

and

XIRR

For regularly spaced cash flows, you can use:

IRR

For cash flows occurring on specific dates, use:

XIRR

The basic logic is the same.

You provide:

the initial investment

the future cash flows

and, when using XIRR, the corresponding dates

Excel determines the rate that makes the NPV equal to zero.

The Initial Investment Must Be Included

This is another common case competition mistake.

Your cash-flow sequence should normally include the initial investment as a negative number.

For example:

Period	Cash Flow
0	($2,000,000)
1	$700,000
2	$800,000
3	$900,000

The negative initial investment is essential.

Without it, Excel is not evaluating the investment correctly.

IRR vs. XIRR

As with NPV and XNPV, timing matters.

IRR

Use when:

cash flows occur at regular intervals

periods are consistent

XIRR

Use when:

actual dates are provided

cash flows occur at irregular intervals

more precise timing matters

For example, if an investment occurs on January 1 and returns occur on March 15, November 1, and August 20 of different years, XIRR may provide a more appropriate calculation.

Why XIRR Can Produce a Different Result

Suppose you calculate:

IRR = 15.2%

and:

XIRR = 14.7%

That does not necessarily mean one calculation is wrong.

They are handling timing differently.

IRR assumes regular periods.

XIRR uses the actual dates.

When the dates are not evenly spaced, the results can differ.

The key is to use the method that matches the data provided.

Common Mistakes

Mistake 1 — Looking only at the IRR

A high IRR does not automatically mean the project creates the most value.

Always consider NPV.

Mistake 2 — Ignoring the required return

An IRR of 12% means little without knowing what return the organization requires.

Mistake 3 — Forgetting the initial investment

The initial investment must be included as a negative cash flow.

Mistake 4 — Using IRR for unusual cash flows without investigation

Multiple changes in cash-flow direction can produce multiple IRRs.

Mistake 5 — Using IRR to compare projects of very different sizes

Percentage return can hide the absolute amount of value being created.

Mistake 6 — Using IRR when actual dates matter

If the case provides irregular dates, consider XIRR.

Mistake 7 — Treating the result as guaranteed

IRR is based on projected cash flows.

Change the assumptions and the IRR changes.

IRR and Sensitivity Analysis

Just as with NPV, you should test your assumptions.

Suppose your base case produces:

IRR = 19%

That sounds strong.

But what happens if:

revenue is 10% lower?

costs are 10% higher?

implementation is delayed?

growth is slower?

customer adoption is weaker?

Your IRR might fall to:

12%

If the required return is:

10%

the project still works.

But the margin of safety has decreased.

This is important information for the decision.

The "Margin Above Hurdle" Idea

A useful way to think about IRR is the distance between:

IRR

and

Required Return

Suppose:

IRR = 18%

Required return = 12%

The investment has a:

6 percentage-point spread

above the hurdle.

Now consider:

IRR = 13%

Required return = 12%

The spread is only:

1 percentage point

Both projects technically pass the hurdle.

But the second project may have much less room for error.

This becomes particularly useful when discussing risk.

Deciphering Cases

When you see an investment opportunity, ask:

What is the investment?

How much cash must be committed?

What are the returns?

Where will the future cash flows come from?

What is the timing?

When will the organization receive those returns?

What is the IRR?

What percentage return does the investment generate?

What is the required return?

What hurdle does the investment need to clear?

What is the NPV?

How much value does the investment create?

How robust is the result?

What assumptions could cause IRR to fall below the hurdle?

This sequence turns IRR from a calculation into a decision tool.

A Case Competition Example

Imagine your team is evaluating a new technology platform.

Investment

$8 million

Expected IRR

21%

Required Return

12%

NPV

+$2.6 million

At first glance, this is attractive.

The investment:

generates a 21% return

exceeds the 12% required return

creates $2.6 million of value

But now test the assumptions.

Suppose a downside scenario produces:

IRR = 13%

NPV = +$0.3 million

The investment still passes the financial hurdle.

That is potentially a much more compelling story than simply presenting the 21% base-case IRR.

You can now tell the judges:

"Our base case generates a 21% IRR and $2.6 million in NPV. Under our downside scenario, returns fall to 13%, but the project remains above the company's 12% hurdle rate."

That demonstrates both confidence and realism.

Presenting IRR to Judges

Avoid putting a large percentage on a slide without context.

Instead, show:

IRR

21%

Required Return

12%

Spread

+9 pts

NPV

+$2.6M

Then explain what it means.

For example:

"The project generates a 21% return, nine percentage points above our required return, while creating $2.6 million in present-value terms."

That is much more informative than:

"Our IRR is 21%."

IRR Should Support the Recommendation

A common mistake is to treat financial metrics as the recommendation.

For example:

"Our recommendation is to invest because the IRR is 21%."

That is incomplete.

A stronger argument might be:

Now the financial analysis is connected to:

the problem

the strategy

the investment

the risk

the recommendation

That is what makes the analysis useful.

Mad Skills Drill

Take the same investment you used for the Chapter 9 NPV exercise.

Calculate:

1. IRR

What rate of return does the investment generate?

2. Required Return

What hurdle rate should the organization use?

3. Spread

How far above or below the hurdle is the IRR?

4. NPV

How much value does the investment create?

5. Sensitivity

What happens when your most important assumption changes?

Then answer this question:

Would you still recommend the investment if the downside scenario occurred?

If the answer is no, identify what would need to change.

A Judge-Friendly IRR Explanation

If a judge asks:

"Why is the IRR attractive?"

A strong answer might be:

"The project generates a 21% IRR compared with the company's 12% required return, giving us a nine-point margin above the hurdle. It also produces positive NPV, so we're not relying on the percentage return alone."

If the judge asks:

"Why didn't you just choose the project with the highest IRR?"

You might respond:

"IRR tells us the percentage return, but it doesn't tell us how much absolute value is created. Because the projects differ in scale, we used NPV alongside IRR to evaluate both return and value creation."

That demonstrates financial maturity.

Chapter Summary

IRR provides a percentage measure of an investment's expected return.

It answers:

"What rate of return does this investment generate?"

It is particularly useful when compared with the organization's required return.

But IRR should not be used in isolation.

A project can have a high IRR and still create less absolute value than another investment.

This is why strong case teams consider:

IRR + NPV + Risk + Strategic Fit

rather than relying on one financial metric.

The strongest teams understand the difference between:

return

and

value.

Key Takeaways

✓ IRR expresses an investment's return as a percentage.

✓ IRR is the discount rate at which NPV equals zero.

✓ Compare IRR with the organization's required return.

✓ IRR above the required return generally supports investment.

✓ IRR below the required return generally suggests rejecting the investment.

✓ IRR is easy to communicate because it is expressed as a percentage.

✓ A high IRR does not necessarily mean the investment creates the most value.

✓ Use NPV alongside IRR when evaluating investment alternatives.

✓ Include the initial investment as a negative cash flow.

✓ Use XIRR when actual dates and irregular timing matter.

✓ Be cautious when cash flows change direction multiple times.

✓ Sensitivity analysis helps determine whether the IRR is robust.

✓ IRR tells you the return; NPV tells you the value.

Looking Ahead

We now have two powerful tools.

NPV tells us:

How much value does the investment create?

IRR tells us:

What rate of return does the investment generate?

But case competitions rarely ask you to evaluate one investment in isolation.

Often, management has choices.

You may have:

several projects

different investment sizes

different risk levels

different implementation timelines

competing strategic priorities

Now the question becomes:

Which investment should we choose?

That is the focus of the next chapter: Comparing Investment Alternatives Which investment creates the greatest value?