F1F9 | Online course | Best Practice Financial Modelling

Best Practice Financial Modelling online

Best Practice Financial Modelling is designed for professionals who need to build, modify or run financial models. For those with limited experience, the course is an excellent introduction to real world financial modelling. Experienced modellers find the quality and productivity of their modelling improves through the introduction of a standardised approach to model design and construction.

What will you learn?

The Best Practice Financial Modelling course will teach you solid modelling techniques which will enable you to model financial statement based forecast models – including valuation methodologies, scenario managers and sensitivity analysis.

By the end of the course, you will be able to:

Read and understand financial models
Create a model containing the Income Statement, Balance Sheet and Cash Flow from scratch based on an existing assets basis
Build models that are easy to review and understand, and for colleagues to adapt while you are on holiday

Why should you sign up?

This course combines clear video tutorials with self-assessed modelling assignments and online support. You can view and revisit the tutorials as many times as you like and take advice from our modelling team as you implement the techniques in your own modelling.

This course is CPD certified for 25 hours.

Book your course

Change currency

Date

Format

Location

Duration

Instructor

Price

Any

Video Based

Online

25 hours approx

Andrew Berkley

$497

Any

$497

Location

Online

Instructor

Andrew Berkley

Duration

25 hours approx

Format

Video Based

Full list of modules

Primary Financial Statements

Placeholders
Calculation blocks
Corkscrews
Row anchored links
Copy or link?
Quick charts
Import / export
Equity

Revenue Price

Constants
Pyramid structure
Formatting numbers
Flags
Embedded constants
Precedents and dependents
Editing a formula
Revenue price

Revenue Demand

2D calculation blocks
F1F9 macros
Find & replace
Revenue demand

Revenue Summary

Revenue summary case study

Operating Costs

Writing a good label
Sign conventions
Sign switch
Operating Costs

Escalation

Day counts
Date functions
Data picks
ISNA
Escalation

Deferred Tax

Counterflows
MIN and MAX
Goal seek
Deferred Tax

Business Operations

How to review a FAST model
Business Operations analysis
Model build challenge: Hotel Raja part 1

Non Current Assets

Initial balances
Accounting depreciation
Look back functions
Capital expenditure

Tax Effects of Non Current Assets

Tax depreciation

Working Capital

Accounts receivable
Accounts payable

Business Assets

Business Assets
Model build challenge: Hotel Raja part 2

Equity Finance

Share capital
Dividends

Debt Finance

Scenario selection (nested IF and CHOOSE)
Scenario selection (OFFSET)
Scenario selection (INDEX)
Senior debt principal repayment
Senior debt interest I
Senior debt interest II

Business Finance

Business Finance
Model build challenge: Hotel Raja part 3

Key Outputs / Analysis

Sensitivities & scenarios
NPV and XNPV
IRR and XIRR
Valuation
Ratios

Quality Control

Track sheet I
Track sheet II
Checks & alerts

Model Finalisation

Placeholders
Flags
Relocating inputs
Model build challenge: Hotel Raja part 4
Model build challenge: Hotel Raja part 5
Model build challenge: Hotel Raja part 6

Find out more:

DOWNLOAD COURSE BROCHURE

Course reviews

Many thanks to Andrew, Aroop and Sukirti for this course. It was very well-organized, usefull and interesting. Instructors were very helpful and friednly. I lookforward to apply the knowledge gained during the course in practice. I think that all the information covered in the course was usefull and effective in its presentation.

[name not given]

October 11, 2021

Amazing teacher, really precise in his answers to our questions. Really interesting lessons. Thank you Omar

G B

September 28, 2021

Due to his great enthusiasm and incredible expertise, the instructor, Omar Shaker, has made the course a learning experience to remember, most definitely! I would personally recommend him without question. Thanks, Omar!

Ryan Rewat GST

September 28, 2021

Thank you again to Andrew and Aroop for this training! Only suggestion would have been to do the course on 3/4 days in a row basis for practicality! But I assume this is not always easy to schedule :) ! Thank you again as I have learneduseful tips on financial modelling!

[name not given]

September 28, 2021

Thank you for this interesting course and positive feedback on each assignment. As repetition is the mother of learning, for me, it would have been probably helpful to have the main shortcuts repeated at the beginning of each course day, when you use them. An alternative, could have been to show them in the chat during the first 10 minutes of the day.

[name not given]

September 28, 2021

Andrew and Aroop definitely haveexceptional knowledge of the material and this comes accross in the way the course is delivered. The format of 3 sessions a day with breaks in between is very good. I also liked the way that assignments were set and reviewed in the following session. With the course beingspread over 2 weeks, it was much easier to keep up to date with other work using the off days.

Alex Houghton-Dodd EBRD

September 13, 2021

This was one of the best trainings I've ever participated in while at the EBRD. No, this was the best training! Incredible work, Andrew and Aroop are the best. Very well structured contents, quality and helpful pre-course that allowed me to dive in the course and be aware of some topics prior to the first session. Superb ability to engage participants and explain challenging notions and concepts. And wow are you fast with Excel. At the same time no bragging but a lot of motivation for the participants. That was insipred! Very well done and look forward to attending other trainings led by Andrew and Aroop. Thank you guys! Everything was up to the point and served either as a refresher for those who knew some staff or a very valuable info.

Artur Petrovich EBRD

September 13, 2021

Very well presented and thought through course with sections/parts logically linked together for better understanding and specific exercisers that provide hands on learning of each step. I liked the chat with quick reminder of the shortcuts throughout the presentations. All topics were useful to understand the structure of the model better and how to make it work efficiently and without mistakes.

A G

April 7, 2021

A D

March 31, 2021

[name not given]

March 22, 2021

The part on CAPEX straigh line depreciation was very valuable to me since it is a tricky part for new modelers.

G L

March 8, 2021

I liked the clarity of the explanations. Even for someone who's not in accounting or financial controlling, I was able to follow the theory very well. Overall, I believe the FAST standard and the helpful keyboard shortcuts will help me to improve my modelling tremendously. My only remark to the format would be the limited video resolution and poor audio quality. When updating the course, I would improve on these points. Other than that, I was very happy with the format.

M V

February 26, 2021

I enjoyed the macros and enhancing my ability to navigate around Excel. Having someone describe the case study solutions, explain key strokes, and slower videos would help.

[name not given]

February 12, 2021

I liked the excel techniques

Miguel

December 29, 2020

A M

December 15, 2020

[name not given]

December 11, 2020

The chapter Sensitivities and Scenarios is a very useful technique, it is so easy to manage and compare

[name not given]

September 16, 2020

A K

September 8, 2020

M V

September 5, 2020

All good.

C G

July 21, 2020

V V

July 17, 2020

H W

July 6, 2020

S B F

July 1, 2020

I think the course reach the most important aspects of modeling, however, I do feel the course could add a module for managing inventory, so it can explain how inventory and cost of goods are related and ways of how could it be model.

F E

June 26, 2020

L V

May 28, 2020

Excellent balance between practical application of theoritical principles and technical excel skills.

D C T

May 17, 2020

M Z

May 14, 2020

X H

May 8, 2020

I did the course online and had to take fairly regular breaks due mainly to the presentation style. While I understand it is a serious course, the standard presentation approach throughout the modules had me battling to concentrate after a period of time. As a comparison, another "craft" I studied online was computer programming through Harvard"s CS50 course. Presentation there was a lot more entertaining, allowing for longer concentration spans. Otherwise the course was absolutely fantastic.

F M

April 19, 2020

K D

April 6, 2020

R L

April 3, 2020

I liked that there were two cases to practice and videos showing how to do the steps.

C C-C

March 25, 2020

Very good explanation of different modelling aspects.

M V

March 22, 2020

[name not given]

October 5, 2020

J V

February 27, 2020

K M

January 27, 2020

The format is easy to follow. Mouse-free instruction was very beneficial to me. There is almost nothing to critisise. May be video recording for Hotel Raja case studies would be nice to have.

O G

January 26, 2020

D S

January 23, 2020