What-If Model – Excel XLS

SCENARIO PLANNING EXCEL DESCRIPTION

What-If Model Excel Template: Download this financial scenario analysis tool to model impacts on company statements and prioritize initiatives effectively. What-If Model is an Excel template (XLS) available for immediate download upon purchase.

The What-If Model will allow a team the ability to model the potential financial impact of a variety of initiatives upon a company's financial statements. This scenario, or "what-if," modeling will incorporate the company’s historical financial statements and five-year projections in conjunction with inputs provided by the Quantitative Model.

The historical and projected financial statements provided by the client will serve as the models "base" or "null" state. The inputs provided by the Quantitative Model provide the variables to be modeled with the client projections.

The What-If Model will then provide expected changes in financial statements and financial statement metrics from the base assumptions. These expected changes allow the team to target and prioritize the scenarios with the greatest expected benefits. This prioritization will aid further discussions with management when determining further work to be performed.

Source: Best Practices in Scenario Planning, Management Accounting Excel: What-If Model Excel (XLS) Spreadsheet, Flevy