Companion files · The Private Markets Career Guides
How Litigation Funding Really Works: Single-Case and Portfolio Deals, Underwriting Merits and Collectability, Return Waterfalls, Funding Agreements, Duration Risk, Fund Economics and the Funder’s Career.
These are the companion files of the book. One workbook rebuilds the Vellacourt case: the Brennock draws, scenarios and waterfall with the ratchet and the claimant floor, the portfolio facility with and without cross-collateralization, the Ondara award purchase, multiples against IRRs, and the ten-year Fund II projection with its J-curve and stress case. A toolkit holds the thirteen 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 3 to 15
One Inputs sheet holds every case assumption: the Brennock budget phases, the ratchet, counsel’s fee and the claimant floor, the four scenarios and their weights, the eight portfolio cases, the award price and collection scenarios, and the Fund II terms. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook54 KBAppendix B
First call checklist, screening memo template, liability diligence checklist, damages diligence checklist, collectability checklist, budget review checklist, counsel assessment checklist, term sheet checklist, funding agreement checklist, disclosure readiness checklist, monitoring checklist, settlement decision checklist and investment committee memo outline.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| Brennock waterfall | $64.0 million paid at month 54: $28.0 million to Fund II (3.5x of $8.0 million deployed beats 30 percent of proceeds, $19.2 million), $12.8 million to trial counsel and $23.2 million to Brennock; an IRR of 52.6 percent |
| Portfolio facility | Eight cases, three lost: 2.20x and 50.7 percent cross-collateralized, against 1.14x and 8.0 percent had each case repaid only its own capital |
| Fund II projection | 1.92x and 20.1 percent gross, 1.52x and 13.4 percent net to limited partners, with a J-curve that bottoms at minus $203.8 million in year 4 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Vellacourt Capital Partners and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is legal, investment or tax advice.
More in corporate finance, markets and banking, 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.
Also available as a standalone free template: litigation finance model.