![Finance Interview Coach - Joshua Jia](/img/default-banner.jpg)
- Видео 33
- Просмотров 292 863
Finance Interview Coach - Joshua Jia
Добавлен 14 авг 2020
Investment banking and private equity interview prep tips from Joshua Jia, the writer of 300 Questions and the founder of Finance Interview Coach
Twitter - 3-Statement LBO Model from Scratch - Finance Interview Coach and Apex (Part 2 of 3)
This is the second live session of a 3-part series of videos featuring an LBO model of Twitter made from scratch. Elon Musk's $44B purchase of Twitter financed by $13.5B of debt made headlines in the past few months, especially given the drastic changes he's made to the company.
The next and final live session will be on Saturday (February 18, 2023) at 2 to 3 pm EST, where I will finish building the Twitter LBO model and add scenario and sensitivity analysis.
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,...
The next and final live session will be on Saturday (February 18, 2023) at 2 to 3 pm EST, where I will finish building the Twitter LBO model and add scenario and sensitivity analysis.
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,...
Просмотров: 2 297
Видео
Twitter - 3-Statement LBO Model from Scratch - Finance Interview Coach and Apex (Part 1 of 3)
Просмотров 2,6 тыс.Год назад
This is the first live session of a series of videos featuring an LBO model of Twitter made from scratch. Elon Musk's $44B purchase of Twitter financed by $13.5B of debt made headlines in the past few months, especially given the drastic changes he's made to the company. The next live session will be next Sunday (February 12, 2023) at 1 to 2:30 pm EST, where I will continue building the Twitter...
2 Hour 3-Statement LBO Case Study - Private Equity - Built from Scratch
Просмотров 238 тыс.2 года назад
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 a...
Stock Market Update - Thursday, Aug 18, 2022
Просмотров 3312 года назад
Daily Stock Market Update (Thursday, Aug 18, 2022) - Finance Interview Coach 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 with an 83% success rate in finance related roles at top banks like Goldman Sachs, Morgan Stanley, and JP Morgan, as well as top PE firms like...
Daily Stock Market Update - Wednesday, Aug 17, 2022
Просмотров 1322 года назад
Daily Stock Market Update (Wednesday, Aug 17, 2022) - Finance Interview Coach 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 Black...
3 Statement LBO Model - Quick Overview + Walkthrough - Finance Interview Coach + Apex Advisory
Просмотров 19 тыс.2 года назад
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 re...
Daily Stock Market Update - Monday, Feb 28, 2022
Просмотров 1682 года назад
Russia and Ukraine failed to reach a ceasefire agreement on Monday and the fighting has continued. This has resulted in a 30% decline in the value of the rouble, which is now worth less than 1 US cent. The Russian stock market ETF, RSX, also declined 30% on Monday. In the US, the markets were flat, with the S&P 500 down 0.2% and the NASDAQ up 0.4%. 4 of 11 sectors in the green, with energy up 2...
Daily Stock Market Update - Friday, Feb 25, 2022
Просмотров 492 года назад
The S&P and NASDAQ were up on Friday by 2.2% after a very volatile week due to Russia's invasion of Ukraine. All 11 sectors were up, led by financials, materials, and consumer staples up 3.3%. Utilities up 31%. CarGuru, the online company that matches buyers and sellers for used and new cars, was up 44% on earnings, with revenue up 144% YoY. LendingTree was up 15.6% on earnings, and their consu...
Daily Stock Market Update - Thursday, Feb 24, 2022
Просмотров 462 года назад
The market rebounded on Thursday, after a very poor trading day on Wednesday that was driven by Russia's invasion of Ukraine. Nasdaq up 3.3%, S&P up 1.5%. Tech up 3.2%, communications up 2.8%, consumer discretionary up 2.3%, while consumer staples down 1.7%. Moderna was up 15% after beating revenue and earnings estimates, and raising their outlook for COVID-19 vaccine revenue of $19B in 2022 vs...
1 Minute Daily Stock Market Update - Wednesday, Feb 23, 2022
Просмотров 532 года назад
It was a very tragic day on Wednesday when Russia invaded Ukraine and the stock market responded very negatively. The NASDAQ down 2.6%, S&P down 1.8%. Led by consumer discretionary falling 3.6%, tech down 2.5%, industrials down 1.8%. Energy up 1.1%, oil prices up above $92. Wheat futures up 3.6%, Soybean futures up 3.3%. Overstock, the online discount furniture retailer, is up 23% on earnings, ...
1 Minute Daily Stock Market Update - Tuesday, Feb 22, 2022
Просмотров 492 года назад
The S&P 500 fell 1.0% and the NASDAQ was down 1.2% on Tuesday, driven by Russia's invasion of Ukraine. The US has announced sanctions, while Germany has frozen its Nord Stream 2 natural gas project, putting further upward pressure on natural gas prices. Consumer discretionary was down 2.9%, energy was down 1.6%, and materials down 1.4%. Home Depot down 9% despite beating top and bottom line, Te...
Weekly Stock Market Update (Feb 18, 2022) - 1 Minute Video - Finance Interview Coach
Просмотров 722 года назад
What a volatile week it's been in the markets! NASDAQ down 1.2%, S&P 500 down 0.7%, and a lot of volatility coming from the expectation that Russia may invade Ukraine. Inflation has been the name of the game with US wholesale inflation at 9.7%, but companies like Walmart have done well as more consumers spend there to save money. In fact, retail spending by US consumers has increased by 3.8% in...
1 Minute Stock Market Update - Wednesday, Feb 16, 2022
Просмотров 522 года назад
Here's a 1 minute update on the stock market, summarizing yesterday's events (Tuesday, Feb 16, 2022). S&P 500 up 1.6%, NASDAQ up 2.5%, driven by Russia's announcement that they will not be attacking Ukraine this month or next month. Airbnb reported Q4 earnings 7.8% higher than last year. However, US wholesale inflation was reported at 9.7% and we are likely to see 6 or 7 rate hikes this year, o...
How to do a short LBO case study (1-4 hours) in private equity - 1 minute video
Просмотров 3,3 тыс.2 года назад
How to do a short LBO case study (1-4 hours) in private equity - 1 minute video
Finance Interview Coach - Interview Coaching / Prep for Investment Banking and Private Equity
Просмотров 5602 года назад
Finance Interview Coach - Interview Coaching / Prep for Investment Banking and Private Equity
Paper LBO from Start to Finish - Private Equity and Investment Banking Interview Prep
Просмотров 15 тыс.2 года назад
Paper LBO from Start to Finish - Private Equity and Investment Banking Interview Prep
Investment Banking Prep Services - Finance Interview Coach
Просмотров 1202 года назад
Investment Banking Prep Services - Finance Interview Coach
Investment Banking Interview Prep - UCLA Lecture - Leveraged Buyouts (LBO) - Part 4 of 4
Просмотров 4312 года назад
Investment Banking Interview Prep - UCLA Lecture - Leveraged Buyouts (LBO) - Part 4 of 4
Investment Banking Interview Prep - UCLA Lecture - Mergers and Acquisitions (M&A) - Part 3 of 4
Просмотров 4352 года назад
Investment Banking Interview Prep - UCLA Lecture - Mergers and Acquisitions (M&A) - Part 3 of 4
Investment Banking Interview Prep - UCLA Lecture - Discounted Cash Flow (DCF) Modeling - Part 2 of 4
Просмотров 3992 года назад
Investment Banking Interview Prep - UCLA Lecture - Discounted Cash Flow (DCF) Modeling - Part 2 of 4
Investment Banking Interview Prep - UCLA Lecture - Enterprise Value and Comps - Part 1 of 4
Просмотров 8092 года назад
Investment Banking Interview Prep - UCLA Lecture - Enterprise Value and Comps - Part 1 of 4
LBO Modeling - Investment Banking Interview Prep - Finance Interview Coach x Investa Insights
Просмотров 4103 года назад
LBO Modeling - Investment Banking Interview Prep - Finance Interview Coach x Investa Insights
Investment Banking Interview Prep Discounted Cash Flow DCF Cont and LBO Intro Finance Interview
Просмотров 3003 года назад
Investment Banking Interview Prep Discounted Cash Flow DCF Cont and LBO Intro Finance Interview
Investment Banking Interview Prep - Discounted Cash Flow (DCF) - Finance Interview Coach (Investa)
Просмотров 5303 года назад
Investment Banking Interview Prep - Discounted Cash Flow (DCF) - Finance Interview Coach (Investa)
Investment Banking Interview Prep - Comparables and Enterprise Value Finance Interview Coach
Просмотров 9983 года назад
Investment Banking Interview Prep - Comparables and Enterprise Value Finance Interview Coach
Leveraged Buyouts (LBOs) - How Returns Are Driven
Просмотров 8113 года назад
Leveraged Buyouts (LBOs) - How Returns Are Driven
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?
yes agreed i believe he did...i had the same question.
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?
because it has the highest seniority
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
Can you pls recommend website to learn investment banking from scratch, majorly practicals that involves excel
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"?
I dont think so. First one is correct
no, neither depreciation nor amortization are included in SG&A
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
Go work in a mine then.
Yea that's our job, is it boring? No if you like but to most people? Yes it is
@@AliRethrbuck working in a mine actually does something useful and so do lots of other jobs out there that don't involve physical labor. this stuff here on the other hand is just a boring waste of time. you're not contributing anything useful to society.
@@Sebastian-hg3xc so you think if all of the finance industry stopped working nothing would happen?
@@AliRethrbuck just because someone doesn’t want to work 80hrs a week in a office with this stuff doesn’t mean there gonna work in a mine 😭😭😭
Awesome video, it would be good if you also put the keyboard entries so we can see the shortcuts you use in excel 👍
He probably learned those shortcuts through countless hours of excel though. It's not impossible to do but you'd need like some key record software real time showing this or something that he'd have to systematically post through his vid, I think. There is another way to do super basic shortcuts though, (might not be what he's doing), just by holding/pressing [alt], it will shortcut you to any specific part of the "excel UI interface" i.e. file, home, insert, page layout, etc... That's probably a big part of how he has his incredible speed also while he's masterfully using 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.