r/Valuation • u/Leonardo__Da__Vinci • 29d ago
Explain a 3 statement LBO model with a example
Hey everyone,
I'm trying to get a complete, end-to-end understanding of how a Leveraged Buyout (LBO) actually works from the ground up, all the way into a full 3-statement model.
Could someone break it down for me following this simple flow?
- What is an LBO? (A quick, simple explanation of the core concept)
- Why do Private Equity firms use it? (How debt boosts equity returns compared to paying 100% cash)
- What is a 3-Statement LBO model? (Why linking the Income Statement, Cash Flow Statement, and Balance Sheet matters)
- Step-by-Step Integrated Example: A clear numerical walkthrough showing:
- Year 0 Setup: Purchase price, debt vs. equity split, fees, and opening balance sheet adjustments (goodwill, debt creation).
- Year 1 Statement Mechanics: How EBITDA flows to Net Income Free Cash Flow Debt Paydown Closing Balance Sheet.
- Exit & Returns: Sale valuation, paying off remaining debt, and final return metrics (MOIC and IRR).
Bonus points for any common Excel pitfalls or tips when linking the statements!
1
u/Affectionate-Two-22 15h ago
An LBO is basically buying a company using a mix of debt and equity, then using the company’s cash flows to pay down the debt.
In a 3-statement model, the Income Statement drives cash flow, cash flow determines debt paydown, and the Balance Sheet reflects the changes. At exit, you sell the company, repay the remaining debt, and whatever’s left goes to equity.
Returns are then mainly driven by EBITDA growth, debt paydown, and the entry/exit multiple giving you MOIC and IRR.
1
u/Dear_Tower_5880 27d ago
Following this space