Join 750k+ learners today. Learn online from Wall Street Prep — the training firm that prepares new hires at the world's top financial institutions.
Welcome to the Wall Street Prep Quick Lesson Series!
In this lesson, we’ll build a leveraged buyout (LBO) model, given some operating and valuation assumptions, in Excel. The goal of this lesson is to show you that an LBO model is actually a very simple transaction at its core, and is quite similar to the mechanics involved when purchasing a home.
Instructor’s Note: In the comments section, in front of row #48 (LBO debt, beginning of period), the note is written as “LTM Debt * LBO Debt Capacity.” It should instead be labeled as “LTM EBITDA * LBO Debt Capacity.”
Before You Watch: Before diving in to the videos below, please read through this LBO Quick Lesson Primer, and be sure to download this lesson’s Excel model template: LBO Excel model template.
Thank you for the amazing introduction to LBO. The analogy to buying a house does make the concept much easier to understand. Good job for explaining.
If I am not mistaking, you did not take into account the $600M of existing debt when inputting for the debt remaining balance in cell D42 for the second video at minute 5:09. Shouldn’t cell D42 be : D51+C42? Meaning the end of year new debt balance of $12,822M +… Read more »
When answering question 2 of the second group of questions “What is the highest purchase price the sponsors would be willing to pay for XYZ shares today?”, why do we subtract Net Debt again? I mean we are using J59 which is equal to D48 + J56, where D48 was… Read more »
Amazing videos, amazing explanation, everything was super well explained. CONGRATULATIONS
Thanks for sharing this information. This was excellent.
Hi, Why is it that in the Question #1 your formula to calculate EV is EV=6.5x*EBITDA instead of EV=6.5x*EBITDA + Net Debt?
Many thanks for simplifying this concept for us
Hi thank you for the videos. I have a question regarding video 2. Why did your “optional paydown” figures change when putting in the values for your cash, debt, and net debt values ?
Thank you for this! I have a question regarding the table of Sources & Uses: In the uses should we add a cash injection of $50m in addition to the EPP and refinanced debt (600 here according to your assumption to not account for $100m cash in the target BS)… Read more »
Thank for well explained LBO, use case made us to understand concept easily.
Can I get more lectures on Advanced Financial Accounting along with IFRS????
Given you use “Free cash flow after required debt paydown” and you keep it stable @8%… it seems you are missing out any operational leverage effect on the FCF, right?
This is very well done. Simple framework/concept and helpful excel format. Doing it myself really helps to bridge knowing to understanding fully. What are some of the bigger qualitative risks or pushbacks a bank might point to in such a case? Thanks!
plz share the excel template
I did not get the year 2 to year 9 debt schedule computation for optional paydown.
Does this analysis ultimately mean that company XYZ is undervalued and that is why the financial sponsor is able to pay a healthy premium today to buy out the shareholders? Thanks
The equity value upon exit is less than its current market cap and we would be paying a premium. Why would you do this?
Absolutely brilliant, I want more
I am wondering when you calculating optional paydown for 2013E (second video 3:18), you add back current cash balance $100, but shouldn’t that $100 be used to retiring current debt? So when calculating the highest price to buying the company, we subtract net debt($500) rather than debt($600). We can’t use… Read more »
Awesome, thank you!
excellent and concise
I have one question about the calculation of cash in the second video. The cash left is the remaining cash from the previous year+cash earned-cash paid. Why the cash paid only include optional debt paydown not a required paydown of 1,000?
Hi, why are we using the exit equity value and then looking for the maximum return in 4 years in question #3? (to the 4th power)
I am confused. At the end of video 2, the ending LBO Debt in row 51 is 11,291.2 in 2014E. Then, in video 3, it is 11,241.2. Why are we taking out a minimum cash balance twice?
Has the debt calculation included the interest? It was not mentioned at all in the calculation.
Hello, what buttons did you press on the keyboard to calculate present value using 25% IRR? so what im asking what do you press to get the inverted V symbol?
Does the “required cash paid down“ in cell C38 refer to the same “required cash paid down” in B38?
Do you have any video on Project Financial Modeling ie to determine the financial viability of a proposed project (before embarking on it)?
There is a new methodology called Engineering Finance used to enhance the ROI of projects and ensuring its long-term sustainability… can you elaborate on it?
So helpful and clear! love it.
Very interesting. I hope you will make the videos easy to download so that one can watch them offline over and over again.
You nailed it. I can’t wait to watch the next videos.
Thanks a lot.
Thank You Sir,
The video very useful.
The LBO model with example is more easy to understand rather than reading the process.
And I think overall process of LBO analysis with decision making was covered in this video.
AM VERY GRATEFULL.
Thank you for the quick revision of LBO model….happy to have this free service
at 4:08 of the second video (debt schedule), Why is the free cash flow value taken from end of 2013 rather than the start (2012A) ? i.e. why 528 and not 420?
please can i access this videos on youtube so i can download for references.
Thank you for sharing this video on how to run a LBO analysis. It was very helpful and definitely offers a macro view on what such an analysis would capture. In a real life LBO analysis, how does one choose a stock price to base the analysis on? is this… Read more »
Hi I just become a subscriber to wall street prep you send me the quick lesson: simple LBO model and I can not download the excel template I get the nonsense pages, sense I got the premium from you, I just want to make sure I won’t have problem with… Read more »
Hi,
How come you subtracted 1 from the current share price when calculating the premium in the last question 3?
Hey, Looking at the 2nd video, didn’t you miss the initial $600 debt for the starting debt on D48? Meaning that your starting debt balance at the beginning of 2013 is the 14,400 from the loan PLUS the 600 from the period before. Please let me know if this is… Read more »
Nice simple and clear presentation
There is a spelling error in your primer — first paragraph under Exit Assumptions
Hi,
I am not able to access the videos. I only see the titles of the videos.
hey, i dont think the videos are showing up.
Just 1 thing: In the comments section, in front of row #48 (LBO debt, beginning of period), you have written it as LTM Debt * LBO Debt Capacity. I think it shoould be LTM EBITDA * LBO Debt Capacity…
Great work and I would like to get you to PNG to develop a finance school if possible.
Looking forward to the next lessons in Financial Modelling!
Hi Administrator,
Thanks so much for the first lesson.
Hope to see subsequent lesson.
Regards,
Hi there,
I could not get access to the video. Any chance to check the tech issue?
Thanks!
BR
Jean
Hi,
What is the keyboard shortcut to copy your formula across horizontally to the end of the data? For example, at time 7:15 in the first video.
Thanks,
Marcel
Hi Mat,
Would you please tell me how to download this video for an offline review?
Regards,
jd