Making revenue forecasting more reliable with scenario modeling helps B2B leaders assess uncertainty, protect budgets, and plan growth with greater confidence.
A revenue forecast can seem robust up to the point when a handful of big tickets fall through the cracks in the next quarter. Now, hiring plans don’t align with the expected demand, marketing budgets are being questioned, and leadership is rethinking their growth goals. The issue is not so much the numbers, but the underlying assumption in the numbers.
If you’re a B2B enterprise, dependable revenue forecasting can’t be done by simply extrapolating from past performance into the upcoming quarter. The sales cycles shift, buyers delay buying, and contract values vary based on pricing pressure. Scenario Modeling can aid revenue leaders in determining the impact on financial results and determining action to take in advance of the disruption to the operating plan.
Table of Contents:
Where Traditional Forecasts Miss the Mark
Build Scenarios Around Business Assumptions
Select the Right Modeling Method
Connect Forecast Changes to Operational Decisions
Recognize the Limits of the Model
Where Traditional Forecasts Miss the Mark
The typical revenue prediction models are based on pipeline value, past win rates, average contract value (ACV), and projected closing dates. These inputs are useful as a benchmark when the market’s conditions have remained relatively stable. They lose their reliability, however, if a number of commercial variables are changing simultaneously.
Let’s take a B2B software company that has a solid enterprise pipeline. The duration of opportunities increases if procurement teams take a while to buy, and expected bookings slide into the following quarters. There can be discounts that salespeople might give to get a sale, which reduces the average contract value. Meanwhile, the marketing function is still directing expenditure towards objectives, which are no longer aligned with buyer behaviour.
A model that only accounts for the expected close rate will be missing these broader financial impacts. May overstate the match of near-term revenue without changing outlook of hiring commitments and spending plans.
It’s not the fact that historical data have lost its value. It’s because historical averages are not necessarily representative of what the business has yet seen.
Build Scenarios Around Business Assumptions
The process of revenue forecasting involves scenario modeling, which involves testing different scenarios based on the current operating plan and how changes in key assumptions play out. The teams don’t agree on one possible number; they consider some possible scenarios.
There are three scenarios that would make sense to consider as a point of departure:
- Baseline: Pipeline conversion, contract values, and renewal rates are largely similar to current levels.
- Upside: If there is increased demand or deal progression, more bookings will come in during the quarter.
- Downside: Slower buyer decisions, diminished pipeline development, or reduced renewals = diminished revenue.
Let’s say a company has a forecast of $10 million in bookings for each quarter. On the negative side, it makes the assumption that 15% of qualified pipelines are not created, sales cycles are lengthened by 30 days, and discounting reduces the average contract value. Every change is related to a different stage of the sales process. The model should include the effect of both risks, but not the double counting of the same risk.
The updated forecast then enables leadership to scrutinize spending commitments, scale back sales capacity, or postpone planned investments. The goal is to learn about the impact of conditioning change, not to create a more complicated spreadsheet.
Select the Right Modeling Method
The model should be as complex as the decision it is supporting. There are three methods that address many of the forecasting needs in business.
Scenario analysis is a comparison of various operating conditions, including increased demand and continued slowdowns. It’s appropriate for executive planning since each outcome can be linked to a response. Its drawback is that it doesn’t consider less obvious combinations of events in a small number of scenarios.
Sensitivity analysis is used to assess the impact of a single assumption upon the forecast. Financial teams may consider the impact of a longer sales cycle, decreasing renewal rate, or change in contract value. This reveals those assumptions to which we should pay particular attention, but it will not necessarily include all interactions between variables.
Monte Carlo simulation involves repeating calculations with probability distributions of uncertain inputs. It can make an approximation of different scenarios and the probability of achieving the target revenue. The results, however, are dependent on the quality of the input data and the validity of the assumptions. A complex simulation is not a substitute for good evidence.
In many B2B businesses, scenario analysis and sensitivity testing are sufficient to inform decision-making without involving them in an overly complex forecast process.
Connect Forecast Changes to Operational Decisions
When a scenario model comes to shape the allocation of resources by leaders, it becomes an earner of its place. This includes having well-defined ownership of assumptions and thresholds of action agreed to.
First, some of the variables that are most critical to revenue must be identified. Depending on the business, they can be a qualified pipeline, opportunity conversion, deal slippage, renewal performance, or expansion revenue. Identify the owner for each variable and when action should be taken to consider a change to the forecast.
Financial outcomes should also be differentiated from early warning signs; teams should do this. Fewer qualified opportunities may indicate lower sales pipeline volumes, and numerous delays in the procurement process may indicate a longer sales cycle. None of these will ensure a loss of revenue, but both should be explored prior to the end of the quarter.
Then, state the reaction to each change in materials. When marketing is in decline, consider spending money on other marketing areas that have higher conversion rates. When confidence in renewal is low, account managers need to get in earlier. Lastly, although there is one bad forecast, the basis for hiring should be different, and hiring should be based on the new forecast of demand.
This is most effective when the common assumptions are shared between sales, marketing, and finance. Sales validates opportunity progression, Marketing validates pipeline quality, and Finance validates impact to revenue and cash flow. The model is realistic in the real operating conditions provided by the input.
Recognize the Limits of the Model
Detailed scenario analysis is possible with some businesses but not others because of the lack of historical evidence. The conversion pattern may not be consistent when new markets, new products, and new ways of selling are introduced. They might use a probabilistic simulation, but a simpler one which incorporates cash runway, present opportunities, and explicit assumptions may be more useful.
A second threat to well-established businesses is the misinterpretation of modelled probabilities as facts. Forecasts should be checked against actuals and assumptions should be adjusted when customers’ behavior changes; teams should identify common mistakes. However, even a sophisticated model will reinforce the old mental pattern with it.
The quality of the assumptions behind the numbers that drive the revenue forecast is a key factor in making better predictions, and what leaders do with those predictions. Organizations that engage in B2B can utilize scenario modeling to explore uncertainty before it affects budgets, staffing, and growth plans. The advantage of its use is not to be able to predict all the market moves, but rather to help the business prepare for the necessary changes.
