Scenario Planning Worksheet: Best, Base and Downside for UK SMEs

The Case for Three Scenarios, Not One

A single-line budget creates false confidence. Most businesses hit neither their optimistic plan nor collapse — they navigate a corridor between the two. Three parallel scenarios make that corridor explicit and force directors to articulate the assumptions that drive variance, not just the outcomes.

For companies seeking commercial finance, presenting a funded base case alongside a stress-tested downside demonstrates that management has considered repayment capacity under adverse conditions. This materially improves lender confidence.

Defining Your Scenarios

Scenarios should differ on a small number of clearly stated drivers rather than every line item. Typical drivers include revenue volume, average selling price, key customer concentration, input cost inflation, and debtor days. Adjust those drivers; let the model cascade the consequences.

• Base case: most likely outcome based on current order book and pipeline, no heroic assumptions
• Best case: achievable with favourable conditions — not a stretch target; cap upside at something you could genuinely defend
• Downside: a plausible adverse combination: one large customer delays or reduces spend, a cost line moves adversely, a planned new contract slips by a quarter

Worksheet Layout

The worksheet runs three side-by-side columns, one per scenario, with shared row headings for P&L and cash flow. Each scenario column contains the driver assumptions at the top, followed by revenue, cost of sales, gross margin, overhead, EBITDA, capex, debt service, and closing cash balance. A fourth column can show the range between downside and best to highlight where management judgment matters most.

The output summary is a single-page dashboard showing closing cash, peak borrowing requirement, and EBITDA margin for each scenario. This is the page a lender or investor reads first.

Linking Scenarios to Financing Decisions

The practical output of the worksheet is a debt-service coverage ratio for each scenario. If the downside scenario produces a DSCR below 1.0x at any point in the forecast, the proposed facility carries repayment risk that needs to be acknowledged — either through a lower draw amount, a longer term, or an operational plan to avoid the downside path.

Directors should confirm scenario assumptions with their accountant or financial adviser before presenting to any lender. Figures produced in this worksheet are planning estimates, not audited projections.