Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Excel Financial Modeling | Sensitivity & Scenario Analysis

Kenji Explains
791K subscribers
516K views 3 years ago
Use sensitivity analysis, scenario analysis, and goal seek/solver to evaluate different scenarios and forecast how a business is going to perform. 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour... 📝 Download the start file here: https://view.flodesk.com/pages/620fd8... 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 …...more
...more
Excel Financial Modeling | Sensitivity & Scenario Analysis
10KLikes
516,630Views
2022Feb 20
Use sensitivity analysis, scenario analysis, and goal seek/solver to evaluate different scenarios and forecast how a business is going to perform. 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour... 📝 Download the start file here: https://view.flodesk.com/pages/620fd8... 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: https://www.careerprinciples.com/cour... 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour... 🏦 The Investment Banking Program: https://www.careerprinciples.com/care... 🚀 All our courses: https://www.careerprinciples.com/all-... 📹 My FREE videos with MoneyUnder30: GEAR: 📹 My Favorite Books & Gear: https://kit.co/kenjiexplains ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 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.

Follow along using the transcript.

Kenji Explains

791K subscribers