Companion files
Assessing Managers Beyond the Investment Case
These are the companion files of Operational Due Diligence in Private Equity by Julian R. Sterling.The book on Amazon →
One Excel workbook that takes the sharpest warning in the book and measures it. Around it, a blank version for your own review programme, four working documents to print, forty questions that mark themselves, and three cases the book does not work. All free. Nothing is gated behind a sign-up, and no email address is asked for.
Six workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 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.
Chapter 3, and Appendix E
Chapter 3 gives this discipline its sharpest warning: never average your way to comfort. The warning is correct. It is also unquantified — a strange thing for a warning about arithmetic. This workbook quantifies it: eight domains, twelve managers, two decision rules.
Three of the twelve carry a flaw the book calls terminal. The averaging model gives all three its top rating. A manager with no independent custody of client assets scores 1.500. A manager with no fatal flaw at all — merely ordinary, twos and threes across the board — scores 2.250.
The model ranks the dangerous one three quarters of a point higher. It does not merely fail to catch the fatal flaw; it rewards it, because a firm with one structural gap is usually a firm that has invested in everything else — and everything else is what the average measures.
Download the workbook24 KBWith eight domains, one scoring 5, and an approval threshold of 2.00, the average clears whenever the other seven average 1.571 or better. Not perfection elsewhere — just good elsewhere.
Now split those eight domains into sixteen to capture more nuance, as programmes regularly do. The fatal domain's weight falls from 12.5 per cent to 6.2, and the average the rest must hold to bury it rises to 1.800. A team that refined its rubric has made it easier to hide a fatal flaw, not harder. Nobody running that exercise would describe it that way. If the model needs to be stronger, add veto rules — not domains.
Three weighting schemes across the same twelve managers — equal, controls-heavy, governance-heavy. Rank correlation against equal weighting: 0.979 and 0.993. Decisions changed: zero out of twelve. Not one recommendation moves.
Now change the model's structure instead — replace pure averaging with veto rules on custody, conflicts and valuation. Five decisions out of twelve change.
Committee time spent debating weights is time that cannot change an outcome. The design decision that determines every outcome — whether the model can say this one issue is disqualifying — is usually taken in a sentence and never revisited.
Chapter 3 asks whether two analysts would draw the materiality line in the same place. The workbook answers it: for each manager, the distance to the nearest threshold, converted into analyst-points — single-notch disagreements needed to cross a boundary.
Four managers sit one point from a different recommendation. Three more sit two. The median is two analyst-points out of eight domains — which is to say two analysts disagreeing by one notch on two domains hand the investment committee different answers on more than half the book.
That is not an argument against scoring. It is an argument for printing the distance to the threshold beside the score. A rating of 2.10 one point from a boundary and a rating of 1.20 eight points from one are not the same statement about a manager, and a report showing only the rating has thrown away the more useful half of the information.
The rating model with the managers and thresholds emptied. Enter your own reviews, one row each; the checks sheet counts what is still missing and tests what must hold in any programme.
Chapter 3 and Appendix E
Eight domains, the three veto domains of Chapter 3, and twelve empty rows for your managers. Rows without a name are ignored. Set your own thresholds, and the file gives the average, the worst veto domain, both recommendations and how far each manager sits from a different answer. The checks sheet ends on the test the book cares about: no manager with a fatal flaw is approved.
The book’s twelve managers are listed in a text file inside the archive. Type them back in and the file returns three fatal flaws, all three approved by the average and rejected by the veto rules.
Download the blank set23 KBSeven pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Appendices A, B and C · Chapters 3 and 14
The request list of Appendix A, seventy documents and questions in ten domains, with received and verified columns. The sixteen red flags of Appendix B, each with why it matters and room for the explanation offered. A rating scorecard that applies the veto rules before the average and records the second reviewer’s view. And the first ninety days of a new analyst, from Appendix C.
Download the PDF22 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Six on the framework and the rating model, six on the firm, the structure and the finance function, seven on custody, audit and compliance, seven on technology, valuation, interviews and the report, seven on Appendix E and seven on the three cases below. 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 in passing 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 6, 7 and 10 · Case one
Two fraudulent change-of-instruction attempts a year on 1.8 million payments. Email checks alone expect to lose 1.08 million a year; a callback written in the procedures but never tested, 0.54; a tested callback, 0.07. Over ten years a loss is near certain without a callback and still a one-in-three chance with a tested one. The policy reads the same in all three: the test is what the analyst asks for.
Chapter 11 and Appendix B · Case two
Interim marks run 2, 4 and 6 per cent above true value and the audit corrects them every December. The extra fees are small, about 6 basis points a year. The harm is elsewhere: a secondary buyer paying 95 per cent of the Q3 NAV pays 100.7 per cent of true value. The test is the sign of the corrections, not their size: four negative out of four happens by chance 6.25 per cent of the time.
Chapters 5 and 9 · Case three
A fund spends 3.0 million a year on deals that never close, while co-investors take 30 per cent of every deal that does. Charging all of it to the fund makes its LPs pay 4.5 million of the co-investors’ search costs over the investment period. The analyst’s test is the practice against the policy, deal by deal.
Download the three cases30 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | twenty-four controls, each stating its own verdict |
Every manager and score is illustrative, as everything in the book is. What is not illustrative is the arithmetic, which holds for any weighted-average model with a fatal domain in it. One control tests that a manager with a 5 in a veto domain still reads “Approve” under averaging — because that is the finding.
The workbook opens in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. It uses 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.
| 22 Sep 2026 | A blank version of the rating model, four working documents on seven pages, forty questions that mark themselves and three new cases. The book’s workbook can now also be downloaded on its own; its content has not changed. |
More in private equity and funds, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: operational due diligence scorecard.
Operational Due Diligence in Private Equity 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 analysisAlso as an ebook on Apple Books · Google Play ยท DRM-free PDF edition ($19.99).
These files accompany Operational Due Diligence in Private Equity. 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.