sensitivity-and-tornado

To create a tornado chart for risk assessment, you need a base financial model with defined input variables and outputs. The analysis ranks these input variables by their impact on the model output, visualizing which assumptions drive the results.

You can build one-variable and two-variable Excel Data Tables for sensitivity analysis by running this process on your base model. It requires specified input ranges and access to base model data to visualize the impact of input variations on outputs.

Sensitivity analysis evaluates how changes in model inputs affect outputs, identifying which assumptions drive the model. You need it after building a financial model to focus on critical variables and support strategic decision-making.

Yes, this tool requires the xlsx dependency and utilizes Excel Data Tables to perform sensitivity analysis. It operates directly on your base model data and specified input ranges within the Excel environment.

Yes, tornado charts rank input variables by their impact on the model output. This helps you identify and focus on the most critical assumptions driving your financial model during risk assessment.