Free Excel templates

A free litigation finance model in Excel

Litigation funding from the funder's side: a single case drawn month by month, four outcomes and their multiples and IRRs, the greater-of waterfall with the claimant floor, an eight-case cross-collateralized portfolio, an award purchase and a fund projection.

A fund commits $8 million to one case. An early settlement returns 2.0x with a 141% IRR; a judgment returns 3.5x; a loss at trial returns nothing. Weighted, the case is expected to return 1.74x on $6 million deployed.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

Litigation_Finance_Investor_Model.xlsx (54 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Litigation Finance Investor, which explains the method behind it, chapter by chapter.

Get the book on Apple Books → Or on Google Play

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

9 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
Every case assumption. Change it here only, one cell at a time, and watch the Checks sheet.
Brennock Draws
The $8.0 million commitment drawn month by month across the four budget phases, capital deployed by month and the monthly cash flows of each scenario.
Brennock Scenarios
The four outcomes modeled at signing, Fund II's multiple and IRR in each, the weights and the expected multiple.
Brennock Waterfall
The greater-of test, the ratchet step, the claimant floor and the split between Fund II, trial counsel and Brennock, for each outcome and for any proceeds and month you choose on Inputs.
Portfolio Facility
The eight cases in order of resolution, the cross-collateralized repayment, the month 36 test, the firm's share, and the case-by-case counterfactual.
Award Monetization
The price against 45 percent of face, the discount, and the three collection scenarios.
MOIC and IRR
The single-payment grid and the Brennock IRRs next to the single-payment figure for the same multiple and life.
Fund II Projection
Deployment, losses, realizations, fees, the European waterfall with preferred return, catch-up, carry and clawback, the J-curve, the stress case and the concentration tests.
Checks
The figures printed in the book beside the formulas that produce them, and structural tie-outs. With the original inputs every line reads OK.

What the worked case returns

MeasureValue
Commitment ($m)8
Early settlement: MOIC2.00x
Early settlement: IRR140.7%
Low settlement: MOIC1.10x
Low settlement: IRR8.2%
Judgment: MOIC3.50x
Judgment: IRR52.6%
Expected MOIC1.74x
Portfolio: MOIC cross-collateralized2.20x
Portfolio: MOIC case by case1.14x
Award purchase: discount to face33.3%

The same eight cases return 2.20x when the funder is repaid across the portfolio, and 1.14x case by case. Cross-collateralization, not case selection, makes most of the difference.

How to use it on your own case

  1. Enter the commitment, budget phases, multiples, percentages and the claimant floor on Inputs.
  2. Read capital deployed by month and the four outcomes with their MOIC and IRR.
  3. Follow the waterfall between the funder, trial counsel and the claimant in each outcome.
  4. Compare the portfolio cross-collateralized and case by case, then the award monetization.

Questions people ask about it

How do litigation funders get paid?

Usually the greater of a multiple of capital deployed and a percentage of the proceeds, paid from the recovery before the claimant, sometimes with a floor for the claimant.

Why is IRR misleading in litigation finance?

Because the same multiple over a short or long case gives very different IRRs. The file shows both side by side.

What is cross-collateralization?

The funder is repaid from the proceeds of all the cases in a portfolio, so a win can cover losses elsewhere.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Litigation Finance Investor go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Litigation Finance Investor. See the book.