Summary
Keywords
Full Transcript
Make a 3-statement financial model built from scratch in Excel. Full tutorial with free template! 📈 Take our Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🆓 DOWNLOAD the Free Excel file for this video: https://careerprinciples.myflodesk.com/f64zoavpdx In this video, you'll learn to make a 3 statement financial model from scratch. First, we'll have a set of assumptions to forecast our income statement. Then, we'll work on the fixed assets schedule to forecast depreciation. Third, we'll work on calculating the interest expense to finalize our income statement. Following the income statement, we'll work on the balance sheet forecast. We'll skip the cash and revolver line items for later in the video. Then, we'll calculate the cash flow statement and plug the ending cash balance back into the balance sheet. Finally, we'll set up a revolver (revolving credit facility) to make sure we don't run out of cash when having a negative forecast. We will also solve any circularity (circular reference) errors we might have in the process. 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/all-courses SOCIALS: 📸 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 - 3 Statement Model Intro 0:28 - Forecasting the Income Statement 6:10 - Fixed Assets Schedule 9:52 - Interest Expense Forecast 10:53 - Balance Sheet Assumptions & Forecast 20:40 - Building the Cash Flow Statement 25:43 - Revolver (Revolving Credit Facility) 30:55 - Fixing Circular Reference Error
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
