Companion files
Building and Running a Compliance Program in Private Markets
These are the companion files of The Private Fund Compliance Officer 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).
One Excel workbook that puts figures on the area the book calls the most heavily scrutinised in private markets compliance, and turns “test periodically” into a number you can defend, now corrected. Around it, a blank version for your own fund, thirteen 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 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.
Appendix F · Chapters 10 and 13
Chapter 10 says the amounts can be large and the stakes enormous. Chapter 13 says to test. Neither contains a figure. But a compliance officer cannot escalate an adjective: “the amounts can be large” does not tell a COO whether to care, and “test periodically” is not an answer to an examiner or a budget.
The grey zone, expressed as a fee. On a 500 million fund with 1.2 million a year of genuinely ambiguous costs, resolving a quarter of them the firm’s way is worth 3 million — the same as charging 2.06 per cent instead of 2.00, undisclosed. That translation is the useful part: forty small judgement calls are impossible to raise in a partners’ meeting without sounding pedantic. Six undisclosed basis points ends the discussion.
The broken deal, four ways. The book’s own illustration, with numbers on it. The flagship’s share runs from 1.25 million to 2.50 million depending on which defensible method is applied — half the cost of the deal, turning on a choice no document compels. And of the four methods, only one costs the firm anything, which is the first thing an examiner will notice about your policy. For an investor with a million committed to the flagship, the choice is worth 625 if the flagship is two billion; the 3,125 the book prints divides by the flagship’s 400 million ticket in the deal, not by the fund, so it is only the ceiling.
Two words in a fee schedule. Move consulting and board fees from offsettable to not, and the firm keeps 2 million more — two per cent of every management fee the fund will ever pay. It is a switch in the file; flip it and watch.
And how much testing is actually enough. There is an exact answer:
n = ln(1−confidence) / ln(1−error rate). To be 95 per cent confident that
under 5 per cent of allocations are wrong, test 59 items. Test twenty and find
nothing — which is what many programmes really do — and all you have established is that
the error rate is probably below 14 per cent. The 59 items cost about
four working days a year. Sixteen checks.
Open the sampling sheet and put your own number in. Most programmes test somewhere between ten and thirty items and describe it as periodic testing. Read off what that actually proves, then read off what fifty-nine proves and what it costs. The gap between the informal habit and the defensible standard is about two and a half days of one person’s year — which is a much easier conversation than the one that follows an examination finding.
It cannot tell you which grey-zone costs belong to the fund; that is what the documents, the disclosure and your judgement are for. It cannot make an allocation method fair — only fixed in advance and consistently applied, which is the chapter’s point and remains right. And the sampling sheet is attribute sampling: it tests whether items are right, not how wrong they are, so a programme should test by value as well. It also assumes a genuinely random sample; testing the items finance hands you tells you about those items and nothing about the population.
The workbook with every input emptied. Enter your own fund, expense base, broken deal and fee schedule; the checks sheet counts what is still missing and tests what holds for any inputs.
Appendix F · Chapters 10 and 13
Commitments, fee and fund life, the fund-borne expenses and the part of them that is genuinely ambiguous, the last broken deal with each vehicle’s ticket and the flagship’s own commitments, the portfolio-company fees with a yes or no for each as your documents categorise it, and the minutes it takes to test one item. The file gives the grey zone as a fee, the broken deal four ways with what the choice is worth per million committed, what the offset categorisation keeps for the firm, and the sample sizes with what they cost.
The book’s inputs are listed in a text file inside the archive. Type them back in and the file returns 2.06 per cent, 1.25 to 2.50 million, 625 per million committed, 2 million kept and 59 items.
Download the blank set22 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 14 · Appendices B, C and F
The risk assessment, scored and traced to a control and a test. The Appendix B program checklist with an evidence column. The Appendix C calendar by month and owner. The code of ethics, with its acknowledgement and periodic certification. The pre-clearance, gifts and outside-activity logs. The restricted list, the wall-crossing log and expert calls. The conflicts register and a conflicted decision recorded. The marketing review record for a performance page. Oversight of valuation and of service providers. The three fee and expense numbers of Appendix F. Investor onboarding, beneficial owners and sanctions. The testing plan and sample record, with the remediation loop. And examination readiness with the findings tracker.
Download the PDF37 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Eight on the function, the program and governance, eight on conduct, MNPI and conflicts, six on marketing, valuation and fees, five on financial crime, vendors, testing, examinations and the career, eight on Appendix F and the workbook, and five 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 book18 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.
Chapter 13 · Appendix F · Case one
Chapter 13’s expense test finds two wrong charges; Appendix F sizes the sample at 59 “if all 59 are clean”. With two errors, the 59 no longer support the claim: at 95 per cent the error rate is only known to be below 10.3 per cent. Making Appendix F’s claim again takes 124 items, 65 more, all clean; the ladder is 59, 93, 124 and 153 for none to three errors. On a quarter of 240 charges (ADDED) the finite population trims it to 104.
Chapters 10 and 8 · Case two
Chapter 10 names the effect of fund-level credit facilities on reported returns and gives no figure. Four deals returning 2.0× in four years, a facility at 6 per cent drawn 180 days (all ADDED): the IRR rises from 18.91 to 20.83 per cent while the investors pay 11.8 million of interest and their multiple falls to 1.943. Any facility cheaper than 18.1 per cent raises the IRR, so the direction is never in doubt, only the size.
Chapters 7 and 13 · Case three
Chapter 7’s flagship and newer fund, twelve shared deals, a policy of pro rata to available capital (all ADDED). Over the year the newer fund took exactly its 27.3 per cent, so the aggregate test passes. Deal by deal, five of its six overweight deals carry the six best marks: a pattern that arises by chance 4.0 per cent of the time, and 72.6 million of gain moved from the flagship’s investors to the newer fund’s track record.
Download the three cases44 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | sixteen controls, each stating its own verdict |
Every figure is illustrative, as everything in the book is. The fund, the firm, the deal and the amounts are invented. The arithmetic is not, and the sampling result applies to any population.
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.
| 24 Sep 2026 | The book’s workbook corrected: Appendix F’s broken-deal choice, “about 3,125” per million committed to the flagship, divides by the flagship’s 400 million ticket rather than its commitments; with the commitments as an added input of two billion it is 625, and 3,125 is its ceiling. Sixteen checks. Added: a blank version, thirteen working documents, forty questions that mark themselves and three new cases. The workbook can now also be downloaded on its own. |
More in regulation and compliance, with free companion files. The full list of titles is on the author page.
The Private Fund Compliance Officer 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 analysisThese files accompany The Private Fund Compliance Officer. 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.