Видео

Young Daniel Lee Brian Garcia William

You forgot to substract cash in purchase price

Video starts at 14:50

Can you provide the template?

You are gay

Hi Josh, great content. How do I book a session with you to learn?

What is happening to cash that you adjusted in 2012? Either that should have been spent on transaction or remained on the balance sheet. You have adjusted that in balance sheet but not spent it on transaction fees or pass it through cash flow statement !

in minute 37 you make a mistake for depreciation calculation. You took the sum of depreciation and amortization. That is why it does not match.

This is an excellent video … Thank you

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!

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

1:28:35 Did you deduct Term Loan Mandatory Amortization twice?

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

Why are financing fees considered Non-current assets instead of Non-Current Liabilities?

Great to watch. Well done!

Could you please share the excel file?

What is the short cut to copy paste cell references that he uses frequently?

Why is the revolver (lowest interest) paid off first?

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

Hey there! I just stumbled upon your channel and wanted to drop a note. Although I'm a Data Analyst and some of the more advanced finance concepts are pretty new to me, I've found your analysis incredibly intriguing and energizing! Your content has sparked a real excitement in me to delve deeper into the world of finance. Thank you so much for sharing your knowledge. Keep up the great work-I can’t wait to see what I'll learn next! Cheers!!!

Should the $25m that you took out of the existing cash balance, to get to the minimum cash balance, not be included in the sources?

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

Great stuff. Have been practicing several times

I would have calculated EBITDA as follows: EBITDA = Revenue - COGS - SG&A + D&A. Why did you assume that COGS and SG&A is pre-D&A?

Hi, firstly thank you for the wonderful video. Just one question 1/ you put in as "Gross profit - SG&A = EBITDA" 2/ isn't that supposed to be"Gross profit - SG&A = EBIT"?

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?

Plzzzzz try to upload dcf i like your videos too much man

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

As I get closer to the end, it gets messy....

59:34 alt e s l

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

Is there a way to download the material used here?

Extremely helpful video! Definitely worth watching multiple times.

Guys why entry and ex8t multiple the same?

Omg voice twin of Sam Sulek

great content, thank you for making it and sharing it

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

what I learned so far. add New Row = Alt + I + R Duplicate Worksheet = Alt + W + N

Really interesting video, tho could you open a few more tabs pls ;)

Where can I get the final Spread sheet?

what fantasy world full of nonsense did i just enter.

god damn this is boring as fuck

I don't get how people can do this sort of work. So boring and useless.

Just curious, does knowing this has a future? I guess a KI could do this task in seconds.

Wow

We went from Hunter gather society to this

Looks pretty boring

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

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.

Your content is great yet distractive with all the starts and stops.