Financial analysis
How to Build a Financial Forecast and Test Scenarios
A forecast is an expected path under assumptions; a scenario is an alternative assumption set used to explore possible outcomes.
Quick answer
A financial forecast builds an estimated path from historical data, business drivers, and assumptions. A scenario tests an alternative path when those assumptions change.
What is the difference between a forecast and a scenario?
A financial forecast is an estimated path under stated assumptions. A scenario is an alternative assumption set used to explore possible outcomes. A budget and a target are plans or commitments and should not be conflated with either.
Steps for a reviewable forecast
- Set the historical baseline and forecast period.
- Define revenue, margin, expense, and working-capital drivers.
- Document each assumption and its source.
- Separate the base forecast from alternative scenarios.
- Review the estimate as new data becomes available.
An illustrative scenario example
| Assumption | Base | Upside | Downside |
|---|---|---|---|
| Revenue growth | 10% | 15% | 5% |
| Gross margin | 40% | 42% | 36% |
| Operating-expense growth | 8% | 6% | 12% |
What should be tested?
Test sensitivity to revenue growth, margin, expenses, collection and payment timing, and branch or cash assumptions where data exists. Scenarios show a range of possibilities; they do not prove what will happen.
Understand profit versus cash: Why can a company be profitable and still run out of cash?
Explore financial forecasting and scenario analysis
Frequently asked questions
What is the difference between a forecast and a scenario?
A forecast is an estimated path under expected assumptions; a scenario is an alternative path used to test a change in one or more assumptions.
How often should financial forecasts be updated?
It depends on the business cycle and data availability; update when material data or assumptions change and document the reason.