James Gilpin – Financial Modelling

James Gilpin – Financial Modelling course is now available at an affordable price. You can check out directly using multiple payment gateway options. If you have any questions or need an alternative payment method, feel free to contact us.

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

Delivery Policy

When will I receive my course?

You will receive a link to download/view your course immediately or within 1 to 24 hrs. It may takes few minutes, also few hours but never more than 24 hrs. Due to different time zone reasons.

How is my course delivered?

We deliver courses through Google Drive or Telegram. Once your order is complete, you?ll receive an email with a Google Drive or Telegram channel access link to view/download the course.

In case you submit a wrong email address, please contact us to resend the course to the correct email.

Where can I find my course?

Upon completing your order, a link to download or access the course will be sent to your email. Alternatively, you can find it in the ‘My Account’ download section.
If you do not see it there, please share a screenshot of your order and payment with me on Telegram at @ bossallcourses_bot to ensure prompt assistance. I am highly responsive on Telegram.