Create an account to use AI

Create a free account to unlock all features:

Ask questions about videos with AI
Use smart search (AI)
Save your favorite videos
Bookmark your favorite categories
Organize your favorite subcategories
Access your personalized favorites page
Access your conversation history
Personalize your homepage with your favorites

Create an account

Already have an account? Log in

Build a 3-Statement Financial Model [Free Course]

Wall Street Prep

Build a 3-Statement Model completely from scratch in 90 minutes. Get the Complete Excel Model for this course at https://www.wallstreetprep.com/free-course-template/?utm_source=ytfmc

We'll go step-by-step to create a 3-Statement Model that links the income statement, balance sheet and cash flow statement.

Timestamps

00:00 Course Introduction and Model Structure

03:53 Before We Begin: The Premium Package

05:56 Historical Income Statement

12:22 Projected Income Statement

21:06 Historical Balance Sheet Assets

26:10 Projected Balance Sheet Assets

29:36 PP&E Roll-Forward Schedule (Depreciation, Capital Expenditures)

39:28 Historical and Projected Balance Sheet Liabilities

47:05 Historical and Projected Balance Sheet Equity

1:00:20 Cash Flow Statement (Excluding Financing)

1:10:25 Cash Flow from Financing (Debt Schedule)

1:18:02 Revolver and Interest ("Finishing Touches")

Build a 3-Statement Financial Model [Free Course] | Knoovi