M&A Modelling

This programme provides participants with a thorough and practical exploration of techniques for modelling and analysing LBO transactions in Excel. The programme is delivered almost entirely ‘through the spreadsheet’ with participants working in Excel building models for most of the time.

The programme goes beyond mechanical aspects of model construction and explores the key issues behind transactions being modelled. It considers acquisition models for both share and asset purchase (‘debt and cash free’); deals and covers both full and partial control transactions, as well as modelling joint venture and Associate investments.

Relevant IFRS transaction accounting is covered in detail before each modelling exercise and emphasis is placed on allowing for different offer prices and structures and incorporating details of any debt component of deal consideration. Full and partial disposal transactions, including IPO, spin offs, split ups and carve out structures, are covered. Incorporating transaction analysis, including forecasting and valuation of synergies, EPS accretion/dilution, contribution analysis, RoIC (standalone, transaction and pro-forma), analysis at various offer prices, pro-forma credit metrics and forecast rating and valuation of the pro-forma post-transaction entity, is covered in detail.
This programme provides participants with a thorough and practical exploration of techniques for modelling and analysing LBO transactions in Excel. The programme is delivered almost entirely ‘through the spreadsheet’ with participants working in Excel building models for most of the time.

The programme goes beyond mechanical aspects of model construction and explores the key issues behind transactions being modelled. It considers acquisition models for both share and asset purchase (‘debt and cash free’); deals and covers both full and partial control transactions, as well as modelling joint venture and Associate investments.

Relevant IFRS transaction accounting is covered in detail before each modelling exercise and emphasis is placed on allowing for different offer prices and structures and incorporating details of any debt component of deal consideration. Full and partial disposal transactions, including IPO, spin offs, split ups and carve out structures, are covered. Incorporating transaction analysis, including forecasting and valuation of synergies, EPS accretion/dilution, contribution analysis, RoIC (standalone, transaction and pro-forma), analysis at various offer prices, pro-forma credit metrics and forecast rating and valuation of the pro-forma post-transaction entity, is covered in detail.

NA

Any bankers working in roles that require them to build or analyse financial models of corporate acquisitions or disposals, in particular the course is relevant for corporate bankers, research analysts, corporate finance bankers, credit analysts and debt and equity capital markets professionals.

Reasonable familiarity with Excel, good knowledge of accounting and financial statement analysis.