How to Build a PAPER LBO Model in 3 Steps! (FREE Excel Included)

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ก.ย. 2024

ความคิดเห็น • 67

  • @rareliquid
    @rareliquid  ปีที่แล้ว +1

    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: th-cam.com/play/PL71QplJWp1RoaKEMTo_9CZA-kyjwT5rGo.html
    ► Private Equity Videos: th-cam.com/play/PL71QplJWp1Rrm0dkWjjIY2cf4jTYSU0t2.html

  • @aishwaryapotdar1348
    @aishwaryapotdar1348 ปีที่แล้ว +23

    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.

    • @rareliquid
      @rareliquid  ปีที่แล้ว +7

      this has been requested quite a bit so will do this later on!

  • @PCDisciple
    @PCDisciple 7 หลายเดือนก่อน +1

    Such an underrated video. This is an incredible resource, hope you’re having a good time in Philly!

  • @shanel.478
    @shanel.478 ปีที่แล้ว +3

    Appreciate the IRR table, def very helpful

  • @larshpt
    @larshpt ปีที่แล้ว +4

    Thanks for the video, always appreciated! Any way you could do a capitalization table?

  • @jasonfrancis0997
    @jasonfrancis0997 10 หลายเดือนก่อน +1

    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

  • @taylorparrish4323
    @taylorparrish4323 6 หลายเดือนก่อน

    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.

  • @maximilianmunster8756
    @maximilianmunster8756 ปีที่แล้ว +4

    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

  • @darrelldas1962
    @darrelldas1962 ปีที่แล้ว +5

    Literally missed these modelling videos. 😭. Precedent valuation can you make?

  • @fernandogonzalezhenr
    @fernandogonzalezhenr ปีที่แล้ว +2

    Would be nice a M&A transaction model of a company using leverage to buy another, and all the implications

  • @markgarcia3239
    @markgarcia3239 หลายเดือนก่อน

    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?

  • @str5148
    @str5148 7 หลายเดือนก่อน +1

    Sir i havea doubt,
    Exit equity value = Ent Value + Net debt - Cash
    So it will be 916
    And MOIC will be 6.1x

    • @joshturanich6646
      @joshturanich6646 6 หลายเดือนก่อน

      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.

  • @christianandreaprile8477
    @christianandreaprile8477 8 หลายเดือนก่อน

    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

  • @zoetuan8326
    @zoetuan8326 ปีที่แล้ว

    Thank you so much for all the great videos!! they helped a ton XD

  • @1989Murmel
    @1989Murmel 11 หลายเดือนก่อน

    Nice, would be nice with a video on reverse DCF also

  • @thesnackbandit
    @thesnackbandit ปีที่แล้ว

    Great video. Super high quality content, hardly a wasted moment. Keep up the great work.

  • @gadripericles3034
    @gadripericles3034 29 วันที่ผ่านมา

    @Rareliquid did you remove the excel file for the paper LBO?

  • @aishwaryapotdar1348
    @aishwaryapotdar1348 ปีที่แล้ว +3

    Is it better to round to the nearest 5 or 10, in a paper lbo, for each step?

    • @rareliquid
      @rareliquid  ปีที่แล้ว +2

      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

  • @bacool
    @bacool ปีที่แล้ว

    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

  • @fezooyxd4113
    @fezooyxd4113 ปีที่แล้ว

    Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

  • @MariaSimónGrau
    @MariaSimónGrau 3 หลายเดือนก่อน

    Someone has the free excel template? When I click on the link it says that the page is not found... Thanks a lot!

    • @Gucci-dj3ko
      @Gucci-dj3ko 2 หลายเดือนก่อน

      Same :(

    • @olegdoev6388
      @olegdoev6388 5 วันที่ผ่านมา

      Same Issue

  • @fullerralphs8045
    @fullerralphs8045 9 วันที่ผ่านมา

    Johnson Jennifer Martin Sandra Brown Paul

  • @Nss1120
    @Nss1120 11 หลายเดือนก่อน

    Massive error in that income statement, MD would rail you for mislabeling the margin…

    • @QrankChannel
      @QrankChannel 6 หลายเดือนก่อน

      You mean the Ebitda / ebit margin thing? Indeed MD will go crazy especially its only noticed when shared with the client 😂

  • @shortsonly2846
    @shortsonly2846 ปีที่แล้ว

    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!

  • @user-hn3uu3gj2g
    @user-hn3uu3gj2g ปีที่แล้ว

    Sheesh this LBO is bad you go to Wharton to trick people into applying for your “online class” eventually lol

    • @rareliquid
      @rareliquid  ปีที่แล้ว +8

      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

  • @ilovelifan
    @ilovelifan ปีที่แล้ว

    thx ben dailo😊

  • @yosf5972
    @yosf5972 ปีที่แล้ว

    Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

  • @cj7sanny399
    @cj7sanny399 ปีที่แล้ว

    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!

  • @YoutubePotato092
    @YoutubePotato092 ปีที่แล้ว

    Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

  • @mrareebytshorts6781
    @mrareebytshorts6781 ปีที่แล้ว

    Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

  • @haoleotop5638
    @haoleotop5638 ปีที่แล้ว

    Hey, when will you talk about the real company Cannafarm Ltd that brings profit?

  • @rapamericain9987
    @rapamericain9987 ปีที่แล้ว

    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!

  • @atchayphoemnay4114
    @atchayphoemnay4114 ปีที่แล้ว

    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!