Wall Street Prep

Quick Lesson: Simple LBO Model

In this video tutorial, we'll build a leveraged buyout (LBO) model, given some operating and valuation assumptions, in Excel. The goal of this video is to show you that an LBO model is actually a very simple transaction at its core - and quite similar to the mechanics involved when purchasing a home. If after watching this video you want to take your LBO modeling to the next level, see Wall Street Prep's advanced LBO modeling course.

Note: To download the Excel template that goes with this video, click here

Building a Simple LBO Model  - Video 1 of 3

Building a Simple LBO Model  - Video 2 of 3

Building a Simple LBO Model  - Video 3 of 3

Comments
avatar
newest oldest most voted
Michael
Michael

In the second video, at the time between 3:55 - 3:56, what is the shortcut you used to fill in all the blanks to the right?

shane
shane

Hi, could you explain why Enterprise value in the exit year is equivalent to EBITDA * EBITDA multiple (6.5x); arent Enterprise Value and EBITDA two different values?

Tony
Tony

Hi for "LBO debt, beginning of period" for 2013, should it be 14,500? Because your net debt/EBITDA(debt capacity) multiple times LTM EBITDA gives net debt for LBO which is 14,400. Now to get LBO debt you need to add the current cash 100. Or am I wrong with any calculation?

Curious Learner
Curious Learner

For Cash we added, prior cash ($100)+ additional from projection periods. However, we did not add prior debt of $600to 2012 debt, why?

Jay
Jay

Hi, Isn't it wrong to include the 100 in Cash (cell C41) in the optional paydown for 2013 (cell D50)? The model implies that the cash balance initially on the company's balance sheet are being used to pay down the debt, when the LBO is first carried out (thereby reducing… Read more »

Nirvan
Nirvan

The videos were really helpful in understanding the math behind LBOs. Thank you for making such videos.

Elizabeth Alexander
Elizabeth Alexander

What is FCF after debt paydown? Is that Operating CF - Inv in PPE - debt principal repayments?

Cezary
Cezary

Hi All, I have a question on exit date: why the investor assumes it sells Target after 5 years? What will the investor do if the market is still avourable after this 5years. Will he stay with its investment in Target or sells irrespectively of good market conditions?

Joe
Joe

Hi

Why do we not take into account the opening debt (cell 42) in the debt schedule? We do appear to take into account the opening cash, so it seems inconsistent that we don't take into account opening debt?

Thank you for a great tutorial!

sadin
sadin

B:16 Free cash flows after debt paydown

net operating cash flow minus net capital expenditures minus minus debt payment plus raise debt?

sadin
sadin

Hi! B:9 Current Debt, what kind of Debt we should put here? The whole company liability (assets minus capital) or only debt from banks, bonds etc interest debt? If we are going to buyout a company, the price is 6 times EBITDA - 10M. 20% will be funded by our… Read more »

Dennis Limbo
Dennis Limbo

Hi,

Does this LBO works for everyone?

Warren
Warren

When I calculate the exit multiple of 6.5x times the EBITDA in 2016 of 3,513.8, I get 22,840, not 22,696 as you show in this video. What did I do incorrectly?

AB
AB

After Video 2, where do we see the deduction in cash/FCF after the REQUIRED debt pay down? I say this for the formula in cash (row 41) - why isn't cash deducted another 1,000? Where is the 1,000 required pay down coming from? Thanks!

X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.