Learn how to build a financial model to forecast your P&L and make it dynamic.
Take our Finance and Valuation course: https://www.careerprinciples.com/courses/finance-valuation-course
DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/644bc2d12cc6cca29ac045e0

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

LEARN:
Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
The complete Finance and Valuation course: https://www.careerprinciples.com/courses/finance-valuation-course
Excel for Business and Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
All our courses: https://www.careerprinciples.com/courses

SOCIAL NETWORKS:
My company's YouTube channel: https://www.youtube.com/@careerprinciples
Instagram – https://www.instagram.com/careerprinciples/?hl=en
TikTok – https://www.tiktok.com/@career_principles
LinkedIn – https://www.linkedin.com/company/careerprinciples/

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

Chapters:
0:00 – Introduction
0:33 – Income assumptions
2:37 – Fixed and variable cost assumptions
6:03 – Preparation of the forecast income statement
10:28 – Energizing with scenario analysis

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

Please feel free to connect and share this video with your friends and family if you find it useful.