A beautiful, yet tricky, part of the modeling equation...

A beautiful, yet tricky, part of the modeling equation...


3 minute read

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.


Start, Grow, or Automate Your
Financial Consulting Business

Subscribe to The Finance Solopreneur and get 1 Actionable Tip each week.

    I will never sell your information for any reason.

    ยซ Back to Blog