PART IV: Investment Decision Making - From Financial Impact to Investment Choice

A financial model tells you what might happen.

An investment decision asks:

Is it worth doing?

That distinction is important.

Teams can build accurate financial models and still make poor investment decisions. They may calculate revenue, costs, profit, and cash flow correctly but fail to connect those numbers to the actual decision facing management.

Investment decision making is about comparing the resources required to pursue an opportunity with the value that opportunity is expected to create.

This requires more than one financial calculation.

It requires judgment.

The Purpose of Investment Analysis

When organizations invest, they give something up today in exchange for an expected benefit in the future.

That investment might involve:

launching a new product
opening a new location
purchasing equipment
implementing technology
entering a new market
acquiring another company
expanding production
hiring additional employees
developing new capabilities

The fundamental question is always:

Will the expected benefits justify the resources and risks required?

Different financial tools answer different versions of that question.

The Investment Decision Toolkit

This part of the manual introduces several tools that case teams can use to evaluate investments.

Chapter 8 — ROI

How profitable is the investment relative to its cost?

Chapter 9 — NPV

Does the investment create value after considering the time value of money?

Chapter 10 — IRR

What rate of return does the investment generate?

Chapter 11 — Comparing Investment Alternatives

Which investment creates the greatest value?

Chapter 12 — Sensitivity and Scenario Analysis

How robust is the decision when assumptions change?

These tools should not be viewed as competing formulas.

They answer different questions.

Discover Your Mad Skills Principle

The goal is not to calculate the number. The goal is to use the number to make the decision.

A judge does not need to know that you can calculate ROI.

They need to understand:

what the ROI means
whether it is attractive
what assumptions drive it
how it compares with alternatives
what risks could change the result
and what you recommend management do

The calculation is the evidence.

The decision is the point.

Deciphering Case Characteristics

Before choosing an investment metric, ask:

What decision is being made?

Are we deciding whether to invest at all?

Are we choosing between two projects?

Are we deciding how much to invest?

Are we deciding when to invest?

What information does the case provide?

Do we have:

initial investment?
annual returns?
costs?
cash flows?
timing?
discount rate?
comparable investments?

What level of analysis is appropriate?

Not every case requires a full discounted cash flow model.

Sometimes a quick ROI calculation is exactly what is required.

Other times, ROI is insufficient and the team needs NPV, IRR, or sensitivity analysis.

The skill is knowing the difference.

PART IV

INVESTMENT DECISION MAKING

The chapters that follow build progressively.

Start with the simplest question:

How much return are we getting for what we are investing?

Then move toward more sophisticated questions:

When do we receive that return?

What is the value of those future cash flows today?

What rate of return does the investment generate?

How confident are we that the investment will actually create value?

This progression allows students to understand not just the formulas, but why the tools exist.

Chapter 8 ROI

Simple Investment Decisions

Learning Objectives

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

explain what ROI measures

calculate ROI for a simple investment

identify situations where ROI is useful

distinguish between annual and cumulative ROI

compare investment alternatives using ROI

recognize the limitations of ROI

communicate ROI effectively in a case presentation

understand when a more sophisticated investment tool is required

Why This Matters

One of the most common questions in a business case is:

Is this investment worth it?

Sometimes you need a sophisticated financial model to answer that question.

Sometimes you don't.

If a company is considering spending $1 million on an initiative and expects to generate $1.5 million in returns, a simple calculation can provide an immediate first look at the attractiveness of the investment.

That calculation is Return on Investment, or ROI.

ROI is one of the simplest financial tools available to a case-solving team.

And that simplicity is its greatest strength.

It is also one of its greatest limitations.

What Is ROI?

ROI measures the return generated by an investment relative to the cost of that investment.

The basic formula is:

ROI = (Return − Investment Cost) ÷ Investment Cost

The result is normally expressed as a percentage.

For example:

An organization invests:

$1 million

The investment produces:

$1.5 million

The gain is:

$500,000

Therefore:

ROI = ($1.5M − $1.0M) ÷ $1.0M

ROI = 50%

The investment generated a 50% return relative to the amount invested.

What Is ROI Actually Telling You?

ROI answers a relatively simple question:

How much return did we generate relative to what we invested?

This makes ROI particularly useful for quick comparisons.

Suppose you have two alternatives:

	Investment	Return	ROI
Project A	$1M	$1.5M	50%
Project B	$5M	$6M	20%

Project A has the higher ROI.

At first glance, that may suggest Project A is more attractive.

But notice something important.

Project B generates:

$1 million of gain

while Project A generates:

$500,000 of gain.

So which project is better?

That depends on the decision.

This is one of the first important lessons of financial analysis:

A financial metric does not make the decision by itself.

When to Use ROI

ROI works particularly well when you need a:

Quick financial check

You can calculate ROI quickly without building a complex model.

Simple comparison

ROI can help compare alternatives when the investments have reasonably similar characteristics.

Communication tool

Executives and judges can understand a percentage return quickly.

Early-stage estimate

During the early stages of case solving, ROI can help determine whether an idea is financially promising before the team spends significant time developing a detailed model.

ROI in Case Competitions

ROI is particularly useful when time is limited.

Imagine your team has three potential recommendations.

You don't yet know which one deserves deeper analysis.

You could estimate:

initial investment

expected return

for each alternative.

This gives the team a quick way to identify which options deserve further investigation.

ROI can therefore function as a screening tool.

It does not necessarily provide the final investment decision.

A Worked Example

Imagine a retailer is considering a new customer loyalty program.

The team estimates:

Initial investment: $2 million

Expected financial return: $3 million

The calculation is:

ROI = ($3M − $2M) ÷ $2M

ROI = $1M ÷ $2M

ROI = 50%

The team can therefore state:

"The proposed loyalty program generates an estimated 50% ROI."

But don't stop there.

The next question should be:

What assumptions create that 50%?

Perhaps the model assumes:

100,000 customers participate

20% increase in purchase frequency

$30 incremental contribution per customer

implementation costs of $2 million

Now the ROI becomes much more useful.

The team can identify the assumptions that need to be tested.

The Difference Between Return and Profit

Be careful with terminology.

When calculating ROI, teams sometimes use "return" to mean total revenue.

That can be misleading.

If you invest $1 million in a marketing campaign and generate $2 million in additional sales, that does not necessarily mean you earned $1 million.

You must consider the costs associated with generating those sales.

A useful question is:

What financial benefit are we actually measuring?

Depending on the case, this might be:

incremental profit

incremental operating income

savings

cash flow

investment proceeds

The appropriate measure depends on the decision.

Annual vs. Cumulative ROI

Another important distinction is timing.

Imagine an investment of $1 million generates:

Year 1: $200,000

Year 2: $300,000

Year 3: $500,000

The total return is:

$1 million

The cumulative gain relative to the original investment is therefore:

But that does not mean the investment was necessarily unsuccessful.

The organization received cash flows over three years.

ROI by itself does not tell us how quickly those returns arrived.

This is a major limitation.

ROI Does Not Consider the Time Value of Money

A dollar received today is generally worth more than a dollar received several years from now.

ROI does not automatically account for this.

Consider two investments:

Investment A

Invest $1 million.

Receive $1.5 million next year.

Investment B

Invest $1 million.

Receive $1.5 million ten years from now.

A simple ROI calculation gives both investments the same:

50% ROI

But economically, they are very different investments.

Investment A returns the money much sooner.

Investment B ties up the organization's capital for much longer.

This is one reason we eventually need tools such as NPV and IRR.

ROI Does Not Capture Risk

Two investments can have identical ROI calculations but dramatically different levels of risk.

Imagine:

Project A

50% ROI

High probability of success

Project B

50% ROI

Highly uncertain market

The percentage alone does not tell us which investment should be selected.

This is why financial analysis must be connected to:

strategic fit

implementation capability

market conditions

uncertainty

risk

organizational capacity

Financial metrics are evidence.

They are not the entire decision.

ROI Does Not Tell You the Size of the Opportunity

Consider:

	Investment	Gain	ROI
A	$100K	$50K	50%
B	$10M	$2M	20%

Project A has a better ROI.

Project B creates a much larger absolute gain.

If the organization has significant excess capital and needs to maximize total value creation, Project B might be preferable.

If capital is extremely constrained, Project A might be more attractive.

Again:

The metric must be interpreted in the context of the decision.

The ROI Trap

One of the most common mistakes in case competitions is treating the highest ROI as automatically meaning "best investment."

It doesn't.

Suppose your team recommends the project with the highest ROI.

A judge might ask:

"Why did you choose that project?"

If your answer is:

"Because it has the highest ROI."

you have not really answered the strategic question.

A stronger answer might be:

"We selected Project A because it generates an attractive 50% ROI while requiring only $1 million of investment, which is consistent with the organization's available capital. Although Project B produces a larger absolute profit, its capital requirement is significantly higher and would limit our ability to fund other strategic priorities."

Now the financial metric is supporting the decision.

Coach's Lens

When a team gives me an ROI calculation, I want them to answer four questions:

1. What are we investing?

What is the initial cost?

2. What are we getting back?

What exactly constitutes the return?

3. When do we get it?

Is it immediate, annual, or spread over several years?

4. What could change it?

Which assumptions are most important?

If the team can answer those four questions, the ROI becomes much more useful.

ROI as a Screening Tool

One of the best uses of ROI in a case is to quickly screen alternatives.

Imagine a team is considering five initiatives.

Rather than immediately building five complex financial models, estimate the ROI of each.

Initiative	Investment	Estimated Gain	ROI
A	$1M	$600K	60%
B	$3M	$900K	30%
C	$2M	$1M	50%
D	$5M	$750K	15%
E	$500K	$50K	10%

The team might decide to investigate A and C more deeply.

This saves time.

And in a case competition, time is a resource.

From ROI to Deeper Analysis

Once ROI suggests an investment may be attractive, ask:

Do we need more analysis?

The answer is often yes.

You may want to investigate:

timing of cash flows

cost of capital

project life

risk

alternative investments

sensitivity to assumptions

This is where the financial toolkit progresses from:

ROI

NPV

IRR

Sensitivity Analysis

Each tool adds another dimension to the decision.

Using ROI in Excel

ROI is straightforward to calculate in Excel.

For example, if:

investment is in cell B2

return is in cell B3

the calculation can be represented conceptually as:

(Return − Investment) / Investment

Excel then converts the result into a percentage.

But remember:

The formula is the easy part.

The difficult part is determining what should go into the formula.

Building the ROI Story

A good case presentation should not simply show:

ROI = 48.6%

Instead, build the financial story.

Investment

$2.0M

↓

Incremental Financial Benefit

$3.0M

↓

Net Gain

$1.0M

↓

ROI

50%

↓

Decision

Proceed, subject to key assumptions.

Now the judge can follow the logic.

Presenting ROI to Judges

Keep the presentation simple.

Highlight:

initial investment

financial benefit

timing

key assumptions

Avoid burying the calculation in a spreadsheet screenshot.

Your audience should understand the conclusion in seconds.

For example:

$2M investment → $3M return → 50% ROI

Then explain the assumptions that make that result credible.

A Stronger Financial Statement

Instead of:

"Our recommendation has a 50% ROI."

Try:

"Our $2 million investment is expected to generate $3 million in incremental financial benefit, producing a 50% ROI. The result is driven primarily by a 15% customer adoption assumption and a $30 contribution per customer."

Now the judges understand:

investment → return → metric → assumptions

That is a financial story.

Sensitivity Thinking

Even when using ROI, think about what happens if your assumptions change.

Suppose the base case is:

50% ROI

But:

Conservative Case

30% ROI

Base Case

50% ROI

Upside Case

75% ROI

Now you have a much stronger understanding of the investment.

The question becomes:

Does the investment remain attractive if our assumptions are wrong?

That question becomes central to the sensitivity analysis later in this part.

Mad Skills Drill

Choose an investment from a previous case.

Calculate:

1. Initial Investment

How much does the organization have to spend?

2. Financial Benefit

What incremental profit, savings, or return does the investment generate?

3. Net Gain

Benefit minus investment.

4. ROI

Net gain divided by investment.

5. Key Assumption

What assumption has the greatest impact on the result?

Then change that assumption.

What happens to ROI?

This is the beginning of sensitivity analysis.

Common Mistakes

Mistake 1 — Using revenue as the return

Sales are not necessarily profit.

Mistake 2 — Ignoring timing

A 50% return next year is different from a 50% return ten years from now.

Mistake 3 — Choosing the highest ROI automatically

ROI does not measure total value.

Mistake 4 — Ignoring investment size

A tiny project can have an impressive ROI but create very little absolute value.

Mistake 5 — Presenting ROI without assumptions

A percentage without supporting logic is difficult to trust.

Mistake 6 — Treating ROI as the final answer

ROI is often a starting point rather than the complete investment analysis.

Deciphering the Decision

When you see an ROI question in a case, don't immediately reach for the formula.

Ask:

What decision is management actually trying to make?

Then ask:

Is ROI sufficient to answer that decision?

If the case requires a quick comparison, ROI may be enough.

If timing is important, consider NPV.

If the question is about the rate of return, consider IRR.

If uncertainty is significant, use sensitivity or scenario analysis.

The skill is not knowing every formula.

The skill is knowing which tool answers the question.

Chapter Summary

ROI is one of the simplest ways to evaluate an investment.

It provides a quick measure of the return generated relative to the investment required.

That makes it useful for:

quick screening

simple comparisons

early financial analysis

communicating financial attractiveness

But ROI has important limitations.

It does not automatically account for:

timing

time value of money

risk

absolute value creation

differences in investment size

Therefore, ROI should be used as part of the investment decision process rather than as an automatic decision rule.

Key Takeaways

✓ ROI measures return relative to investment.

✓ ROI is useful for quick financial comparisons.

✓ ROI can be an effective screening tool.

✓ Always define what "return" actually means.

✓ Consider investment size, not just percentage return.

✓ Consider when the return occurs.

✓ Don't assume the highest ROI automatically represents the best investment.

✓ Make the assumptions behind the ROI visible.

✓ Use sensitivity analysis when assumptions are uncertain.

✓ Move to NPV or IRR when the decision requires deeper analysis.

✓ The goal is not to calculate ROI.

✓ The goal is to use ROI to make a better decision.

Looking Ahead

ROI gives us a quick view of investment attractiveness.

But it treats a dollar received today and a dollar received several years from now too similarly.

That raises an important question:

What are those future cash flows actually worth today?

In the next chapter, we move to Net Present Value (NPV) and introduce the time value of money—the next step in making more sophisticated investment decisions.

Chapter 9 NPV

Understanding the Value of an Investment Today

Learning Objectives

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

explain the purpose of Net Present Value (NPV)

understand the time value of money

identify the role of the discount rate

calculate a simple NPV

interpret positive and negative NPV

use NPV to compare investment alternatives

understand why NPV is generally preferred when investment measures conflict

identify common NPV mistakes

communicate an NPV result clearly in a case presentation

Why This Matters

ROI gives us a useful first look at an investment.

But ROI has a major limitation.

It does not tell us when the return occurs.

Consider two investments.

Investment A

Invest:

$1 million

Receive:

$1.5 million next year

Investment B

Invest:

$1 million

Receive:

$1.5 million ten years from now

Both investments produce a:

50% ROI

But would you really consider them equally attractive?

Probably not.

The first investment returns the money much sooner.

That matters because money has a time value.

A dollar received today can be invested, used, or otherwise put to work.

A dollar received ten years from now cannot.

NPV helps us account for that difference.

Discover Your Mad Skills Principle

A dollar is not just a dollar. When you receive it matters.

This is one of the most important ideas in investment analysis.

NPV brings the timing of cash flows into the decision.

Instead of simply asking:

"How much money will we make?"

we ask:

"What is the value today of the money this investment is expected to generate in the future?"

That is a much more useful investment question.

What Is NPV?

NPV stands for:

Net Present Value

It measures the present value of an investment's future cash flows after accounting for the initial investment.

In simple terms:

NPV tells us how much value an investment creates or destroys in today's dollars.

The basic logic is:

Present Value of Future Cash Flows

minus

Initial Investment

equals

NPV

If the result is positive, the investment creates value relative to the required return.

If the result is negative, the investment destroys value relative to the required return.

The Time Value of Money

The foundation of NPV is the time value of money.

Imagine someone gives you a choice:

Option A: Receive $1,000 today.

Option B: Receive $1,000 five years from now.

Most people would choose Option A.

Why?

Because if you receive the money today, you can potentially:

invest it

earn a return

use it to reduce debt

fund another opportunity

improve liquidity

Therefore, future cash flows need to be adjusted to reflect their value today.

This process is called:

Discounting

Discounting Future Cash Flows

Suppose you expect to receive:

$1,100 one year from now

and your required return is:

10%

The present value is approximately:

$1,000

Why?

Because $1,000 invested at 10% would become approximately $1,100 after one year.

So:

$1,100 one year from now is economically equivalent to approximately $1,000 today at a 10% required return.

This is the basic idea behind NPV.

The Discount Rate

The discount rate represents the return required for taking on the investment.

It reflects the opportunity cost of capital and, depending on the context, the risk associated with the investment.

For example, if the discount rate is:

10%

then a future cash flow is discounted at 10% per period.

The higher the discount rate, the less valuable future cash flows become today.

This creates an important relationship:

Higher discount rate → Lower NPV

Lower discount rate → Higher NPV

The NPV Formula

The mathematical formula for NPV is:

NPV = Σ [Cash Flowₜ ÷ (1 + r)ᵗ] − Initial Investment

Where:

Cash Flowₜ = cash flow in period t

r = discount rate

t = time period

You do not need to memorize the formula simply to compete in a case.

Excel can perform the calculation.

But you should understand the logic behind it.

The formula is simply:

Take each future cash flow, convert it into today's value, add those values together, and subtract the initial investment.

A Simple Worked Example

Imagine a company is considering a new production system.

The initial investment is:

$1,000,000

The company expects the following cash flows:

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

The required return is:

10%

We need to discount each future cash flow.

Year 1

$400,000 ÷ 1.10

≈ $363,636

Year 2

$400,000 ÷ 1.10²

≈ $330,579

Year 3

$400,000 ÷ 1.10³

≈ $300,526

The present value of the future cash flows is therefore approximately:

$994,741

Now subtract the initial investment:

$994,741 − $1,000,000

≈ −$5,259

The NPV is slightly negative.

That tells us that, at a 10% required return, the investment does not quite create enough value to meet the required return.

Interpreting NPV

There are three basic outcomes.

Positive NPV

NPV > 0

The investment is expected to create value above the required return.

All else equal, this supports proceeding.

Zero NPV

NPV = 0

The investment is expected to earn approximately the required return.

It is essentially value neutral relative to the required return.

Negative NPV

NPV < 0

The investment is expected to generate less value than the required return.

All else equal, this suggests the organization should not proceed.

The Key Decision Rule

For a conventional investment:

Positive NPV → Accept

Negative NPV → Reject

But remember the phrase:

All else equal.

A positive NPV does not automatically mean "do it."

Strategic fit, execution risk, capacity, ethics, regulation, and other considerations may still matter.

Likewise, a negative NPV does not necessarily mean an idea should be discarded without further thought.

Perhaps the assumptions need to be challenged.

Perhaps the project can be redesigned.

Perhaps the organization has a strategic reason to accept a lower financial return.

Financial analysis informs the decision.

It does not replace managerial judgment.

Why NPV Is Powerful

NPV provides several advantages.

1. It considers timing

Cash flows received sooner are worth more than cash flows received later.

2. It considers the required return

The discount rate provides a benchmark for what the organization needs to earn.

3. It measures value creation

A positive NPV indicates that the investment creates value relative to the required return.

4. It supports comparisons

NPV can help compare different investment opportunities.

5. It supports strategic decisions

It translates future financial consequences into a common present-value measure.

Comparing Investments Using NPV

Imagine an organization is considering two projects.

	Project A	Project B
Initial Investment	$5M	$5M
NPV	$2M	$3.5M

If the projects have similar strategic and risk characteristics, Project B creates more value.

That gives the team a stronger financial reason to recommend Project B.

But now imagine:

Project A: $2M NPV

Project B: $3.5M NPV

and Project B has substantially greater execution risk.

The decision is no longer simply:

"Pick the higher NPV."

The team must consider whether the additional value justifies the additional risk.

Again:

The financial metric informs the decision.

NPV and ROI

It is useful to understand how NPV differs from ROI.

ROI asks:

How much return are we generating relative to our investment?

NPV asks:

How much value are we creating today after accounting for the timing of cash flows and the required return?

ROI is simple and intuitive.

NPV is more sophisticated.

ROI can be useful for an early screen.

NPV is often more appropriate when evaluating significant investments with cash flows occurring over multiple periods.

When to Use NPV

NPV becomes particularly useful when:

the investment is significant

cash flows occur over multiple years

timing matters

alternatives have different cash-flow patterns

the organization has a defined required return

you need to assess value creation

the case explicitly asks about investment value

If the case gives you a discount rate and a series of future cash flows, that is often a strong signal that NPV is an appropriate tool.

Coach's Lens

One of the easiest ways to decide whether NPV belongs in your analysis is to look for three things:

1. An investment

How much money must be committed?

2. Future cash flows

What financial benefits occur over time?

3. A discount rate

What return does the organization require?

When all three are present, NPV is likely to provide useful information.

NPV in Excel

Excel makes NPV calculations relatively straightforward.

For regularly spaced annual cash flows, the basic NPV function can be used to discount future cash flows.

A common structure is:

=NPV(discount rate, future cash flows) + initial investment

The initial investment is typically entered as a negative cash flow.

For example:

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

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

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

An Important Excel Warning

One of the most common mistakes teams make is misunderstanding what Excel's NPV function is doing.

When using the standard NPV function, the initial investment is often not included inside the range of future cash flows being discounted.

Instead, you calculate the present value of the future cash flows and then add the initial negative investment.

Conceptually:

NPV = PV of future cash flows + initial investment

Because the initial investment is negative, adding it subtracts the investment.

This is a small technical detail that can create a major error if it is overlooked.

NPV With Actual Dates

Sometimes the case does not provide neat annual cash flows.

Instead, cash flows occur on specific dates.

For example:

January 1, 2027

September 15, 2027

March 30, 2028

December 10, 2028

In situations where actual dates matter, Excel's:

XNPV

can be more appropriate.

XNPV allows the calculation to account for the actual timing between cash flows.

This becomes particularly useful when:

investments occur partway through a year

cash flows occur irregularly

implementation timing varies

the case provides specific dates

NPV vs. XNPV

NPV

Best suited to:

regular periods

annual or periodic cash flows

consistent timing

XNPV

Useful when:

actual dates are provided

cash flows occur at irregular intervals

more precise timing is important

The principle remains the same.

You are discounting future cash flows back to today.

The difference is how timing is handled.

A Common Mistake

Suppose your spreadsheet calculates:

$4.2 million

A team may say:

"Our NPV is $4.2 million."

But if the initial investment has not been subtracted, that may actually be the present value of the future cash flows, not the NPV.

Remember:

NPV includes the investment.

The initial cash outflow must be reflected.

NPV and the Investment Decision

Imagine your team has calculated:

Initial investment: $10M

NPV: $4M

A weak presentation says:

"The NPV is $4 million."

A stronger presentation says:

"The initiative requires a $10 million investment and generates an estimated $4 million in value above our 12% required return."

The second statement explains what the number means.

That is the level of communication judges need.

NPV Is Only as Good as the Assumptions

A spreadsheet can produce an NPV to the nearest dollar.

That does not mean the forecast is accurate to the nearest dollar.

Your NPV depends on assumptions about:

revenue

growth

costs

investment

timing

useful life

discount rate

terminal value, where applicable

If those assumptions are weak, the NPV is weak.

This is why sensitivity analysis becomes essential.

The NPV Sensitivity Question

Suppose your base-case NPV is:

+$10 million

That sounds attractive.

But what happens if:

revenue is 10% lower?

costs are 10% higher?

growth is slower?

implementation takes longer?

the discount rate increases?

Perhaps NPV falls to:

−$2 million

Now the recommendation is much less certain.

This is why a strong team does not simply present:

"Our NPV is positive."

It asks:

"How robust is that positive NPV?"

Discover Your Mad Skills Principle

Don't use NPV to prove your recommendation. Use NPV to test your recommendation.

This changes how the team approaches financial analysis.

If the NPV is negative, don't simply change an assumption until it becomes positive.

Ask:

What is causing the negative result?

Perhaps the investment is too large.

Perhaps the launch should be phased.

Perhaps the pricing strategy should change.

Perhaps the target market is too small.

Perhaps the project should be redesigned.

Financial analysis should improve the recommendation.

Deciphering Cases

When a case provides an investment opportunity, ask:

What is the initial investment?

What cash leaves the organization?

What are the future cash flows?

Where does the financial benefit come from?

When do those cash flows occur?

Timing matters.

What discount rate should we use?

What return does the organization require?

What does the NPV tell us?

Does the investment create value?

What assumptions drive the result?

What could cause the NPV to change?

What should management do?

This final question is the most important.

A Case Competition Example

Imagine a company is considering a five-year technology investment.

Initial Investment

$5 million

Expected Annual Cash Flow

$1.7 million

Discount Rate

10%

The team calculates the NPV.

Suppose the result is:

+$1.4 million

The financial conclusion is:

The investment is expected to create approximately $1.4 million in value above the company's 10% required return.

But the strategic conclusion should go further.

For example:

Now the financial analysis is supporting the recommendation rather than sitting beside it.

Communicating NPV Visually

Avoid presenting a spreadsheet full of discounted cash flows.

Instead, consider showing:

Investment

−$5M

↓

Future Cash Flows

↓

Present Value

$6.4M

↓

NPV

+$1.4M

Then communicate the decision.

The judge should be able to understand the conclusion almost immediately.

Common Mistakes

Mistake 1 — Forgetting the initial investment

This can turn a present-value calculation into something that is incorrectly labeled NPV.

Mistake 2 — Using the wrong discount rate

The discount rate should be logically connected to the organization's required return and the risk of the investment.

Mistake 3 — Ignoring timing

Cash flows occurring at different times should not simply be added together without considering their timing.

Mistake 4 — Treating NPV as a guaranteed outcome

NPV is based on assumptions.

It is an estimate, not a guarantee.

Mistake 5 — Showing excessive precision

A forecast based on uncertain assumptions does not become more credible because it says:

$1,437,829

instead of:

approximately $1.4M

Mistake 6 — Using NPV without explaining it

Judges need to understand what the NPV means for the decision.

Mistake 7 — Ignoring strategic considerations

A positive NPV does not eliminate operational, strategic, ethical, or implementation risks.

Mad Skills Drill

Take an investment from a previous case.

Build a simple NPV model.

Include:

Initial Investment

The cash outflow at Year 0.

Future Cash Flows

Estimate annual cash flows for at least three years.

Discount Rate

Choose a reasonable rate and explain why.

NPV

Calculate the present value of the future cash flows and subtract the initial investment.

Then ask:

What happens to NPV if our most important assumption changes?

Try:

lower revenue

higher costs

slower growth

higher discount rate

delayed implementation

Record what happens.

You have now moved from calculating NPV to thinking about financial risk.

A Judge-Friendly NPV Explanation

If a judge asks:

"What does your NPV tell us?"

A strong answer might be:

"Our $5 million investment produces approximately $1.4 million of positive NPV at our 10% required return. In other words, after accounting for the timing of the expected cash flows and the required return, the project is expected to create approximately $1.4 million of additional value."

If the judge asks:

"What could change that?"

You should be ready to identify the two or three assumptions that matter most.

That is where the analysis becomes credible.

Chapter Summary

NPV takes investment analysis beyond simple return calculations.

It recognizes that the timing of cash flows matters and converts future cash flows into present values using a discount rate.

A positive NPV generally indicates that an investment is expected to create value above the required return.

A negative NPV suggests that the investment does not meet the required return.

But NPV is not a prediction of the future.

It is a decision tool built from assumptions.

The strongest case teams therefore use NPV to:

evaluate investments

compare alternatives

test assumptions

understand value creation

strengthen recommendations

Most importantly, they explain what the NPV means rather than simply displaying the number.

Key Takeaways

✓ NPV measures value created after considering the time value of money.

✓ Future cash flows are discounted back to today's value.

✓ The discount rate represents the required return or opportunity cost of capital.

✓ Positive NPV generally supports investment.

✓ Negative NPV generally suggests rejecting the investment.

✓ NPV is particularly useful for multi-year investments.

✓ The initial investment must be included in the calculation.

✓ Use XNPV when actual dates and irregular timing matter.

✓ NPV is only as credible as the assumptions behind it.

✓ Sensitivity analysis helps determine how robust the result is.

✓ NPV should support the decision—not replace strategic judgment.

✓ The goal is not to calculate NPV. The goal is to understand whether the investment creates value.

Looking Ahead

NPV tells us whether an investment creates value in today's dollars.

But another question remains:

What rate of return is the investment actually generating?

That leads us to the next tool:

Internal Rate of Return, or IRR.

IRR allows us to express the investment's return as a percentage and provides another way to compare investment opportunities.

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

recognize 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:

Chapter 11

Comparing Investment Alternatives

Which investment creates the greatest value?