Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Modelling
Building a Model in Excel Part 1
Introduction (2:11)
1 Before we Start (5:12)
2 Excel Settings (4:02)
3 Excel Shortcuts (4:23)
4 Formatting and Styles (7:11)
5 Building the Historic Subtotals (6:07)
6 Calculating historic ratios (3:49)
7 Forecasting the Income Statement (3:59)
8 Forecasting the Balance Sheet (8:29)
9 Building the Cash Flow Statement (6:16)
10 Balance the Balance Sheet (6:16)
11 Forecasting Interest (7:31)
12 Linking Interest to the P&L (7:07)
13 Sense Checking the Model (9:16)
14 Formulas Checking & Stress Testing (8:40)
15 Building Scenarios into the Model (7:33)
16 Intro to DCF Valuation (3:47)
17 Forecasting Unlevered Free Cash Flow (5:17)
18 Estimating Terminal Value (4:02)
19 DCF to Share Price Target (3:39)
20 Sensitivity Analysis (11:18)
21 Wrap Up (1:30)
BONUS SECTION: Building a Model in Excel Part 2
Welcome (3:32)
1 Before we Start: A Few Tips (7:01)
2 Introduction to the Practical Guide (1:25)
3 Forecasting the P&L (13:03)
3a Exercise
3b Exercise Solution
4 Income Statement (7:06)
4a Exercise Solution
5 Balance Sheet (6:24)
5a Exercise Solution
6 Additional Exercise Answer (0:28)
7 Cash Flow Statement (10:08)
7a Exercise Solution
8 DCF (9:40)
8a Exercise Solution
9 Sensitivity Analysis (4:05)
9a Exercise Solution
10 Multiples Analysis and Comps
Wrap-up (2:06)
13 Sense Checking the Model
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock