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: ua-cam.com/play/PL71QplJWp1RoaKEMTo_9CZA-kyjwT5rGo.html ► Private Equity Videos: ua-cam.com/play/PL71QplJWp1Rrm0dkWjjIY2cf4jTYSU0t2.html
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.
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?
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.
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
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
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!
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
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!
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!
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!
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: ua-cam.com/play/PL71QplJWp1RoaKEMTo_9CZA-kyjwT5rGo.html
► Private Equity Videos: ua-cam.com/play/PL71QplJWp1Rrm0dkWjjIY2cf4jTYSU0t2.html
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.
this has been requested quite a bit so will do this later on!
Such an underrated video. This is an incredible resource, hope you’re having a good time in Philly!
Appreciate the IRR table, def very helpful
Thanks for the video, always appreciated! Any way you could do a capitalization table?
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
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.
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
Literally missed these modelling videos. 😭. Precedent valuation can you make?
Missed these as well!
will try to do more!
Would be nice a M&A transaction model of a company using leverage to buy another, and all the implications
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?
Sir i havea doubt,
Exit equity value = Ent Value + Net debt - Cash
So it will be 916
And MOIC will be 6.1x
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.
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
Thank you so much for all the great videos!! they helped a ton XD
Nice, would be nice with a video on reverse DCF also
Great video. Super high quality content, hardly a wasted moment. Keep up the great work.
@Rareliquid did you remove the excel file for the paper LBO?
Is it better to round to the nearest 5 or 10, in a paper lbo, for each step?
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
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
Hey, when will you talk about the real company Cannafarm Ltd that brings profit?
Someone has the free excel template? When I click on the link it says that the page is not found... Thanks a lot!
Same :(
Same Issue
Johnson Jennifer Martin Sandra Brown Paul
Massive error in that income statement, MD would rail you for mislabeling the margin…
You mean the Ebitda / ebit margin thing? Indeed MD will go crazy especially its only noticed when shared with the client 😂
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!
Sheesh this LBO is bad you go to Wharton to trick people into applying for your “online class” eventually lol
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
thx ben dailo😊
Hey, when will you talk about the real company Cannafarm Ltd that brings profit?
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!
Hey, when will you talk about the real company Cannafarm Ltd that brings profit?
Hey, when will you talk about the real company Cannafarm Ltd that brings profit?
Hey, when will you talk about the real company Cannafarm Ltd that brings profit?
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!
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!