Build a 3-Statement Financial Model [Free Course]
Wall Street Prep Wall Street Prep
43.9K subscribers
159,054 views
0

 Published On Premiered Jun 13, 2022

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-c...

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")

show more

Share/Embed