Introduction

Numbers are everywhere in business cases. Revenue. Costs. Margins. Growth. Market size. Return on investment. Cash flow. Valuation. Forecasts. Scenarios. Sensitivity analysis.

For many case competitors, financial analysis is where the case begins to feel more difficult. The numbers can be unfamiliar. The spreadsheet can become complicated. And under competition time pressure, it is easy to fall into the trap of believing that the team that builds the most sophisticated financial model will have the strongest solution. That is not the goal.

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

This distinction is at the heart of this manual. A spreadsheet is a tool. It is not the answer.

The strongest case teams use financial analysis to understand what is happening, identify opportunities, test assumptions, compare alternatives, evaluate risk, and determine whether their recommendations are financially credible. They don't simply calculate numbers. They interpret them. That means moving beyond asking: "What does the number say?" to asking: "What does the number mean?" And then, ultimately: "What should we do about it?" This progression from numbers to insights to decisions is the foundation of financial case analysis.

You do not need to become an investment banker or an Excel expert to become an excellent case competitor. You do, however, need to become comfortable using financial information to support business judgment. That starts with understanding the financial situation.

Before building a forecast, you need to understand the organisation's current performance. Before calculating ROI, you need to understand what investment you are evaluating and what return actually matters. Before building a market-sizing model, you need to understand the market opportunity. Before calculating NPV or IRR, you need to understand the decision the organisation is actually trying to make. In other words: Financial analysis should follow the business question—not the other way around.

Throughout this manual, you will develop the financial skills needed to move from basic financial understanding to more sophisticated decision analysis. You will work with financial statements and ratios, comparative analysis, market sizing, estimation, budgeting, revenue and cost modelling, ROI, NPV, IRR, valuation, sensitivity analysis, and scenario analysis.

But the calculations are only part of the learning. The more important skill is learning what to do with the results.

A 15% ROI might look attractive. But attractive compared with what?

A market might be worth $500 million. But how much of that market can the organisation realistically capture?

Revenue might be growing. But is profitability growing with it?

An investment might have a positive NPV. But what assumptions are driving that result?

A forecast might look impressive. But how resilient is it if those assumptions change?

These are the questions that turn financial analysis into business insight. That is also why this manual places such an emphasis on Excel. Excel is incredibly powerful, but its value comes from how you use it. A beautifully constructed spreadsheet filled with formulas does not create a winning case. A simple model that helps a team understand the economics of a decision can be far more valuable.

The goal is not to make your spreadsheet impressive. The goal is to make your decision defensible.

As you work through this manual, you will therefore be encouraged to think about financial analysis in three ways:

Understand.
What is happening financially, and why?

Compare.
What alternatives, benchmarks, or scenarios should we evaluate?

Decide.
What does the analysis tell us about what the organisation should do?

This is where financial analysis becomes part of case solving rather than a separate technical exercise. Ultimately, judges are not evaluating your spreadsheet. They are evaluating your thinking. They want to know whether you understand the economics of your recommendation, whether you have tested the assumptions behind it, whether you have considered uncertainty and risk, and whether the numbers make the decision more or less credible. The numbers should reduce uncertainty, not create an illusion of certainty.

Use them to understand.

Use the analysis to compare.

Use the scenarios to test.

And then use your judgment to decide.