Merger and Acquisition Modeling

Following the successful delivery of several training programs on “hard” corporate finance skills in the Netherlands, London, New York and Asia I offer since 2015 an open programme primarily focussed on analyst and associates of investment banks, corporate finance boutiques, corporate finance advisors, private equity firms, M&A departments of corporates and equity analyst. Based on my experience as an active corporate finance advisor/valuator and being affiliated with several universities, I will provide the courses with a nice blend between practice and theory. Participants of the training programme will improve their hard corporate finance skills and will be able to apply the learnings immediately after the modules in their day-to-day work. Furthermore, the training program gives the delegates an opportunity to network with their peers. 

In this two day course the participants will develop an integrated merger/acquisition-model in excel that enables them to analyse the transaction from both an equity and credit perspective. The course will start with basic valuation analysis of the target, followed by synergy modelling/valuation, assessment of deal structure, consolidation of financial statements of target and bidder, and modelling/evaluation of the funding structure. Based on the merger/acquisition-model, participants will sensitize for different transaction and funding structures and analyse the impact on key credit and equity metrics. In this course we will use a case study of an acquisition of a target company and the participants will develop a merger/acquisition-model in excel based on half completed spreadsheets/templates.

• Introduction to M&A
• Target and synergy valuation
• Analysing and modelling transaction structure
• Purchase Price Allocation
• Consolidating financial statements
• Analysing and modelling funding structure
• Deal assessment on key credit/equity ratios

Prerequisites are: intermediate accounting, basic valuation and financial modeling skills

Participants have to bring their laptop along and a pre course instruction will be sent before the course starts. The course venue is located on the Zuidas in Amsterdam (Atrium, Strawinskylaan 3051, first floor). The course venue is located nearby metro/train station Amsterdam Zuid. Lunch and drinks are included. The course will be held in English unless all of the particapants are Dutch. 

Hans Haanappel