The Entrepreneur’s Guide to Financial Modelling
Most founders treat the financial model as something you build once, to raise money or satisfy the bank, and then forget in a spreadsheet nobody opens again. That is a waste of one of the most powerful decision-making tools a business owner has. A good model is not a document you produce for other people. It is an instrument you use to think.
I’m Adam J. Graham, and after years of building, scaling, and selling companies, I’ve come to rely on financial modelling not as an accounting exercise but as a way of seeing the future clearly enough to make better choices in the present. You do not need to be a finance specialist to do this well. You need to understand what a model is really for, how to build one that earns its keep, and how to use it without fooling yourself. This is the founder’s guide I wish I’d had.
What a financial model is really for
A financial model is a simplified, numerical version of how your business makes money, written down in a way that lets you ask “what if?” and get an honest answer. At its heart it connects the things you do, sell to more customers, raise prices, hire a team, change your costs, to the things that result, revenue, profit, and cash in the bank.
The purpose is not prediction. Nobody can forecast the future accurately, and a model that claims to is lying. The purpose is understanding. A good model shows you which levers in your business actually matter, how sensitive your outcomes are to the assumptions you are making, and where the cliffs are before you walk off one. It turns vague optimism into specific, testable expectations, and that is what makes it valuable whether you are running the business day to day or preparing it for sale.
The three statements that matter
A complete model rests on three connected views of the business, and a founder should understand all three even if an accountant maintains them.
The profit and loss shows whether the business makes money over a period: revenue, minus costs, equals profit. It answers the question “are we profitable?” The cash flow shows when money actually moves in and out, which is rarely the same as when it is earned. It answers the far more urgent question “will we run out of cash?” Plenty of profitable businesses have died because the profit was on paper while the bank account hit zero. The balance sheet shows what the business owns and owes at a moment in time, the accumulated result of every decision so far.
The reason these three matter together is that they keep each other honest. A change you make in one ripples through the others. Model only the profit and loss and you can convince yourself a plan works while heading straight for a cash crisis the P&L never shows you.
Build it on drivers, not guesses
The difference between a model that helps and a model that misleads is whether it is built on drivers or on wishful top-line numbers. A weak model says “revenue grows twenty percent a year” with no explanation of how. A strong model builds revenue up from its components: number of customers, average order value, purchase frequency, retention rate. Now growth is not a hope, it is the result of assumptions you can examine, defend, and adjust.
The same discipline applies to costs. Separate the costs that stay broadly fixed regardless of volume from the ones that rise as you sell more. Once your model is built this way, it becomes a genuine thinking tool. You can ask what happens if retention improves by five points, or if you hire two salespeople, or if a key supplier raises prices, and watch the answer flow through profit and cash. A driver-based model does not just tell you where you might end up. It tells you why, and which of your own actions changes the destination.
Use it to find the levers that matter
Once you have a driver-based model, its real power is sensitivity analysis: changing one assumption at a time to see how much it moves the outcome. This is where founders discover that their instincts about what matters are often wrong.
You might find that a small improvement in customer retention does more for long-term profit than a large push on new sales, because retained customers cost nothing to reacquire. You might find that a modest price increase, which feels terrifying, drops almost entirely through to the bottom line because your costs barely move. You might find that the expensive hire you were agonising over barely dents cash flow, while a supplier renegotiation you had not prioritised transforms it. The model turns these from arguments into evidence. It shows you the two or three levers that genuinely move your business, so you can stop spreading effort evenly and concentrate it where the numbers say it counts.
Model the downside before you need to
Optimism is a founder’s fuel, and it is also the thing a financial model exists to keep in check. The most important scenario to build is not the one where everything goes right. It is the one where things go wrong, because that is the scenario that determines whether you survive long enough to enjoy the one where things go right.
Build at least three versions: a realistic base case, an upside, and a genuine downside where sales come in slower, a big customer leaves, or costs rise. Then look hard at the downside and ask the questions that matter. How long before cash runs out? What is the earliest warning sign I would see? What would I cut, and how quickly could I act? A founder who has already modelled the bad scenario is calm when early signs of it appear, because the response is planned rather than panicked. The model does not stop bad things happening. It buys you the time and clarity to deal with them.
Keep it alive
The final mistake is treating the model as a one-off artefact. A model built once and never revisited becomes fiction within months, as reality drifts away from the assumptions you froze. A model that earns its place is a living instrument you update regularly with what actually happened, so you can compare forecast to reality and learn.
That comparison is where the real education lives. When actual results miss the model, you do not just note the variance, you ask why your assumption was wrong and what that teaches you about the business. Over time your assumptions get sharper, your forecasts get more honest, and your feel for the numbers becomes instinctive. That is the real compounding benefit of financial modelling: not a perfect prediction of the future, but a founder who understands their own business deeply enough to steer it with confidence, in good times and bad, and who can prove that understanding to any buyer, banker, or board that ever asks.
Adam Graham is a serial entrepreneur, CEO of JustFix, and creator of Exit Mode. He writes about scaling, selling, and building businesses worth buying, drawing on years of experience leading companies through growth, crisis, and exit.
Want more insights like this? Join 45,000+ founders getting weekly strategies on scaling and selling their businesses. Subscribe to The Growth Mindset Newsletter →