Blog · Territory, capacity and quota planning · Finance and FP&A teams
Build coherent best, base and worst case assumptions for a business plan. Follow a US service company's revenue, profit and cash calculations, then connect each outcome to a decision and an owner.
A best and worst case scenario business plan connects plausible sales, costs and payment assumptions to profit, cash and management decisions. Start with a base case, change related drivers together, and identify what management would do if the downside began to appear.
A scenario is a description of how the business could operate under stated conditions. It needs a cause, an operating response and a financial consequence. Lower customer demand might reduce completed work, weaken pricing and leave more staff time unfilled; it does not automatically reduce every expense by the same percentage.
The SBA's business plan guidance calls for financial projections that support the funding request and explain the assumptions behind them. A scenario comparison makes those assumptions visible. It should help the reader distinguish a supported plan from a favorable outcome that management hopes to achieve.
Use the broader scenario analysis method for general scenario mechanics. Here, the task is narrower: make a business plan's operating story and funding exposure agree. A sales team's best case forecast category is one input, rather than a complete business scenario.
Consider Cedar Field Services, an illustrative US commercial maintenance company planning its next quarter. All amounts are USD. Service visits are completed and billed within the quarter; collection can occur later. Opening unrestricted cash is $120,000 in every case, and management requires a quarter-end cash floor of $50,000.
| Operating assumption | Downside | Base | Upside |
|---|---|---|---|
| Completed service visits | 2,400 | 3,000 | 3,450 |
| Revenue per visit (USD) | 145 | 150 | 150 |
| Variable expense per visit (USD) | 63 | 60 | 58 |
| Fixed cash operating expense (USD) | 220,000 | 220,000 | 235,000 |
| Depreciation expense (USD) | 10,000 | 10,000 | 10,000 |
The downside assumes fewer renewals, selective price concessions and more fragmented routes that raise variable expense per visit. Fixed cash expense stays committed. The upside assumes fuller routes and lower variable expense per visit, but also additional supervisory and dispatch costs.
Attach evidence to each input: renewal schedules for visits, signed price schedules for revenue per visit, payroll and purchasing records for costs, and staffing commitments for fixed expense. Label unsupported inputs as assumptions. The scenario names alone are not evidence.
Keep one-time investment separate from recurring operating costs. The SBA's startup cost guidance distinguishes one-time expenses from monthly expenses; that separation is also useful when an established company's plan includes expansion. Buying equipment should not become a recurring operating charge merely because it appears in the same planning workbook.
Use the same definitions across the columns:
Revenue = Completed visits × Revenue per visit
Contribution = Revenue − Variable expense
Operating profit = Contribution − Fixed cash operating expense − Depreciation
| Calculation (USD) | Downside | Base | Upside |
|---|---|---|---|
| Revenue: visits × revenue per visit | 348,000 | 450,000 | 517,500 |
| Variable expense: visits × expense per visit | 151,200 | 180,000 | 200,100 |
| Contribution: revenue − variable expense | 196,800 | 270,000 | 317,400 |
| Less fixed cash operating expense | 220,000 | 220,000 | 235,000 |
| Less depreciation | 10,000 | 10,000 | 10,000 |
| Operating profit | −33,200 | 40,000 | 72,400 |
For example, downside revenue is 2,400 × $145 = $348,000. Its variable expense is 2,400 × $63 = $151,200. Contribution of $196,800 cannot cover $220,000 of fixed cash expense plus $10,000 of depreciation, producing a $33,200 operating loss.
These are operating results before income tax and interest. There is no interest expense in this simplified example. Every dollar amount is exact; no rounding is needed. The expense classifications must stay consistent across cases so that a movement reflects changed operations rather than a different accounting presentation.
Profit is not the amount available to pay bills. The SEC's guide to financial statements explains that operating cash flow reconciles income for noncash items and changes in operating assets and liabilities. Apply that distinction to the plan before judging whether the downside is affordable.
The following changes are explicit scenario inputs. Receivables, inventory and payables are changes from opening balances, not closing balances. Cash tax payments are supplied planning amounts, not a tax-rate calculation; depreciation is the only noncash expense assumed here.
| Cash bridge (USD; signed cash effects) | Downside | Base | Upside |
|---|---|---|---|
| Opening unrestricted cash | 120,000 | 120,000 | 120,000 |
| Operating profit | −33,200 | 40,000 | 72,400 |
| Add back depreciation | 10,000 | 10,000 | 10,000 |
| Increase in receivables | −60,000 | −30,000 | −45,000 |
| Increase in inventory | 0 | −10,000 | −15,000 |
| Increase in payables | 0 | 5,000 | 7,000 |
| Cash income tax payments | 0 | −10,000 | −15,000 |
| Capital spending | −10,000 | −20,000 | −30,000 |
| Debt principal payments | −5,000 | −5,000 | −5,000 |
| Closing cash: sum of rows above | 21,800 | 100,000 | 99,400 |
| Required closing cash floor | 50,000 | 50,000 | 50,000 |
| Headroom: closing cash − floor | −28,200 | 50,000 | 49,400 |
The upside has higher profit than the base case but slightly less closing cash. Additional receivables, inventory and investment absorb the benefit. The downside has a $28,200 gap to the required closing cash floor, even though the bank balance remains positive.
Prove the base case independently through cash receipts and payments. Customer receipts are $450,000 − $30,000 = $420,000. Variable operating payments are $180,000 + $10,000 − $5,000 = $185,000, assuming the payables increase relates to those purchases. Then $120,000 + $420,000 − $185,000 − $220,000 − $10,000 − $20,000 − $5,000 = $100,000, matching the bridge.
A quarter-end comparison cannot prove the company remains above its floor throughout the quarter. Use cash flow scenario analysis to test dated collections and payments, and the cash flow forecast method to maintain the baseline schedule.
Finance owns the reconciliation and common definitions. Sales owns renewal and pricing evidence; operations owns delivery capacity and variable costs; the budget owner confirms which spending is committed. Each assumption needs a review date and a person responsible for replacing it with actual evidence.
For Cedar Field, the downside prompts a funding or spending decision before cash approaches the floor. A proposal to delay investment belongs in a separate response version, with the delayed payment and operational consequences shown. Do not silently include an unapproved cost reduction in the downside and then claim the exposure is covered.
The upside also needs a response: confirm that staffing, equipment and customer terms can support the extra work. Keep the original scenarios frozen while comparing actual results with them. Changing the baseline after the quarter begins removes the evidence needed to explain a miss.
Bring your scenario workbook, supporting sales assumptions and cash schedules to Covirage; it maps the columns, and its tools compute and check the supplied profit and cash comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for the supporting workflow.
A base case plus a coherent upside and downside is a useful starting set. Add another case when it tests a different decision, such as a delayed opening or an unavailable supplier. More scenarios help only when their assumptions and responses remain clear.
Use a severe but explainable operating case for the normal planning comparison. A complete shutdown can be a separate continuity exercise. Define what makes your downside plausible, which costs remain committed and which actions management could actually take.
They do not need probabilities to reveal exposure or test an action. If you assign probabilities, explain the evidence and keep the individual outcomes visible. A weighted average can hide a cash shortfall that still needs a specific response.