Companion files · The Private Markets Career Guides

The Litigation Finance Investor

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 workbook, the toolkit and the read-me, in one archive90 KB

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.

The files

Three numbers to reproduce first

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 facilityEight 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 projection1.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.

Also by Julian R. Sterling

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.