Scenario analysis, sensitivity analysis and what-if analysis are very similar concepts and are really only slight variations of the same thing. The worst-case scenario for Maria is a gross income of $70,000 and a cost of goods sold amounting to $35,200. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek. Simulating the future, under various set of assumptions, allows scenario analysis - which when combined with different optimization techniques, allows prescriptive analysis to be performed. This study gives a structured overview over the broad range of scenario-methods, including important combinations with other methods of futures-analysis. In Scenarios, Stories, Use Cases: Through the Systems Development Life-Cycle, Ian F. Alexander and Neil Maiden write about the types of scenarios and when to use them in software development. This leaves Maria with a gross profit of $34,800. Scenarios uncover inevitable or near-inevitable futures. Instead, it presents several alternative future developments. All are very important components of financial modelling – in fact, being able to run sensitivities, scenarios and what-if analysis is often the whole reason the model was built in the first place. Scenario analysis is a process of analyzing future events by considering alternative possible outcomes (sometimes called "alternative worlds"). As the analysis underlying each scenario proceeds, you often identify some particularly powerful drivers of change. You can use the tools and techniques beyond software, and as a great way to help you connect with customers, design better products and foster innovation. By using scenario analysis, she will be able to determine different possible income values and then, perform probability analysis. Scenario analysis is a what-if analysis in which a model's output is calculated for a number of scenarios. Scenario analysis and planning is a useful tool for exploring plausible futures of SES (Bengston et al., 2012). 4 Scenario analysis differs from techniques such as sensitivity analysis, forecasting or value at risk (VaR). In another example, a bank might attempt to forecast several possible scenarios for the economy (e.g. Scenario Analysis and Planning. A sufficiently broad scenario-building effort yields another valuable result. For example, a firm might use scenario analysis to determine the net present value (NPV) of a potential investment under high and low inflation scenarios.. Sensitivity analysis is the process of Sensitivity analysis is the process of recalculating outcomes under alternative assumptions to determine the impact of a particular variable. Scenario analysis is most commonly used in finance to estimate the expected value of an investment in a number of situations (such as best case scenario, base case scenario and worst case scenario). Thus, scenario analysis, which is one of the main forms of projection, does not try to show one exact picture of the future.