Euromoney Audit Training

A 4-day computer based program with case studies and workshop sessions featuring:

• M&A and Structure of Financial Models
• Standalone Valuation in a Merger Transaction
• Risk Assessment and Cost of Capital
• Synergy Analysis
• Leveraged Buy-outs
• Accounting and Financing Structures in M&A
• Technical Project Finance Modeling Issues
  

 

 

MODULE I: Day 1

Morning: Introduction to M&A and Structure of Financial Models

The course begins with introductory comments about the skills for effective modeling and general objectives
in financial modeling for M&A transactions. After the introductory discussion, the course covers the empirical
evidence on the performance of M&A endeavors.
Issues include: Is there and economic rational for mergers?  After an acquisition has been completed, how should we determine whether it has been a success or a failure? Can we find any successful mergers? Not with-standing the media hype, have what is the empirical evidence on the success of mergers? What does a real-world M&A model look like? What are the real incentives of investment bankers with respect to M&A transactions? How should modeling of a merger be structured?

LECTURES

• Review of Basic Terminology in M&A
• History of M&A
• Studies on M&A Effectiveness
• Event studies
• LBO’s
• Recent history
• Selected Examples
• Financial Statement Review for M&A
• Stock price and financial returns
• Price to earnings ratios and EV/EBITDA
• Return on equity and return on capital employed
• Value/Book and Value to Replacement Cost
• Debt/Capital, EBIT/Interest, Debt/EBITDAX
• Model Layout for M&A
• Financial model overview
• Transaction structure in M&A models
• Organization of M&A models

CLASS EXERCISES
• Exercise 1a: Review of Modeling in Actual M&A
Transaction
• Exercise 1b: Simple Financial Model of an Acquisition

MODULE II: DAY 1

Afternoon: Construction of Basic Financial Model

Participants in the course will learn how to build a model from a blank slate. The first modeling session covers
development of a basic model, given capital expenditures, revenues and expenses. Issues addressed include: How can we make the models flexible enough to use historic financial data, future projections and estimates of residual value? What should the financial statements look like in our models? What are some of the excel rules that guide accurate and efficient development of models? How can financial models be audited to check errors that we will make? What should we do to incorporate alternative debt structures and interest during construction into the model?

LECTURES

• Comments on spreadsheet style and conventions
• Building block approach to modeling
• Basic Mechanics of Financial Models
• Separation of historical period from projection period
• Sources and uses of funds statement in transaction
• Cash flow, net income, equity balance, construction financing and income taxes
• Construction of a balance sheet and use as an auditing tool
• Conversion of Investment to Corporate Model
• Historical financial statements and reconciliation
• On-going capital expenditures and depreciation
• Mechanics of modeling outstanding shares
• Modeling of short-term debt and temporary securities
• Working Capital
• Balance sheet approach
• Use of revenue and expense ratios
• Cash flow effects
• Mechanics of Adding Debt to Financial Models
• Debt balance tables
• Inclusion of interest expense, debt repayment
and debt balance
• Credit quality measures

CLASS EXERCISES
• Exercise 2a: Base Model Layout and Financial
Statements without Debt
• Exercise 2b: Addition of Debt to the Basic Model

MODULE III: DAY 2

Morning: Standalone Valuation in a Merger Transaction

The second day begins with the valuation discussion by introducing the concept of free cash flow in decision
making. Participants will learn the mechanics of computing free cash flow from financial statements and will consider how free cash flow can be practically applied in valuation of stocks. Issues addressed include: How do investment banks come up with valuation of acquisition candidates? What are the pros and cons of various valuation methods (other than getting the answer that we want)? How do investment
banks present results of their valuation analysis? How can we get our hands around the residual value? What multiple method is best in various industries? What does the price to earnings really mean in terms of value generated by a company? How do the mechanics of alternative valuation techniques work?

LECTURES
• Discounted Free Cash Flow
• Theory and economic value analysis (EVA)
• Free cash flow without leverage
• Cost of capital applied to free cash flow
• Residual value
• DCF Compared to payback rule and accounting
earnings criteria
• Use of Multiples in Valuing Acquisition Candidates
• Alternative Multiples (P/E, EBITDA/ Value, M/B)
• Rational behind alternative multiples
• Multiples in transactions versus ongoing companies
• Multiples and valuation by business segments
• Valuation multiples in case study

CLASS EXERCISES

• Exercise 3a: Analysis of Valuation in Merger Transactions
• Exercise 3b: Derivation of Implied Cost of Capital from Price Earnings Analysis
• Exercise 3c: Application of Alternative Valuation Techniques in the Financial Model

MODULE IV: DAY 2

Afternoon: Risk Assessment and Cost of Capital

After covering valuation, we move to risk assessment in the valuation models. Risks are evaluated through application of the cost of capital, sensitivity analysis and simulation using volatility of cash flows. Issues addressed in this section include: What basis should be used for evaluating cost of capital given how badly the CAPM has been discredited? How do investment banks compute cost of capital in M&A analysis? What fundamental value drivers create risks in M&A modeling? Given all of the difficulties in measuring cost of capital and residual value, what alternative approaches to free cash flow should be used? What are the pros and cons of using alternative multiples in valuing acquisition candidates? How can tornado diagrams be applied in M&A applications? How useful are option pricing concepts related to creating time series equations with volatility and using Monte Carlo Simulation is assessment of risk?

LECTURES
• Cost of Capital and Decision Making Investment decisions and cost of capital
• Cost of capital and valuation
• Cost of capital applied to free cash flow
• CAPM and its limitations
• Computation of Cost of Capital using Alternative Methods
• Dividend growth model
• Debt capacity model
• Risk premium method
• Implied cost of capital in financial ratios
• Merton model in valuation of equity
• Implied cost of capital from reverse engineering financial models of similar companies
• Adjustments to cost of capital for taxes and leverage
• Adjustments to beta for leverage
• Computation of all-equity beta
• Adjustments for interest expense
• Risk analysis of economic assumptions
• Commodity price risk
• Technology risk
• Input and supply availability risk
• Foreign currency and political risk

CLASS EXERCISES

• Exercise 4a: Time Series Model of Copper Prices
• Exercise 4b: Break-even case using Southport Minerals
• Exercise 4c: Inclusion of Sensitivity Analysis and Tornado Diagram in Southport Case

MODULE V: DAY 3

Morning: Synergy Analysis

A merger or acquisition involves a change in management control of assets. If management can achieve cost savings, marketing benefits or price increases through synergies, shareholder value is enhanced. Valuation of synergies depends on specific circumstances, but some common principles apply. Issues in the synergy part of the course included: Where to companies involved in acquisitions say that synergies come from? How should the value of synergies be related to the amount of money paid for an acquisition? How are synergies estimated in transactions given the short time frame for completing transactions and the confidential nature of much data? What statistical methods can be used to compute synergies?

LECTURES

• Theory of Synergies
• Optimization of asset management
• Alternative types of synergies
• Receipt of synergy valuation by target company or acquiring company
• The synergy trap
• Negative synergies
• Identifying synergies
• Unique synergies to acquiring company, industry or general
• Economies of scale
• Marketing improvements
• Productivity enhancements
• Negative synergies
• Case studies in identifying synergies
• Valuation of Synergies
• Available information
• Level of detail
• Examples of synergy valuation
• Alternative ways to achieve savings
• Synergy valuation in case studies

CLASS EXERCISES

• Exercise 5a: Macro Exercises
• Exercise 5b: Addition of Anthema assumptions to financial model
• Exercise 5c: Computation of bid price with alternative cost of capital and country risk assumptions

MODULE VI: DAY 3

Afternoon: Leveraged Buy-outs

A controversial form of acquisition is leveraged buyouts. This form of acquisition often involves complex capital structures with many trenches of debt and the debt has many covenants that adds difficulty to the modeling process. Issues addressed in this section include: Have leveraged buyouts been good for the economy? What type of financial ratios and cash flow analysis is required to complete a leveraged buyout? What amounts of senior debt, subordinated debt and mezzanine financing should be used in raising money for a leveraged buyout? How can cash flow waterfalls, asset sales, covenants and other aspects of leveraged buyouts be modeled?

LECTURES

• Review of Leveraged Buyouts
• Definition of Leveraged Buyouts
• Theory behind Leveraged Buyouts
• Studies of efficiency from Leveraged Buyouts
• Debt Structure in Leveraged Buyouts
• Senior and subordinated debt
• Covenants
• Rating Agencies
• Financial Ratios
• Modeling of Leveraged Buyouts
• Cash flow waterfall
• Modeling the impact of covenants
• Project finance model outputs

CLASS EXERCISES

• Exercise 6a: Review of Leveraged Buyout Case
• Exercise 6b: Modeling a Complex Debt Structure in the Context of a Leveraged Buyout

MODULE VII: DAY 4

Morning: Accounting and Financing Structures in M&A

A key question for management is how an acquisition will affect earnings per share and the general financial condition of the company after the acquisition. This section reviews issues associated with dilution and accretion effects of acquisitions. Actual financial data from companies is used in the class exercises. Issues addressed in this section include: What are the benefits and costs of using multilateral agencies? What are the various multilateral agencies that can be used? How do rating agencies assess project finance debt? How can you use project finance models to assign a risk rating?

LECTURES
• Currency in an M&A Transaction
• Cash payment and debt financing of M&A transactions
• Share exchange in M&A transactions
• Accounting with pooling of interests and purchase accounting
• Mechanics of computing earnings accretion
and dilution
• Translation of exchange ratios into implicit prices
• Combined and standalone earnings per share
with different growth estimates
• Modeling from alternative perspectives
• Effects of financing on acquisitions
• Actual cases
• Relevance for valuation
• Tax effects

CLASS EXERCISES
• Exercise 7a: Exercise on Accretion and Dilution using Relative P/E Ratios
• Exercise 7b: Comprehensive M&A Simulation with Goodwill Accounting, Acquisition Premiums, Debt and Equity Financing and Assumption of Existing Debt

MODULE VIII: DAY 4

Afternoon: Technical Project Finance Modeling Issues

The afternoon module deals with miscellaneous technical issues that arise in project finance modeling. Subjects include working capital, formatting, use of data tables, depreciation, leases, and resolving circularity. The module will cover further use of macros in modeling as well as financial issues associated with the topics. Issues include: Does it matter that circularity arises in our models? Are data tables worth the hassle in model building? What should be done to include movements of working capital in the model? Can
we demonstrate the basic cost and benefits of leases with a relatively simple model?

LECTURES
• Circularity Macros
• Alternative methods to resolve circularity
• Working with range names
• Alternative ways to enter data
• Use of range names
• Theory and Analysis of Leases
• Tax depreciation versus debt repayment
• Tax reasons for using leases
• Formulas for computing lease payments
• Accelerated Depreciation
• Tax depreciation conventions
• Formulas for computing tax depreciation
• Vintage computations of tax depreciation

CLASS EXERCISES
• Exercise 8a: Computation of Lease Rates
• Exercise 8b: Working Capital, Data Tables and Resolving Circularity

• Ed Bodmer

  Edward Bodmer has created innovative forward pricing, productivity measurement and investment valuation software for consulting clients throughout the United States. He has taught energy economics and finance throughout the world, and formulated significant government policy and corporate strategy in the U.S.
  
  Mr. Bodmer's consulting clients include investment banks, commercial banks, research institutions and government agencies on a wide variety of complex valuation and advisory matters. He has constructed a unique framework for electricity price forecasting and valuation using production cost modelling techniques combined with option price theory and Monte Carlo simulation.
  
  Mr. Bodmer is also an adjunct professor at leading University where he teaches courses in microeconomics. Along with his practical experience that covers a multitude of major advisory projects, he has taught specialised courses in financial modelling, electricity pricing, option valuation, mergers and acquisitions and contracting to investment banks, commercial banks, industrial corporations and electric utility companies.
  
  Mr. Bodmer was formerly Vice President at the First National Bank of Chicago where he directed analysis of energy loans and also created financial modelling techniques used in advisory projects. He has used the models in providing expert testimony on subjects ranging from capital structure to investments in multi-billion dollar nuclear plants to complex valuation of new investments.
  
  Mr. Bodmer received an MBA degree specialising in econometrics (with honours) from the University of Chicago and a BS degree in finance from the University of Illinois (with highest university honours). He has written many articles and is in the process of completing a textbook on valuation of electricity assets.

  Courses run by this instructor

  • Real Estate Modeling - New York City
  • Project Finance Modeling Masterclass - New York City

Interested in holding this course in-house? Please fill out your details and a member of our team will be in touch with more information.

Financial Modeling In Excel - Miami

20-22 Jun 2012 (Miami, United States)
17-19 Dec 2012 (Miami, United States)
20-22 Nov 2013 (Miami, United States)

The course begins by concentrating on spreadsheet best practice, auditing and the advanced use of Excel. These skills are then applied to the construction of financial, valuation and investment models. Delegates learn how to incorporate forecasting, optimization, risk assessment and sensitivity scenarios into these models. The course is taught using a step-by-step approach to enable delegates to construct financial models for a wide range of practical scenarios.

Structuring Leveraged & Mezzanine Finance - New York City

17-19 Oct 2012 (New York, United States)

The aim of this course is to provide participants with exposure to leveraged and mezzanine financing techniques in the context of M&A and private equity structures.

Mergers & Acquisitions - New York City

17-19 Sep 2012 (New York, United States)

The aim of this course is to provide participants who already have some transaction experience with further exposure to M&A, company valuation and deal structuring and financing. You will also be introduced to international practice in executing mergers and acquisitions, including an appreciation of today's market practices and procedures including due diligence, accounting issues and valuation techniques.

Advanced Corporate Finance Techniques - New York City

10-12 Dec 2012 (New York, United States)

Advanced Corporate Finance Techniques explores the broad realm of complex financing tools available to corporate issuers. You will develop strategies used to create value-adding debt financing transactions, considering many of the latest debt financing alternatives available today.

Fusiones y Adquisiciones - Mexico City

10-13 Sep 2012 (Mexico City, Mexico)

Este programa de entrenamiento ha sido desarrollado por banqueros de inversión con más de 20 años de experiencia práctica en el mercado medio. El curso desarrolla y compara metódicamente ambos puntos de vista en la transacción con el fin de proveer a los participantes de una visión completa de los factores críticos en la operación de fusiones y adquisiciones en el ámbito real de transacciones de negocios. A lo largo del programa, los conceptos principales son enfatizados con el uso de ejemplos y casos de estudio con el propósito de analizar y mostrar la aplicación práctica de dichos conceptos.

Private Equity Investments - New York City

5-7 Nov 2012 (New York, United States)

This three-day course has been designed to provide participants with an overview of the private equity industry and the investment process throughout the different stages of a company’s growth. It explains the investment process, objectives, financial instruments and negotiation options from the point of view of both the investor as well as the business owner.

Loan Syndication – Structuring, Selling Down & Documentation - Miami

22-24 Aug 2012 (Miami, United States)

With the financial world currently undergoing significant changes, one of the most important challenges in banking is to reinforce the syndicated loan function and to refresh techniques given the evolution of the syndicated loan market. This course enables you to ensure that your staff – whether bankers, lawyers or investment professionals – have the tools to cope with the new environment.

Financial Modeling in Excel - Port of Spain

12-14 Jun 2013 (Port of Spain, Trinidad and Tobago)

The course begins by concentrating on spreadsheet best practice, auditing and the advanced use of Excel. These skills are then applied to the construction of financial, valuation and investment models. Delegates learn how to incorporate forecasting, optimization, risk assessment and sensitivity scenarios into these models. The course is taught using a step-by-step approach to enable delegates to construct financial models for a wide range of practical scenarios.

 

Comments