The Funds Flow Spreadsheet: Calculating Your Net Proceeds

The 30-Second Definition

The Funds Flow spreadsheet (often called the Capital Waterfall) is the definitive, step-by-step financial map that dictates the precise path every single pound takes at the exact moment of completion. It tracks the movement of money from the buyer’s acquisition vehicle, down through the corporate structure to clear outstanding liabilities, and finally calculates the exact net proceeds wired to the shareholders' personal bank accounts.

Headline Enterprise Value vs. Cash in Bank

The single biggest shock a mid-market business owner faces occurs in the final 48 hours before completion, when the corporate finance advisors present the final Funds Flow model. Up to this point, everyone has been talking about the multi-million-pound headline offer. The Funds Flow sheet is where economic reality hits.

The capital waterfall legally enforces the "Debt-Free, Cash-Free" and closing adjustments agreed in the Share Purchase Agreement (SPA). 

It ensures that all third-party stakeholders who hold a legal claim over the company's assets are paid off before any funds are distributed to the founders.

The Stages of the Capital Waterfall

When the buyer releases the gross transaction funds, the money trickles down through a strict legal hierarchy:

- Tier 1: Institutional Debt Clearance: The first cash is diverted directly to any banks or asset finance companies holding charges over your business to legally release their security interests.

- Tier 2: Transaction Overheads & Fees: Your corporate finance brokers, M&A lawyers, transaction accountants, and tax advisors are paid directly from the closing funds.

- Tier 3: Employee Obligations & Bonuses: Any contractual transaction bonuses, stay-bonuses for key executives, or outstanding redundancy/holiday pay settlements are funded at this point, including associated national insurance contributions.

- Tier 4: Transaction Retentions: The cash required to fund the indemnity escrow account or the capital required to secure the W&I insurance policy is carved out and sent to the respective third-party providers.

- Tier 5: Net Shareholder Distribution: The remaining cash at the absolute bottom of the spreadsheet—the Equity Value—is finally divided among the shareholders based on their cap-table percentages and wired to their personal bank accounts.

Calculate Your Net Take-Home Proceeds Early

Never wait until the night before completion to see the funds flow model. You need to model your gross-to-net bridge months in advance to ensure that your net post-tax proceeds are sufficient to fund your exit goals, retirement plans, or next business venture.