Build a Dynamic Financial Model in Just 15 Minutes
Learn to make a financial model to forecast your P&L and make it dynamic.
🔥 Take our Finance & 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'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/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: https://www.careerprinciples.com/courses
SOCIALS:
🎬 My Company 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 - 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.
Видео Build a Dynamic Financial Model in Just 15 Minutes канала Kenji Explains
🔥 Take our Finance & 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'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/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: https://www.careerprinciples.com/courses
SOCIALS:
🎬 My Company 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 - 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.
Видео Build a Dynamic Financial Model in Just 15 Minutes канала Kenji Explains
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Clear the Formatting of an Excel Sheet in One Click #shortsInvesting in Real Estate through REITsStorytelling with Data (Crash Course)5 Impressive Visuals You Didn't Know Excel Could DoAdd Subtotals Automatically in Excel #shortsMastering Excel: Top 10 Formulas You Need to Know5 Excel Formulas Everyone Should Know10 Hidden Time Saving Hacks in ExcelCell Referencing in Excel (When to add a $ in a cell)Split Excel Data into Multiple Sheets Automatically8 Excel Features You Probably Didn't Know!Make a Pivot Table Profit & Loss DashboardUseful Date Formulas in ExcelInflation Explained for BeginnersExcel for Finance: 10 Formulas You NEED to KNOWHow to HIGHLIGHT the Active Row ✅The Excel Trick I Use Every Day #shortsReplace Pivot Tables with the GROUPBY function in ExcelDid You Know This Excel Shortcut? #shortsOnly the Top 1% of Analysts Have These 5 Excel SkillsMaster the FILTER Formula in Excel (Beginner to Pro)