Financial Modelling

City Training UK

Course summary

1 day

750 GBP excl. VAT

English

London

4.8 (8 Reviews)

City Training UK

Open / Scheduled

Request Information

Course description

Financial Modelling Training Course

Financial Modelling - A One-Day Training Course

This course from City Training in London has been designed to develop the participants’ understanding of Financial Modelling. Based on Excel case studies, the participants will use best practice modelling rules and Excel shortcuts, learning how to forecast and create a fully integrated financial model based on real historical financial statements. This training will give the basic modelling fundamentals to work on in-house models.

Key Topics in this course

Using Excel keyboard shortcuts
Using standards for best practise
Understanding circular references and iteration
Modelling a detailed three-statement financial model step-by-step
Modelling a detailed debt schedule include a cash sweep
Finding errors and integrity checking

About the trainer:

Robert has 20 years of experience in Accounting and Corporate Finance in London. He started his career in auditing at KPMG in London, where he focused on industrial and service clients. He then moved to the Corporate Finance department of KPMG in London where he completed successfully a variety of M&A transactions in the mid-market segment. Robert then set up his own Corporate Finance practice in London and has been training since 2010 on a regular basis Accounting, Financial Statement Analysis and Corporate Finance at leading institutions worldwide.

Robert has an MSc in Physics from Oxford and is a fully qualified Chartered Accountant.

Request Information

Suitability - Who should attend?

This course is designed for participants who are:

Financial analysts in investment banks
Junior equity research
Junior investment managers
Finance functions at corporations
All other interested Finance professionals

Training Course Content

The content of this course is split into three sessions:

Session 1 Financial Modelling Fundamentals

Participants will learn how to model and integrate the income statement, balance sheet and cash flow of a real company using Excel. In addition to learning the steps necessary to build a three statement financial model, participants will also cover how to build models accurately and efficiently through a series of best practice modelling rules. Participants also learn how to stress-test the assumptions used, to check their work efficiently and to document it.

Using keyboard shortcuts
Setting Excel up for maximum efficiency
Working with key modelling formulas and structures
Building 3-statement projections
Modelling cash and revolver
Addressing standards for good models
Constructing the income statement, balance sheet and cash flow statement
Introduction to checking methodologies
Performing audit trails
Incorporating interest income and expense

Session 2 Three Statement Modelling

Through the process of building a more complex three statement model, participants are taught how to model operating cash and calculate interest using average debt and average cash balances. The session is designed to expose participants to different three statement modelling styles: multi-sheet, tower, and different income statement layouts. Exposure to a mix of modelling styles will help prepare them to work on in-house models or models they may inherit from other finance professionals.

Modelling operating cash, excess cash and the revolver
Calculating interest on cash and debt balances
Working with intentional circular references
Avoiding non-intentional circular references
Building models with different styles and layouts
Calculating ratios

Session 3 Financial Modelling & Forecasting

Participants will learn how to build a three statement model using a detailed revenue forecast with price and volume drivers. A full debt schedule, including a cash sweep, is incorporated into the model. Common errors are covered from balancing a non-balancing balance sheet to debugging a model that is non-intentionally circular.

Complex 3 statement models
Modelling a detailed revenue forecast
Modelling a cash sweep
Modelling a detailed debt schedule include a cash sweep
Consolidating and re-applying knowledge of circularity, iteration, and a toggle switch
Building cash flow statements from scratch
Troubleshooting techniques for cash flow statements
Finding errors and integrity checking

Session 4 Integrity & Error Checking

Common errors are covered from balancing a non-balancing balance sheet to debugging a model that is non-intentionally circular.

Troubleshooting techniques for cash flow statements
Finding errors and integrity checking
Using Excel tools to help with integrity checking
Finding unidentified hard numbers quickly and easily
Using Excel’s “Jump tool” to trace through formulas with ease
Using Excel to show the formulas underlying output
Using Excel to find inconsistencies in the model
Using Excel’s auditing tool to trace formulas

Expenses

The cost of this training programme for Financial Modelling is £750 plus VAT per delegate.

About provider

City Training is a highly-distinguished supplier of premium public courses, in-house training, and courses for universities and schools. The company focuses solely on financial training and covers the areas of financial accounting, corporate finance, valuation, credit analysis, regulatory capital, mergers and...