Your Instructor
James Gilpin is a chartered accountant (ACA), CFA charterholder (CFA) and former investment banker based in London, with over 20 years of practical and teaching experience. He makes learning Excel modelling simple, breaking down each process into easy to learn steps
Course Curriculum
Building a Model in Excel Part 1
Available in
days
days
after you enroll
-
StartIntroduction (2:11)
-
Start1 Before we Start (5:12)
-
Start2 Excel Settings (4:02)
-
Start3 Excel Shortcuts (4:23)
-
Start4 Formatting and Styles (7:11)
-
Start5 Building the Historic Subtotals (6:07)
-
Start6 Calculating historic ratios (3:49)
-
Start7 Forecasting the Income Statement (3:59)
-
Start8 Forecasting the Balance Sheet (8:29)
-
Start9 Building the Cash Flow Statement (6:16)
-
Start10 Balance the Balance Sheet (6:16)
-
Start11 Forecasting Interest (7:31)
-
Start12 Linking Interest to the P&L (7:07)
-
Start13 Sense Checking the Model (9:16)
-
Start14 Formulas Checking & Stress Testing (8:40)
-
Start15 Building Scenarios into the Model (7:33)
-
Start16 Intro to DCF Valuation (3:47)
-
Start17 Forecasting Unlevered Free Cash Flow (5:17)
-
Start18 Estimating Terminal Value (4:02)
-
Start19 DCF to Share Price Target (3:39)
-
Start20 Sensitivity Analysis (11:18)
-
Start21 Wrap Up (1:30)
BONUS SECTION: Building a Model in Excel Part 2
Available in
days
days
after you enroll
-
StartWelcome (3:32)
-
Start1 Before we Start: A Few Tips (7:01)
-
Start2 Introduction to the Practical Guide (1:25)
-
Start3 Forecasting the P&L (13:03)
-
Start3a Exercise
-
Start3b Exercise Solution
-
Start4 Income Statement (7:06)
-
Start4a Exercise Solution
-
Start5 Balance Sheet (6:24)
-
Start5a Exercise Solution
-
Start6 Additional Exercise Answer (0:28)
-
Start7 Cash Flow Statement (10:08)
-
Start7a Exercise Solution
-
Start8 DCF (9:40)
-
Start8a Exercise Solution
-
Start9 Sensitivity Analysis (4:05)
-
Start9a Exercise Solution
-
Start10 Multiples Analysis and Comps
-
StartWrap-up (2:06)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.