Hellow guys, Welcome to my website, and you are watching Build a Dynamic Financial Model in Just 15 Minutes. and this vIdeo is uploaded by Kenji Explains at 2023-05-07T10:45:00-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Build a Dynamic Financial Model in Just 15 Minutes |
| Video Uploader | Video From Kenji Explains |
| Upload Date | This Video Uploaded At 07-05-2023 13:45:00 |
| Video Discription | 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. |
| Category | Education |
| Tags | financial model | excel financial model | 3 statement model | three statement model | excel financial modeling | financial modeling | build a financial model | dynamic financial model | financial model from scratch | forecasting | excel forecasting | build a financial model in 15 minutes | excel dynamic model | scenario analysis excel | profit and loss statement excel | income statement excel | build an income statement | forecast an income statement | choose formula excel |
