Three Way Forecasting: UK Lenders Expect Five Years of Forecasts
A three way forecast links your profit and loss, balance sheet and cash flow so you can see when profit turns into cash, or when it doesn’t. That link exposes funding gaps and timing risks that a profit-only forecast hides, and it underpins the planning packs, cash management decisions and lender submissions that growing businesses rely on.
TL;DR:
Growing businesses seeking funding should prepare at least two years of historical data and five years of forecasts, with working capital assumptions tied to cash.
Reforecast monthly using operating drivers such as headcount, units sold, and payment timing, then update immediately after a lost customer, delayed funding, or cost shock.
Build assumptions and supporting schedules before the statements, keep actuals separate from forecasts, and use formula links with a balance check in every period.
Size borrowing against the forecast’s lowest cash point, add a buffer, and give lenders a concise summary with funding timing, three scenarios, and sensitivities.
Calculate runway by dividing current cash by average monthly cash burn, so the forecast gives a date rather than a general sense of financial safety.
Table of Contents
The mechanics: how the income statement, balance sheet and cash flow link
Step-by-step build order for a serviceable three-way forecast
Forecasting techniques: driver-based modelling, rolling forecasts and scenario testing
Using a three-way forecast for funding, bank submissions and operational planning
Practitioner perspective from Keystone: building and maintaining three-way forecasts for founders
What is a three way forecast (3-statement model)?
A three way forecast, often called a 3-statement model, joins three views of the same business into one working file. The income statement shows whether trading is profitable over a period. The balance sheet shows what the business owns and owes at a point in time. The cash flow statement shows how cash actually moved, which is rarely the same as profit because of timing differences in payments, receipts, stock and debt.
Building these separately produces three disconnected opinions about the business. Linking them means a change in one, a new hire, a slower-paying customer, a stock purchase, flows automatically through the other two, which is what makes the model useful rather than decorative.
Income statement: revenue, costs and profit over a month, quarter or year.
Balance sheet: assets, liabilities and equity at each period end.
Cash flow statement: the actual cash movement, reconciling opening to closing balance.
Early-stage and growing businesses typically build this monthly, since quarterly or annual views miss the short-term cash crunches that cause the most damage.
Why three way forecasting matters for planning and funding
Profit and cash diverge constantly. A business can report a healthy margin and still run out of money because customers pay late, suppliers demand faster payment or stock sits unsold. Working capital metrics such as days sales outstanding and days payable outstanding translate those operational realities into cash timing, which is exactly what government guidance on financial model essentials flags as a common blind spot: founders often model profitability well but omit working capital cycles, which funders treat as a red flag during due diligence.
Investors and lenders typically expect at least two years of historic data and five years of forecasts from growing businesses, according to gov.uk guidance, so a forecast built without that depth will struggle to pass scrutiny. Lenders read historics against forecast assumptions to judge whether a plan is grounded in reality, and when a model cannot show how working capital assumptions convert into cash, that gap undermines the whole submission. Missing the point at which cash turns negative is the single most common reason a funding conversation stalls.
The mechanics: how the income statement, balance sheet and cash flow link
Getting the statements to talk to each other is mostly mechanical, but it has to be done in the right order and checked at every step.
Net profit flows into retained earnings. Each period’s profit or loss from the income statement adds to (or reduces) retained earnings on the balance sheet, which in turn affects total equity.
Depreciation and capital expenditure connect all three statements. Depreciation reduces profit on the income statement, reduces fixed assets on the balance sheet, and is added back in the cash flow statement because it is a non-cash charge; capital spending appears as a cash outflow and increases fixed assets before depreciation starts.
Working capital schedules set the timing of cash. Debtor days, creditor days and stock days convert sales and purchases into the actual dates cash arrives or leaves, and these schedules sit behind the balance sheet movements that drive the cash flow statement.
Debt, interest and any revolving facility close the loop. Interest charges hit the income statement, the loan or revolver balance moves on the balance sheet, and drawdowns or repayments appear as financing cash flows, with any shortfall triggering a draw on the facility automatically rather than by manual entry.
Each of these links should be built as a formula, never typed in as a static number, because a hardcoded figure breaks the moment an assumption changes upstream. When the three statements are properly linked, the balance sheet should balance in every period without a plug, and that single check is the fastest way to confirm the mechanics are sound.
Step-by-step build order for a serviceable three-way forecast
Models built in a random order tend to collapse the first time an assumption changes. A disciplined sequence, consistent with ICAEW’s introductory modelling guidance, keeps the file serviceable long after the first draft.
Define the model’s purpose and outputs. Decide whether this is for internal planning, a bank submission or investor due diligence, since that shapes the level of detail and the summary page you build at the end.
Build assumptions and scenario pages first. Every driver, growth rate, margin, days sales outstanding, should live on one clearly labelled sheet, separate from the calculations.
Separate actuals from forecast periods. Keep historical data on its own tab or clearly flagged columns so nobody mistakes an assumption for a fact.
Build supporting schedules before the statements. Revenue, working capital, capex and debt schedules feed the three main statements, not the other way round.
Link the schedules into the income statement, balance sheet and cash flow. Test that the balance sheet balances in every single period before moving on.
Add checks, flags and version control. A visible error flag, a balance check row and a dated file-naming convention catch mistakes before they reach a lender.
Pro Tip: Give the model one clearly stated purpose on its cover sheet. A forecast trying to serve a bank, an investor and internal budgeting at once usually serves none of them well.
Forecasting techniques: driver-based modelling, rolling forecasts and scenario testing
A static annual budget goes stale within weeks of market conditions shifting. Driver-based modelling and rolling forecasts keep the numbers relevant, and ICAEW’s guidance on choosing the right modelling tool notes that rolling forecasts suit high-uncertainty periods better than fixed-date budgets because they maintain a constant forward horizon.
Pick drivers tied to actual operations, units sold, headcount, average order value, rather than arbitrary growth percentages.
Reforecast on a rolling basis, typically monthly or quarterly, so the horizon always extends a consistent distance ahead.
Build base, upside and downside scenarios with named triggers, such as a key customer loss or a delayed funding round, rather than vague optimism or pessimism.
Update cash flow forecasting drivers as soon as real sales, payment or cost data comes in, rather than waiting for a scheduled review.
This cadence matters most for cash. A business whose customers routinely pay late needs its model to reflect that pattern every month, not just at budget time, which is one reason late payment causes such persistent cash strain for small UK businesses.
Common pitfalls, model controls and validation checks
Most broken models fail for the same handful of reasons, and ICAEW’s guidance on assessing forecast reliability treats the model as an analytical engine: one built so that changing a variable shows its cash impact immediately, which only works if the structure stays clean.
Hardcoded numbers inside formulas break the moment an assumption changes elsewhere.
Leftover dummy or test data from early drafts can silently distort live outputs if it isn’t flagged.
Missing balance checks, sign checks or a capped revolver limit let errors travel undetected through every later period.
Undocumented assumptions leave nobody able to explain why a number looks the way it does six months later.
Pro Tip: Flag any cell containing test or placeholder data in a bright, consistent colour, and remove the flag only once real data replaces it. This single habit, drawn from the ICAEW Financial Modelling Code, prevents dummy figures from reaching a lender by accident.
Using a three-way forecast for funding, bank submissions and operational planning
A forecast earns its keep when it tells you, and a lender, exactly how much cash you need and when. The British Business Bank’s guidance on reforecasting notes that cashflow forecasts exist specifically to show whether borrowing is needed, how much, and how it will be repaid, and recommends reforecasting whenever a material event changes the picture.
Bank of England guidance treats a liquidity forecast as a live document that must be updated frequently to catch shortfalls early, according to the Bank’s liquidity forecasting framework, rather than a one-off document filed and forgotten.
Runway is simply current cash divided by the average monthly cash burn from the forecast, giving a date rather than a vague sense of safety.
A funding ask should be sized against the lowest cash point in the forecast, with a buffer, not against a rough guess.
A one-page summary with a funding timetable, base, upside and downside scenarios, and a short sensitivity table is what most lending packs need to be assessed quickly.
Practitioner perspective from Keystone: building and maintaining three-way forecasts for founders
We build every three-way forecast around a stated purpose first, whether that is a bank submission, an investor pack or internal planning, because a model trying to serve every audience usually satisfies none. Integrating bookkeeping directly into the forecast means actual results flow in automatically each month, so a reforecast takes hours rather than days.
We keep assumptions and historicals on clearly separated sheets, consistent with recognised modelling discipline.
We run reforecasts on a rolling monthly cadence rather than waiting for a fixed annual review.
We prepare lender-ready summary pages alongside the working model, not as an afterthought.
What most forecasting advice gets backwards
Most guidance on three-way forecasting obsesses over formula complexity: nested scenario switches, elaborate macros, dashboards nobody reads. The harder problem is almost never technical. It’s that most models get built once, for one funding round or one board meeting, and then quietly die because nobody updates them. A forecast with five scenario toggles that nobody touches after month two is worse than a simple one that gets reforecast every month, because a live, simple model tells you the truth and a dead, sophisticated one tells you nothing.
The priority for most founders isn’t a better template. It’s a cadence: a standing monthly habit of feeding real numbers back into the assumptions and watching how the cash position moves. Get that discipline right first, and the mechanical links between the three statements become far easier to trust.
— Shoaib
How we can help you build and maintain a three-way forecast
We build three-way forecasts as part of how we support founders day to day, combining Flexible Accounting Services That Grow With You, priced between £99 and £199 per month, with the bookkeeping, VAT filing and reporting work that keeps a forecast’s historicals accurate.
[
](www.keystonefa.co.uk)
We build the initial model, then run monthly reforecasts as part of ongoing support.
We prepare lender-ready funding packs alongside the forecast, drawing on live bookkeeping data.
We handle the accounting services that feed a forecast, from bookkeeping to year-end reporting, under one engagement.
If you run a sole trader or small trades business and want a simpler starting point for tracking cash day to day, the cash flow guide for tradespeople from TradeTally covers practical invoicing and tracking habits worth adopting before a full model is needed. Get in touch through Keystonefa to start building a working forecast.
This article is general information, not a substitute for advice from a qualified financial advisor. Consult a qualified financial professional about your own circumstances before acting on anything here.
FAQ
Is it true that most small businesses fail due to cash flow problems?
There’s no single verified figure behind that claim, so we won’t repeat an unsourced statistic. What’s well established is that cash timing, not profitability alone, is a leading cause of business failure, which is exactly why gov.uk’s financial model guidance stresses linking cash flow to profit forecasts.
What is a 3 statement model?
A 3 statement model is another name for a three way forecast: a linked income statement, balance sheet and cash flow statement built so that a change in one flows through the others automatically. It is the standard structure recommended in ICAEW’s modelling guidance for serviceable, auditable forecasts.
What is a cash forecasting model and how does it work?
A cash forecasting model projects cash inflows and outflows over future periods, reconciling an opening balance to a closing balance each month. The Bank of England’s liquidity forecasting guidance treats it as a live document that needs regular updates to catch shortfalls before they become urgent.
What are different methods of forecasting?
Common approaches include driver-based forecasting, which ties numbers to operational metrics like units sold, rolling forecasts that maintain a constant forward horizon, and scenario forecasting that models base, upside and downside cases. ICAEW’s guidance on modelling tools notes that rolling forecasts suit uncertain conditions better than fixed annual budgets.
How often should a business reforecast its three-way model?
Reforecast monthly as standard practice, and immediately whenever a material event, a lost customer, a delayed round, a cost shock, changes the picture. The British Business Bank recommends reforecasting whenever such events occur, rather than waiting for a scheduled review.
Sources
Recommended