2 Hour 3-Statement LBO Case Study - Private Equity - Built from Scratch

Watch me build a 3-statement LBO model from scratch. Great practice and review for private equity case study interviews!

About me: My name is Josh Jia and I have 9 years of investment banking and private equity experience. Since founding Finance Interview Coach, I have helped place over 100 people in finance related roles at top banks like Goldman Sachs, Morgan Stanley, and JP Morgan, as well as top PE firms like Apollo, Onex, and Blackstone.

We also provide interview coaching for corporate development, equity research, hedge funds, venture capital, corporate / commercial banking, private debt, and FP&A.

[georgepatterson]

interesting to watch the spreadsheet take shape - i have no idea whats involved here but seems like qualified folks would be able to follow along well.

[asunagilfoyle]

i love how this is just...free for anyone to watch.

[praveen]

Amazing content, cannot believe someone will post something like this for free on the internet.

[kellenjemeyson]

Show the part where you lay off all the front line staff to cover the debt service

[Nomad]

In your NWC Schedule you had a miscalculation. Time stamp, 1:01:20. You multiplied cogs twice rather than days. It should be 61 for days payable outstanding.

[lskee]

Randomly stumbled across this, this is awesome! New Sub

[ballsyclan]

A couple of questions:
1) Should the Minimum cash amount be included under "Uses" given that should be the minimum operating cash needed to operate the business and therefore included
2) Why is OID not included as part of the Uses?
3) How come the existing cash is not used to net off the refinanced debt portion?

[farhanashaik]

Thanks for the video. Please prepare an interview/career guide for private equity so that we can study it and Ace interviews. Thank you.

[SouthsideWing]

Great stuff. Have been practicing several times

[migueltavarez]

Awesome video, it would be good if you also put the keyboard entries so we can see the shortcuts you use in excel 👍

[simondechoisy]

Josh - would it ve possible to get hold of a copy of the case study instructions?

[saudarshi]

I wish I saw this video 5 years ago, Great job!

[thechanagal]

When you stepped up PP&E by 15% when you did the purchase price allocation, how come it didn’t create a deferred tax liability

[lindsaybok]

This video is amazing and really on point even for a current analyst myself! Is there any way you can send the answer sheet? I could not find the link for it and would be hugely appreciated if you could share the link!

[safeershahid]

Hi! its an amazing tutorial. please share the practice file so we practice along with the tutorial.

[nicolashassoun]

Great video, super helpful, I just have a question regarding the CFI at the end, why don't you include the revolver commitment fee to the Borrowing / (repayment) of Revolver line in the CFI?

[benjaminpowell]

Loved the walkthrough, can we download this anywhere? thanks

[lukasfinster]

great stuff!! Have learned a lot - i have tried to replicate it but noticed that cash - interest is not considered. Could you please explain?

[Fact-Flingofficial]

try to upload dcf i like your videos too much man

[alexandervalladares]

This is an excellent video … Thank you