How to Complete LBO for Private Company, No Cash Flow Statement?

Relatively new to LBOs so please bear with me! Started practicing on a case where the only financial information in the CIM was a basic financial forecast (think revenue - operating expenses = EBITDA) and detailed calculations on said revenue, operating expenses, and Adj/EBITDA, no balance sheet or statement of cash flows. Goal is to come up with a recommended acquisition price for the company, sources/uses, and IRR over 5 years. A few questions below:

  • I'm lost as to how to build out the model. My understanding was I at least need a statement of cash flows to work out FCF, but I don't have that. Am I thinking about this wrong?

  • I'm assuming I have to make a lot of assumptions on entry/exit multiple, debt to take on, etc. b/c literally none of that is given. Normally I'd look at some public comps, but the company in question is a landscaping company, and not sure there are many public comps for that. How else can I make more educated assumptions instead of randomly pulling numbers?

Thanks in advance for any help!

 
Most Helpful

Hi!

I am in no way a pro at this so please correct me if wrong. I would generally approach it something like this, assuming you have an on-site test with no access to comps.

As others have mentioned, you don’t need a historical CFS/BS.

  1. Is historical capex / NWC available? If yes, then project these based on historical avg in % to revenue. If no, then try to think if this Company is asset heavy or if the business model would imply a large NWC, and base forecast of this. Use historical D&A as a guideline for Capex perhaps? If these assumptions feel like you are shooting from the hip, construct a sensitivity table with these parameters at the and.
  1. In terms of Entry/Exit multiple, I would use a random entry multiple (e.g. 10x EBITDA) just for the purpose of setting up the model (incl. S&U, debt and return analysis). Assume Exit = Entry, and when the model mechanics is done, backsolve the multiple so you get a reasonable exit IRR.
  1. If no details is given on debt, assume a generic bullet loan with the optionality to cash sweep + RCF. You can gauge the quantum by looking at what levels your FCFs turns negative, but generally around 3-6x. Assume a margin of, let’s say, 500 BPS
 

Doloremque nisi molestiae nostrum eum illo iste velit. Voluptate et voluptatem id dolore. Dolor sit officiis explicabo molestias odio ut.

Career Advancement Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 99.0%
  • Warburg Pincus 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

April 2024 Private Equity

  • Principal (9) $653
  • Director/MD (22) $569
  • Vice President (92) $362
  • 3rd+ Year Associate (90) $280
  • 2nd Year Associate (205) $268
  • 1st Year Associate (387) $229
  • 3rd+ Year Analyst (29) $154
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (314) $59
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”