A three statement forecast model is a cornerstone of effective financial planning and analysis for UK SMEs. By integrating profit and loss, cash flow, and balance sheet forecasts into a single, coherent model, you gain a reliable and actionable view of your business health and future performance. This practical guide walks through the process, with real-world examples and step-by-step advice, to help you build a robust three statement forecast model tailored for your business.
Why Build a Three Statement Forecast Model?
For finance teams and business owners, relying on standalone profit and loss forecasts is rarely enough. Cash flow and balance sheet positions often move very differently from headline profits, especially with accruals, timing of receipts, and capital expenditure. A fully linked three statement forecast model gives clarity on cash requirements, covenant compliance, tax liabilities, and working capital needs, ensuring decisions are grounded in reality rather than optimistic projections. For example, a UK SME in retail may show strong profits during the Christmas period, but unless cash tied up in stock and delayed customer payments are forecasted, the business could face a cash shortfall in January.
Key Components of a Three Statement Forecast Model
Every robust three statement forecast model contains the following:
- Profit and Loss (P&L): Revenue, direct costs, overheads, depreciation, interest, and tax.
- Cash Flow Statement: Operating, investing, and financing cash movements.
- Balance Sheet: Assets, liabilities, and equity positions at each period-end.
All three must reconcile: for example, profit after tax links to retained earnings; changes in working capital affect both balance sheet and cash flow; and capital expenditure impacts fixed assets and cash balances.
Step 1: Start with Revenue and Cost Drivers
Begin by establishing your revenue forecast assumptions. This should be underpinned by clear volume, price, and timing logic, with supporting evidence such as pipeline data, contracts, or market trends. For a deeper dive into forecasting sales and revenue, see our guide on revenue forecasting methods.
Similarly, model direct costs and overheads based on operational plans. Consider fixed versus variable costs, planned hires, inflation, and supplier contracts. For example, if your SME plans to launch a new product line, project its impact on both sales and related costs. This builds your P&L forecast foundation and makes your three statement forecast model more realistic.
Step 2: Build the Profit and Loss Statement
Use your assumptions to construct a period-by-period P&L, including all income and expenses down to operating profit. Add expected depreciation and interest charges, and estimate tax based on UK rules and reliefs. For instance, a construction SME may forecast contract revenues and match these with direct labour and materials, then factor in depreciation on new equipment purchased during the year.
Be mindful of non-cash items. Depreciation, amortisation, and accruals appear in profit, but do not directly affect cash in the same period. Understanding these is key for accurate cash forecasting and for building a reliable three statement forecast model.
Step 3: Model the Balance Sheet Movements
Next, forecast your balance sheet. Start with opening balances and adjust for forecast activity. Key lines to model include:
- Trade receivables and payables, based on debtor and creditor days
- Inventory, calculated from cost of goods sold and stock turns
- Fixed assets, updated for new purchases and depreciation
- Loans and finance, including scheduled repayments
- Share capital and retained earnings, linked to profit and dividends
Ensure each balance sheet item logically links back to the P&L or cash flow. For example, an increase in receivables matches an increase in sales not yet collected, reducing cash. A wholesaler SME, for instance, may see a surge in trade receivables after a large seasonal order, putting pressure on available cash until customers pay.
Step 4: Construct the Cash Flow Statement
The cash flow statement ties together profit and balance sheet movements. Use the indirect method: start with operating profit, adjust for non-cash items (like depreciation), and reconcile working capital changes. Add investing activities (capex, asset sales), and financing flows (loans, repayments, dividends). This is where the three statement forecast model reveals the real liquidity impact of business activity.
Check that the opening cash, plus all forecast cash flows, equals closing cash on the balance sheet. Any mismatch should prompt a thorough review for formula or logic errors. In practice, UK SMEs often discover unexpected cash gaps here, prompting proactive action on credit control or supplier terms.
Step 5: Integrating and Validating Your Model
With all three statements built, link them together. Use cross-referencing formulas to ensure that movements in one statement drive the others. For example, P&L net profit should feed into retained earnings; capex should reduce cash and increase fixed assets.
Validate your model by:
- Ensuring the balance sheet balances at each period end
- Tracing major items through all statements (e.g. a loan drawdown impacting cash and liabilities)
- Comparing modelled results to recent actuals for reasonableness
- Stress-testing assumptions for sensitivity and risk
Practical Modelling Tips for UK SMEs
Keep your three statement forecast model structure simple and transparent. Use clear input sections for assumptions, avoid hardcoded numbers in formulas, and document logic for each calculation. Set up version controls and change logs, particularly if the model will be shared or audited.
For many SMEs, Excel is sufficient, but for more complex or collaborative needs, cloud-based forecasting software or external support may be appropriate. If you require specialist assistance in building or reviewing your three statement forecast model, consider the accounting and business support available from Business Junction.
Finally, ensure your three statement forecast model supports regular review and update as part of your management accounts month end checklist. This will keep forecasts current and decision-making robust as conditions change.
Regulatory and Tax Considerations
UK SMEs must ensure their three statement forecast model reflects statutory reporting requirements and tax planning. For example, timing of VAT payments, PAYE, and corporation tax must be factored into cash flow. Capital allowances and R&D reliefs can materially impact tax forecasts and cash timing.
Good models also support compliance by highlighting periods of cash shortfall or covenant breach risk, enabling early mitigation. For more on financial governance and controls for tax risk, see our dedicated resource.
Conclusion and Next Steps
A well-constructed three statement forecast model is vital for informed decision-making, cash management, and regulatory compliance. By systematically linking profit, cash, and balance sheet, UK SMEs gain a holistic, actionable view of their financial future. Invest time in building, validating, and maintaining your three statement forecast model to ensure resilience and agility in a changing business environment.
Actionable Checklist:
- Gather actuals and opening balances for all three statements
- Define main revenue and cost drivers, using realistic evidence
- Forecast P&L, balance sheet, and cash flow for at least 12 months
- Link all statements so changes flow through the model
- Stress-test assumptions and update regularly with new information
By following these steps, your SME can use a three statement forecast model not only as a compliance tool, but as a valuable driver of growth and stability.