Advanced Financial Modelling – 3 Days

This course is the next step after taking the Essential Financial Modelling course. It builds on the approach taken in Essential Financial Modelling, extending it to cover Leveraged Buy Out models and Acquisition models before going on to introduce more advanced areas of Excel knowledge

Computer models are used extensively in business acquisitions or mergers. These models quantify all financial factors that will affect the outcome. They are used to judge the benefits of the business combination and to determine the price that can be paid for the target company.

"Course was very well laid out and concise, packing a lot of learning into a short time"
Rates Analyst

"Very useful, especially as a refresher to M&A work and to consolidation"
Accountant

Acquisition models are normally very complicated. This is required to deal with the intrinsic difficulties of business combinations. Complex models regularly contain errors. These errors may be material enough to wrongly influence the conclusion about whether to proceed with a combination.

To answer this problem Coe & Co has developed a three day course to deal with modelling acquisitions and mergers and some of the other more advanced features of Excel.

The course is modular, combining lectures with many hands-on sessions. It takes a single case study and works through each of steps required to build a comprehensive acquisition model. This includes consideration of each of the accounting issues involved, which are explained using everyday language, and shows their practical effect.

Course contents:

Revision of best practice modelling techniques
Leveraged Buy Out models and LBO valuation
Drawing up accounts at an alternative year end
Satisfying the requirements of an acquisition model
Consolidation theory
Consolidated income statements, balance sheets and cash flow statements
Incorporating the funding instruments used
Calculating the cost of the funding structure
Differences between mergers and acquisitions
Data analysis functions in Excel
Creating and editing Excel macros
Advanced quality control

"The course clarified and consolidated my existing knowledge, reinforcing the principles taught on the Best Practice Modelling course"
Accountant

"Good logical approach was very easy to relate to"
Corporate Financier

"Useful to hear real life examples of where models have been used"
Equity Researcher

"Good focus on work, not waffle, felt we were using time beneficially"
Accountant

How will you benefit from this course?

You will benefit by gaining:

Knowledge of the theory and practice of LBO valuation
Experience of the practical issues surrounding acquisitions and mergers
Understanding how to structure acquisition models to give results quickly, accurately and efficiently
First hand experience of working all the way through an example, covering each step needed in an acquisition model
An introduction to performing data analysis in Excel
Experience of writing, recording and editing an Excel macro

Courses

Advanced Financial Modelling – 3 Days

Course contents:

How will you benefit from this course?