
Get the skills we teach at top PE Firms...
Our intensive private equity curriculum was developed from our providing live instruction for 19 of the top 25 PE Firms. This course will enable individuals to develop the skills needed to perform in the PE industry. We will teach you how to transition from operating as a banker to an investor. You will learn how to construct a detailed operating model focusing on revenue build, variable cost, overhead and SG&A. How to account for maintenance vs growth capital expenditure and depreciation as well as the complexities with modeling debt.
The course also teaches Leveraged Buyout Analysis, from key LBO principles, structuring and debt capital markets, to equity distribution waterfalls.
You will also learn vital Excel skills for Diligence and Financial Modeling.
- Cleaning and standardizing in Excel
- Analyzing data from a target company
- Integrating and consolidating data
- Parse through Data Room to conduct financial performance analysis
Led by our experienced instruction team of former practitioners, you get a unique blend of industry insight combined with a passion for teaching. The average TTS instructor has been part of the team for 8.5 years.
What you will learn?

Applied Excel and LBO Fundamentals & Valuation
Manipulating and analyzing data
- Lookup and reference tools, e.g. Lookups, offset, index, match, indirect
- PivotTables and data analysis tools
- Charts and data visualization in Excel
LBO fundamentals and valuation
- What is an LBO and how it can create value
- How leverage increases the return on equity
- LBO valuation as an alternative valuation methodology
- Characteristics of suitable LBO candidates
- Sources and uses of funds at entry
- Simplified debt / equity split for entry capital structure
- Estimating cash flows available to capital holders
- Distribution of proceeds at exit
- Exit routes and exit value
- Calculating the returns
- Money-on-money / Multiple of invested capital
- Turning an LBO model into an LBO valuation
LBO – Operating Model, M&A Adjustments & 3-Statements
- Transaction value including dilution from stock options
- Sources and uses using Debt to EBITDA multiples for financing structure
- Modeling alternative financing structures
- Goodwill on acquisition and acquisition balance sheet
- Building the operating model
- Building the cash flow statement and balancing the balance sheet:
- Calculate debt and interest:
- Estimate the IRR
- Evaluation of the deal and issues that should be highlighted at investment committee
LBO – Detailed Financial & Return Structure and Special Topics
LBO – Detailed Financial & Return Structure
- Sources and uses of funds at entry
- Complex capital structure including multiple debt tranches including high yield bonds, mezzanine finance (PIK) and shareholder loans (PIK).
- Managing different financing scenarios within a model
- Full operating forecast
- Cash sweep modeling
- Minimum cash balance covenant
- Revolver
- Mandated and accelerated repayments
- Test on interest expense cap as a percentage of EBITDA
- Calculating debt ratios for testing financial covenants e.g. DSCR, Debt to EBITDA and Interest coverage
- Cash sweep modeling
- Calculating the returns for the different providers of capital e.g. sponsor, management and mezzanine:
- Disaggregating returns into their drivers (building the returns bridge)
LBO – Special Topics
- Asset vs stock purchase
- Tax deductibility of goodwill
- Section 338 elections
- Dividend recapitalizations
- Net working capital adjustments / peg
- Tax deductibility of interest expense
Private Company Forecasting and LBO Analysis
Part 1 – Operating Model
Based on a private company CIM the participants will build a detailed forecast financial model for a private company. This model will include the following:
- A detailed revenue build using a bottom-up approach using volume and price analysis for multiple product lines. Different margins are used for each product
- A detailed SG&A build
- Forecast of working capital
- The breakdown of capex, between maintenance and expansion capex
Part 2 – Valuation and Debt Structuring
- Recap on relative and absolute valuation approaches
- Overview of debt capacity calculations
- Based on the historic and forecast EBITDA and cash flows, we will estimate an appropriate acquisition valuation and debt structure for a potential LBO
Part 3 – LBO Model
Using one of the templates used earlier in the program evaluate the target company as a potential LBO target by incorporating:
- An acquisition valuation range;
- A proposed debt structure; and
- The full operating model built earlier in the day
At the end of the program the instructor will act as the investment committee, critique assumptions made and offer potential model improvements.
What Does A Day Look Like?
Who Is This Course For?


Course Details
What’s Included
Schedule
Prerequisites
How Do You Like To Learn?

Flexible Learning Options
Our courses are available in both in-person or virtual classroom formats. If you learn better in your own space or traveling isn’t convenient, virtual is great solution. Either way, you get the skills and support you need to succeed.

Course Pricing
Cancellation Policy
See what our students say

Training The Street has been teaching the biggest finance firms for over 20 years. To help unlock your career potential, we offer certificates to provide the recognition you deserve.
After you finish your course, you will receive a certificate which can be easily added to your LinkedIn profile.



















