MergerWaterfallStart modeling free
For the advisors and attorneys who represent the company

See what each deal term does to the payouts.

Merger Waterfall turns the cap table and deal documents into each shareholder's payout, shows how it moves as terms are negotiated, and produces a closing spreadsheet that proves its math.

Distribution · Present
Studio's presentation view of the Closing run: $15.00M total consideration, $11.85M net equity proceeds, and a waterfall chart running from enterprise value through deductions to the Series B and Series A payouts.

Studio showing the $15.00M Northwind Logistics / Atlas Freight Group demo deal: from headline price, through debt, holdbacks and expenses, to what each class of shareholder receives.

Who it's for

Everyone on the company's side of the table.

The people who advise on the deal, the people who paper it, and the people who are paid by it all need the same numbers, in words they understand.

Sell-side advisors

Bankers, M&A advisors, fractional CFOs

“What does this offer really pay the founders, and how do I show the board?”

Every offer turned into a payout per holder, on one picture you can present.

Company counsel

Deal and venture attorneys for the company

“What is this preference or holdback worth, before I spend a turn negotiating it?”

Each term traced to its clause and priced in dollars, for every holder.

The company

Founders, the CFO, the board, employees

“What do I actually walk away with, and when?”

Your own number, at closing and in total, and a spreadsheet you can trust.

Why Merger Waterfall

Three problems every company sale runs into.

Nobody can say what a term is worth. Every redline moves the payouts unseen. And the final spreadsheet has to be right, provably. Each has its own page.

01

Turn each term into dollars, holder by holder.

Liquidation preferences, participation, escrow and earnouts are written for lawyers. Merger Waterfall reads them from the charter and the cap table and shows, in dollars, what each one means for each shareholder.

  • Every term traced to its clause
  • The whole deal on one axis
  • Each holder sees their own number
Deal terms, made clear: the full story
Cap Table · Terms from documents
The 'Terms from documents' review: Series A and Series B terms each with a section reference such as § 2.1.2 and a label 'In the text' or 'Inferred'. Series B participation reads 'Confirmed missing · flagged'.

02

Watch the payouts move as the terms move.

Every turn of a negotiation changes who gets paid what. Merger Waterfall keeps a version for each turn, so you can show the effect of a price change, a new preference or a bigger holdback the same day it is proposed.

  • A version for every turn
  • Go back to what was proposed
  • Know the moment terms move on
  • Ask your assistant what a change does
Negotiations, visualized: the full story
Distribution · Runs
The Runs list in Studio with three versions: 'LOI — $14.0M offer' at $10.85M, 'Signing draft — $15.0M' at $11.85M, and 'Closing' at $11.85M marked as a locked closing snapshot.

03

The closing spreadsheet that proves its own math.

The spreadsheet that goes to the paying agent is the one document nobody can get wrong. Merger Waterfall exports it with live formulas, built-in checks and an audit trace for every dollar, from the version you locked at closing.

  • Checks that re-run in Excel
  • Every holder, every class, to the dollar
  • A trace for every dollar
  • Locked at closing
Final spreadsheets, auditably right: the full story
Exported workbook · Summary
The Summary sheet of the workbook Studio exports for the Northwind / Atlas closing run: deal details, $15,000,000 enterprise value, $11,850,000 net equity proceeds, three validation checks all reading OK, and the deal waterfall chart.

Deal scenarios

The questions clients actually ask.

Seven moments, from a financing years before a sale to the week of closing. Each is answered on the Northwind Logistics demo deal by the same engine Studio runs; every number below is computed, not illustrated.

Try it on your next deal.

Bring the cap table export and the charter. Leave with a distribution spreadsheet you can hand to the board, the buyer and the auditor.