Optimize - What Ifs
Backsolve combined input changes required for a specific output.
Input Parameters/Data
Input Variable(s): Input driver(s) of the model. For each item, add Name and Reference (cell reference of its value).
Output Variable: Output of interest (e.g. Valuation, Profit, NPV, IRR etc.). Add Name and Reference.
Output Settings - Direction: Select direction of change - Increase or Decrease.
Output Settings - Change By: Select % of change in output variable.
Output Settings - Scenarios: Toggle to run scenario analysis for each input variable.
Notes
Input Cell references can be any cell in Excel (i.e. including cells with formulas).
While there are multiple solutions for an optimization problem, Fontic's solver provides a practical solution for most professionals i.e. wherever feasible, apply a pro-rata change across inputs.
Output
Excel Chart: Output chart to visualize the inputs change required for the selected output change.
Individual Scenario Outputs: Output charts of the individual scenario analysis for each input variable.
Data: Output data of required input changes and their weighted impact on the output.