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. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Accounting Template, Scenario Analysis Excel: What-If Model Excel (XLS) Spreadsheet, Flevy
Did you need more documents?
Consider a FlevyPro subscription from $39/month. View plans here.
For $14.00 more, you can download this document plus 2 more FlevyPro documents. That's just $13 each.
Project Management Process Mapping Energy Industry Project Planning Workbook Consulting Proposals Oil & Gas Proposal Template Tender Consulting Sales Order Management Integrated Financial Model Renewable Energy Solar Energy Gantt Chart Templates
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |