Financial scenario planning asks how a business decision behaves when the assumptions change. Instead of treating one forecast as the answer, you test plausible alternatives: slower sales, higher costs, delayed receipts or a different start date. The purpose is to understand risk and choose actions while there is still room to change the plan.
In this article
- Choose the decision to test
- Set realistic assumptions for each scenario
- Compare profit and cash outcomes
- Agree triggers for changing the plan
This does not require a complicated model. A clearly explained spreadsheet covering the decision, its costs and its effect on cash can be more useful than a detailed forecast nobody understands. The essential ingredients are reliable starting figures, explicit assumptions and a decision that the analysis will inform.
Start with a specific question
“Will the business grow?” is too broad. “Can we take on a new contract that requires stock purchases before the customer pays?” gives the model a clear job.
Define the options, the decision date and the period to examine. A short project may need weekly cash analysis. A new premises decision may need several years of trading projections as well as closer attention to the first months. Identify commitments that become difficult to reverse, such as a lease or equipment order.
Collect the latest cash balance, trading results, outstanding invoices, supplier balances and existing borrowing. Check whether known liabilities and planned owner withdrawals are reflected. A model starting from the wrong bank position cannot reliably show the cash available.
Build a base case you can explain
Separate assumptions from calculations. Show sales volumes, prices, payment timing, staff costs, supplier terms and one-off spending individually. Document the source of each important input: a signed contract, supplier quotation, historical average or management estimate.
Distinguish sales from cash receipts. An invoice may contribute to profit before it produces cash. Equipment expenditure can reduce cash immediately while its accounting treatment differs. Where tax payments or VAT affect cash, use the business's actual circumstances and obtain advice rather than assuming a standard treatment.
The GOV.UK business plan guidance describes financial forecasts as part of planning. For an internal decision, connect the forecast to the operational plan: who will sell, deliver, recruit and collect payment?
Test changes that could genuinely happen
| Assumption | Question to test | Possible response to explore |
|---|---|---|
| Sales ramp-up | What if orders arrive later? | Stage recruitment or defer spending |
| Customer payment | What if collection takes longer? | Deposits, credit checks or tighter follow-up |
| Input cost | What if the supplier quotation increases? | Revise price or negotiate terms |
| Capacity | What if delivery takes more hours? | Limit intake or add temporary capacity |
| Launch date | What if opening is delayed? | Reduce pre-opening commitments |
Avoid choosing percentages merely to produce a reassuring result. Use actual volatility, contract dependencies and operational knowledge. A downside scenario should be plausible and coherent: if sales fall, not all costs will necessarily fall at the same time.
Illustrative example: testing a new contract
Imagine a manufacturer considering an order producing £60,000 of sales, with £36,000 of direct production costs. These figures are illustrative and exclude tax effects. Some materials must be purchased before delivery, while the customer pays after invoicing.
The base case shows a contribution of £24,000 before overheads. That does not mean the order finances itself. The cash model places material payments, wages and customer receipts in the relevant weeks.
A second case delays the customer receipt by a month. A third combines that delay with additional rework costs. Management compares the lowest cash position with funds genuinely available, including other commitments.
The decision might be to negotiate a deposit, deliver in stages or decline terms that create excessive exposure. The forecast does not predict which outcome will occur; it reveals what would need to be true for the order to remain manageable.
Find the thresholds, not just the totals
Look for the point at which the decision stops meeting your criteria. What sales volume covers additional fixed costs? How late can payment arrive before a cash shortfall? How much cost increase removes the expected contribution?
Separate available bank cash from unused facilities, and verify any facility limits and conditions before relying on them. Show the amount and timing of a possible funding gap. A total annual profit can hide a critical shortfall in an earlier month.
Then agree triggers. For example, require a minimum number of committed orders before spending, or review the plan when collections slip beyond the modelled assumption. Name the person responsible for monitoring each trigger.
Keep the model useful after approval
Save the version used for the decision and record approved assumptions. When actual results arrive, compare them with the plan and explain significant differences. Update the forecast without overwriting the evidence of what was originally agreed.
How many scenarios are enough? Start with a credible base case, a relevant downside and one alternative action. Add scenarios when they answer a distinct question.
Is scenario planning a guarantee against losses? No. Unexpected events and inaccurate inputs remain possible. The benefit is a clearer view of exposure and options.
For help turning a spending decision into a practical financial model, discuss outsourced CFO support with EPOS Accountancy. Supply the decision, timing, available records and major uncertainties. Deliverables and fees are agreed through a quote; visit pricing for the next step.