Merger and Acquisition Modelling

Merger and Acquisition Modelling free download

Learn how to structure and model business integrations using best-practice techniques and sound financial assumptions

This intensive video-based course assumes a sound grasp of financial modelling techniques and awareness of the current accounting implications of M&A transactions.

During the course, delegates will construct a flexible integrated merger model capable of analysing the pro-forma credit ratios and combined profit metrics of a proposed transaction whilst also building the functionality to identify the optimal capital structure to be used to finance an acquisition. Best practice financial modelling and accounting techniques will be applied throughout.

Merger modelling presents a completely different accounting and technical challenge to preparing an integrated forecast for a single business. This course and the model built is relevant to both equity, debt and credit analysts and corporate financiers who are potentially involved in the origination of or financing of acquisitions.

In the programme we will produce a complete forecast for the recent acquisition of Shire Pharmaceuticals by Takeda of Japan and see the huge impact of the fair value adjustments in this transaction.

At the end of the programme delegates will:

• Be able to model a merger from scratch and more effectively populate and interrogate template merger models;

• Model all aspects of a merger including

  • goodwill and fair value adjustments,

  • refinancing

  • fees and correctly accounting for the different types

  • consolidation adjustments

  • synergies, nil-dilution synergies and control premia

  • deal sensitivity and establishing an optimal financing mix based on target pro-forma credit metrics