Financial Modeling for Acquisitions in Excel
Edward Bodmer

Objective
Financial Modeling for Acquisitions in Excel will provide participants with the ability to create and understand different types of acquisition models. Through building models in a hands-on environment, you will be better able to value the benefits and costs of different types of merger and acquisition transactions; to quantify the risks to lenders and equity investors in a transaction; and to create efficient and transparent analyses.

Key benefits

Who should attend?
Financial professionals involved in analysis of mergers and acquisitions who are interested in creating acquisition models or who simply would like to understand how to interpret models created by others.

Prerequisite
Financial Modeling for Acquisitions in Excel makes extensive use of computer case studies, therefore all participants are required to have a solid, basic knowledge of Excel prior to attendance. An academic or equivalent background, and/or relevant professional experience is required.

Accreditation
Amsterdam Institute of Finance is registered with CFA Institute as an Approved Provider of continuing education programs. This program is eligible for 18 CE credit hours as granted by CFA Institute. If you are a CFA Institute member, CE credit for your attendance at this event will be automatically recorded in your CE Diary.

Additional information
Participants will need to bring a laptop computer equipped with Microsoft Excel 2000 or higher for use during the program. The Excel Solver add-in and the Analysis Tool-Pack add-in should be installed. If requested, a laptop can be provided at an additional charge.

Faculty
Edward Bodmer teaches a number of modeling courses and is a consultant who specializes in financial analysis and modeling. He is also a lecturer at the Center for Energy Economics at the University of Texas at Austin.

For information about admission, please see our Practical Information.

Program Content
Day 1

Part I –  Introduction

Exercises 

Part II  –  Acquisition Exercises

Participants will complete a series of case exercises that represent components of an acquisition model. The exercises include setting up a model to evaluate alternative holding periods, developing a pro-forma balance sheet, modeling of different debt issues, cash flow sweeps, a cash flow waterfall, debt defaults and Monte Carlo simulation.

Exercises

Day 2

Part II  –  Acquisition Exercises continued

Day 3

Part III – Valuation Modeling in Acquisitions

This part addresses valuation and risk analysis issues that arise in acquisition analyses. Rather than examining basic valuation issues, this component of the course covers problems that arise in valuation relating to stock options, high cost debt, income taxes and other items. Measurement and valuation of synergies will also be covered.

Exercises