· 3 min read · By Ramy Hanna, Principal & Founder
Financial modelling: testing the numbers before you bet on them
Before you hire, borrow, raise or acquire, build the model. Here's what financial modelling is, what makes one credible, and how it de-risks big decisions.
Every significant business decision is a bet on a future that hasn’t happened yet — a new hire, a bigger lease, a loan, a capital raise, an acquisition. A financial model is how you test that bet on a spreadsheet before you make it with real money. Done well, it doesn’t predict the future; it shows you the range of futures and whether the business survives all of them.
What a financial model actually is
A financial model links your key business drivers — units, clients, prices, headcount, costs — to your three financial statements, so that changing one assumption flows through to profit, cash and the balance sheet. The point isn’t a single “answer”. It’s the ability to ask “what if?” and see the consequences instantly: what if growth is slower, rates rise, or a big customer leaves?
What makes a model credible
- Driver-based, not hard-coded. Revenue should be built from things you can defend — capacity, conversion, price — not a number typed into a cell.
- Assumptions are visible and separate. Every assumption lives in one place, clearly labelled, so a board or lender can interrogate it.
- It ties to reality. The model’s starting point should reconcile to your actual accounts, not an idealised version.
- It has a downside. A single optimistic case isn’t a model — it’s a hope with decimal places.
Scenarios: the part that earns trust
The value of modelling is in the scenarios. We typically build at least three: a base case (realistic), a downside (slower growth, a lost customer, higher costs) and an upside. If the business can service its commitments through a reasonable downside, the decision can be made with genuine confidence. If it only works in the base case, that’s a finding worth having before you commit.
Common uses
Growth and business-planning models for setting strategy and targets; funding models to present to a lender or investor; pricing and unit-economics models; hiring and capacity models; and acquisition or exit models. In each case the model turns a gut-feel decision into an evidence-based one — which is exactly what a board, a bank or an investor wants to see.
Where a virtual CFO fits
Building and, more importantly, interrogating the model is core virtual CFO work. The spreadsheet is the easy part; the judgement about which assumptions are realistic, where the risk sits, and what the numbers are really telling you is what makes a model useful for business growth planning. See how we work.
Frequently asked questions
What is financial modelling?
Building a spreadsheet that links your business drivers to your financial statements, so you can test how decisions and scenarios affect profit, cash and the balance sheet before you commit.
Why do I need a financial model?
To de-risk big decisions — hiring, borrowing, raising, acquiring — and to present credible numbers to a board, lender or investor.
How many scenarios should a model have?
At least three: a realistic base case, a downside and an upside. The downside is the one that matters most.
Book a free 30-minute consultation and we’ll talk through the decision you’re modelling and how to test it properly.