A financial forecast is only as good as the process behind it. Here's an honest look at how we actually build a three-year forecast for a client — not the polished output, but the steps that get us there.
Step One: Understand the Business Before Touching a Spreadsheet
Before any numbers get built, we spend time understanding how the business actually makes money — the sales cycle, the cost structure, seasonality, what drives a customer to buy, and what's changed recently. A forecast built without this context is just a spreadsheet with someone's optimism plugged in.
Step Two: Build Revenue From the Ground Up, Not Top-Down
Rather than starting with “we want 20% growth” and working backward, we build revenue projections from the operational drivers — units sold, average transaction size, customer count, conversion rates, whatever actually drives revenue in that specific business. A bottom-up forecast is slower to build but far more defensible, because every number connects to something the business owner can explain and stand behind.
Step Three: Build Costs With the Same Discipline
Fixed costs, variable costs, and how they scale with revenue get the same ground-up treatment. This is where a lot of forecasts fall apart — costs that don't actually scale the way the model assumes, or one-time costs treated as recurring (or vice versa).
Step Four: Stress-Test the Assumptions
Once the base case is built, we run sensitivity analysis against the key assumptions — what happens if sales come in 15% below plan, if a major cost rises unexpectedly, if a key customer leaves. This is where we find out whether the forecast is actually resilient or just optimistic.
Step Five: Compare Against Real Benchmarks
Wherever possible, we compare the resulting projections against industry benchmarks and the business's own historical performance. A forecast that looks reasonable in isolation but is wildly out of step with comparable businesses gets flagged and revisited before it goes anywhere near a lender or investor.
Step Six: Build in the Explanation, Not Just the Numbers
The final forecast isn't just a set of numbers — it comes with a clear explanation of every major assumption, so the client can present and defend it confidently themselves, without needing us in the room.
Why the Process Matters More Than the Template
Anyone can fill in a forecast template. What actually makes a forecast credible to a lender or investor is whether the process behind it holds up to questions — which is exactly what steps two through five are designed to ensure.