Trusted By:
1 Part Course  | 
Book places now

Modelling for Mergers & Acquisitions

Learn how to master the Modelling of Integrated Financial Statements

Modelling for Mergers & Acquisitions Training Course

A one-day live webinar

This course is a ‘must know’ for;

  • Corporate Financial professionals at all levels, with limited experience in M&A modelling
  • M&A professionals, seeking to identify and quantify value creation for their clients through the use of an M&A (mergers and acquisitions) model; and
  • Financial Analysts seeking to refresh and develop their modelling skills in modelling the impact of acquisitions on a client’s financial statements as well as a better understanding of the accounting implications

  • This course is hands-on with practical examples and illustrations in excel exercises and case studies
  • The trainer has qualified as a Chartered Accountant and is well qualified to understand both the accounting and financial aspects of the workshop
  • He has spent time working on building models to incorporate the financial effects of various types of transactions

  • Learn how to build a standard M&A model, which analyses all the key financial issues on an M&A transaction (sufficient for pitch purposes)
  • Learn how to build a fully integrated M&A model, combining acquirer and target financials

M&A Analysis and Modelling

During this course, you will build a fully integrated merger financial model which combines financial statement forecasts for an acquirer and target company M&A. Practical consolidation issues are addressed. The deal synergy analysis M&A focuses on the financing structure, pricing, earnings and credit impact of the deal. The three main ways of determining value creation for acquirer shareholders are emphasised, namely EPS (Earnings per share) accretion/ (dilution), Return on Invested Capital and PV of M&A Synergies vs. Bid Premium paid.

As an M&A case study, we will consider the hypothetical acquisition model of Adidas by Nike, and build both ‘short-form’ and ‘long form’ models.

Individual exercises will be undertaken to highlight the 3 key measures of value creation:

  • EPS accretion/ (dilution)
  • Return on Invested Capital
  • Present Value of deal synergies vs. premium acquisition model paid to target shareholders 

Key Topics:

  • Preparing the stand-alone data for acquirer and target
  • Preparing key deal data
  • Building a flexible funding structure using a sources and uses of funds table
  • Calculating deal goodwill
  • Accounting for a Non-Controlling interest
  • Enterprise Value to Equity Value bridge and deal adjustments in private M&A
  • Dealing with fair value adjustments to the target's net assets
  • Dealing with refinancing of target's debt
  • Modelling fees (advisory, debt-issuance and equity-issuance)
  • Consolidating the financial statements of acquirer and target
  • Synergies
  • Assessing the M&A valuation creation potential of the deal using: 
    • Earnings accretion / dilution and relative P / E analysis
    • Return on invested capital (ROIC) analysis
    • Net present value of synergies vs. control premium
  • Contribution analysis M&A
  • Impact on credit ratios and ratings
  • Analysis at various prices (AVP)
  • Identifying the maximum offer price and a suitable mix in project finance model 

 

After graduating from Cambridge University in 1993, the trainer worked as an auditor with Arthur Andersen, gaining a comprehensive knowledge of corporate accounting and financial statements. He qualified as a chartered accountant (ACA) and then worked in investment banking in the City of London, initially with HSBC and subsequently at Merrill Lynch. Throughout his time in the City, he was in a front-office role, advising companies on valuation, financing, acquisitions, foreign exchange and derivatives. This breadth of practical experience and his passion for sharing and communicating knowledge naturally then led him towards a career in financial training.

He has worked in financial training for the last ten years and delivered training courses on accounting, financial modelling, corporate finance, valuation and capital markets at investment banks, private equity and corporate finance firms worldwide.

This one-day workshop will guide participants through the mechanics of modelling M&A transactions with the end results which can be used to evaluate deals from the buyside perspective.

  • Good and knowledgeable lecturer.
  • Good to have two merger models with different [levels] of how advanced they are to use in future pitches and projects, and to get more understanding.
  • Very detailled course on M&A modelling, very useful for combining target accounts into the parent company and analysing the potential returns/impact of an acquisition. Good to understand the necessary adjustments that need to be made.
  • Good engagement from the trainer, asking different people to answer questions and complete excercises on screen. Very practical, which was ideal, was worried it would only be theory. Provided a bank of excercises/templates that will be useful when doing M&A modelling.
Number of places:

£795.00

Per participant

Discounts available:

  • 2 places at 25% less = £596.25
    per person
  • 3 places at 30% less = £556.50
    per person
  • 4 places at 35% less = £516.75
    per person
  • 5 places at 40% less = £477.00
    per person
  • 6+ places at 45% less = £437.25
    per person
  • 9+ places at 50% less = £397.50
    per person
  • ADD TO BASKET REQUEST CALL BACK

    Have this course presented In-House

    • On a date, time and in a location of your choice
    • Topics expanded or deleted to your bespoke requirements
    CLICK HERE TO REQUEST A FEE QUOTE

    Have this course pre-recorded

    • Full course recording edited exclusively for your company
    • Files converted to enable housing on your LMS
    CLICK HERE TO REQUEST A FEE QUOTE

    We use cookies

    In order to show you courses tailored to your profession we use cookies.

    To enjoy all the features of this website please accept.