Model the profitability of a panel bid under different rate cards, leverage models, and AI-driven delivery
Most panel bids are priced from the rate card downwards — a percentage discount off headline, a promise of "efficiency", and a hope that volume covers the compression. This tool models the actual economics: matter mix, leverage, AI substitution, realisation, write-offs and working capital, over the panel term.
Structured inputs only — no RFP upload, no client data leaves your browser. Everything you enter stays local unless you unlock the full report.
5
Intake steps
~15 min
To complete
3-yr
Panel-term P&L
Step 1 of 5
Firm baseline
Your rate card, cost-to-serve and target margin. Everything else builds off these.
Consortium mode models a joint bid where two or more firms share the work. Each firm's economics is modelled separately, with a coordination overhead absorbed by each member.
In consortium mode, this is the lead firm / bid coordinator. Individual member names go in the composition block below.
Currency drives display prefix and default values. Changing mid-flow will not auto-convert entered values.
Rate card (headline, per billable hour)
Cost-to-serve (per billable hour)
Applied only if cost basis is salary-only. 0.35 ≈ 35% overhead over salary.
Firm-level target for panel work. Used for RAG rating.
Consortium mode: each member firm's rate card, leverage, cost of capital and coordination overhead are set here. Work allocation between members happens on Step 3 alongside matter mix.
Adjust after configuring — reducing count discards later member data.
Roles inform reporting narrative only (no calculation weight).
Member firms
Optional
Jurisdictional tax overlay
Home vs cross-border tax effects on this bid. Indicative only — not a substitute for tax advice.
Off (default) preserves pre-tax-only behaviour. On adds post-tax margin, post-tax break-even and a tax summary to the full report.
Firm home jurisdiction
Seeded from home jurisdiction (UK 25% / AU 30%); editable.
Other jurisdiction (single — see scope note below)
Applied to gross fees, not margin. Default 0% for UK–AU (treaty), 10% for pairs involving Other.
% of the cost incurred in the Other-jurisdiction on that matter — not % of margin. The Other-jurisdiction office charges the home office at cost + this markup; the markup lands as taxable profit in the Other jurisdiction, the remainder of the matter's margin sits with home. Simplified cost-plus; for material bids, TNMM or profit-split may be more appropriate — consult tax advisers.
Two-jurisdiction scope only: home + one Other. Bids spanning three or more jurisdictions should model the dominant split here and flag the remainder for explicit tax advice.
Step 2 of 5
Panel context
Who the buyer is, what commercial structure they demand, and how long you're committing.
Informs AI-substitution defaults; does not affect calculation weights.
Pricing structure demanded
Applied to rate card in discount / mixed modes. Held flat over the term.
Applied to all effective billable hours.
Rate rise on the underlying card; panel discount % stays flat.
Step 3 of 5
Matter mix & leverage
What work you expect to do on this panel, how much, and who does it.
Enter the matter categories you expect to bill on this panel. Volumes should be your realistic annual expectation, not the RFP's headline addressable spend. Leverage percentages must sum to 100 per row.
Consortium allocation
Work allocation matrix
Split each matter category between consortium members. Rows must sum to 100% (±0.5% tolerance).
Jurisdictional tax overlay
Work-location matrix
Which matter categories are worked at home vs the Other jurisdiction you configured on Step 1.
Categories added after the tax overlay was configured default to "Same as home" — check the highlighted rows.
Step 4 of 5
AI delivery-substitution assumptions
What share of hours by task type can be shifted to AI-assisted delivery, across three sensitivity scenarios.
Substitution % = the share of hours in each task type that AI-assisted delivery (deployed tool + supervised workflow) can absorb. Central = Alt-V Legal Tech Atlas central estimate. Conservative and aggressive scenarios apply multipliers to your central assumption.
Substitution rates (central assumption)
Task-type share of typical matter hours
Residual (partner strategy, court appearance, negotiation) = 15%. Not AI-substitutable in the current model.
Sensitivity multipliers
Patchy adoption, heavy supervision
Realistic supervised deployment
Full workflow redesign
Charged to cost, applied to every matter in the mix regardless of scenario.
Step 5 of 5
Realisation, write-offs & working capital
The below-the-line drag most rate-card models ignore.
Of hours worked, % actually billed on the invoice.
Each member's share of consortium revenue and their allocation across matter categories.
Tax overlay
Jurisdictional tax summary
Indicative post-tax analysis. Does not substitute for tax advice from a qualified tax adviser.
Section 1
Three-year P&L — all scenarios
Revenue, cost, working-capital drag and margin for each of the three AI substitution scenarios.
Section 1a
Per-firm P&L breakdown
Central-scenario year-1 economics for each consortium member, after coordination overhead.
Section 2
Margin bridge — year 1 (central)
From an as-is delivery to panel-term delivery: where the margin comes from, and where it goes.
Section 3
Sensitivity
How the margin moves across AI-substitution scenarios and years.
Section 4
Break-even analysis
The panel discount (or fixed fees) at which year-1 margin hits zero, given your other inputs.
Section 4a
Partnership dissolution scenario
If a consortium member exits mid-term, work redistributes to the remaining firms at their own rate cards and leverage. Coordination overhead absorption per remaining member increases proportionally.
In the print dialog choose 'Save as PDF' and untick 'Headers and footers' under More settings — otherwise the browser stamps the file path on every page.