Skip to main content

PART V: From Numbers To Insights

PART V: From Numbers To Insights

Turning Financial Analysis into a Winning Case Recommendation

"The purpose of financial analysis is not to prove that your numbers are right. It is to help you make a better decision."


From Financial Analysis to Financial Storytelling

Throughout this manual, we have progressively built the financial skills required to solve business cases.

We began with the financial statements.

We learned how to understand the current financial situation and identify changes in revenue, costs, profitability, liquidity, efficiency, leverage, and growth.

We then moved into comparative analysis.

We learned how to compare the organization against its own history and against relevant benchmarks.

From there, we learned how to quantify opportunities.

We explored:

  • market sizing
  • estimation
  • budgeting
  • revenue modelling
  • cost modelling

We then moved into investment decision making.

We learned how to use:

  • ROI
  • NPV
  • IRR
  • comparative investment analysis
  • sensitivity analysis
  • scenario analysis
  • decision making under uncertainty

These tools allow you to build a financially credible recommendation.

But there is still one important step.

You have to make the numbers mean something.

That is the purpose of Part V.


The Real Challenge

A case competition team can spend hours building an excellent financial model.

The spreadsheet can contain:

  • dozens of assumptions
  • multiple worksheets
  • detailed calculations
  • financial ratios
  • market estimates
  • cash flows
  • valuation calculations
  • sensitivity tables
  • scenario analysis

And yet the final presentation may still fail.

Why?

Because the judges don't have the spreadsheet in front of them.

They don't experience the analysis the way your team experienced it.

They experience the story you tell them about the analysis.

That creates an important distinction.

Analysis answers:

What do the numbers say?

Insight answers:

What does that mean?

Decision making answers:

What should we do about it?

Communication answers:

Why should anyone believe us?

This is the progression we will explore in Part V.


Discover Your Mad Skills Principle

Numbers are evidence. Insights are meaning. Recommendations are decisions.

Your job is not to show the judges everything you calculated.

Your job is to show them the few things that matter most to the decision.


The Financial Story

Think about financial analysis as a chain.

Number

Observation

Insight

Implication

Action

This is one of the most important concepts in this manual.

Let's look at each step.


1. The Number

This is the raw financial information.

For example:

Revenue increased by 18%.

That is a number.

It is factual.

But by itself, it isn't particularly insightful.


2. The Observation

You interpret what changed.

Revenue increased by 18% over the last three years.

This gives the number context.

But we still don't know why it matters.


3. The Insight

Now we identify what the number actually tells us.

For example:

Revenue growth has been concentrated in a lower-margin customer segment.

Now the number has meaning.

The company is growing.

But the quality of that growth may be a problem.


4. The Implication

Now connect the insight to the business decision.

Continuing to pursue volume in this segment may increase revenue without generating proportional profit growth.

Now management knows why the issue matters.


5. The Action

Finally:

Prioritize higher-margin customer segments and redesign pricing for the lower-margin segment.

Now the analysis has become a recommendation.


The Complete Chain

Number

Revenue increased 18%.

Observation

Growth has accelerated over three years.

Insight

Most growth is coming from a lower-margin segment.

Implication

Revenue growth is not translating proportionally into profitability.

Action

Shift growth toward higher-margin customers and improve pricing.

That is what financial storytelling looks like.


Discover Your Mad Skills Principle

Don't stop at "what happened." Ask "why does it matter?"


Why Teams Struggle With This

Many teams have been trained to think about financial analysis as finding the correct answer.

They calculate:

  • the ratio
  • the percentage
  • the NPV
  • the IRR
  • the market size
  • the budget

Then they put the answer on the slide.

But a case competition isn't an accounting exam.

There is rarely a single number that solves the case.

The number is evidence that supports your argument.

The real skill is deciding:

Which numbers matter?

and:

What do those numbers tell us?


The Financial Analysis Trap

A common presentation looks like this:

Financial Performance

Revenue: $125M

Revenue Growth: 12%

Gross Margin: 38%

EBITDA: $17M

EBITDA Margin: 13.6%

ROA: 8.2%

ROE: 14.5%

Current Ratio: 1.4

Debt/Equity: 0.82

Technically, this may be accurate.

But what does the judge take away?

Probably very little.

The team has presented information.

It hasn't necessarily presented insight.


The Better Version

Instead:

Growth is strong—but profitability is not keeping pace.

Revenue has grown 12%, but EBITDA margin has declined from 16.2% to 13.6%, indicating that incremental revenue is generating weaker profitability.

Implication: The company should prioritize profitable growth rather than revenue growth alone.

Now the numbers support a message.

The judge knows what matters.


Financial Analysis Should Answer Questions

One way to improve financial storytelling is to stop thinking:

"What numbers should we show?"

Instead ask:

"What question does the decision maker need answered?"

For example:

Question

Is the company financially healthy?

Use:

  • liquidity
  • solvency
  • profitability
  • cash flow

Question

Where is the problem?

Use:

  • trend analysis
  • margin analysis
  • cost structure
  • product/customer mix

Question

Is the opportunity large enough?

Use:

  • TAM
  • SAM
  • SOM
  • market growth
  • customer economics

Question

Can we afford the recommendation?

Use:

  • budget
  • cash flow
  • financing capacity
  • investment requirements

Question

Will the investment create value?

Use:

  • ROI
  • NPV
  • IRR
  • payback where appropriate

Question

How confident are we?

Use:

  • sensitivity analysis
  • scenarios
  • thresholds
  • risk analysis

This is much more powerful than simply selecting financial tools because they are available.


Tool Selection Should Follow the Question

One of the recurring themes throughout this manual is that tools should serve decisions.

Don't use:

ROI because ROI is available.

Use ROI because:

You need a simple measure of investment return.

Don't use:

NPV because it sounds sophisticated.

Use NPV because:

You need to understand whether an investment creates value after considering the time value of money.

Don't use:

TAM/SAM/SOM because every case needs market sizing.

Use it because:

The decision depends on understanding the size of the opportunity and the portion the organization can realistically capture.

Don't run:

sensitivity analysis because judges expect it.

Run it because:

You need to understand which assumptions could change the decision.


The Financial Question Map

A useful way to organize your analysis is:

Business Question

Financial Tool

How healthy are we?

Financial statements & ratios

What is changing?

Comparative analysis

Where is the opportunity?

Market sizing

What will it cost?

Budget

What will we earn?

Revenue model

What will it make?

Profit model

Is it worth investing?

ROI / NPV / IRR

Which option is best?

Comparative analysis

What could go wrong?

Sensitivity / scenarios

What don't we know?

Uncertainty analysis

What should we do?

Decision analysis

This table can become a useful reference throughout the manual.


From Analysis to Recommendation

The ultimate purpose of the financial analysis is to strengthen your recommendation.

A recommendation should therefore connect three things:

Strategic Logic

Why should we do this?

  •  

Financial Logic

Why does it make economic sense?

  •  

Implementation Logic

How will we make it happen?

When all three connect, the recommendation becomes much stronger.


The Three-Legged Recommendation

Think of your recommendation as a three-legged stool.

LEG 1 — STRATEGY

Does it solve the problem?

LEG 2 — FINANCE

Does it create sufficient value?

LEG 3 — IMPLEMENTATION

Can the organization actually execute it?

Remove one leg and the recommendation becomes unstable.

A financially attractive recommendation that cannot be implemented is weak.

A strategically attractive recommendation that destroys value is weak.

A feasible recommendation that does not solve the core problem is weak.

Strong case solutions connect all three.


Financial Analysis Is Evidence

This distinction is worth emphasizing.

Your financial analysis should not sit separately from the rest of your case.

It should reinforce the strategic argument.

For example:

Strategic Analysis

The company has a strong brand but weak digital reach.

Customer Analysis

Younger customers increasingly prefer digital purchasing.

Market Analysis

The digital segment is growing at 15% annually.

Financial Analysis

A digital investment produces:

$4.2M NPV

with positive value even under the downside scenario.

Recommendation

Invest in a digital channel focused on younger customers.

Now the financial analysis isn't an isolated section.

It is part of the story.


The Financial "So What?"

One of the easiest ways to improve financial analysis is to ask:

So what?

After every major financial finding, ask it again.

Finding

Operating costs increased 22%.

So what?

Profit margins declined.

So what?

The company is generating less profit from each dollar of revenue.

So what?

Future growth may not improve shareholder value unless cost efficiency improves.

So what?

The recommendation should address the cost structure rather than simply pursue additional revenue.

Now you have an insight.


The Five-Second Test

A useful test for your presentation is:

If a judge looks at this slide for five seconds, what should they understand?

If the answer is:

"They should understand all the calculations."

you have a problem.

If the answer is:

"They should understand that profitability is declining despite strong revenue growth."

you have a message.

The slide should make that message easy to find.


Financial Slides Should Have a Point

A financial slide should not simply be titled:

Financial Analysis

or:

Financial Results

Those titles describe the contents.

They don't communicate the insight.

Instead:

Weak

Financial Performance

Stronger

Revenue Growth Has Failed to Translate Into Profit Growth

Or:

Weak

Investment Analysis

Stronger

The Digital Investment Creates $4.2M of Value Even Under Downside Conditions

The second version tells the audience what they should understand.


Discover Your Mad Skills Principle

A slide title should communicate the insight—not merely identify the topic.


Turning Tables Into Insights

Tables are useful when precise comparisons matter.

But tables often become difficult to present.

Suppose you have:


2024

2025

2026

Revenue

$90M

$101M

$115M

Costs

$72M

$84M

$99M

EBITDA

$18M

$17M

$16M

The important message isn't the table.

It is:

Revenue is growing, but rising costs are eroding EBITDA.

The table becomes evidence for the message.


Turning Financial Analysis Into a Chart

The same principle applies to charts.

Don't ask:

"What chart should we use?"

Ask:

"What comparison do we need the audience to see?"

If the point is growth versus profitability, perhaps a combination chart is useful.

If the point is scenario variation, a range or column chart may work.

If the point is cost composition, a stacked chart may work.

The visualization should follow the insight.


The One-Sentence Financial Insight

Challenge yourself to summarize every major analysis in one sentence.

For example:

"Despite 12% revenue growth, EBITDA margin has fallen 260 basis points because operating costs are growing faster than sales."

If you cannot summarize the analysis in one sentence, you may not yet understand the insight.

This is an excellent team exercise.


Mad Skills Drill

Take three analyses from your case.

For each one, complete:

What did we calculate?


What changed?


Why did it change?


Why does it matter?


What should management do?


Now reduce each analysis to one sentence.


The Financial Storyboard

Before building the financial slides, create a simple storyboard.

Slide 1

Current Situation

What does the organization look like today?

Slide 2

Problem / Opportunity

What financial issue matters most?

Slide 3

Key Driver

What is causing it?

Slide 4

Recommendation

What should the organization do?

Slide 5

Financial Impact

What happens financially?

Slide 6

Risk / Sensitivity

How robust is the recommendation?

Slide 7

Decision

Why should management move forward?

You may not need seven slides.

The purpose is to understand the story.


A Financial Story Does Not Need More Numbers

One of the most common mistakes teams make when they discover that their financial story isn't convincing is to add more analysis.

More ratios.

More charts.

More calculations.

More tables.

Often the solution is the opposite.

Remove.

Remove anything that doesn't contribute to the decision.

Then strengthen the connection between the remaining evidence and the recommendation.


The 80/20 Financial Principle

In most cases, a small number of financial insights will drive most of the decision.

Your job is to find them.

Ask:

Which 20% of our analysis explains 80% of the financial decision?

Those are the numbers that deserve space in the presentation.

The rest may still be useful during preparation and Q&A.

But they don't necessarily belong on the slide.


Coach's Lens

One of the biggest differences I see between developing teams and experienced teams is not necessarily their ability to calculate.

It is their ability to choose.

Developing teams often think:

"We calculated this, so we should show it."

Experienced teams ask:

"Does this help the judge understand our decision?"

That distinction is critical.

Your spreadsheet can contain everything.

Your presentation should contain what matters.


Part V Roadmap

The remaining chapters will build this skill progressively.

Chapter 14 — Building the Financial Story

How to turn financial analysis into insights and connect those insights to the recommendation.

Chapter 15 — From Excel to the Deck

How to decide what belongs in the presentation and how to communicate financial information visually.

Chapter 16 — Defending the Numbers

How to prepare for questions, defend assumptions, and communicate financial logic under pressure.

Chapter 17 — The Financial Case-Solving Workflow

How to bring everything together into a repeatable process that can be used during an actual case competition.

The goal is not simply to become better at financial analysis.

It is to become better at using financial analysis to make and defend decisions.


Part V Opening Takeaway

The financial analyst's job is not finished when the spreadsheet is complete.

That is when the real work begins.

You need to determine:

What matters?

Why does it matter?

What does it mean for the business?

What should management do?

How confident are we?

And ultimately:

How can we communicate the financial logic clearly enough that someone else is willing to act on it?

That is the difference between doing financial analysis and using financial analysis to solve a case.


Discover Your Mad Skills

Don't show me your spreadsheet.

Show me what you discovered.

Show me why it matters.

Show me what you recommend.

And show me why the numbers give us confidence to act.

That is how you turn numbers into insights.