Use sensitivity analysis, scenario analysis, and goal seek/solver to evaluate different scenarios and forecast how a business is going to perform.

📝 Download the start file here: [ Ссылка ]
👉 Excel for Business & Finance Course: [ Ссылка ]

1. Goal Seek / Solver: using goal seek, we can find an input to reach our desired output. For example, how many sales do we need to generate to make a million dollars. Excel Solver is the advanced version of this, where we can choose multiple inputs and set constraints to reach our desired output.

2. Sensitivity Analysis: using a sensitivity analysis table we can evaluate how changing a set of inputs will affect our profitability. The inputs we change are the price range and the quantity sold range. This is one of the functions on the What-If-Analysis section under the data tab of Excel.

3. Scenario Analysis: using a scenario analysis, we can see how different revenue and cost forecast will affect our profitability. For this we create a base, best, and worst case scenario, and use the choose formula to create a dynamic model.

LEARN:
📈 The Complete Finance & Valuation Course: [ Ссылка ]
👉 Excel for Business & Finance Course: [ Ссылка ]
📊 Get 25% OFF Financial Edge Using Code KENJI25: [ Ссылка ]

SOCIALS:
📸 Instagram - [ Ссылка ]
🤳 TikTok - [ Ссылка ]

📹 My FREE videos with MoneyUnder30:
- Index Funds Explained: [ Ссылка ]
- How to Invest: [ Ссылка ]
- Stock Market Investing: [ Ссылка ]
- How Zero Commission Brokers make money: [ Ссылка ]
- 50/30/20 Budgetting Rule: [ Ссылка ]

GEAR:
📹 My Favorite Books & Gear: [ Ссылка ]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Intro
0:27 - Goal Seek & Solver
6:25​ - Sensitivity Analysis
9:22​ - Scenario Analysis

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

свернуть