Financial Modeling What If

Financial Modeling What If Analysis?

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.

Example Excel Model

Below is a screenshot from one of CFI’s online analyst training and certification courses.  To how how to build an excel model step-by-step, click on the image below.

financial modeling questions

Additional Questions and Answers

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:

Analyst Certification Program