Advanced LBO Modelling

Course Overview

This course covers the key elements of modelling in an LBO analysis. Participants will value the target business using historic data and available equity research. The valuation process will incorporate absolute and relative valuation techniques. Once the target business has been valued, participants will be introduced to LBO analysis and construct an LBO model.

The LBO modelling analysis will be developed by assessing the debt capacity of the business to determine the range of capital structures available for the transaction and how credit analysis is used in the LBO modelling process.

The participants will then cover more complex LBO instruments such as warrants and PIKs and how to calculate returns to each of the equity and debt providers.

Participants will model a more complex capital structure and calculate exit values and the IRRs generated by each investor. Using the integrated model participants will then analyse various scenarios (management case, base case, payout case) to derive the optimum financing structure taking into account the financial constraints of each investor.

The participants will undertake an adjusted present value (“APV”) analysis to determine where value has been created in the LBO transaction, using an APV model and finally look at recovery analysis for a failed LBO transaction.

Case Study: The participants will use a variety of case studies and exercises during the two days, based on publicly quoted and generic businesses.

Participants will be required to bring a laptop and a calculator to the course.

Course Content

Leverage Overview

• Background to the LBO market
• Basic theory – The effect of leverage on firm value

Valuing the target

• Sourcing information – Historic and forecast date
• Analysing equity research
  • Key attributes of broker analysis
  • Pluses and minuses of equity research
• Building a DCF valuation using equity research
• Modelling the stand alone valuation

Case Study I: Participants model the stand alone valuation of the target using historic data and equity research

LBO Modelling Overview

• Key elements of an LBO model
  • Comparing and contrasting DCF and LBO models
  • Sources and uses of funds
  • Key drivers in an LBO model
• From stand alone valuation to LBO analysis

Case Study II: Participants use the stand alone valuation of the target to complete and LBO model

Assessing debt capacity for LBO financing

• Financial interdependencies
• Financing growth
• Sustainable debt
• Target debt capacity assumed in a WACC calculation, debt capacity and interest cover
• Debt capacity in LBOs
• Debt capacity multiples in practice and credit analysis

Case Study III: Modelling the debt capacity of the target using multiple and credit analysis

Capital providers and their typical characteristics

• Institutional and management equity
• Traditional/new lenders
• Senior tranche profiles
  • A, B, C, RCF
• Subordinated tranche profiles
  • Second lien
  • Mezzanine (with/without warrants)
  • PIK
  • High yield bonds
• More complex issues – warrants and options
• Typical LBO transaction sensitivity analysis, management, base and payout cases

Case Study IV: Modelling a more complex capital structure with various scenarios calculating exit value and IRR for each of the capital providers

Assessing value creation in LBO transactions – APV analysis

• Key components of an APV valuation
  • Unlevered value
  • Value of the tax shield
  • Direct and indirect cost of leverage
• APV valuation and DCF valuation
• APV valuation in a steady state
• Calculating AP in a steady growth environment
• Incorporating APV analysis in an LBO transaction analysis

Case Study V: Where has value been created, modelling APV analysis for an LBO transaction

LBO failure

• Calculating recoverability for different capital providers

Case Study VI: Estimating recoveries for different debt tranches

“Very good overview of LBO Modelling. Good studies, good teacher”

Delivering this course in-house for you to a number of participants could be very cost effective. Please call us on 020 7387 4484 to discuss this further.

If you have any questions about this seminar please write to us at post@redcliffetraining.co.uk.