Optimize - Scenarios
Increase/decrease inputs jointly to evaluate the impact on output.
Input Parameters/Data
Input Variable(s): Input driver(s) of the model. For each item, add Name, Reference and Change By value (i.e. increase, decrease or maintain value).
Output Variable: Output of interest (e.g. Valuation, Profit, NPV, IRR etc.). Add Name and Reference.
Individual Scenario Analysis: Toggle to run individual scenario analysis for each input variable.
Notes
Input Cell references can be any cell in Excel (i.e. including cells with formulas).
Output
Excel Chart: Output chart of the scenario analysis to visualize the changes in input(s) and the corresponding output.
Individual Scenario Outputs: Output charts of the individual scenario analysis for each input variable.
Data: Output data used for the chart(s).