How to Use this Manual

How to Use This Manual

This manual is designed to help you become more confident using financial analysis and Excel in business cases and case competitions. 

• It is not intended to turn you into an accountant, investment banker, or financial modeller.
• It is designed to help you answer a much more practical question:

What do the numbers tell us about the decision we need to make?

In case competitions, financial analysis should never exist simply because the case contains numbers. Your calculations should help you understand the situation, compare alternatives, test assumptions, evaluate risk, and demonstrate that your recommendation makes business sense. The strongest teams do not necessarily build the most complicated financial models. They build the models that help them make better decisions.

Start With the Decision, Not the Spreadsheet

One of the easiest mistakes to make in a case competition is opening Excel before deciding what you are trying to understand. Before building a model, ask:

• What decision are we trying to make?

• What financial question needs to be answered?

• Which numbers actually matter?

• What assumptions will we need to make?

• What calculation would help us compare our options?

• What evidence would make our recommendation more credible?

Only then should you open Excel. Excel is a tool for thinking, not a substitute for thinking.

You Do Not Need Every Tool in Every Case

This manual contains a range of financial tools, calculations, modelling techniques, and Excel skills. You will rarely need all of them.

• A market-entry case might require market sizing, revenue projections, investment requirements, and break-even analysis.
• A capital investment case might require cash-flow forecasting, NPV, IRR, and sensitivity analysis.
• A growth strategy might require pricing assumptions, customer projections, margins, and ROI.
• A valuation case may require an entirely different set of tools.

The objective is not to demonstrate how many financial techniques you know. The objective is to identify which analysis will help you make the decision.

Use the Manual in Three Ways

1. Learn the Fundamentals

Work through the chapters to build your understanding of the financial concepts and Excel techniques commonly used in business cases. Do not focus only on memorising formulas. Make sure you understand:

• what the calculation measures;

• why it matters;

• when you should use it;

• what assumptions it depends on; and

• how the result might influence a business decision.

Understanding the logic behind the calculation is more valuable than simply knowing which Excel function to use.

2. Use It as a Case-Solving Reference

During practice cases, return to the relevant chapters when you encounter a financial question. Ask yourself: What am I trying to understand? Then select the tool that helps answer that question.  Over time, you should become increasingly comfortable recognising which financial analysis fits different types of business decisions.

3. Use It to Build Your Excel Skills

Excel becomes much easier when you use it regularly.

• Rebuild the examples.
• Change the assumptions.
• Test different scenarios.
• Break the model and figure out why it broke.
• Then build it again.

The objective is not simply to learn where the buttons are. It is to become comfortable enough with Excel that the software does not slow down your thinking when the pressure of a case competition begins.

Build From Simple to Sophisticated

Case teams sometimes assume that more complicated financial analysis will impress judges. That is rarely true. A simple model that clearly explains the economics of your recommendation is usually more valuable than a sophisticated model that nobody can explain. Start with the simplest calculation that answers the question. Then add complexity only when it improves the quality of the decision. For example:

Estimate → Calculate → Compare → Test → Interpret

You might begin with an estimate of market demand, calculate potential revenue and costs, compare several alternatives, test the most important assumptions, and then determine what the results mean for your recommendation. The sophistication comes from the quality of the thinking, not the number of formulas.

Treat Assumptions as Part of the Analysis

Most case financials require assumptions. That is normal. You may need to estimate:

• market growth;

• customer adoption;

• pricing;

• implementation costs;

• margins;

• staffing requirements;

• conversion rates; or

• future cash flows.

Do not hide these assumptions. Make them visible. Ask whether they are reasonable, explain where they came from, and test what happens when they change. A strong financial model does not pretend that the future is certain. It helps you understand what needs to be true for your recommendation to work.

Always Interpret the Number

Never allow a calculation to become the conclusion. Suppose your analysis produces: ROI = 24%. That is a calculation. The analysis begins when you ask: So what? 

• Is 24% attractive?
• Compared with what?
• How quickly is the investment recovered?
• How sensitive is the return to your assumptions?
• What risks could reduce it?
• Does the return justify the resources required?
• What does this tell us about the recommendation?

The same principle applies throughout this manual:

Calculate → Interpret → Decide

Your job is not simply to produce numbers. Your job is to explain what those numbers mean for the business decision.

Connect the Financials to the Recommendation

Financial analysis should not become a separate section of your case solution that has little connection to the strategy. The numbers should support the story you are telling. Your analysis might demonstrate that:

• the opportunity is large enough to pursue;

• one alternative creates more value than another;

• the organisation can afford the investment;

• the recommendation can become profitable;

• the implementation timeline is financially realistic;

• the downside risk is manageable; or

• the strategy remains attractive even if key assumptions change.

When the financial analysis and strategic recommendation reinforce one another, your argument becomes much more persuasive.

Practise Under Time Pressure

Knowing how to build a model and being able to build one during a case competition are different skills. Once you understand the techniques in this manual, practise them under increasingly realistic time constraints. You should eventually be able to:

• organise case data quickly;

• identify the financial question;

• select the appropriate analysis;

• build a clean model;

• identify and test important assumptions;

• recognise unreasonable outputs;

• extract the key insight; and

• communicate that insight clearly to your team.

Speed should come from familiarity and structure, not from rushing.

Remember Who the Financials Are For

Ultimately, the financial analysis is not for Excel. It is not even primarily for you. It is for the decision makers across the table. Judges rarely need to see every formula you created. They need to understand the financial logic behind your recommendation. They should be able to answer:

• What will this cost?
• What could it generate?
• How long will it take?
• What assumptions are we making?
• What happens if those assumptions are wrong?
• Is this financially worth doing?

If your analysis allows the judges to answer those questions, the financials are doing their job.

The Discover Your MAD Skills Mindset

Throughout this manual, remember one principle:

The goal is not to prove that you can do the math. The goal is to use the math to make a better decision.

Numbers provide evidence. Excel helps you organise and test that evidence. But neither replaces judgment. The strongest case solvers know when to calculate, what to calculate, how much precision is reasonable, and most importantly, what the result means. That is the skill this manual is designed to help you develop.