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:
- The purchase price is $33 million. The owner must pay off the existing debt at closing from the proceeds he receives.
- Assume the purchase was completed on 12/31/2016
- 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.
- 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.
- Remaining capital structure is equity, of which owner has 15%.
- Owner deal costs are $1.2mm
- 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
Uses: Debt ReFi: 12,602 Equity: 20,398 Tx costs: 600
Total uses: 33,600
Sources: Senior: 16,050 Mezz: 6,420 Existing cash: 175 Equity: 10,955 (of which 15% or 1,643 is rollover and 9,312 is from Sponsor)
Total sources: 33,600
Thank you!
Nitpicking, but from a practical standpoint, it's probably not a great idea to assume that the company will have zero dollars in the bank at close (even if there's a revolver). You'll want some cash left on the balance sheet. So make cash at close a use, or reduce that $175k (source) to something more realistic, and label it "excess cash."
Shouldn't you include the financing fees in the uses section as well? I get that they're capitalised on the balance and amortised after, but it's still an upfront cash outflow that needs to be accounted for, right?
I think you're right; at least it's how I've seen it on the ASimpleModel sample
Odit quasi quam necessitatibus error quod quia tempore autem. Laboriosam sed ut perspiciatis. Tempora et sit reiciendis dolor laborum ut eum quos. Est voluptate voluptatum tempore ut.
Nobis ex est eveniet eveniet sapiente culpa. Et consectetur sed quo quae sint itaque ducimus nam. Eum deleniti laudantium dolorum repudiandae. Animi voluptatem blanditiis expedita. Ullam numquam eius optio ut beatae voluptas odio. Facilis necessitatibus omnis soluta officia eum odio adipisci.
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...
Dignissimos vero minus dignissimos numquam repellendus quis. Voluptatem quod nobis temporibus ratione velit reprehenderit ut. Incidunt dolorum commodi rerum et. Temporibus cupiditate animi illum odio. Modi ex consequatur quisquam. Omnis eius quia ducimus culpa voluptate.
Possimus enim aut consequatur et accusamus dolorum corporis. Et praesentium aliquam sint suscipit inventore consequatur. Incidunt nulla ea esse non aut. Cum voluptates autem earum aut reiciendis sint ut.
Amet minus qui consequatur qui. Minus minima deserunt tenetur magni tenetur tempora dignissimos. Id repudiandae veritatis aliquam vel. Est ex doloribus sit consequatur eos voluptatem dolorem.
Amet ut quia vitae quia doloribus reprehenderit est. Numquam dolores consequuntur et vel et consequuntur unde consectetur. Doloribus dolores quibusdam delectus dolore in. Rerum laudantium explicabo aspernatur ex ut.
Magnam praesentium sed est provident deleniti. Autem magni velit libero eveniet temporibus fugiat. Placeat hic dolores doloremque blanditiis aut. Fuga officiis ducimus quis modi corrupti.
Quos ipsum enim animi dignissimos maiores omnis. Est perspiciatis deserunt iusto et rerum magni officiis. Sequi delectus doloribus earum numquam autem. Dolor et optio omnis velit rem eum quisquam.
Quaerat voluptatem nobis nostrum quia officia. Iste repudiandae aliquam porro minus. Voluptas delectus qui eligendi deleniti aliquam aspernatur. Dolorem blanditiis non qui. Nam vero vero omnis et consequatur perspiciatis quod commodi. Nihil libero eum aperiam expedita.
Pariatur dolore illo quos qui aliquid quia omnis. Earum reiciendis et perspiciatis eos sed quia est. Vel sit eum dolor dolores tempore. Illum officiis velit earum maxime.