Don't leave your financial model review to chance

Get Superpowers in Reviewing a Financial Model

START YOUR TRAINING

Did someone teach you how to review a model? Or did you figure it out yourself?

Hi, Kyle Chaning-Pearce here.

Let me ask you a question:

Could you imagine a surgeon being self taught? Can you imagine a Civil Engineer figuring out herself how to calculate the critical load failure mechanism in a building, completely unaided? 

So why do we expect people to be able to review (or build) financial models, on which billion dollar decisions are made… without any training?

If you’re already a Sherlock Holmes in the financial modeling world, look no further. However, if you need the ability to dig in, and discern the non-obvious… this course will teach you how to pull apart a financial model and scrutinise it from different angles.

Working in a role at a Professional Model Auditor, I saw people deconstruct models and be able to review them in as little as 30 minutes. Model review can take up to 200 hours... so how did they do it?

HOW TO REVIEW A FINANCIAL MODEL

Teaching financial modeling courses, it struck me that most people who encountered models didn’t need to build them, but they needed to know what they were doing for models they already had. And people felt they didn’t have the knowledge to tamper with “someone elses model” so they just did the bare minimum with the model and “shut their eyes and hoped for the best” when running the model.

This course will give you superpowers with Excel and Financial Modeling. You’ll breeze through model review, and finally interact confidently with Excel.

I’ve distilled everything I know about reviewing financial models and put it into bite size videos that break the process down. You’ll learn

  • The mindset you need to be efficient at reviewing financial models
  • Best Practice financial modeling, and worst practice
  • 6 Categories of Errors – I’ve taken years of experience and hundreds of models that I’ve seen and boiled it down into these lessons
  • Setup – you’ll see the Software and the Shortcuts that professionals use to make the job as easy as possible
  • In Module 6 you’ll learn about the four stages of the model review process, and see each step applied to a case study model
  • You’ll get your own case study model to review and write findings in Module 7. I’ll then provide a worked example review, as if you were “watching over my shoulder”
  • If you help to set your organisaitons policy- you’ll love the Reducing Errors in an Organisation module, which looks at the three main areas you can easily invest in, to quickly raise the bar and reduce risk across your organisation
  • Lastly look at more advanced review cases – speed up your review of multi-asset models, or if it’s a bigger more formal review, how to review iterations of models.

LEARN, PRACTICE, APPLY

WATCH THE TRAINING

Dive into the step-by-step 3 hour video training, showing you exactly how to review a model

PRACTICE YOUR SKILLS

Put your new found knowledge and skills to use with the case study - how many errors can you find?

APPLY YOUR KNOWLEDGE

Train hard, fight easy - Use the quick reference guide to jog your memory when you're reviewing your next model

Finally, Get The Training And Tools You Need

"After going through this course I feel like I have a secret weapon" - recent training participant

WHAT YOU ARE GOING TO GET

  • 3 hours of jammed packed video content

  • 30 Videos of jammed packed content

  • How to Review a Model PDF checklist

  • .xlsx case study model of an acquisition

  • Worked example of solutions to case study

  • LIFETIME Access to all the training material

Course Modules: Build Your Knowledge Step-By-Step

MODULE 1: Introduction, Course Aims & Structure   
Introduction to the Course 01:30
Course Aims & Structure 02:47
   
MODULE 2: the General Principles Behind a Successful Model Review  
The 6 General Principles 06:24
   
MODULE 3: Discover Financial Modeling Best Practices and See Examples of What Not To Do!  
Best Practices for Model Transparency and Robustness 12:30
   
MODULE 4: 6 Types of Errors and Examples of Each  
Best Practice & Anchoring Errors 02:51
Errors in Excel Formula & Use of Tools 05:20
Errors in Model Infrastructure & Module Specific Errors Like Tax or Working Capital Calculations 03:43
Other Errors - Omissions, Extras & Errors 04:33
   
MODULE 5: Your Excel Setup - The Software and Shortcuts to Speed up Your Model Review  
Introduction to Your Setup & How to Use Software to Speed up Your Review 08:42
The 8 Must Have Shortcuts to Speed Up Your Review 07:22
   
MODULE 6: Learn the Model Review Process to Triage Your Review and Get the Most Bang for Your Buck!  
Why to Triage Your Review and Introduction to the 4 Stages of the Model Review Process 08:44
The Commercial Review for Quick Wins and to Get in the Right Ballpark 07:24
The Systematic Extreme Value Review - Linking the Scenario Manager to Stress Test the Model 06:41
The Systematic Extreme Value Review  - Creating a CFW Data Table to Systematise Your Stress Test 08:31
The Systematic Extreme Value Review  - Interrogating Issues that Pop Up 08:56
Undertaking Other Checks like Trace Dependents, Macros etc 03:38
Getting into Cell by Cell  05:46
   
MODULE 7: Practice Your Skills with a Case Study Acquisition Model - Can Find All the Errors? [Worked Example Included]  
Introduction to the Small Business Acquisition Case Study and How to Review The Model  04:33
Worked Example of Conducting the Commercial Review - What Row Differences Reveals 08:44
Worked Example of Conducting the Commercial Review - A True Commercial Review with Transition Points 05:47
Worked Example of Commercial Review & Cell by Cell Review Side by Side - Using Row Totals to Indicate Errors 11:41
Worked Example of Systematic Review - Updating the Scenario Manager - Part 1 09:55
Worked Example of Systematic Review - Updating the Scenario Manager - Part 2 08:53
Worked Example of Systematic Review - Constructing the CFW Data Table to Systematise Stress Tests 02:55
Worked Example of Systematic Review - Conducting Extreme Value Analysis 05:41
Worked Example of Systematic Review - Interrogating Extreme Values to Find Errors 09:35
Worked Example of Cell by Cell Review - Finalising Review 02:22
Worked Example - Bringing Review Together with Analysis & Recommendations 03:27
   
MODULE 8: Beyond You: How to Reduce Errors Across Your Organisation  
Reduce Errors Across Your Organisation 03:40
   
MODULE 9: Extending Model Review Skills with Version Iterations & Multi-Asset Models  
Iterations & Multi-Asset Model Review 06:45
   
Course Closing  
Closing 00:44

"Kyle was fantastic – deep understanding of the overarching principals of modeling and finance, but also great knowledge of the nuts and bolts of it."

Gabriel Davies
Project Finance Professional

SIGN UP TODAY

Get instant access to How to Review A Model and learn Financial Modeling like you've never seen it before.

Close

50% Complete

Two Step

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.