How to model LBO with no CFS or BS?
Hello,
How would I short form LBO model a company with only the last three years of income statements by month?
Trending Content - Investment Banking Forum
| +195 | Evercore > Goldman and I don’t think it’s particularly close anymore | 73 | 6h |
| +159 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 18 | 18h |
| +125 | Think Twice before Recruiting for HOUSTON IB!! | 60 | 13h |
| +86 | UBS Offer Day | 36 | 7h |
| +74 | I hate Wells Fargo | 20 | 20h |
| +57 | No return offer - feeling like a failure is an understatement | 24 | 20h |
| +49 | How cooked am I as an incoming WF IB SA 2027? | 17 | 2d |
| +47 | WF Return offers | 32 | 11h |
| +41 | 2026 Investment Banking Return Offer Climate | 25 | 2d |
| +41 | Should I go back into a junior IBD role for comp? | 19 | 14h |
Career Resources
It's possible with just the income statement - do they give you other assumptions about the transaction? If no, you'll need to make educated guesses about the company's existing net debt (might be possible to derive from interest expense), sources and uses, NewCo. debt, and KPIs like rev growth, COGS and OPEX growth, D&A, etc. (I always like that part because it's an opportunity to get creative within the context of the company and the industry).
From there, project out the next 5 years of the income statement and model the full debt situation based on your assumptions, and then assume an appropriate EBITDA multiple to get to EV and get to equity value from there.
If there is cash sweep or dividends, model those as well, and then you throw a quick XIRR on there, a MOIC calculation, and a sensitivity analysis of revenue growth and IRR and you're good to go.
Anybody have other stuff to add or change?
thanks so much
Et saepe modi temporibus aspernatur et eum tempora. Quod sapiente quis cumque. Illo suscipit reprehenderit ipsa aspernatur eum impedit.
Eum modi reiciendis nulla numquam. Vero magnam ut dignissimos ipsum qui quam ipsam. Occaecati autem sapiente similique et nihil ut ab.
Consequatur quia optio rerum aperiam quam iste. Qui at quod aut nihil autem ut. Quam eos magnam sed rerum alias.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...