Financial Forecast Modelling for SME Businesses

4 min read
Dec 20, 2022 8:30:00 AM
Financial Forecast Modelling for SME Businesses | Secantor
6:22

What Is a Financial Forecast, and Why Does It Matter?

A financial forecast is a model that shows the likely financial outcome of a business's plans over the medium to long term, typically three to five years. Built from expected sales and costs, a good financial forecast produces a projected profit and loss, balance sheet and cashflow forecast, month by month, so directors can see what achieving their goals actually means in financial terms, and test what happens if things don't go to plan.

Despite how useful this is, many SMEs don't have one. Decisions about pricing, hiring, investment and growth end up being made without a clear view of where they lead, which is a significant gap given how much difference financial forecasting makes to the quality of those decisions. A financial forecast is one part of the wider management information a growing business needs to run with confidence.

What Does a Good Financial Forecast Include?

A financial forecast should link three things together: the profit and loss account, the balance sheet, and the cashflow forecast, each projected forward monthly. Linking all three matters, because a plan that looks profitable on paper can still run out of cash, and a forecast that only covers profit and loss won't show that risk until it's too late to plan around it.

A good financial model also allows for scenario planning: modelling best case, worst case and most likely outcomes so a business can see the impact of different assumptions on cash requirement and business value, rather than relying on a single fixed prediction that's unlikely to be exactly right. This kind of forward planning matters at every stage of growth; our article on what good management information looks like at different stages of growth sets out how the sophistication of forecasting typically needs to evolve as a business scales.

How Is a Financial Forecast Used in Practice?

A financial forecast earns its value well beyond the point it's built. Once in place, it typically supports three ongoing uses:

Setting financial targets. The first year of a forecast becomes the current year's budget, shared with the management team, with responsibility for different parts of it assigned across departments. It should be reviewed and rolled forward annually as the business progresses.

Tracking variance. Actual performance, drawn from monthly management accounts, should be reported against the forecast every month, so directors can see where the business is ahead of or behind plan and take corrective action while there's still time to act on it. Our guide on how to use management accounts effectively covers this process in more depth.

Supporting funding applications. Where a business needs to raise finance, a well-built forecast is the tool that explains to a bank or investor why the funding is needed and how it will be repaid or returned.

Forecasting also works hand in hand with KPIs; the forecast sets the target, and the right KPIs show whether the business is on track to hit it, month by month rather than only at year end.

How Is a Financial Forecast Built?

Building a financial forecast starts with expected sales and costs, then turning those assumptions into a full three-statement model linking profit and loss, balance sheet and cashflow. This is usually a few days' work for an experienced Part-Time Management Accountant, and it's worth treating as an investment rather than an overhead, since the forecast then becomes the reference point for every monthly review that follows.

For businesses that need the forecast tied into a wider strategic and financial plan, a Fractional Finance Director typically leads the process of building the model and embedding it into monthly reporting and financial control, while a Fractional CFO is usually the right fit where the forecast needs to support funding, growth strategy or long-term value creation.

This is a pattern Secantor sees consistently across decades of hands-on work with hundreds of SME businesses: financial forecasting is one of the most valuable disciplines a growing business can build, and one of the most commonly missing.

Get Help Building Your Financial Forecast

Secantor's experienced Finance Directors, CFOs and Management Accountants build financial forecasts for SME businesses, guiding you from analysing your current financial position through to a bespoke model built around your business plan. If your strategic plan itself needs shaping first, our advisors can help with that too, since the forecast should always flow from the plan rather than the other way around.

Book a Free 30-Minute Business Review

Frequently Asked Questions

What is the difference between a financial forecast and a budget?
A budget is typically the first year of a financial forecast, used as the current year's financial target. The forecast extends further, usually three to five years, to show the likely financial trajectory of the business's wider plans.

How far ahead should a financial forecast look?
Most SMEs benefit from a forecast covering three to five years, with the first year acting as the immediate budget and the following years providing a longer-term view to support strategic decisions.

How often should a financial forecast be updated?
A financial forecast should be reviewed and rolled forward at least annually, with actual performance from monthly management accounts reported against it every month so variance can be identified and addressed early.

Do I need a financial forecast to apply for funding?
Most lenders and investors expect to see a credible financial forecast as part of a funding application, since it demonstrates both the need for the funding and the business's ability to repay or deliver a return.

Who should build a financial forecast?
A Part-Time Management Accountant is usually well placed to build the model itself, while a Fractional Finance Director or Fractional CFO typically leads how it's used to support financial control, funding or long-term strategy, depending on the business's priorities.

Get Email Notifications