Revenue forecasting is more art than science. You can have perfect historical data and still miss your number because of a surprise market event, a key deal slip, or a competitive loss.
That's where scenario planning comes in. Instead of predicting one future, build multiple scenarios: conservative, expected, and optimistic. This gives your leadership team a range of outcomes and helps you plan accordingly.
Why Scenario Planning Matters
A single-point forecast is often wrong. But a range of scenarios gives you three things:
- Confidence: You're not caught off-guard if results fall between scenarios
- Planning: Finance can budget for a range. Operations can scale resources up/down
- Risk Management: You identify downside risks early and can mitigate them
The Three-Scenario Framework
1. Conservative Scenario (30th Percentile)
This is your downside case. Assume:
- Longer sales cycles (add 20% to ACV close time)
- Lower win rates (reduce by 15-20%)
- More churn/attrition
- Key deals slip to next quarter
Purpose: Plan for the worst. If your conservative case still hits company goals, you're in good shape.
2. Expected Scenario (50th Percentile)
Your base case. Use:
- Historical close rates and deal sizes
- Current pipeline
- Typical seasonality
- Planned hiring/headcount additions
Purpose: Most likely outcome. This is your budget and plan.
3. Optimistic Scenario (70th Percentile)
Your upside case. Assume:
- Shorter sales cycles (reduce ACV close time by 15-20%)
- Higher win rates (increase by 10-15%)
- Larger average deal size
- New product/segment traction
Purpose: Show leadership the upside potential. Motivate the team.
Building Your Scenarios
Step 1: Segment Your Pipeline
Group deals by:
- Deal stage (discovery, demo, proposal, negotiation)
- Customer type (new business, expansion, renewal)
- Rep (tenure, track record)
Step 2: Assign Win Rates by Stage
Use historical data. Example:
- Discovery → Proposal: 40% win rate
- Proposal → Negotiation: 70% win rate
- Negotiation → Closed: 90% win rate
Step 3: Calculate Pipeline Value
For each deal, multiply deal size × win rate × probability of advancement by quarter end.
Step 4: Build Your Scenarios
- Conservative: Reduce win rates by 15-20%. Push deals out by a quarter
- Expected: Use current pipeline + historical assumptions
- Optimistic: Increase win rates by 10-15%. Accelerate key deals by 2-4 weeks
Commission Forecasting with Scenarios
Commission spend is a direct result of revenue. If you forecast revenue scenarios, you should also forecast commission spend.
Example:
- Conservative Revenue: $3.5M → Commission spend: $245K (7% of revenue)
- Expected Revenue: $4.2M → Commission spend: $294K (7% of revenue)
- Optimistic Revenue: $5.1M → Commission spend: $357K (7% of revenue)
This gives your Finance team a range for compensation budgets and helps avoid overspending in good quarters.
Scenario Planning Best Practices
- Update regularly: Review scenarios monthly. Pipeline changes, deals slip, new business closes
- Document assumptions: Write down why you chose each win rate, close time assumption. This helps when results diverge
- Track actuals vs. scenarios: Which scenario was closest? Use this to refine future forecasts
- Pressure-test: What if your largest deal slips? What if you lose your top rep? How do scenarios change?
- Communicate with leadership: Show all three scenarios, not just the expected case. Transparency builds trust
Using RevenuePulse for Scenario Planning
RevenuePulse's Scenario Simulator lets you:
- Build multiple forecast scenarios with different assumptions
- Run what-if analysis (e.g., "What if average deal size increases 20%?")
- Automatically calculate commission spend for each scenario
- Compare scenarios side-by-side
- Track actual results vs. forecasts
Conclusion
Scenario planning removes false precision from forecasting. Instead of pretending you know the future, build a range of outcomes. This gives your team confidence, helps planning, and keeps you mentally prepared for surprises.