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