img

LBO Modeling

Course Start Date: 12th November 2023

Training Duration: 4 Days

Practical application through exercises:

  • Excel Exercises
  • Case Studies

Learning Outcomes

icon

Understand the characteristics of a good LBO candidate

icon

Understand design and develop structure for a LBO model

icon

Learn to forecast financial statements for the LBO target

icon

Prepare flexible debt schedules for different sources of debt

icon

Understand and prepare source of value creation in a LBO transaction

icon

Perform scenario analysis and develop the LBO dashboard

Course Outlines

  What is LBO and what are the key characteristics of a good LBO candidate

  • Introduction to LBO modelling
  • Model design and structure for the LBO case
  • Forecasting the operating cash flows of the LBO target
  • Target’s enterprise value and uses of funds
  • Various sources of funds

Senior Debt (Term Loan A, B, etc.)

High yield, Mezzanine, PIK and Shareholder loan

Revolving line of credit

  • Preparing flexible debt and interest repayment schedules for different sources of funding
  • Incorporating cash sweep in debt schedules and avoiding circularity
  • Calculating exit IRR and MOIC for the GP and 
  • Analysing the various sources of value creation – Revenue Growth, Margin Expansion, Multiple Expansion and Deleveraging 
  • Scenario and Sensitivity Analysis for analysing LBO

Case Study: Large global or regional LBO transaction