Advanced LBO Modelling

Name: Advanced LBO Modelling
Availability: InStock

Master the key elements of modelling in an LBO Analysis

Modern architecture in the heart of a city with many windows that create a sense of light

A two-day course

Book Places Now

In-house pricing available – often more cost-effective for teams of 10+

Download: Course Outline

Day One

Advanced LBO training is split into five sessions.

Session 1 – Short Form LBO Model

Forecasting the unlevered free cash flow from operating data
Deal Terms: Offer Price and Enterprise Value; Sources & Uses of Funds
Allocating cash flows to repay debt using a simple cash sweep
Linking up the interest expense
Exit returns and sensitivity analysis of equity returns vs. entry multiple, leverage and exit multiple
Exercise – complete a Short Form LBO model

Session 2 - Leveraged Buyout Model – Equity Value Creation

Analyse the components for equity value creation
Decomposing value creation into revenue growth, EBITDA margin improvements, debt repayment, multiple expansion, and deal fees
Build a bridge chart to show absolute amounts of value creation and Multiples of Invested Capital
Exercise: Building a Value Creation Bridge, both absolute and Money Multiple based

Session 3 - Completion Mechanisms and Deal Adjustments

Leveraged buyout training contrasts Locked-Box vs. Completion Account Mechanisms
Reconciling Enterprise Value to Actual Equity Purchase Price
‘Normal’ OWC
Book Value vs. Fair Value adjustments
Under/(over) spend on Capex
Debt-like liabilities
Locked-box roll forward
Exercise: Estimate the Equity Purchase Price after deal adjustments for Completion Accounts and Locked-Box deals.

Session 4 – LBO Debt Financing and Debt Capacity

Debt capacity analysis
Determining a maximum debt capacity using unlevered free cash flows
Amortising Senior Loan
Bullet subordinated tranches
Mezzanine
Exercise: Determine the level of debt the company could obtain

Session 5 – Modelling a Debt Waterfall

Estimating unlevered free cash flow
Cash flow available for debt service vs. Cash Flow available for debt repayments
Mandatory Repayments: straight-line amortisation, balloon and bullet repayments
LBO financial modelling training covers the issuance/repayment of revolver
Cash available after mandatory repayments and revolver
Covenant-based constraints on cash distributions to equity investors
Accelerated/ discretionary repayments
Final Day One Exercise: Build a full debt waterfall model, with mandatory repayments, revolving credit facility, discretionary repayments and equity distributions.

Day Two

The second part of this course is split into a further five sessions.

Session 6 – Building a Long Form Model – LBO Case Study

Deal Assumptions: Equity Offer Value and Enterprise Value
Sources and uses of funds with senior, subordinated, mezzanine, shareholder loan and sweet equity
Calculating deal Goodwill and building a consolidated balance sheet
Integrating an Operating Model with NewCo Finance Structure
Create a debt waterfall with mandatory repayments, revolving credit facility, and covenant-based cash sweep
Current and deferred taxation, given limitations on the tax deductibility of debt
Determine the key ratios
Exit enterprise value and bridge to equity value
Value creation schedule with a value creation bridge
Internal rates of return for all investors
Sensitivity analysis concludes session 6 of this advanced leveraged buyout course

Session 7 – LBO Management Incentive Structure

Ratchet Share Mechanisms vs. Sweet Equity
Calculation of risk and rewards: IRR and Money Multiples
Exercise: Contrasting RSM vs Sweet Equity with varying IRRs.

Session 8 – Leveraged Recapitalisations – Case Study

Benefits of a leveraged recapitalisation
Recapitalised Source and the use of an LBO funds schedule
Assumptions – interest and new debt capacity
Integrating the new debt funding within a waterfall
Integrating the new interest rates post-recapitalisation
Exit values and IRR, with and without the recap
Value creation schedule with a value creation bridge
Exercise: Incorporating a Leveraged Recap within an existing LBO Model

Session 9 – Buy-and-Build LBO Modelling

Integrating a bolt-on acquisition within an existing platform business model
Bolt-on Enterprise Value and Equity Value
Bolt-on sources & uses of funds
Flexing the completion date and pro-rating bolt-on cash flows
Integrating the Bolt-on Income statement and cash flow within a short-form platform model
Analysing exit returns and value creation from the bolt-on
LBO Modelling Course Exercise: Incorporating a Bolt-on Acquisition within an existing LBO Model

Session 10 – Structure of PE Funds: GP vs. LP Returns

The life cycle of a PE fund: Investment, Development & Harvesting Phases
Measuring Fund Performance: % PI, DPI, RVPI, IRR vs. TVPI
Fund vs. GP vs. LP returns: carried interest & catch-ups
American vs. European Funds
Exercises: Calculating Performance Ratios, IRRs and Multiples for Funds and GPs

After graduating from the University of Cambridge in 1993, our LBO modelling course expert began his career as an auditor at Arthur Andersen, where he developed a strong foundation in corporate accounting and financial statement analysis. He later qualified as a Chartered Accountant (ACA) and transitioned into investment banking in the City of London, holding roles at both HSBC and Merrill Lynch.

During his time in London, he held a front-office role advising companies on valuation, financing, acquisitions, foreign exchange, and derivatives. His broad practical experience, combined with a strong passion for sharing knowledge, naturally led him to pursue a career in training.

Over the last decade, our LBO course expert has specialised in financial training, delivering across a broad range of subjects, including leveraged buyouts. His areas of expertise include accounting, financial modelling, corporate finance, valuation, and capital markets. He has trained professionals at investment banks, private equity firms, and corporate finance teams globally.

Delivered across two days, advanced leveraged buyout training delves deep into the subject:

Build an LBO model that incorporates complex debt structures
Model the impact of the new LBO financing structure and key issues around structuring
Estimate debt capacity
Identify potential adjustments in determining an appropriate equity purchase price based on a business enterprise value
Training ensures participants complete a fully integrated LBO model with:
- Deal Terms
- Source and use of LBO funds
- Integrated financial statements
- Detailed debt waterfall, allocating cash flows across a debt structure with potential for dividend distributions
- Equity value bridge charts illustrating components of value creation
- Sensitivity analysis

Redcliffe’s leveraged buyout course is presented by a qualified Chartered Accountant with practical investment banking experience.
By the end of the course, participants will have completed a series of LBO models and Excel-based exercises, all of which will be provided for future reference.
Participants receive a summary workbook covering all aspects of training upon course completion.
Advanced LBO training is ‘hands-on’. Using Excel, participants are guided through how LBO models are built and developed in practice to varying degrees of complexity.

Redcliffe’s LBO modelling course is a must-know for:

Corporate Finance professionals at all levels, especially those focused on private equity transactions.
Private equity LBO professionals who manage or oversee the execution of their firm’s deals.
Finance professionals within portfolio companies who want a closer understanding of the private equity LBO process and how their companies fit within the context of a PE fund.

Leveraged buyout training begins with an introduction to a rapid approach for assessing LBO opportunities. This foundation ensures participants grasp the core concepts before progressing to more advanced modelling techniques.

LBO financing structures and debt capacity are explored, and sessions review equity finance, pure debt finance, and mezzanine finance.

Sessions focus on building a debt waterfall and developing an advanced LBO model from scratch with NewCo/OpCo consolidation and integrated consolidated LBO financial model forecasts. This LBO modelling course further explores modelling a leveraged recapitalisation and the benefits obtained from undertaking this.

The trainer was extremely well-versed on the subject matter and was able to answer all our queries practically via Excel examples, which is fantastic for those looking to master the modelling aspect of LBOs.
Good interaction with the teacher, very user-friendly and organized models.
The trainer was brilliant in the delivery of the course. The content was completely relevant, and the "hand-outs" were spot on.
Fantastic tutor, who provided a great walkthrough of complex modelling and learn new Excel skills.
The trainer was fantastic!
The course content was very relevant for PE professionals, and the trainer did a great job as an instructor.
Great course, and the models were very useful and will help us with our models going forward.

Request a fee quote for an exclusive in-house presentation of this course

Request a fee quote for a pre-recorded course
(min. 50 participants)