A beautiful, yet tricky, part of the modeling equation...
What are the ๐ฆ๐ผ๐๐ฟ๐ฐ๐ฒ๐ & ๐จ๐๐ฒ๐?
๐ญ๐ผ๐ผ๐บ ๐ข๐๐: the Sources & Uses show ๐ฉ๐ฐ๐ธ a company is purchased (Sources) and ๐ธ๐ฉ๐ฆ๐ณ๐ฆ the proceeds go (Uses).
But first — let's simplify.
I wish it was called the "Uses & Sources" and not the other way around.
It's easier to understand that way.
Here's an example:
You go to the grocery story and buy 3 things:
1. Apples
2. Cheese
3. Milk
To keep our example simple let's assume they each cost $10.
When you go to check out, you have to pay for your groceries somehow.
Our total price is $30, and that is the "Uses."
$30 gets ๐ถ๐ด๐ฆ๐ฅ to pay the grocery store.
———
Okay, so I know my Uses, but now I need a Source.
I could pay with cash, a debit card, or a credit card.
(↑ ๐ฐ๐ณ ๐ฆ๐ท๐ฆ๐ฏ ๐ข ๐ค๐ฐ๐ฎ๐ฃ๐ฐ)
It just needs to match my Uses, the $30.
Let's say I use my credit card and charge $30.
That's my ๐ด๐ฐ๐ถ๐ณ๐ค๐ฆ.
$30 ๐จ๐ค๐ช๐ง๐๐๐ from my credit card to pay $30 to the grocery store (๐ช๐จ๐).
Most importantly: THEY MATCH.
———
In a PE/M&A Transaction, a company is purchased the same way.
Sources & Uses.
(๐ฐ๐ณ ๐ณ๐ฆ๐ข๐ญ๐ญ๐บ, ๐๐ด๐ฆ๐ด & ๐๐ฐ๐ถ๐ณ๐ค๐ฆ๐ด)
Look at the image below,
the total cost of the company (including fees) is $26,356 (the gray bar).
The orange bars are the Uses,
and you can see most of that goes to pay the Seller (b/c they just sold their company),
but other parts pay for things like debt, fees, and something called "rollover."
("๐ณ๐ฐ๐ญ๐ญ๐ฐ๐ท๐ฆ๐ณ" ๐ช๐ด ๐ข ๐ต๐ฐ๐ฑ๐ช๐ค ๐ง๐ฐ๐ณ ๐ข๐ฏ๐ฐ๐ต๐ฉ๐ฆ๐ณ ๐ฅ๐ข๐บ)
———
The blue bars are the Sources,
and you can see the PE firm used a combo of debt and equity to buy the company.
Debt: Revolver, Senior, Mezz
Equity: Rollover, PE Firm, Outside Capital
Most importantly: The Sources ๐ข๐๐ฉ๐๐ the Uses.
———
Since the Sources & Uses match here,
they will match in our Balance Sheet as well (and keep us balanced!).
The Debt & Equity will increase (for a total of $26,356),
all the Assets will be marked to "fair market value,"
and anything in excess of the Asset values will go to Goodwill.
That's how we stay in balance.
———
For a complicated roll-up model?
I just put the whole transaction into Goodwill.
That way, here's what I see in my Statement of Cash Flows:
Financing Section: the new Debt & Equity
Investing Section: the purchase of the Company
(๐ฆ๐น๐ค๐ฆ๐ฑ๐ต ๐ง๐ฐ๐ณ ๐ง๐ฆ๐ฆ๐ด, ๐ต๐ฉ๐ฆ๐บ ๐จ๐ฐ ๐ต๐ฐ ๐ต๐ฉ๐ฆ ๐๐ฏ๐ค๐ฐ๐ฎ๐ฆ ๐๐ต๐ข๐ต๐ฆ๐ฎ๐ฆ๐ฏ๐ต)
Once the deal closes, a professional firm will come in and put together an "opening day balance sheet" that correctly marks the Assets to "fair value."
My job is to build a cash flow model to get the deal done, so I keep it simpler where I can.
———
So there you have it. The Sources & Uses.
I hope you found this helpful.
—Chris
If and when the time is right, I offer refreshingly straightforward Financial Modeling Courses for FP&A and Private Equity Professionals that have been recognized all over the world. Check them out if you're interested (if not, that's cool too ๐). Just click here.