This modelling course equips participants for analysing and valuing complicated transactions such as mergers, acquisitions or LBOs (leveraged buyouts).

Subjects covered on our merger course include acquisition processes, accounting treatments and analysis, key risks together with deal structure and financing.

This course is designed for people who, in a short space of time, want to explore how a model can be used to analyse particular commercial challenges. How could we use a model to, for example, model a new deal, value an acquisition target, or analyse an acquisition or a buy out? What are the similarities, differences and uses of the various approaches?

This course covers a lot of broad ground and always sparks lots of interesting discussion. The course is probably best suited to someone who has some experience of modelling but, in a focussed way, wants to explore how a model can be used for different purposes.

The course combines some of the best bits from our most popular programs – and covers merger, valuation and LBO modelling in one program.

This course is run in an interactive, participative format, where participants learn by doing. The key concepts covered in the main teaching sessions are punctuated and illustrated by detailed case and modelling work.

Much of the course work involves Excel modelling and analysis, equipping participants with the tools to analyse leveraged acquisitions and mergers:

  • Building up from partially-complete models
  • Working with integrated financial statements
  • Developing the acquisition structure and modelling instruments
  • Running scenarios, iterating and optimising.

Case work on the course

As part of their work on this course delegates model transactions based on real-life mergers and acquisitions

The approach has been designed to equip participants to put key concepts into practical use immediately.  Delegates will be led through a comprehensive review of analysis practices, from initial principles through to more advanced techniques that are used in transaction analysis.

By the end of this course, participants will understand:

  • Drivers on M&As (mergers and acquisitions)
  • How to model integrated financial statements
  • How to use financial statements to value a business
  • How to model the balance sheet impact of acquisitions, spin-offs and demergers and prepare pro-forma acquisition accounts
  • How to model and present the impact of changes in deal structure, financing mix and capital structure, together with the impact on value
  • How acquisition debt facilities can be structured and modelled
  • Drivers on debt capacity and the interests of debt holders
  • Risks and rewards to different parties.

You can see the full outline for the merger course

Merger modelling outline

All our course reviews are publicly available, with past training delegates’ feedback forms all listed online.

As a result of using high-quality trainers, and teaching in very small class sizes, delegates’ course reviews consistently show very strong feedback for our financial modelling course training.


You can see what other delegates have said about their course with us

Course reviews

Our trainers will come to your company.

If you have 3-4 employees who may be interested in the same course in-house training will likely prove cost effective.



Course reviews

Read our reviews