CorporateFinanceAcademy.com
Scenario Analysis is an extremely useful finance and accounting tool. In this video learn how to do scenario analysis decision making by doing scenario analysis in excel. We will briefly explain sensitivity analysis vs. scenario analysis and most importantly we will walk you through two examples of how to apply scenario analysis in financial statements and in a capital expenditure decision process.
0:00 Overview of Scenario Analysis
2:27 Sensitivity Analysis vs. Scenario Analysis
3:20 Scenario Analysis in Excel - Income Statement
7:27 Downside Case
10:20 Scenario Analysis in Excel - Investment
14:14 Summary
