BXL's EZ Scenarios

Beyond Excel's (BXL's) Add-in:

EZ Scenarios

BXL's EZ Scenarios

Easily add scenarios to existing models! This works with any model (Financial, FP&A, Engineering, etc.) and any model type (FAST, BPM, SMART, Table Based, etc.). Available scenarios include:

  • Discrete Scenarios like Best Case, Base Case, Worst Case scenarios.

  • Sensitivity Analysis with tornado charts used to determine which inputs have greatest impact on outputs

  • Monte Carlo Simulations with Histograms and Scatter plots to determine what are likely outcomes given a range of possible inputs.

  • Combo Scenarios that identify which combination of inputs and values yield the best result.

We can do all these things without changes of any kind to existing models, and it does it better than Excel’s built-in scenario functions

Here is How it Works

Below left is a tutorial adding a Sensitivity Analysis to an existing model, without changing the model in any way! Below right is how to use BXL's Dynamic Form which makes entering input locations, input values, and output locations simple.