Build a 3Statement Model completely from scratch in 90 minutes. Get the Complete Excel Model for this course at https://www.wallstreetprep.com/freec...
We'll go stepbystep to create a 3Statement 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 RollForward 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")