Contingency Fee and Net to Client

Excel Formulas › Legal & Billing

All versions

In a contingency case the firm takes a percentage of the recovery, then costs come off, and the client nets the rest. The order — fee on gross vs net of costs — changes everyone’s number, so model it explicitly.


Quick formula: fee, costs, and net to client:
=recovery*fee_pct then net = recovery - fee - costs
Attorney fee is the percentage of recovery; the client nets recovery minus fee minus case costs.

The example

$100k recovery, 33.3%, $8k costs.

AB
1ItemValue
2Fee 33.3%$33,300
3Net to client→ $58,700

The formula

The formula:

=recovery - recovery*fee_pct - costs // client net after fee and costs

How it works

How it works:

  1. Attorney fee = recovery × fee percentage (often 33–40%).
  2. Net to client = recovery − fee − case costs, in this common ordering.
  3. Some agreements take the fee on the net of costs instead — (recovery - costs) × fee_pct — which lowers the fee.
  4. Always state which base the percentage applies to in the fee agreement.

“Fee on gross” vs “fee on net of costs” is not a rounding detail. On a $100k recovery with $8k costs at 33.3%, fee-on-gross is $33,300 and fee-on-net is $30,636 — a $2,664 swing that comes straight out of the client’s pocket or the firm’s. Many jurisdictions regulate the default; the agreement must spell out the base. This is illustrative math, not legal advice.

Try it: interactive demo

Live demo

Recovery, fee %, costs.

Fee · Net

Variations

Fee on net of costs

Costs off first:

=(recovery - costs) * fee_pct

Tiered contingency

Higher % if it goes to trial:

=IF(settled_pretrial, recovery*0.33, recovery*0.4)

Effective fee rate

Fee ÷ recovery:

=attorney_fee / recovery

Pitfalls & errors

Define the base. Fee on gross vs net of costs changes every number.

Costs vs fee. Case costs (filing, experts) are separate from the attorney fee.

Not legal advice. Fee rules vary by jurisdiction — this is illustrative math.

Practice workbook

📊
Download the free Contingency Fee and Net to Client practice workbook
A contingency-fee sheet with the net-of-costs, tiered, and effective-rate variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate a contingency fee in Excel?
Fee is the percentage of recovery: =recovery*fee_pct. Client net = recovery - fee - costs.
What's the difference between fee on gross and fee on net?
Fee on gross applies the percentage to the full recovery; fee on net applies it after costs: (recovery - costs) * fee_pct, which is lower.
How do I model a tiered contingency?
Use IF on whether it settled pre-trial: =IF(settled_pretrial, recovery*0.33, recovery*0.4).

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Fee allocation across matters · Trust account balance · Profit margin & markup