James Gilpin – Financial Modelling

Learn to build a 3 statement financial model

What You’ll Learn In Financial Modelling

Building a Model in Excel Part 1

• Introduction (2:11)
• 1 Before we (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 : 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)

About James Gilpin

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