Scenario Analysis in Excel! Scenario Analysis DECISION MAKING!
ฝัง
- เผยแพร่เมื่อ 27 มิ.ย. 2024
- 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
very easy to understand, thanks
Great !!!!
Great analysis. Many thanks.
thanks for the kind words!
Thanks for the Video.Please suggest how we can do in data validation.Thanks
can you be more specific?
Thanks.Best,Best and worst case we can keep in list of Data validation and outcomes can performed on (for price and quantity variables)
Could you send the excel template?
Good day! May I know what SG&A stands for?
Selling, General, and Administrative
Great
Could you send the excel template?