Essential Financial Modelling
Core financial modelling skills that every analyst should know
This Gridlines training course is endorsed by the IPFA
This course will transform your financial modelling skill set and confidence. You will learn to build a complete 3 statement financial model - from start to finish based on a solar project acquisition case study.
We will teach you the core financial model design and construction techniques every Project Finance / Infrastructure professional should know.
The course is the result of 20 years of experience in Project Finance modelling and knowledge built up teaching thousands of analysts how to be build better financial models, in less time, making fewer errors.
The course covers foundation level core modelling skills as well as advanced financial topics.
In a few weeks, this course will equip you to deliver effective and well constructed financial models.
Your Instructor
Kenny has spent the last 20 years in financial modelling both in delivery of financial modelling assignments in training of financial modelling professionals. He has trained thousands of modellers from the world’s leading commercial and investment banks, top tier accounting firms, infrastructure funds and developers.
Course Curriculum
-
Preview1.1 Part 1: Welcome (1:17)
-
Start1.1 Part 2: Introducing the Financial Modelling Handbook
-
Start1.2 Setting up your excel environment (Windows) (1:48)
-
Start1.3 The importance of keyboard shortcuts (1:52)
-
Start1.4 Introducing our Ninja modelling tools (3:17)
-
Start1.5 Ninja modelling tools: Formatting macros (2:53)
-
Start1.6 Ninja Modelling tools: Productivity macros (7:23)
-
Start1.7 Ninja Modelling Tools: Review macros (5:21)
-
Start1.8 Three ground rules for course participation (0:47)
-
Start1.9 FAQs
-
Start2.1 Introduction to core modelling skills
-
Start2.2 What makes models hard to read (2:24)
-
Start2.3 What makes models easy to read (1:37)
-
Start2.4 Understanding model structure (3:57)
-
Start2.5 Model structure part I: Workbook level (3:59)
-
Start2.6 Model structure part II: Worksheet level (5:45)
-
Start2.7 Model structure part III: Calculation block level (6:06)
-
Start2.8 Model structure part IV: Calculation block components (2:13)
-
Start2.9 Links Part I: When to create, when to copy (2:04)
-
Start2.10 Link Part II: How to navigate using links (2:16)
-
Start2.11 Links Part III: Why to avoid linking to a link (5:04)
-
Start2.12 How to use placeholders (5:17)
-
Start2.13 Why mark imports and exports (3:30)
-
Start2.14 The best keystroke in excel: F11 quick chart (1:12)
-
Start2.15 How to model balances (5:43)