Financial modeling what-if analysis is a type of sensitivity analysis performed in Excel to test how changes in assumptions impact certain outputs in a model. Under the Data Ribbon in Excel, there are three types of what-if analysis: Goal Seek, Data Table, and Scenario Manager. In financial modeling and valuation, Goal Seek and Data Tables are the most commonly used types of sensitivity analysis.
CFI is a the official global provider of financial modeling and valuation analyst FMVA Designation. CFI's mission is to help anyone become a world-class financial analyst and has a wide range of resources to help you along the way. In order to become a great financial analyst, below are some additional questions and answers for you to explore further: