Chapter 10: IRR

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 organisation'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 discount rate at which the present value of future cash flows 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 organisation. 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 organisation's required return is 8%. 15% looks attractive.
• If the required return is 20%. 15% does not meet the organisation's expectations.

Therefore, the important comparison is IRR vs the 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 organisation. 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 this statement: "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

Positive cash inflows follow one initial cash outflow. 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 sign multiple times, there may 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 unthinkingly 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 mistake in case competitions. 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 is made on January 1 and returns occur on March 15, November 1, and August 20 in 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

• Looking only at the IRR. A high IRR does not automatically mean the project creates the most value. Always consider NPV.
• Ignoring the required return. An IRR of 12% means little without knowing what return the organisation requires.
• Forgetting the initial investment. The initial investment must be included as a negative cash flow.
• Using IRR for unusual cash flows without investigation. Multiple changes in cash-flow direction can produce multiple IRRs.
• Using IRR to compare projects of very different sizes. Percentage return can hide the absolute amount of value being created.
• Using IRR when actual dates matter. If the case provides irregular dates, consider XIRR.
• 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 yields an IRR of 19%. That sounds strong. But what happens if:

• 10% lower revenue

• costs are 10% higher

• delayed implementation

• slower growth

• weaker customer adoption

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 organisation 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: "We recommend the investment because it addresses our primary strategic constraint, generates a 21% return against a 12% hurdle rate, creates $2.6 million in NPV, and remains financially viable under our downside scenario." 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:

• IRR: What rate of return does the investment generate?
• Required Return: What hurdle rate should the organisation use?
• Spread: How far above or below the hurdle is the IRR?
• NPV: How much value does the investment create?
• Sensitivity

What happens when your most important assumption changes? Then answer this question: Would you still recommend the investment if the downside scenario were to occur? 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 the question: "What rate of return does this investment generate?" It is particularly useful when compared with the organisation'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 organisation'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 the investment creates.
• IRR tells us what rate of return the investment generates.

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?