Companion files · The Private Markets Career Guides
How to Find, Value, Negotiate and Integrate Acquisitions Inside a Company: Strategy, Pipeline, Synergies, Accretion, Diligence, the Board and the First 100 Days.
These are the companion files of the book. One workbook rebuilds the Norcastle and Pellridge case: the target's standalone value, the synergies and what they are worth, the walk-away price and the premium paid, accretion in years one and two, the return on capital against the cost of capital, and leverage before and after the deal. A toolkit holds the checklists and templates of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 6 to 11
One Inputs sheet holds every assumption: EBITDA, multiples, synergies and their phasing, cost to achieve, tax, cost of capital, the walk-away rule, financing, share count and leverage. One sheet per analysis, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook15 KBAppendix B
Acquisition criteria template, target screening checklist, first call and confidentiality checklist, indication of interest template, diligence request list, synergy case template, board paper template, day-one checklist and synergy tracking template.
Download the toolkit41 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| Value | Worth $792.0 million on its own, bought for $864.0 million: a premium of $72.0 million, half of the $143.8 million of net synergy value, below a walk-away price of $878.3 million |
| Accretion | Earnings per share up 0.6 percent in year one and 1.7 percent in year two |
| Capital | A return on capital of 6.6 percent against a cost of capital of 8.0 percent, and leverage from 2.0x to 2.93x, just under a 3.0x ceiling |
The files are provided as they are, without warranty of any kind. The models are illustrative: Norcastle Group, Pellridge Controls and the other names are fictional, the models are simplified, and the figures are the book’s assumptions, not market benchmarks or forecasts. Nothing here is investment, legal, accounting or tax advice.
More in private equity, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.