Simple LBO Model: Video Tutorial
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.
Simple LBO Model – Excel Template
Use the form below to download the Excel template that goes along with the simple LBO model video series.
The equity value upon exit is less than its current market cap and we would be paying a premium. Why would you do this?
I don’t understand the pre-deal information, transaction and exit year
assumptions for CVS in the LBO primer. Can you explain it to me? Thank you.
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?
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?
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?
For Cash we added, prior cash ($100)+ additional from projection periods. However, we did not add prior debt of $600to 2012 debt, why?
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 »
The videos were really helpful in understanding the math behind LBOs. Thank you for making such videos.
What is FCF after debt paydown? Is that Operating CF – Inv in PPE – debt principal repayments?
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?
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!
B:16 Free cash flows after debt paydown
net operating cash flow minus net capital expenditures minus minus debt payment plus raise debt?
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 »
Does this LBO works for everyone?
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?
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!