Setting a revenue target is relatively easy.
Figuring out what has to change in the business to actually produce it is much harder.
Suppose your company wants to produce $100 million in bookings next year. You model your current revenue engine using actual pipeline, conversion, sales cycles, capacity, retention, expansion and historical performance.
The prediction comes back: $84 million.
That’s not necessarily bad news. In fact, it’s extremely useful information.
Because now you know the problem you’re trying to solve.
You don’t have a $100 million planning exercise.
You have a $16 million Revenue Engineering problem.
The question becomes: What needs to change in the revenue system to produce another $16 million?
That’s where what-if scenario analysis comes in.
Table of Contents
- What Is What-If Scenario Analysis in Revenue Planning?
- Why Start With a Baseline Revenue Prediction?
- Which Revenue Levers Can You Model?
- Does More Pipeline Always Produce More Revenue?
- How Does Conversion Affect a Revenue Scenario?
- How Do Sales Cycle and Timing Affect the Plan?
- How Does Sales Capacity Affect Revenue Growth?
- How Do Retention and Expansion Affect the Model?
- How Do You Find the Most Efficient Path to the Target?
- How Do You Turn a Scenario Into an Operating Plan?
- How Does ayeQ Use What-If Scenario Analysis?
- Frequently Asked Questions
What Is What-If Scenario Analysis in Revenue Planning?
What-if scenario analysis is the process of changing one or more assumptions in a revenue model to understand how those changes affect the predicted revenue outcome.
In B2B revenue planning, those assumptions might include pipeline creation, conversion by stage, sales-cycle length, average deal size, sales capacity, retention, expansion or other variables that influence revenue performance.
Instead of assuming the company simply needs “more pipeline” or “better conversion,” leadership can test those assumptions.
For example:
- What happens if Marketing creates 15% more qualified pipeline?
- What happens if conversion improves at one particular stage?
- What if the average sales cycle decreases by 10%
- What happens if we add two sellers in Q1?
- What if those sellers don’t reach full productivity until Q3?
- What if retention improves by three percentage points?
- What if expansion revenue increases?
And ultimately: What combination of changes gets the revenue engine from $84 million to $100 million?
That’s a very different exercise from taking a $100 million target and dividing it among the revenue teams.
It turns annual planning into a system optimization problem.
Why Start With a Baseline Revenue Prediction?
Scenario analysis is only useful if you have a credible starting point.
Before modeling a better future state, leadership needs to understand what the current revenue system is positioned to produce.
That means using actual operating performance wherever possible: historical pipeline creation, current pipeline, stage-by-stage conversion, sales cycles, average deal sizes, Sales capacity and productivity, retention and expansion.
Different revenue streams should also be modeled independently when they behave differently.
The result is a baseline prediction: If we don’t materially change how this revenue engine operates, what is it positioned to produce?
That becomes the control case against which other scenarios can be compared.
If the baseline prediction is $84 million and the target is $100 million, every scenario can now be evaluated against the same $16 million gap.
Without a baseline, scenario planning can easily become a collection of optimistic assumptions.
With one, leadership can see exactly how much each proposed change moves the predicted outcome.
Which Revenue Levers Can You Model?
The specific revenue levers will depend on the company’s business model, but a B2B revenue model will often include variables such as:
- Pipeline creation
- Pipeline by revenue stream
- Opportunity volume
- Conversion by sales stage
- Average deal size
- Sales-cycle length
- Sales capacity
- Seller productivity
- Ramp time for new sellers
- Customer retention or churn
- Expansion revenue
The important point is that these variables don’t operate independently.
Changing one part of the system can create requirements—or constraints—somewhere else.
If Marketing generates substantially more pipeline, Sales needs the capacity to work it. If conversion improves, more opportunities advance into later stages and consume resources there. If Sales capacity increases, the business may need additional pipeline to keep that capacity productive. If retention declines, new-logo bookings may have to compensate for the lost revenue.
Revenue is the output of an interconnected system.
That’s why changing one number in a spreadsheet isn’t the same thing as modeling a revenue scenario.
Does More Pipeline Always Produce More Revenue?
No.
This is one of the most important reasons to model the entire revenue engine.
When a company has a revenue gap, the default answer is often: “We need more pipeline.”
Sometimes that’s true.
But suppose the current constraint isn’t pipeline creation. It’s conversion.
Sending substantially more opportunities into a system with poor conversion may simply create more lost opportunities.
Or suppose Sales is already at capacity. Creating another $20 million in pipeline won’t necessarily create the expected bookings if the organization doesn’t have enough capacity to work those opportunities effectively.
Timing matters too. If the sales cycle is nine months, pipeline created late in the year may have little impact on that year’s bookings.
The better question isn’t: How much more pipeline do we need?
It’s: Which constraint is preventing the revenue engine from producing more?
Sometimes the answer will be pipeline. Sometimes it won’t.
How Does Conversion Affect a Revenue Scenario?
There isn’t just one conversion rate in a B2B revenue engine.
Opportunities move through multiple stages, and every transition has its own conversion rate.
Those rates may also differ significantly by revenue stream.
A company may convert extremely well once an opportunity reaches proposal but lose too many opportunities between discovery and solution development.
Another may move opportunities efficiently through the middle of the funnel but lose an unusually high percentage at the final stage.
An overall win rate can hide both problems.
Scenario analysis lets leadership get more specific: What happens to bookings if conversion at this particular stage improves from X% to Y%?
Then the model can calculate how that change flows through the rest of the revenue engine.
This also makes the resulting plan more actionable.
“Improve win rate” isn’t much of an operating instruction.
“Improve conversion from Stage 3 to Stage 4 from 42% to 48% in our enterprise new-logo stream” is something the organization can actually investigate and manage.
How Do Sales Cycle and Timing Affect the Plan?
Annual planning is constrained by time.
An opportunity that takes nine months to move from qualification to close cannot be treated the same way as an opportunity with a 60-day sales cycle.
The timing of pipeline creation therefore matters.
Suppose a scenario requires Marketing to generate an additional $20 million in qualified pipeline. That may look sufficient mathematically.
But if most of that pipeline needs to contribute to bookings during the planning year, when does it need to exist?
If the sales cycle is long, the required pipeline may need to be generated in Q1 or Q2—not Q4.
Scenario analysis can also test the effect of shortening the sales cycle.
What happens if the average cycle decreases by 10%? Does that meaningfully increase bookings during the planning period?
If so, improving velocity may be a more efficient lever than simply generating substantially more demand.
The model helps expose that tradeoff.
How Does Sales Capacity Affect Revenue Growth?
Pipeline doesn’t close itself.
Sales capacity places a practical constraint on how much opportunity volume the organization can effectively manage.
If the model indicates that the company needs substantially more pipeline to hit its target, leadership also needs to ask:
Do we have enough Sales capacity to work it?
If not, the scenario may require additional sellers.
But that introduces another variable: ramp time.
Hiring five sellers in June doesn’t necessarily create five fully productive sellers in June. Recruiting, onboarding and ramp time determine when that additional capacity can begin contributing meaningful output.
A credible scenario therefore needs to model both how much capacity is required and when that capacity becomes productive.
Otherwise, the revenue plan can assume output from resources that don’t yet exist.
How Do Retention and Expansion Affect the Model?
For recurring-revenue businesses, growth doesn’t begin at zero on January 1.
The existing customer base is already part of the revenue engine.
That means retention, churn and expansion need to be included in the growth model.
Consider two scenarios for closing a revenue gap.
One requires a significant increase in new-logo pipeline.
Another requires a smaller pipeline increase combined with better retention and more expansion from existing customers.
Both may theoretically produce the same overall growth.
But they could require very different levels of investment and carry very different execution risks.
This is also why annual revenue planning shouldn’t be built independently by Sales, Marketing and Customer Success.
The performance of each function affects the output of the same revenue system.
How Do You Find the Most Efficient Path to the Target?
This is where what-if scenario analysis becomes especially powerful.
Suppose the baseline revenue prediction is $84 million and the target is $100 million.
Leadership develops three scenarios.
- Scenario A closes the gap primarily through a substantial increase in qualified pipeline.
- Scenario B combines additional Sales capacity with improvements in stage conversion.
- Scenario C combines a smaller pipeline increase with improved conversion, retention and expansion.
All three scenarios may produce $100 million in the model. But that doesn’t make them equally attractive.
Each may require different investments, hiring plans, process changes and levels of execution risk.
So the question becomes more sophisticated than: Which scenario gets us to $100 million?
It becomes: Which combination of changes gives us the most achievable path to $100 million with the least amount of additional resources?
That’s optimization.
And it’s one of the fundamental differences between setting a growth target and engineering a growth plan.
How Do You Turn a Scenario Into an Operating Plan?
Once leadership identifies a scenario it believes the organization can execute, the model can work backward from the desired outcome.
If $100 million requires a particular amount of qualified pipeline, Marketing can understand what it needs to produce.
If the model requires a certain number of qualified opportunities, BDR can understand its requirement.
Sales can see the pipeline required at each stage, the conversion assumptions behind the plan, and the capacity and productivity required to support it.
Customer Success can see the retention and expansion assumptions required from the existing customer base.
Finance can see where additional investment or capacity needs to be added and when.
Now the company isn’t simply aligned around a $100 million target.
It’s aligned around the system required to produce $100 million.
That’s when a revenue target becomes an operating plan.
And it leads to the next important question:
What exactly does each team have to produce for the plan to work?
We’ll tackle that in our next article.
How Does ayeQ Use What-If Scenario Analysis?
ayeQ uses actual CRM opportunity and performance data within a governed revenue model to establish a baseline prediction and model how changes to revenue levers affect future bookings.
Through ayeQ Annual Plan Builder, B2B companies can model revenue streams, pipeline requirements, stage-by-stage conversion, sales cycles, capacity and other performance assumptions.
Companies can then create what-if scenarios to evaluate how different combinations of changes affect predicted performance and determine what would have to be true for the revenue engine to produce the desired target.
The selected scenario can then be translated into aligned performance requirements across Marketing, BDR, Sales and Customer Success.
The objective isn’t simply to build a forecast.
It’s to answer:
What has to change for our revenue engine to produce the number?
Frequently Asked Questions
What is what-if scenario analysis?
What-if scenario analysis is the process of changing one or more assumptions in a model to evaluate how those changes affect the predicted outcome. In B2B revenue planning, companies can adjust assumptions such as pipeline creation, stage conversion, sales-cycle length, deal size, capacity, retention and expansion to understand their potential impact on future bookings or revenue.
How is scenario analysis used in revenue planning?
Scenario analysis allows leadership to compare different paths to a revenue target. A company can first establish a baseline prediction of what its current revenue engine is positioned to produce, identify the gap between that prediction and the target, and then test combinations of operational changes that could close the gap.
What revenue levers can be modeled in a what-if scenario?
Common B2B revenue levers include pipeline creation, opportunity volume, stage-by-stage conversion, average deal size, sales-cycle length, Sales capacity and productivity, seller ramp time, customer retention, churn and expansion. The appropriate variables depend on the company’s revenue model and revenue streams.
How is what-if scenario analysis different from revenue forecasting?
Revenue forecasting primarily estimates what a business is likely to produce based on current pipeline, historical performance and other assumptions. What-if scenario analysis evaluates how that predicted outcome changes when underlying assumptions change. Forecasting helps answer “Where are we headed?” Scenario analysis helps answer “What would we have to change to get somewhere else?”
Can scenario analysis determine whether a revenue target is achievable?
Scenario analysis can help leadership determine whether the assumptions required to reach a revenue target are supported by historical performance, capacity and available resources. It cannot guarantee that the target will be achieved, but it makes the assumptions behind the plan explicit so leadership can evaluate whether the proposed path is credible and executable.
Does increasing pipeline always increase revenue?
Not necessarily. Additional pipeline may have limited impact if another part of the revenue system is constraining growth. Poor stage conversion, insufficient Sales capacity, long sales cycles or timing can all limit how much additional pipeline converts into bookings. Scenario analysis can help identify where the primary constraints exist.
Why should conversion be modeled by sales stage?
Every transition in a B2B sales process can have a different conversion rate, and those rates may also vary by revenue stream. Modeling conversion stage by stage provides a more precise view of how opportunities move through the revenue engine and can reveal where conversion improvements would have the greatest effect.
How does Sales capacity affect a revenue plan?
Sales capacity determines how much opportunity volume the organization can effectively work. A plan that requires substantially more pipeline may also require additional sellers or improved productivity. Because new sellers require time to recruit, onboard and ramp, the timing of additional capacity should also be reflected in the revenue model.
How do retention and expansion affect revenue planning?
For recurring-revenue businesses, retention determines how much existing revenue remains, while expansion determines how much additional revenue can be generated from existing customers. Both can materially affect the amount of new-logo growth required to achieve the overall revenue target.
What is revenue scenario modeling?
Revenue scenario modeling is the process of creating alternative sets of assumptions within a revenue model and comparing their predicted outcomes. It allows leadership to evaluate multiple potential paths to a growth target before committing resources to a particular plan.
How does ayeQ perform what-if scenario analysis?
ayeQ combines actual CRM opportunity and performance data with a governed revenue model. Companies can establish a baseline prediction, change assumptions across revenue levers, compare resulting scenarios, and translate a selected scenario into aligned performance requirements across the revenue organization.