LBOs

Question 1

What is an LBO?

Answer 1

An LBO model is the basic analysis that projects the returns of an invesment

In a LBO we put debt in a company and the idea is that the cashflow from the company pays down debt

LBO modeling requires 3 statement modeling because that is how we calculate cash flows

In its simplest form an LBO is just a projection of the cashflows of the company. How much do we pay to get in, how much cash we generate over time, how much cash we get when we sell, what are our returns.

Question 2

What are the key LBO value drivers?

Answer 2

1) EBITDA Growth
- Grow revenue
- Cut costs
- Make acquisitions to grow EBITDA

2) Raise Debt and Pay it down
- Allows us to buy bigger companies with a lower cost of capital than equity
- Need to make sure that cash flow is consistent so that we can pay off debt
- Reduce capex to pay more debt down

3) Multiple expansion
- Build a higher quality business

Question 3

Key Sections of an LBO Model

Answer 3

• Transaction Assumptions
• Sources & uses
• Financial Forecast / Operating Model
• 3-Statement Model (IS/CF/BS)
• Returns Analysis

Question 4

What has higher impact in an LBO: Multiple expansion or EBITDA margin expansion?

Answer 4

It depends….but typically you would see multiple expansion being a greater drive of returns as your are expanding your exit value by a one turn of EBITDA. Its rare to get that much value from margin expansion unless you have a significant margin expansion.

Question 4

How can we decide on the premium per share price for an LBO?

Answer 4

Rule of thumb is 15% - 30% premium

Question 5

Private Company EV Buld

Answer 5

Question 5

How are growth equity deal modeled? Do they also use LBOs?

Answer 5

Growth equity deals tend to use more structured securities. (i.e convertible pref, debt + warrants or earn-outs vs straight equity buyout)

Question 5

What are options? What is the treasury stock method?

Answer 5

• Options are securities that can be excercised into shares
• When the option holder excercises its right to buy options the company receives money from the option holder
• Company uses the proceeds from the employees to buy back share?

Options can only be excercised if they are in the money. Option needs to be below the current share price to be excercised.

If option is $5 and current share price is $10 the option holder will excercise its rights

Question 5

Transaction Assumptions

How do you determine equity value and enterprise value?

Answer 5

Enterprise Value

1) Calc fully diluted shares outstanding “FDSO”

FDSO = Basic Shares outstanding + Net Options + Net Warrants + Restricted Sotck Units

2) Calculate Common Equity Value

• FDSO * Proposed Purchase Price per Share

3) Add Debt to EQuity Value

• Debt, Convertible Debt, Preft Stock, Capitalized Leases

4) Substract Cash and Cash equivalents

• Cash, Mkt Securities, Liquid investments

Question 6

Treasury Stock Method

Answer 6

• Cash Proceeds: Options outstanding * option price
• Shares Repurchased: Cash proceeds / Current Share Price
• Net Shares: Shares - Shares Repurchase

Question 6

2) Sources & Uses

Answer 6

LBO Model Steps
- Ater defining transaction assumptions.
- Next steps is the S&U

• Think about that in the S&U section we define how we are going to fund the purchase of this business

Question 7

Sources (Equity)

Answer 7

• Common Equity: Bottom of the cap structure
• Pref Stock: Higher claim than common equity. Hybrid between debt and equity as they get a dividend before common stock. More downside protection due to liquidation preferences at exit.
• Options: Security that allows you to receive shares down the road.

Question 8

Uses

Answer 8

• Purchase equity: Buy shares from existing owners
• Refinance existing debt or assume it: When you buy a company you can buy the shares only. You also need to assume the debt
• Cash to BS: We need to send some cash fo the B/S so the company can keep operating. Keep in mind that in the EV calc we take net debt therefore there is no cash left to run the business
• OID: Think of it like a debt fee to make debt more attractive
• Fees: Amortize over life of debt. Treat this similar to interest expenses because they save you on taxable income
• Expenses: Fees on advisors (bankers, lawyers, accountants). This can’t be amortized as this are one time expenses

Question 9

Section 3 of an LBO: 3 statement model

Answer 9

Question 10

Flowing Revenue to Free Cash Flow

Answer 10

Question 11

Balancing a Balance Sheet

Answer 11

Question 12

Net Working Capital and why do we care?

Answer 12

Net working capital matters in an LBO because any additonal net working capital that the business needs is a use of cash.

For example, if our accounts receivables increase our customers owe us more money therefore more cash is tied in the business

Question 13

Other Balance Sheet Items

Answer 13

Question 14

LBO Purchase Accounting

Answer 14

• When we do an LBO we recap the business therefore we wipe out all the equity and debt in the existing business and replace it with new equity and debt

Question 15

Godwill Calculation in an LBO

Answer 15

• Goodwill is used in a LBO to account for the “excess purchase price” of another company
• To calc goodwill we calc the step-up of equity
• Step-up of equity = Purchase price - (FV of Assets - FV of Liabilities) + Existing Goodwill
• Keep in mind that the FV of Assets and FV of liabilities is equal to your Book Value of Equity

Question 16

The Paper LBO

Answer 16

• Tests LBO concepts without having to open excel
• Simple paper LBO steps

1) Transaction Assumptions
2) Sources & Uses
3) Walk from Income Stament to Cash Flow Statement
4) Calculate Returns

Question 17

• Rule of 72 (Double your money)
• Rule of 114 (Triple your money)
• Rule of 144 (Quadruple your money)

Answer 17

• Rule of 72: Stipulates that the aprox return required to double an investment can be calculated by dividing ( 72 / number of year)

i.e What is the rate of return I need to double my money in 5 years? (72 / 5) = 15%