Choose the method for the goal

I return to the question I set at the start and compare ways to answer it. I choose a method that fits the industry and the data I can support, rather than adding complexity for its own sake.

Build the model in clear steps

I separate source data, assumptions, calculations, and outputs. I want to see how a change in an input moves through the model and affects the answer.

Compare scenarios and explain the drivers

I change the assumptions that matter and compare the results. I explain which variables drive the difference, what the model suggests, and what it cannot tell me.

Compare with actual results

Where comparable actual figures are available, I compare them with the model using matching periods and definitions. If they are not available, I record the indicators I need to follow later.

Why I put this stage here

The financial model comes after the goal, industry context, and data checks. That gives the calculations a clear purpose and a basis I can explain.

A related project: an answerable cash question

In the liquidity project, the current bank balance was unknown. The model therefore asks what opening liquidity a scenario would require, rather than claiming to predict the company’s actual funding shortfall.

Explore the project