Transaction schedules · in 8 models

Sources and uses

What the deal costs and who funds it.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: sources and uses.Updated 30 September 2026

Part of m&a and private equity models, with the models, labs and guides around it.

Part of real estate models, with the models, labs and guides around it.

Part of project finance and infrastructure models, with the models, labs and guides around it.

Part of healthcare financial models, with the models, labs and guides around it.

What it does

The opening balance sheet of a transaction. Uses are what has to be paid: the purchase price, fees, financing costs, any cash funded to the balance sheet or debt refinanced. Sources are where the money comes from: each debt tranche, rollover, and the equity cheque that balances the two. Leverage at close and the equity share of the deal are read straight off it.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Leveraged buyout model
  • Assumptions, rows 9–15: LTM revenue, LTM EBITDA margin, Entry multiple, EV / LTM EBITDA, Transaction fees, % of enterprise value…
  • Sources & Uses, rows 5–10: LTM EBITDA, Purchase enterprise value, Transaction fees, Financing fees…
  • Sources & Uses, rows 13–20: Revolver drawn, Term loan B, Senior notes, Total debt…
  • Sources & Uses, rows 23–26: Total debt / LTM EBITDA, Total equity, % of total sources, Net debt at close, Check: total sources - total uses
Merger model: accretion and dilution
  • Assumptions, rows 23–30: Offer premium to unaffected price, Stock consideration, % of equity purchase price, New debt, % of cash consideration, Interest rate on new debt…
  • Sources & Uses, rows 5–8: Equity purchase price, Transaction fees, Financing fees, Total uses
  • Sources & Uses, rows 11–15: Acquirer shares issued to target shareholders, New debt raised, Acquirer cash used, Total sources…
  • Sources & Uses, rows 18–19: Pro forma net debt, Pro forma net debt / combined Year 1E EBITDA
Purchase price allocation model
  • Assumptions, rows 8–19: Offer price per target share, Target diluted shares, Equity purchase price, Transaction costs…
Carve-out and standalone cost model
  • Assumptions, rows 103–114: Entry multiple, EV / run-rate standalone EBITDA, Term loan, multiple of run-rate standalone EBITDA, Interest rate on the term loan and revolver, Transaction fees, % of price…
  • Buyer, rows 6–17: Run-rate standalone EBITDA, FY0, Purchase price: EV, Transaction fees, Financing fees…
Healthcare services model: hospital operator
  • Assumptions, rows 68–70: Entry multiple, EV / FY0 EBITDA, Transaction fees, % of enterprise value, Debt at entry, x FY0 EBITDA
  • Returns, rows 6–14: EBITDA, FY0, Enterprise value at entry, Entry EV / FY1 EBITDA, Transaction fees…
Hotel underwriting model
  • Assumptions, rows 57–60: Purchase price, Closing costs, % of purchase price, Property improvement plan (PIP), per key, PIP, total
  • Debt, rows 6–11: Purchase price, Closing costs, Property improvement plan (PIP), Total cost before financing…
  • Debt, rows 14–20: Senior loan, Mezzanine loan, Equity, Total sources…
GPU cloud infrastructure model
  • Financing, rows 6–16: GPUs and servers, every cohort, Fit-out, every cohort, Upfront fees, Cash funded to the minimum…
  • Cash Flow, rows 55–58: Build period, Sources: operating cash flow, equity, debt and the revolver, Uses: capital spending, debt service, fees and cash held, Check: sources - uses through the build
ICG management buyout model
  • Assumptions, rows 20–22: ICG shares held by the MBO Team, Cash proceeds to the MBO Team at the offer price, MBO Team share of the ordinary equity
  • Sources & Uses, rows 5–10: Fully diluted shares, Equity value at the offer, fully diluted, Net debt assumed, 30 June 2026, Purchase enterprise value…
  • Sources & Uses, rows 13–18: MBO Team shares at the offer price, Of which sold to BidCo for cash, Of which rolled into the acquisition vehicle, Every other shareholder’s shares at the offer price…
  • Sources & Uses, rows 21–26: Cash consideration to shareholders, Rollover of MBO Team shares, Refinancing of existing bank loans, Transaction and financing costs…
  • Sources & Uses, rows 29–39: Funding needed beyond the preferred and existing cash, Facility B drawn, Revolver drawn at close, Senior debt drawn at close…

What a reviewer looks for

  • Fees left out of uses, so the equity cheque is understated.
  • A refinanced debt shown on one side but not the other.
  • Sources hardcoded to equal uses rather than one line being the balancing item.

Learn it, then build it

Vocabulary: Leverage Model, Merger Model.

Other transaction schedules