What-If Model (Excel XLS)

EXCEL DESCRIPTION

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.

Got a question about the product? Email us at flevypro@flevy.com.

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