Companion files
Raising Private Markets Capital from Wealth Managers
These are the companion files of The Private Wealth Fundraiser by Julian R. Sterling.The book on Amazon →
One Excel workbook that runs the forecast the book describes in full and never performs, now corrected. Around it, a blank version and a coverage and readiness model for your own channel, 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.
Chapter 15, and Appendix F
Chapter 15 gives the method in enough detail to build it — in-scope advisors, a conversion curve by month since launch, tickets per producing advisor, average ticket, and a redemption rate on aged tranches — then states the Thornbury conclusion without showing the numbers. This workbook is the model: eighty-four months, four platforms, one page of inputs. Revised: the redemption-free period now drives the model (it was connected to nothing), and the diagnostic sheet is live.
The conclusion holds. Gross flows never fall — they are zero until the first platform goes live in month 7, then rise in every one of the seventy-eight months after — while the organic growth rate peaks and falls by 72 per cent. But the finding worth having is the one the chapter does not make. There are three peaks and they are years apart. Gross flows never turn down. Net flows peak at month 44. The organic growth rate peaks at month 29.
Fifty-five months separate them. The head of distribution reports gross flows and sees seven years of growth; the chief executive reports the organic growth rate and sees a business that stopped improving in month twenty-nine. Both are right, and the gap is four and a half years — long enough for a distribution team to be praised, promoted and replaced before anyone reconciles them.
Download the workbook142 KBThe chapter says drag grows with the age of the book. Over seven years it does. Month by month it does not: 38.7 per cent of gross flow at month 18, falling to 14.2 per cent at month 36, then climbing to 41.5 per cent by month 84.
Year three is the bottom of the U. It is also, precisely, when a distribution team first has enough history to build a credible multi-year forecast — and the two years it can see show drag improving. A team that extrapolates what it can see will forecast an improvement at the exact moment it is about to reverse. The remedy is in the model, not in judgement: redemptions modelled as a rate on aged tranches produce the U-shape by themselves.
The chapter promises that a forecast miss tells you whether conversion, ticket size or timing was wrong. It does. Measured at month 36: a two-point fall in the conversion ceiling costs 11.1 per cent of flow but only 6.6 per cent of assets; a ten per cent smaller ticket, 10.0 and 6.0. A three-month launch slip costs the least flow — 5.5 per cent — and the most assets, 11.6 per cent.
So flows and assets short in proportion points at conversion or ticket size; flows near plan with assets well short points at timing, and at a problem that happened earlier than the month being read.
Holding a 30 per cent organic growth rate at month 60 needs 24 per cent more gross flow than the model produces. That cannot come from working saturated platforms harder; it has to come from new ones, which take nine to twelve months from approval to production. So the decision had to be taken around month 48 — a year before anyone was looking at the shortfall. The cohort model does not merely forecast. It dates the decision.
Two workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 2, 6, 15 and 16 · Appendix F
The book’s forecast with its inputs emptied: your seed, your conversion curve, your ticket economics, your redemption terms and up to four platforms, with the three peaks, the U of redemption drag, the gross flow a growth target needs and the signature of a miss recomputed. And a new file for the arithmetic Chapters 2, 6 and 16 ask for: the triage of a target list against what a salesperson can hold, the coverage model of a platform tier by tier, and the readiness self-assessment with the book’s thresholds.
The book’s figures are listed in a text file inside the archive. Type Aldergate’s platform back in and the file shows what Chapter 6 leaves out: each external must deliver 700 to 1,050 touches a year, and the book never says how many one person can. Enter yours and the sheet says whether the plan is designed or merely asserted.
Download the blank set77 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 16 · Appendices B and C
The channel map and coverage triage. The vehicle’s engineering questions and the liquidity sentence, word for word. The narrative ladder and the retelling test. The coverage and operating model. The platform due diligence tracker and gaps register. The Appendix B readiness checklist. The six moments of advisor work in the plumbing. The fee stack, the total-cost sheet and the new-class test. Advisor meeting preparation. The objection inventory and the event scorecard. The family office decision map. Servicing, the bad-news notice and the day the gate binds. The funnel, the metric set and the readiness score.
Download the PDF40 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 channel and the decision, seven on product, narrative and the operating model, seven on approval, plumbing and fees, six on the field, family offices, servicing and compliance, seven on Chapters 15, 16 and Appendix F, and six 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.
Download the questions18 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 4 and 13 · Case one
Chapter 13’s advisor who “delivers sixty percent”, at Chapter 4’s five per cent cap, on Thornbury’s 536 million: requests of 8.33 per cent of NAV, 3.8 times what the Appendix F model redeems in that quarter. If the rush lasts one quarter the client is whole in the next. If it persists, the rolling queue lowers every later fill rate, she has 88.4 per cent back after a year, and once the sleeve and the facility are spent each quarter at the cap costs the holders who stay 0.84 per cent of NAV.
Chapters 6 and 9 · Case two
The book gives two clocks, “two to three years” and “three to five”, and they measure different things. On Appendix F’s flows at a 0.75 per cent margin, the first holds only if the channel costs at most 1.20 million a year, the second at most 1.09 million. At 1.5 million, revenue covers the cost from month 40 and the channel has paid for itself in month 71. With net flow at half of gross, Chapter 9’s own question, it has not paid back within seven years.
Chapter 9 · Case three
Chapter 9 says to put the minimum committed volume in the agreement and never computes it. For a class twenty basis points cheaper, it is 16.6 million, and the class still pays at 30 of the 100 million promised: its own cost is small. The side letters are not. If the institutional MFN clauses pass the discount on, the minimum becomes 193 million, 1.9 times the promise.
Download the three cases71 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | forty-four controls in the book’s workbook, each stating its own verdict; every other workbook ends with its own |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Every firm and figure is illustrative, as everything in the book is. What is not illustrative is the shape of the result, which holds for any plausible set of inputs. The three peak months on sheet 4 are computed, not typed — change an assumption and they move.
The 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 book’s workbook corrected: the redemption-free period was connected to nothing (the twelve-month lag was typed into the formulas), so the suggestion to set it to zero described a result the file could not produce; it now drives the model, and at zero the U-shape of redemption drag remains (22.5 per cent at month 36). The miss scenarios on sheet 5, typed values before, are recomputed live. Gross flow is zero until month 7 and rises in 78 of the 84 months, not all 84. Forty-four checks, all passing. Added: a blank version, a coverage and readiness model, thirteen working documents, forty questions and three cases. |
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: AUM and net flow forecast model.
The Private Wealth Fundraiser 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 The Private Wealth Fundraiser. 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.