As Quarter 2 concludes, the budget, set months ago, is likely outdated. For the modern CFO, this moment isn’t about simply checking variances; it’s about leading a disciplined, dynamic forecasting effort that steers the business through market volatility. In an environment defined by rapid shifts – from interest rate hikes and supply chain disruptions to sudden changes in consumer demand – a rigid, once-a-year budget is a liability. The solution lies in adopting a process that prioritizes flexibility, collaboration, and high-quality, driver-based data.

1. Shift from Static Budgets to Dynamic Rolling Forecasts

The first step in achieving forecasting discipline is abandoning the traditional fixed budget as the primary guide.

• Adopt Rolling Forecasts: Instead of projecting a single year, implement a rolling forecast (e.g., a 12-month or 18-month look-ahead) that is updated monthly or quarterly. This ensures the forward-looking plan is always grounded in the most recent actual performance and current market realities. A rolling forecast forces continuous evaluation and prevents the “set-it-and-forget-it” mentality.
• Decouple Forecasting from Budgeting: Budgets are primarily for control and accountability (what should happen), while forecasts are for planning and strategy (what will happen). Clearly separate these exercises. Using the forecast as a punitive measure encourages sandbagging and inaccuracy.

2. Embrace Scenario Planning and Stress Testing

Volatile markets demand not just one forecast, but a range of probable outcomes. This is where the discipline of Scenario Planning is non-negotiable.

• Three-Point Projection:Develop a minimum of three scenarios:

1. Base Case:The most likely outcome, incorporating current performance trends and known market conditions (e.g., confirmed interest rate outlook).
2. Best Case:An optimistic, yet plausible, scenario (e.g., successful new product launch, earlier resolution of supply constraints, a key competitor falters).
3. Worst Case (Stress Test): A severe, plausible downside (e.g., a recession, major input cost spike, or significant customer churn).

• Calculate Impact on Cash Flow: For each scenario, the most critical output is the projected Cash Flow Statement. Stress testing liquidity, covenant compliance, and working capital needs under the worst-case scenario is the CFO’s highest priority in a downturn.

3. Move to Driver-Based Modelling

Forecasting shouldn’t rely on simply extrapolating historical financial line items. True discipline comes from linking the forecast to the operational drivers of the business.

• Identify Key Drivers:Determine the few operational metrics that have the greatest impact on financial performance.

1. Sales/Revenue:Number of salespeople, lead-to-conversion rate, or average contract value (ACV).
2. Cost of Goods Sold (COGS):Commodity input prices, production capacity utilisation, or unit labour cost.
3. Operating Expenses (OPEX): Headcount (as a driver for salary/benefit costs), or Customer Acquisition Cost (CAC).

• Model the Relationships: Build the forecast model so that changes to a single operational driver (e.g., a 10% increase in lead conversion rate) automatically ripple through the financial statements. This makes assumptions transparent, easily debatable across departments, and rapidly updatable.

4. Foster Cross-Functional Collaboration

A finance-only forecast is a deeply flawed one. The finance team provides the structure and historical data, but the operational teams own the future drivers.

• Engage Department Heads: Require input and sign-off from sales, marketing, and operations. Sales: Provides forecasts on deal close probability, ACV, and sales cycle length. Operations: Provides updates on supply chain risks, inventory lead times, and capital expenditure needs. Marketing: Provides projections on customer acquisition volume and cost of campaigns.
• Reconciliation (Top-Down/Bottom-Up): Use a combined approach. Start with a Top-Down view (executive targets) and reconcile it with a Bottom-Up view (detailed departmental projections). The reconciliation process is where alignment and final accountability are hammered out.

5. Prioritise Data Accuracy and Granularity

A disciplined forecast is built on a foundation of clean, granular, and timely data.

• Granularity: Move past high-level P&L summaries. Forecasts should be at the appropriate level of detail (e.g., by product line, customer segment, or geographic region) to highlight specific risks and opportunities that macro data often masks.
• Data Integrity: Ensure the data feeding the forecast is extracted directly from verifiable sources (ERP, CRM) and is clean. Garbage in, garbage out is exponentially more damaging in a volatile environment.
• Variance Analysis: At the close of Q2, a rigorous variance analysis is essential. The focus shouldn’t just be on the number, but on the cause. Was the variance due to a change in price (market volatility) or volume (execution)? Answering this informs the accuracy of the remaining two quarters.

By embedding these five disciplines – dynamic planning, scenario testing, driver-based modelling, cross-functional collaboration, and data rigor – CFOs can transform forecasting from an annual compliance exercise into a powerful, agile tool for strategic decision-making in any market condition.

Did you find these insights valuable? Follow Stewart & Smith Advisory for more expert guidance on navigating the complexities of business finance.