For our example, we will analyze several financial scenarios. In the Excel document, I have defined the key input variables that will drive the scenario analysis: revenue growth, cost of goods sold, ...

How to use Scenario Manager in Excel You’ll find that the Scenario Manager is easier to use, but you must ensure the relevant data has already been added to the spreadsheet before moving forward.

Figure A We’ll use this simple mortgage calculator to demonstrate Excel’s Scenario Manager. Refer to Table A to build this sheet if you like, or download the example file.

Sure enough, Excel has a perfect tool for that job, and you probably won’t be surprised to learn it’s called Scenario. It lets you create an ensemble of basic circumstances and then, as you make ...