How to Build a PAPER LBO Model in 3 Steps! (FREE Excel Included)

In this video, I show you step by step how to build a paper Leveraged Buyout (LBO) model.

🧑‍🏫Wharton / Wall Street Prep PE Certificate Program🧑‍🏫
► Learn from real investors (including the founder of Carlyle) about the private equity industry
► Use code RARELIQUID for up to $500 OFF for ANY cohort

⬇️Download the Excel for FREE⬇️

🍎Sign up for my courses🍎

▶️Playlists▶️

🎥Related Videos🎥

🧑‍🎓Career Resources👩‍🎓

⏱Timestamps⏱
0:00 - Introduction

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

📱Interact With Me📱

🔎Disclaimer🔎
All content in this video is for entertainment purposes only. I am not a professional financial advisor and my statements are not to be taken as instructions or directions. In addition, some of the links above are affiliate links, meaning that at no additional cost to you, I may earn a commission if you click through and make a purchase.

[rareliquid]

Links to all of the things I mentioned in the video below!

🧑‍🏫Wharton / Wall Street Prep PE Certificate Program🧑‍🏫
► Learn from real investors (including the founder of Carlyle) about the private equity industry
► Use code RARELIQUID for up to $500 OFF for ANY cohort

⬇Download the Excel for FREE⬇

🍎Sign up for my courses🍎

▶Playlists▶

[aishwaryapotdar]

Please do one for M&A as well. An accretion dilution or anything that you think is relevant! Thanks a lot for all of your videos.

[PCDisciple]

Such an underrated video. This is an incredible resource, hope you’re having a good time in Philly!

[shanel.]

Appreciate the IRR table, def very helpful

[taylorparrish]

Great content. Would love to see more advanced / in-depth modelling videos. I have a finance degree and went into consulting after school. While there I taught myself to code and work as a data engineer these days. I've recenlty had a renewed interested in finance and have gone through some of your modelling videos to refresh.

[maximilianmunster]

Can you make a live stream where you Build a big LBO for a firm like your videos with the DCFs for apple and co

[jasonfrancis]

I really love watching your modeling videos. I was wondering if you can do a DCF valuation tutorial for a bank. I'd really appreciate it, thanks

[darrelldas]

Literally missed these modelling videos. 😭. Precedent valuation can you make?

[larshpt]

Thanks for the video, always appreciated! Any way you could do a capitalization table?

[fernandogonzalezhenr]

Would be nice a M&A transaction model of a company using leverage to buy another, and all the implications

[Murmel]

Nice, would be nice with a video on reverse DCF also

[markgarcia]

Seen a couple of your videos but can you explain how come you use CapEx through the entire life of the model? How would you handle a situation where CapEx is needed say in Year 0 or Year 1 and no additional CapEx is required?

[christianandreaprile]

could you make a video where you analyze financial statement results please? for exemple j.pm Morgan last quarterly?... something like ''how to read financial statements''. it will be very helpful. thank you for your job

[thesnackbandit]

Great video. Super high quality content, hardly a wasted moment. Keep up the great work.

[aishwaryapotdar]

Is it better to round to the nearest 5 or 10, in a paper lbo, for each step?

[gadripericles]

@Rareliquid did you remove the excel file for the paper LBO?

[zoetuan]

Thank you so much for all the great videos!! they helped a ton XD

[str]

Sir i havea doubt,
Exit equity value = Ent Value + Net debt - Cash
So it will be 916
And MOIC will be 6.1x

[bacool]

Know any friends from Wharton who were able to get into a no name LMM PE firm without a banking or PE bankground? Applying this cycle with entrepreneur and sales/marketing operating exp. I will do the Jan Cohort for the WSP course

[MariaSimónGrau]

Someone has the free excel template? When I click on the link it says that the page is not found... Thanks a lot!