Scenario modeling

View how to build best and worst cases without copying your model, and compare them side by side with variance.

How scenario modeling works in Drivetrain

Keep your base case as it is and build scenarios on top. Change only what you want to test, link scenarios across models and compare the results side by side.

1
Create a new scenario from any model
- Open the scenario menu in any model, then name a new scenario or pick one that already exists.
- Each new scenario starts identical to the base case, with the same structure, dimensions and data sources already in place.
2
Adjust assumptions in a best case scenario
- Change drivers such as deal targets or average revenue per account for the regions and segments you expect to grow.
- Edits stay inside the scenario and don't change the base case.
- Anything you leave unchanged keeps inheriting from the base case.
3
Build a worst case scenario
- Switch to another scenario from the same menu and lower the assumptions you want to stress-test.
- Copy and paste values across periods, just as you would in a spreadsheet.
4
Reuse scenarios across linked models
- Use the same scenario name, such as best case, in both revenue and expense models.
- Data flows across linked models, so consolidated forecasts stay aligned to each scenario.
5
Compare scenarios side by side with variance
- Add several scenarios to any table, as columns or rows.
- See the variance and percentage variance against the base case, calculated for you.
- Switch between monthly, quarterly and yearly views.
6
Compare scenarios visually in charts
Plot scenarios against each other in a chart, such as a line chart, to see how far outcomes spread over time.

How Drivetrain simplifies scenario modeling

Build upside and downside cases in the same model, instead of a new spreadsheet for each one.
See every scenario next to the base case, with the variance already calculated.
Run the same scenario across revenue and expense models, so consolidated forecasts stay aligned.

FAQs

Does Drivetrain require copying the model to create a new scenario?

No. Scenarios live inside the same model. A new scenario starts identical to the base case, with the same structure, time summaries, dimensions and data sources.

In Drivetrain, if the base case is updated, does the best case change too?

Yes, for anything the scenario hasn't changed. Values edited in a scenario stay independent and don't affect the base case, while everything else continues to inherit from the base case.

Can Drivetrain use the same scenario across revenue and expense models?

Yes. The same scenario name, such as best case, can be used in several models. Drivetrain flows data across linked models, so consolidated forecasts stay aligned to each scenario.

How does Drivetrain compare scenarios?

Side by side. Multiple scenarios can be added to any table as columns or rows, and Drivetrain calculates the variance and percentage variance against the base case. Results can be viewed by quarter or year, or plotted in charts.