Create an Excel scenario: How it works

First, click into the cell next to the Selected model entry. You can find the scenario manager in the Data tab. In the Datentools group, click the What-If Analysis icon. In the submenu, select the Scenario Manager command. The dialog window of the same name is opened. Click the Add button. The Add Scenario dialog box is displayed. In the Scenario Name input, type the text Basic 5%.


Create the first scenario


Now it is about the changeable cells. Only the model name and the interest rate should be changed.


Lesetipp


Note: Each scenario can contain a maximum of 32 variables.


Add more scenarios


Therefore, click into the cell next to the Selected model name, then hold down the [Ctrl] key, and then click in the cell next to interest rate. This creates two cells that are not immediately adjacent to each other. Click the OK button. The Scenario Tools dialog box is displayed. Tap the selected model: 5% model. The second field should already be 0.05. Click the Add button to return to the Add Scenario dialog box.


Call the different models


Now additional scenarios with different interest rates are to be added. Rename the next scenario using BestCase 4%. So this is the cheapest offer. By clicking on the OK button, you enter the following window and enter the model name: Model with 4%. In the Interest rate field enter: 0.04. By clicking the Add button you get the possibility to create another model. This gets the name WorstCase 6%. This is the highest expected interest rate.


Click on the OK button to enter the following window. The selected model receives the name model with 6% and the interest rate of 0.06. You can create as many scenarios as you want, but these three models are an example. Click the OK button to display Scenario Manager.


In Scenario Manager, you will find the Scenarios list box. Select the scenario to display in this list box. Clicking on the Display button computes the values ​​with the selected model and displays them in the table.


This is how you quickly call up the individual scenarios and see the results. But the scenario manager can do more. The Add button allows you to create additional scenarios. Click the Delete button to delete the selected scenario. To edit a scenario, click the Edit button. For a clear overview of all values ​​in a spreadsheet, use the Summary button.