Sources and Uses statement - private LBO model

I need help with a basic lbo model -I'm a newbie and have done as much research as I can, want to confirm I'm handling debt and fees correctly. Given assumptions:

  1. The purchase price is $33 million. The owner must pay off the existing debt at closing from the proceeds he receives.
  2. Assume the purchase was completed on 12/31/2016
  3. Senior debt limited to 2.5x EBITDA; interest -3%; this is a revolver, so all cash above $500k is applied to the revolver, then to the Mezz debt.
  4. Mezz debt limited to 3.5x EBITDA, including senior debt; interest - 12%, plus 3% warrants given the Mezz lender. Strike price is based on the equity value of the new capital structure.
  5. Remaining capital structure is equity, of which owner has 15%.
  6. Owner deal costs are $1.2mm
  7. PE deal costs are $600k – The Company pays these costs, but are not deducted from owner proceeds

I'm struggling with my sources and uses statement -

EBITDA: $6,420k Current cash from balance sheet: $175k Debt from balance sheet: $12,602k

Do I include debt in the total purchase price? or include lines for refinanced debt? how do I account for the fees owed by the owner? Do I have my Mezz debt correct? Here's where I am now:

Sources: Cash - 175 Senior debt - 16,050 (2.5x EBITDA) Mezz debt - 6,420 (1x EBITDA) Sponsor Equity / Cash - 11,545 Management Equity - 36,227

Uses: Equity purchase price - 20,573 (total purchase price less debt) Debt assumed by seller - 12,602 Financing Fees - 1,252 (3% for senior debt, 12% for Mez debt) Transaction costs - sponsor - 1,200 Transaction costs - seller - 600

Total uses: 36,227

7 Comments

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.8%
  • Morgan Stanley 07 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.7%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $101
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...”