# The Litigation Finance Investor: companion files

Julian R. Sterling

## What is here

- **Litigation_Finance_Investor_Model.xlsx**: the workbook that rebuilds the Vellacourt case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Brennock Draws, Brennock Scenarios, Brennock Waterfall, Portfolio Facility, Award Monetization, MOIC and IRR, Fund II Projection, Checks.
- **Litigation_Funder_Toolkit.docx**: the thirteen checklists and templates of Appendix 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, investment committee memo outline), in editable form.

## Which sheet answers which chapter

- Chapters 3 and 10: Brennock Draws (the $8.0 million commitment drawn month by month across the four budget phases, and the monthly cash flows of each outcome)
- Chapter 9: Brennock Scenarios (the four outcomes modeled at signing, their weights and the expected multiple of 1.74x)
- Chapter 11: Brennock Waterfall (the greater-of test, the ratchet, the claimant floor and the split between Fund II, trial counsel and Brennock, with a calculator for any proceeds and month)
- Chapter 4: Portfolio Facility (the eight cases, the month 36 test, 2.20x cross-collateralized against 1.14x case by case)
- Chapter 5: Award Monetization (45 percent of a $50.0 million award for $15.0 million, and three ways out)
- Chapter 13: MOIC and IRR (the same multiple over different holding periods, and why phased draws lift the IRR)
- Chapter 15: Fund II Projection (deployment, losses, fees, the European waterfall, the J-curve, the stress case and the concentration tests)

## Two inputs to change first

1. On Inputs, move the judgment outcome from month 54 to month 42: watch the ratchet step fall to 3.0x or 30 percent, and the multiple and the IRR move on Brennock Scenarios and MOIC and IRR.
2. On Inputs, set case H's fee income to zero: watch what Fund II receives with and without cross-collateralization on Portfolio Facility. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Vellacourt Capital Partners, Fund II, Brennock, the firm and Ondara are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case figures are illustrative assumptions, not benchmarks. Provided as is, without warranty. Not legal, investment or tax advice.
