Modeldrill

Returns and scenarios Updated November 2026

Sources and uses

In an LBO, uses are everything the deal must pay for: the equity purchase price, existing debt that is refinanced, and transaction and financing fees. Sources are where the money comes from: each new debt tranche, rolled management equity, balance sheet cash used, and sponsor equity, which is the plug that makes sources equal uses.

Syntax

Sponsor equity = Total uses - new debt - rollover equity - cash used
PartWhat it is
equity purchase priceEnterprise value at the entry multiple minus net debt assumed or refinanced
debt refinancedExisting debt repaid at close, a use; if it is assumed instead, it is neither a source nor a use
feesAdvisory fees (expensed at close) and financing fees (capitalized against the debt and amortized)
debt tranchesEach sized as a multiple of EBITDA, for example 4.0x term loan plus 1.5x notes
rolloverManagement or seller equity reinvested in the new company, a source that needs no cash

Examples

EBITDA 100, entry multiple 8.0x, existing debt 150 (no cash), fees 3% of EV
EV = 8 × 100 = 800; equity purchase price = 800 - 150 = 650; fees = 24
Uses = 650 + 150 + 24

Result: Total uses 824

Sources: term loan 4.0x EBITDA = 400, senior notes 1.5x = 150, management rollover 40
=824 - 400 - 150 - 40

Result: Sponsor equity 234; sources 400 + 150 + 40 + 234 = 824, equal to uses

Checks: total leverage = (400 + 150) / 100; equity share = (234 + 40) / 824

Result: 5.5x leverage; 33 percent equity contribution including the rollover

Lenders look at both; a thin equity share means a small cushion before the debt is impaired.

Common mistakes

  • Putting enterprise value and the refinanced debt both on the uses side: enterprise value already includes the debt, so use either EV plus fees, or equity price plus debt refinanced plus fees, never both.
  • Hard-coding sponsor equity so the table can stop balancing; compute it as uses minus every other source and keep a check cell that must return zero.
  • Treating advisory and financing fees the same way: advisory fees are expensed at close and reduce opening equity, while financing fees are netted against the debt and amortized over its life under US GAAP.
  • Sizing the tranches as a share of the purchase price; lenders size them as multiples of EBITDA, and interview questions are phrased that way.

Practice Sources and uses

These drills check your answer on live data, free, no account needed.

  • Leveraged buyout sources and usesSet up the funding of a buyout. Uses: the purchase enterprise value (B10: EBITDA times the entry multiple), the equity purchase price (B11: enterprise value less the net debt being refinanced), the refinanced net debt (B12), transaction fees (B13: the percentage in B6 of enterprise value), cash funded to the balance sheet (B14) and total uses (B15). Sources: new debt (B17: EBITDA times the leverage multiple in B4), sponsor equity as the balancing amount (B18), total sources (B19) and the equity share of the funding (B20).
  • Buyout exit: money multiple and IRRA sponsor buys a business and sells it after the years in B7. Fill the entry equity (B10: entry EBITDA times entry multiple, less debt at entry), exit EBITDA (B11: entry EBITDA grown by B5 for the years held), exit enterprise value (B12), debt at exit (B13: entry debt less what was repaid), exit equity (B14), the money multiple (B15) and the IRR (B16: the multiple raised to the power of 1 over the years held, minus 1).
  • IRR grid by entry and exit multipleFill the grid B9:F12 with the IRR for every pairing of entry multiple (column A) and exit multiple (row 8). Entry equity is the entry multiple times entry EBITDA less debt at entry; exit equity is the exit multiple times exit EBITDA less debt at exit; the IRR is (exit equity / entry equity) ^ (1 / years held) - 1. One formula, filled right and down.

Questions

Why is sponsor equity the plug in sources and uses?

Because the debt is sized first by what lenders will provide at a given leverage, and the price is set by the deal, so the sponsor writes whatever check closes the gap. Sponsor equity = uses minus all other sources.

Is cash on the target balance sheet a source of funds?

Only the part above the minimum operating cash, and only if the deal uses it to fund the purchase. Many models show it as a source and refinance gross debt as a use, which nets to the same thing as subtracting net debt.

What is a typical equity contribution in an LBO?

It moves with the credit cycle; something between a third and a half of the total uses has been common in recent years, with more equity in smaller or riskier deals. Treat it as an output of the leverage the lenders will give, not an input.

Related

  • Enterprise value to equity valueEquity value = enterprise value - debt + cash - preferred stock - minority interest. The EV to equity bridge step by step, with examples and per share value.
  • Net debtNet debt = total debt - cash and equivalents. What to include (leases, preferred, minority interest), a worked example, net debt to EBITDA and the EV bridge.
  • Debt scheduleA debt schedule rolls each loan forward: closing = opening + draws - repayments, with interest on the opening balance. Layout, example, amortization, sweeps.
  • Cash sweepHow a cash sweep repays term debt from excess cash flow: the MIN formula, the sweep percentage, the minimum cash balance and a two-year worked example with numbers.

Previous: Net debtNext: Cash sweep