Finance Interview Coach - Joshua Jia
Finance Interview Coach - Joshua Jia
  • Видео 33
  • Просмотров 324 398
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,...
Просмотров: 2 572

Видео

Twitter - 3-Statement LBO Model from Scratch - Finance Interview Coach and Apex (Part 1 of 3)
Просмотров 2,9 тыс.Год назад
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
Просмотров 262 тыс.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
Просмотров 3502 года назад
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
Просмотров 1372 года назад
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
Просмотров 21 тыс.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
Просмотров 1802 года назад
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
Просмотров 542 года назад
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
Просмотров 512 года назад
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
Просмотров 532 года назад
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
Просмотров 762 года назад
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
Просмотров 562 года назад
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,8 тыс.2 года назад
How to do a short LBO case study (1-4 hours) in private equity - 1 minute video
How to Do
Просмотров 1842 года назад
How to Do
Finance Interview Coach - Interview Coaching / Prep for Investment Banking and Private Equity
Просмотров 6242 года назад
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
Просмотров 17 тыс.2 года назад
Paper LBO from Start to Finish - Private Equity and Investment Banking Interview Prep
Investment Banking Prep Services - Finance Interview Coach
Просмотров 1333 года назад
Investment Banking Prep Services - Finance Interview Coach
Investment Banking Interview Prep - UCLA Lecture - Leveraged Buyouts (LBO) - Part 4 of 4
Просмотров 4923 года назад
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
Просмотров 4903 года назад
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
Просмотров 4463 года назад
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
Просмотров 8763 года назад
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
Просмотров 4693 года назад
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
Просмотров 3283 года назад
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)
Просмотров 5853 года назад
Investment Banking Interview Prep - Discounted Cash Flow (DCF) - Finance Interview Coach (Investa)
Investment Banking Interview Prep - Comparables and Enterprise Value Finance Interview Coach
Просмотров 1,1 тыс.3 года назад
Investment Banking Interview Prep - Comparables and Enterprise Value Finance Interview Coach
Leveraged Buyouts (LBOs) - How Returns Are Driven
Просмотров 9143 года назад
Leveraged Buyouts (LBOs) - How Returns Are Driven
Stock Pitch
Просмотров 2,4 тыс.4 года назад
Stock Pitch
DCF
Просмотров 5674 года назад
DCF
Comps
Просмотров 4634 года назад
Comps

Комментарии

  • @cristianoronaldo-lr2mw
    @cristianoronaldo-lr2mw Месяц назад

    What is the revolver

  • @georgewood00
    @georgewood00 Месяц назад

    Amazing thank you so much

  • @adrilife2709
    @adrilife2709 Месяц назад

    Joshua thanks for the explanation while going through the model, very valuable material.

  • @steffenvergeylen1097
    @steffenvergeylen1097 2 месяца назад

    Hi. At 50:15 mark. So let's say CF is negative, then you borrow money equal to the amount of the negative CF? Is there like no limit you can borrow then? I wonder because the formula doesn't consider that.

    • @financeinterviewcoach-josh5963
      @financeinterviewcoach-josh5963 2 месяца назад

      Revolvers typically have a maximum (1-2x EBITDA) and you pay a commitment fee on the undrawn amount, but I didn't build that max capacity in here. There's not really a point of creating a hard max that breaks your model and gives you negative cash, better to just have an error check so it highlights when you are past your max.

  • @OmerLints-m3s
    @OmerLints-m3s 2 месяца назад

    Powlowski Loaf

  • @GarfieldGlander-t5h
    @GarfieldGlander-t5h 2 месяца назад

    Kshlerin Ranch

  • @JimmyShea-d6s
    @JimmyShea-d6s 2 месяца назад

    Zieme Points

  • @FIN-u7i
    @FIN-u7i 2 месяца назад

    1:19:42 those values of D&A have been changed in the start we put it as 2% of revenue but its different now that made my calculations different than yours is it a mistake or did I miss something

  • @MacaulayKelly
    @MacaulayKelly 2 месяца назад

    8862 Geovany Hollow

  • @asunagilfoyle
    @asunagilfoyle 2 месяца назад

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

  • @sarahfasson3055
    @sarahfasson3055 3 месяца назад

    are you not double counting the mandatory amortization at 1hour 29min mark?

  • @LyndDaphne
    @LyndDaphne 3 месяца назад

    699 Kunze Place

  • @WrightGracie
    @WrightGracie 3 месяца назад

    3093 Lonie Parkways

  • @TheGuillotineKing
    @TheGuillotineKing 3 месяца назад

    I did this in under 5 minutes with AI my how times have changed

  • @rileycacamacdonald9690
    @rileycacamacdonald9690 3 месяца назад

    1607 Brody Field

  • @AnjelicaBiagini
    @AnjelicaBiagini 3 месяца назад

    8804 Felton Shoals

  • @peterhans8905
    @peterhans8905 3 месяца назад

    Is it possible to download the slide deck somewhere by any chance? Thank you so much in advance!

  • @FudgeBondu
    @FudgeBondu 3 месяца назад

    Walker Jeffrey Jones Brian Walker Jennifer

  • @YkgjfhFhfhjr
    @YkgjfhFhfhjr 3 месяца назад

    8692 Loyal Roads

  • @maguirakonwell
    @maguirakonwell 3 месяца назад

    550 Bryon Well

  • @CroninLynn
    @CroninLynn 3 месяца назад

    3515 Gennaro Island

  • @cameronweber2043
    @cameronweber2043 3 месяца назад

    I enjoy Joshua's LBO case study video, but viewers please note that gross profit minus SG&A is NOT EBITDA; you would not subtract D&A from EBITDA to get to EBIT, but rather add D&A to EBIT to get EBITDA. D&A as an expense is either going to be a part of COGS or a part of Operating expenses (SG&A in this case), depending on the nature of the business.

    • @financeinterviewcoach-josh5963
      @financeinterviewcoach-josh5963 3 месяца назад

      I'm glad you enjoy the video! In private equity, we typically do not include D&A in SG&A, because it is a non-cash expense that simply represents an asset becoming worth less over time. It is an accounting metric that is not useful for analyzing core profitability other than the fact that it effects taxes. So in PE case studies and PE models, we strip D&A out of SG&A. You are correct that in the financial statements of most public companies, D&A is included in SG&A as that is just what most accountants for public companies are used to doing. So it's just a difference between how PE investors look at SG&A and how accountants for public companies look at SG&A.

  • @БожидарБожидарЙОРДАНОВ

    02493 Trantow Harbor

  • @krishnasinghalCFA
    @krishnasinghalCFA 4 месяца назад

    Can I get this final template, Please?

  • @amankaur1899
    @amankaur1899 4 месяца назад

    Hi Josh, big fan of your videos (from India). I have learned so much from them, more than any paid course I ever did. Just wondering if you forget to record the Part 3 of 3 lol

  • @martinsafarian4404
    @martinsafarian4404 4 месяца назад

    You forgot to substract cash in purchase price

  • @martinsafarian4404
    @martinsafarian4404 4 месяца назад

    Video starts at 14:50

  • @Julia-sz1xn
    @Julia-sz1xn 4 месяца назад

    Can you provide the template?

  • @CharlieKirk-oe2os
    @CharlieKirk-oe2os 4 месяца назад

    You are gay

  • @liyin9978
    @liyin9978 5 месяцев назад

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

    • @financeinterviewcoach-josh5963
      @financeinterviewcoach-josh5963 2 месяца назад

      Hi, thanks for your inquiry. You can schedule a session with me here: www.financeinterviewcoach.com/services/schedule-a-call/

  • @ajaydhameliya5793
    @ajaydhameliya5793 5 месяцев назад

    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 !

  • @alexanderdeboeck-ub5tj
    @alexanderdeboeck-ub5tj 5 месяцев назад

    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.

  • @alexandervalladares2501
    @alexandervalladares2501 6 месяцев назад

    This is an excellent video … Thank you

  • @lindsaybok9002
    @lindsaybok9002 6 месяцев назад

    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!

  • @thechanagal396
    @thechanagal396 6 месяцев назад

    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

  • @DH0518
    @DH0518 6 месяцев назад

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

    • @Mr3921151
      @Mr3921151 6 месяцев назад

      yes agreed i believe he did...i had the same question.

  • @saudarshi6916
    @saudarshi6916 6 месяцев назад

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

  • @AdanSheikh-uq1tg
    @AdanSheikh-uq1tg 7 месяцев назад

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

  • @financialrecovery453
    @financialrecovery453 7 месяцев назад

    Great to watch. Well done!

  • @natashasajnani4352
    @natashasajnani4352 7 месяцев назад

    Could you please share the excel file?

  • @filipeiller986
    @filipeiller986 7 месяцев назад

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

  • @samuel.andermatt
    @samuel.andermatt 8 месяцев назад

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

    • @yunjiebao6367
      @yunjiebao6367 6 месяцев назад

      because it has the highest seniority

  • @lukasfinster7890
    @lukasfinster7890 8 месяцев назад

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

  • @dtxdatan2645
    @dtxdatan2645 8 месяцев назад

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

  • @sambreakwell884
    @sambreakwell884 8 месяцев назад

    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?

  • @safeershahid9150
    @safeershahid9150 8 месяцев назад

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

  • @SouthsideWing
    @SouthsideWing 8 месяцев назад

    Great stuff. Have been practicing several times

    • @akinwunmizainab6070
      @akinwunmizainab6070 8 месяцев назад

      Can you pls recommend website to learn investment banking from scratch, majorly practicals that involves excel

  • @MichaelScott858
    @MichaelScott858 9 месяцев назад

    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?

  • @beyondalpha2437
    @beyondalpha2437 9 месяцев назад

    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"?

  • @nicolashassoun1731
    @nicolashassoun1731 11 месяцев назад

    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?