Make a 3statement financial model built from scratch in Excel. Full tutorial with free template!
Take our Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...

DOWNLOAD the Free Excel file for this video: https://careerprinciples.myflodesk.co...

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:
The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
Power BI for Business Analytics: https://www.careerprinciples.com/cour...
All our courses: https://www.careerprinciples.com/courses

SOCIALS:
Instagram https://www.instagram.com/careerprinc...
TikTok   / career_principles  
‍ LinkedIn   / 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

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