Financial Modeling What-If Analysis
Financial modeling what-if analysis is a type of sensitivity analysisWhat is Sensitivity Analysis?Sensitivity Analysis is a tool used in financial modeling to analyze how the different values for a set of independent variables affect a dependent variable performed in Excel to test how changes in assumptions impact certain outputs in a model. Under the Data Ribbon in ExcelExcel Modeling Best PracticesThe following excel modeling best practices allow the user to provide the cleanest and most user-friendly modeling experience. Microsoft Excel is an extremely robust tool. Learning to become an Excel power user is almost mandatory for those in the fields of investment banking, corporate finance, and private equity., there are three types of what-if analysis – Goal Seek, Data Table, and Scenario Manager. In financial modeling and valuationFMVA® CertificationJoin 350,600+ students who work for companies like Amazon, J.P. Morgan, and Ferrari
, Goal Seek and Data Tables are the most commonly used types of sensitivity analysis.
![Financial Modeling What If Analysis]()