Learn to make a financial model to forecast your P&L and make it dynamic.
Take our Finance & Valuation Course: https://www.careerprinciples.com/cour...
DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/644bc2...

In this video we'll build a financial model in just 4 steps. First, we'll make a revenue forecast using the number of orders and the order value. Then, we'll work on forecasting the variable expenses (COGS) and the fixed expenses (SG&A). Third, we'll build the income statement and the profit margins based on the assumptions. Finally, we'll make the model dynamic by creating scenario analysis using the choose formula on Excel.

LEARN:
Power BI for Business Analytics: https://www.careerprinciples.com/cour...
The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
All our courses: https://www.careerprinciples.com/courses

SOCIALS:
My Company YouTube Channel:    / @careerprinciples  
Instagram https://www.instagram.com/careerprinc...
TikTok   / career_principles  
‍ LinkedIn   / careerprinciples  

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ ​ Intro
0:33​ Revenue Assumptions
2:37 Fixed & Variable Cost Assumptions
6:03 Building the Income Statement Forecast
10:28​ Making it Dynamic with Scenario Analysis

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