Scenario planning converts uncertainty into a set of financially coherent outcomes. Instead of trying to produce one perfectly accurate forecast, management evaluates how changes in a few critical business drivers could affect revenue, profitability, working capital, cash flow, and financing needs.
The Three Core Scenarios
The base case represents the most probable operating outcome based on current performance, known customer activity, realistic market expectations, and management’s approved operating plan.
The best case represents a credible upside outcome in which favorable assumptions occur, such as stronger sales conversion, improved pricing, faster collections, or better operating leverage. It should be achievable, not merely aspirational.
The worst case represents a plausible downside outcome that tests the company’s resilience, potentially including lost customers, delayed projects, margin compression, slower collections, or an unexpected cost increase.
Scenario planning generally evaluates multiple possible outcomes rather than relying on a single forecast, with base, best, and worst cases serving as the common starting structure.
Building the Model Around Business Drivers
Effective scenario planning avoids creating three independently maintained financial models. Instead, build one integrated model with a scenario selector that changes a controlled assumptions table.
The drivers worth tracking typically include unit or customer growth, average selling price, gross margin, payroll growth, days sales outstanding, inventory days, capital expenditures, and customer loss or churn. As an illustration, a base case might assume 5 percent unit growth, a 2 percent price increase, 34 percent gross margin, 45 days sales outstanding, and normal churn. A best case might assume 12 percent growth, a 5 percent price increase, 38 percent gross margin, 38 days sales outstanding, and lower churn. A worst case might assume an 8 percent decline in units, no price increase, 29 percent gross margin, 60 days sales outstanding, and elevated churn.
The correct assumptions for any business should reflect its contracts, backlog, sales pipeline, operational capacity, customer concentration, cost structure, and liquidity position, rather than generic industry averages.
A CFO’s Take on Base, Best, and Worst-Case Modeling
The base case explains what management currently expects. The best case identifies the resources needed to capture upside. The worst case establishes how quickly the company must respond to protect cash and enterprise value.
This kind of modeling becomes genuinely useful when management can answer three questions: what assumptions would have to change for the company to enter this scenario, how would that change be recognized early, and what decisions would need to be made before the financial impact becomes irreversible.
