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

Рет қаралды 36,011

Күн бұрын

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
► tinyurl.com/5n8kr4tz
⬇️Download the Excel for FREE⬇️
► Paper LBO: www.wallstreetprep.com/lc-rl-...
🍎Sign up for my courses🍎
► How to get into MBA programs: forms.gle/9yEyycuP7NnQBjue8
► How to get into investment banking: forms.gle/wt4cZrezbxVgNzGUA
▶️Playlists▶️
► Modeling and Finance Tutorials: • Modeling and Finance T...
► Private Equity Videos: • Private Equity
► Investment Banking Videos: • Investment Banking
► MBA Videos: • MBA Videos
🎥Related Videos🎥
► How to Build a Simple LBO: • How to Build a Leverag...
► How PE Investors Make SO MUCH MONEY: • How Private Equity Inv...
► Interview with a Former Bain Capital PE Investor: • What It's REALLY Like ...
► Secrets to Breaking Into Private Equity: • Secrets to Breaking in...
► Good vs. Bad Day in the Life of a PE Associate: • A Good vs. Bad Day in ...
🧑‍🎓Career Resources👩‍🎓
► Buy the Resume That Got Me Into JPM: rareliquidcareers.com/
► Wall Street Prep (Use code RARELIQUID for 20% OFF!): gv142.isrefer.com/go/rliquid/...
► TTP - The BEST GMAT prep resource: targettestprep.referralrock.c...
► Books I recommend: amzn.to/3gy28xv
► My filming equipment: a.co/cf97WjW
► Favorite apartment products: rareliquidcareers.com/apartment
⏱Timestamps⏱
0:00 - Introduction
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
📱Interact With Me📱
► Instagram: / rareliquid
► Twitter: / rareliquid
► TikTok: / rareliquid
► LinkedIn: / ben-chon-8b0ba34a
► Business Inquiries: ben@rareliquid.com
🔎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.

Пікірлер: 63

@rareliquid 11 ай бұрын

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 ► tinyurl.com/5n8kr4tz ⬇Download the Excel for FREE⬇ ► Paper LBO: www.wallstreetprep.com/lc-rl-paperlbo-template/ 🍎Sign up for my courses🍎 ► How to get into MBA programs: forms.gle/9yEyycuP7NnQBjue8 ► How to get into investment banking: forms.gle/wt4cZrezbxVgNzGUA ▶Playlists▶ ► Modeling and Finance Tutorials: kzfaq.info/sun/PL71QplJWp1RoaKEMTo_9CZA-kyjwT5rGo ► Private Equity Videos: kzfaq.info/sun/PL71QplJWp1Rrm0dkWjjIY2cf4jTYSU0t2

@PCDisciple 5 ай бұрын

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

@shanel.478 11 ай бұрын

Appreciate the IRR table, def very helpful

@zoetuan8326 11 ай бұрын

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

@larshpt 11 ай бұрын

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

@aishwaryapotdar1348 11 ай бұрын

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.

@rareliquid 11 ай бұрын

this has been requested quite a bit so will do this later on!

@taylorparrish4323 4 ай бұрын

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.

@jasonfrancis0997 8 ай бұрын

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

@thesnackbandit 10 ай бұрын

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

@1989Murmel 9 ай бұрын

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

@fernandogonzalezhenr 11 ай бұрын

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

@maximilianmunster8756 11 ай бұрын

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

@christianandreaprile8477 6 ай бұрын

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

@ilovelifan 11 ай бұрын

thx ben dailo😊

@bacool 11 ай бұрын

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

@aishwaryapotdar1348 11 ай бұрын

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

@rareliquid 11 ай бұрын

depends on what units you're working with. so if it's below 100, then generally to the nearest 5 but if it's a few hundred+, nearest 10 is prob fine

@darrelldas1962 11 ай бұрын

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

@aishwaryapotdar1348 11 ай бұрын

Missed these as well!

@rareliquid 11 ай бұрын

will try to do more!

@str5148 5 ай бұрын

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

@joshturanich6646 4 ай бұрын

You will have to subtract the debt from your final cash flow generated because you have to pay the debt back to the lender after the 5 years. That is why it is negative rather than positive. Therefore it = exit EV - debt + FCF generated to get to your exit equity.

@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!

@Gucci-dj3ko 11 күн бұрын

Same :(

@mrareebytshorts6781 11 ай бұрын

Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

@Nss1120 9 ай бұрын

Massive error in that income statement, MD would rail you for mislabeling the margin…

@QrankChannel 4 ай бұрын

You mean the Ebitda / ebit margin thing? Indeed MD will go crazy especially its only noticed when shared with the client 😂

@atchayphoemnay4114 11 ай бұрын

Wait, do you think cryptocurrency will crash? I dont think so. More and more companies are integrating cryptocurrency into their operations: Amazon, Cannafarm Ltd, Burger King, even Starbucks, dude!

@user-hn3uu3gj2g 11 ай бұрын

Sheesh this LBO is bad you go to Wharton to trick people into applying for your “online class” eventually lol

@rareliquid 11 ай бұрын

lol pls explain why this LBO is "bad." i'm guessing you're assuming that this should be a full-fledged 3-statement LBO with multiple debt tranches, a debt waterfall, multiple scenarios for operating assumptions, and etc when this is a PAPER LBO tutorial which is a common SIMPLE test that many recruiting for private equity need to take. if you have any experience whatsoever in banking or PE you would know from the title. paper LBOs are also a good beginner's step to understand how an LBO works the courses i've been working on are going to be extremely useful for candidates AND fairly priced. have spent 1 year working on it with a team when i could've easily made a shoddy course and started selling one 6 months ago

@YoutubePotato092 11 ай бұрын

Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

@rapamericain9987 11 ай бұрын

Wait, do you think cryptocurrency will crash? I dont think so. More and more companies are integrating cryptocurrency into their operations: Amazon, Cannafarm Ltd, Burger King, even Starbucks, dude!

@yosf5972 11 ай бұрын

Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

@fezooyxd4113 11 ай бұрын

Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

@haoleotop5638 11 ай бұрын

Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

@shortsonly2846 11 ай бұрын

Wait, do you think cryptocurrency will crash? I dont think so. More and more companies are integrating cryptocurrency into their operations: Amazon, Cannafarm Ltd, Burger King, even Starbucks, dude!

@cj7sanny399 11 ай бұрын

Wait, do you think cryptocurrency will crash? I dont think so. More and more companies are integrating cryptocurrency into their operations: Amazon, Cannafarm Ltd, Burger King, even Starbucks, dude!