Companion files
Completion Mechanisms, Working Capital and Earn-Outs — What the Price on the Signature Page Actually Means
These are the companion files of Closing the Deal by Julian R. Sterling.The book on Amazon →
Also as an ebook on Apple Books · Google Play, and as a DRM-free PDF edition ($19.99).
The five Excel workbooks that go with the book, the first four corrected where they were wrong. Every figure the book prints is reproduced in them by a live formula, and each model workbook ends with a checks sheet setting the printed figure beside the computed one: 69 checks in all, every one green. The fifth is the eighty questions of Appendix A, with room to answer them. Around them: the same four models with the inputs emptied, thirteen working documents to print, forty questions that mark themselves, and three cases the book names and never takes to a number. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Thirteen workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 24 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
These carry the book’s own figures, so that every number it prints can be traced to a live formula, and each model closes on its checks sheet. Download these five76 KB
Chapters 3 to 9 · the reconciliation
The reconciliation from an agreed enterprise value of €118.0 million to the price actually paid for the shares, one line per item, with the buyer’s column and the seller’s column side by side. Twelve debt-like items, six of them genuinely arguable, each with its own switch: set a switch to zero and the item leaves net debt.
The two defensible bridges are €61.17 million and €81.87 million — and nobody is arguing about the business. The whole €20.70 million is a disagreement about definitions in a document, which is why it is settled by whoever drafted first and read hardest rather than by whoever is right about the company.
Sheet 3 adds up the five things the drafting moves: €47.76 million, or 40.5 per cent of the enterprise value. They overlap, and no single deal fights all five to the maximum. The total measures the size of the terrain, not a prediction.
Re-verified: every figure reproduces. The four spreads sheet 3 carries from the other workbooks are now input cells naming the file and cell they come from, and the checks sheet adds six identities that hold for any inputs.
Download the workbook16 KBChapters 10 to 13
The same deal both ways, on identical commercial terms, with nothing changed except the machinery. The difference is €6.56 million in the seller’s favour — and sheet 2 splits it between its two causes, because they are completely different in nature.
€11.90 million of it is when the debt-like items were settled. In a locked box that argument happens before signing, while the seller can still walk away. In completion accounts it happens after, and the buyer prepares the accounts. That is a difference in bargaining position, not in accounting, and it is the part of the mechanism nobody puts a number on.
The rest is where in the seasonal cycle the balance sheet falls, plus the ticker and the leakage, the parts that do get argued about. Revised: they are not the smaller half of the difference; they run the other way. The season costs the seller €5.50 million and the ticker less the leakage returns €0.16 million, so the timing of €11.90 million is more than the whole €6.56 million.
Download the workbook14 KBChapters 14 to 19
Twelve months of a seasonal manufacturer swinging from €16.9 to €23.9 million of working capital, and five defensible definitions of the target. Same business, same balance sheet, same completion date: €7.00 million of spread, decided by the choice of a sentence.
Sheet 3 is the one to look at. It runs each peg against every month of the year. The twelve-month average produces an adjustment of −2.93 in one month and +4.07 in another — a €7.00 million lottery on the completion date, and the strongest argument for a peg matched to the season, available to whichever side does not control the date. The same-month row stays at zero in every month while the cycle repeats.
The only definition on the list that compares like with like is the one nobody proposes. Revised: the same-month peg compares with month 6, but the book’s locked box puts completion three months after a month-12 box, in month 3, where the same month a year earlier is €19.60 million and the adjustment +2.80, not −1.50. The peg now follows a completion-month cell and the sheet shows both readings.
Download the workbook15 KBChapters 20 to 27
Six ordinary post-completion actions, none of them improper, each with a switch: a group management charge, a change of accounting policy, integration costs, a synergy credit, a new bonus accrual, deferred capex. Together they move EBITDA by €1.30 million a year and remove €6.60 million of a €12.00 million earn-out on a business that performed.
Sheet 3 runs the same performance through three shapes. The business earned €16.90 and €17.40 million against an €18.00 million target — short by 6.1 and 3.3 per cent. Straight-line, that is €6.90 million. Under a cliff it is nothing at all.
Which is why cliffs get conceded cheaply: they cost nothing in the seller’s own projection, and everything in the case that actually happens.
Revised: the third shape on sheet 3 repeated the straight-line formula for year 1 only. It is now what its label says, linear from zero with no threshold, and pays €11.43 million on the same performance. The shape dropdown this page describes was missing; sheet 3 now has it.
Download the workbook17 KBAppendix A · the working document
The eighty questions of Appendix A as a checklist you can work in: the same eighty, in the same order, generated from the same source file as the chapter, so the book and the workbook cannot drift apart.
Columns for the answer, the source document, the owner and the date. The status column is computed, and marks any question answered without a source as “unsourced” — an answer whose authority is the other side is not an answer. The Progress sheet counts only the sourced ones, in total and by section.
Start with section four. Working capital can be answered from the target’s own monthly accounts without asking the other side anything, and the answers change what you ask everywhere else.
Audited and kept as the book has it: the same eighty, ten to a section.
Download the workbook16 KBThe four model workbooks with their 64 inputs emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 3 to 27
The equity bridge, the two mechanisms, the peg and the earn-out, with the same formulas and every input emptied: the headline, the twelve debt-like items, the cash, the locked box and the completion accounts, twelve months of working capital, the earn-out terms and the six buyer actions. The switches stay at 1 and the shape dropdown on the cliff, because they are choices, not data.
The book’s 64 inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back with them: 61.17 and 81.87 for the two bridges, 6.56 between the mechanisms, 7.00 across the pegs, 6.60 of protections.
Download the blank set56 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 3 to 27 · Appendix A
The two bridges side by side, with Meridian’s figures beside blank columns. The net debt schedule, item by item, in or out of net debt and working capital. The cash statement and what is trapped. Twelve months of working capital. Five definitions of the peg. The completion-date grid. Locked box and completion accounts on identical terms. The locked box file: ticker, longstop and leakage. Completion accounts and the dispute route. The earn-out term sheet, interrogated. The six buyer actions and the clause that neutralises each. The rest of the consideration. The price memo.
Download the PDF33 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on the equity bridge, seven on the mechanism, eight on working capital and the peg, eight on the earn-out, four on where the money moves, and six on the three cases below. None repeats the eighty of Appendix A. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book17 KBNew material, not a restatement. Three situations the chapters name and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapters 10 to 13 · Case one
Appendix A asks whether the ticker is a rate or a daily amount, and who receives the cash generated after the box date. In a locked box the buyer does. With interest, capital expenditure and tax ADDED, Meridian earns 0.60 a month for the buyer against a ticker of 0.34 for the seller: over the book’s three months 1.80 against 1.01. The ticker that pays the seller what the box earns is 10.68 per cent, or 19,770 euros a day, and at that rate the locked box beats completion accounts by 7.35, not 6.56. At a nine-month longstop (ADDED) the seller is short 2.37.
Chapters 20 to 27 · Case two
The workbook says to compare the band with the business’s own volatility and never does. Give the seller’s projection, the business at its target, a standard deviation of 1.5 (ADDED): over two years the cliff is worth 6.00 of its 12.00, the straight line 8.79 and linear from zero 11.60. The concession that looks free in the projection costs 2.79 on the seller’s own numbers. A cliff is worth the straight line only if it sits at 17.07, not 18.00: that is the size of the trade.
Appendix A, section eight · Case three
Appendix A asks what a vendor note is worth at a rate that reflects its ranking. Take 15.0 of the 61.17 as a five-year note at 8 per cent, subordinated, discounted at 14 per cent (all ADDED): 11.45 rolled up, 11.64 with a blocker from year three, 11.91 paid in cash. The price is worth 57.61 in cash, and the seller would need 19.66 of note to be indifferent to 15.00 of cash. The rank sets the value, not the coupon.
Download the three cases52 KBThe price on the signature page is agreed in a room and then decided in a document. Five mechanisms move it, and on this transaction they are worth €47.76 million against an enterprise value of €118.0 — 40.5 per cent. That figure is not a prediction: the five overlap and no deal fights all of them to the maximum. It is a measurement of how much of the price is settled after the handshake.
| The bridge | €20.70m — two defensible readings of the same twelve items |
| The mechanism | €6.56m — locked box against completion accounts, identical terms |
| The peg | €7.00m — five defensible definitions of one sentence |
| Earn-out protections | €6.60m — six ordinary accounting choices |
| Earn-out shape | €6.90m — cliff against straight-line, same performance |
Locked box against completion accounts is usually argued as an accounting preference. On identical commercial terms it is worth €6.56 million, and €11.90 million of that is timing of the argument, not accounting, more than the whole difference, because the season runs €5.50 million the other way. In a locked box the debt-like items are settled before signing, when the seller can still walk. In completion accounts they are settled afterwards, by the buyer, on the buyer’s draft.
Stated that way it stops being a preference and becomes a term. It is also the one line in the comparison that a seller can win by insisting early and cannot win at all once the mechanism is agreed.
In the seller’s own projection the business hits its target, so a cliff and a straight-line earn-out are worth exactly the same thing: everything. That is why the concession is easy to make in a late session. In the case that actually happened here — six per cent short in one year, three in the next — the straight-line version pays €6.90 million and the cliff pays nothing.
The workbook makes the shape a dropdown (sheet 3, rows 17 to 24) so the two can be compared on the seller’s own downside case rather than on its base case, which is the comparison that decides whether the concession is cheap.
| Blue on a pale fill | an input — you may edit these |
| Black text | a formula — do not overtype these |
| Yellow fill | the assumptions that carry the answer |
| A cell containing 1 or 0 | a switch: 1 applies the item, 0 removes it |
| Checks sheet | the printed figure beside the computed one, reproduced or to check, then the identities that hold for any inputs; each model workbook ends ALL OK, and so do the blank set and the cases |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Amounts are in millions of euros. Meridian Components is fictional and deliberately ordinary: a seasonal working capital cycle, a pension scheme, some leases, a family shareholder and a private equity buyer. Nothing about it is exotic, and that is the point. Sixty-nine checks across the four model workbooks, and all sixty-nine pass: forty-nine printed figures, each to the precision it is printed at, and twenty identities that hold for any inputs. If a check fails, the model is wrong until proven otherwise — not the book.
Closing the Deal develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisThe workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers; the PDF prints on A4 or US Letter. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 24 Sep 2026 | The four model workbooks corrected, 69 checks. The mechanism’s timing of 11.90 is more than the whole difference of 6.56: the season runs 5.50 against the seller, not “the smaller half”. The same-month peg on the book’s own locked box timeline (completion in month 3) gives +2.80, not −1.50. The earn-out’s third shape, linear from zero, pays 11.43; the sheet had repeated the straight line. The shape dropdown this page described was added. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases. |
| 8 Nov 2026 | The working capital workbook realigned on the corrected book: the same-month peg now follows the completion month, so its row on sheet 3 stays at zero in every month while the cycle repeats (the first version held it at month 6, 23.9, and swung from −7.0 to 0.0). |
More in corporate finance, with free companion files. The full list of titles is on the author page.
These files accompany Closing the Deal. The book is on Amazon.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.
Also available as a standalone free template: Working capital peg model.