Law Firm Earn-Out Calculation Spreadsheets: Use case and AI Confidentiality
An earn-out defers part of the price of a business until the business hits agreed profit targets, and the vendor’s solicitor models it before the first payment falls due. The sheet shows the business’s results by year, every adjustment the vendor argues for, the targets in the sale agreement, the payment tiers and the buyer’s set-off claim. Staff paste the sheet into ChatGPT or Claude to check a formula or summarise the dispute. This page marks every item in a three-year earn-out model for a cabinet-making business that rule 9, privilege and the Privacy Act bear on, recomputes each figure, and shows how the same model is worked on Ermos inside the firm.
The earn-out calculation spreadsheet
Built by the vendor’s solicitor from the sale agreement’s earn-out schedule, rerun at each reporting date and used in negotiating any dispute with the buyer.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Line | CY26 (Year 1) | CY27 (Year 2) | CY28 (Year 3) | Basis |
| 2 | Reported EBITDA: Pascoe Cabinetry Pty Ltd, sold by Nadia Pascoe to Hutchins Fit-Out Group Pty Ltd1 | 371,0002 | 402,0002 | 530,0002 | Year 1 is ten months of actual results plus forecast; years 2 and 3 are the vendor’s scenario |
| 3 | Add back: group management charge | 48,000 | 48,000 | 48,000 | Clause 4.2(b). The buyer says the charge is an ordinary cost and refuses the add-back ($144,000 over three years)3 |
| 4 | Add back: one-off rebrand costs | 22,5004 | 0 | 0 | Year 1 only; invoices attached |
| 5 | Less: insurance recovery included in EBITDA | (15,000)4 | 0 | 0 | Excluded by clause 4.3 |
| 6 | Adjusted EBITDA | 426,500 | 450,000 | 578,000 | Reported plus add-backs less the recovery |
| 7 | Target EBITDA | 420,0005 | 460,0005 | 500,0005 | Schedule 6 of the sale agreement |
| 8 | Achievement of target | 101.55% | 97.83% | 115.60% | Adjusted EBITDA divided by target |
| 9 | Payment tier | 100% | 60% | 125% | Under 85%: nil. 85% to under 100%: 60%. 100% to under 115%: 100%. 115% and over: 125%. Annual amount $200,0006 |
| 10 | Earn-out before set-off | 200,000 | 120,000 | 250,000 | Annual amount multiplied by the tier |
| 11 | Buyer set-off claim | (37,500)7 | 0 | 0 | Stock write-down warranty claim, disputed |
| 12 | Net payable | 162,500 | 120,000 | 250,000 | Earn-out less set-off |
| 13 | Three year total | 532,500 | Gross $570,000 less set-off $37,500 | ||
| 14 | Internal | Nadia needs Year 1 paid by 29 January 2027 and will take $150,000 in full settlement of Year 1, because she moves to Perth in March for her husband’s dialysis. Do not tell the buyer’s solicitors.8 |
An invented spreadsheet. Totals and percentages are recomputed from the rows. Hover or tap any highlighted item for the analysis; the full list is below.
Earn-out calculation workbook agent
An Agent+ that sets up the earn-out calculation from the sale agreement's schedule and updates it at each reporting date from the accounts supplied. It follows your firm's workbook layout, shows each adjustment and the clause behind it, and lists the items the buyer disputes.
What it does
- Reads the earn-out schedule and the period's accounts
- Updates the workbook, showing each tier and adjustment
- Lists disputed items and set-off claims for review
What stays with your people. The solicitor checks the workbook against the agreement and the partner decides the position taken with the buyer.
An Agent+ is built once and anyone in the practice can run it. It works from your own documents and runs on Ermos Dominion, the AI unit in your office, or on Ermos Edge, your own instance in an Australian data centre.
What leaves the firm
- 1The business, the vendor and the buyer
The company sold, the vendor and the buyer, named in the sheet. Confidential to the client under rule 9, and commercially sensitive while the earn-out is being negotiated. Rule 9 confidentiality guide.
Frontier Models (ChatGPT, Claude) Transmitted to the provider, generally offshore on personal plans Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case - 2Reported EBITDA for three years
Actual and forecast earnings of a private business. The vendor’s confidential financial information, shared with the buyer for the sale only. Legal privilege guide.
Frontier Models (ChatGPT, Claude) Three years of earnings transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case - 3The management charge add-back and the buyer’s objection
An adjustment of $48,000 a year ($144,000 over three years) that the buyer disputes. Without it, Year 1 reaches 90.12% of target rather than 101.55%. The dispute that decides the first payment. Legal privilege guide.
Frontier Models (ChatGPT, Claude) The disputed add-back and its effect transmitted Ermos Edge The AI can still misapply an add-back; a solicitor must decide which are allowed Ermos Dominion Stays on the unit, but the AI can still misapply an add-back; a solicitor must decide which are allowed Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case - 4The one-off add-back and the insurance exclusion
Two further adjustments for Year 1, $22,500 added and $15,000 removed. The vendor’s argued position, with supporting invoices. Legal privilege guide.
Frontier Models (ChatGPT, Claude) The vendor’s argued adjustments transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case - 5The targets
EBITDA targets of $420,000, $460,000 and $500,000 from the sale agreement’s schedule. Confidential terms of the contract that bind both sides. Rule 9 confidentiality guide.
Frontier Models (ChatGPT, Claude) Contractual targets transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case - 6The payment tiers and the annual amount
Nil under 85%, 60% from 85% to under 100%, 100% from 100% to under 115% and 125% at 115% or more, on an annual amount of $200,000. The deal’s economics. Year 1 at 101.55% earns $200,000, Year 2 at 97.83% earns $120,000 and Year 3 at 115.60% earns $250,000. Legal privilege guide.
Frontier Models (ChatGPT, Claude) The payment tiers and the amounts they produce transmitted; on consumer tiers it can train future models Ermos Edge The AI can still misapply a tier boundary; a solicitor must recompute each payment Ermos Dominion Stays on the unit, but the AI can still misapply a tier boundary; a solicitor must recompute each payment Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case - 7The buyer’s set-off claim
A $37,500 stock write-down claim set against the Year 1 payment, which reduces it from $200,000 to $162,500. The buyer’s claim and the vendor’s answer to it are privileged work product. Legal privilege guide.
Frontier Models (ChatGPT, Claude) The buyer’s claim and the vendor’s position transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case - 8The firm’s note on the settlement floor and the vendor’s husband
Privileged. The lowest amount the vendor will take, the date she needs the money and the reason, which is her husband’s dialysis. Health information about a third party is sensitive information under the Privacy Act. Legal privilege guide.
Frontier Models (ChatGPT, Claude) A settlement floor and a third party’s health information transmitted; on consumer tiers it can train future models Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case - 9The formula bar
A cell formula, =B2+B3+B4+B5, that shows how the adjustments combine into adjusted EBITDA. A formula with no figure in it, though it shows the method the vendor is relying on.
Frontier Models (ChatGPT, Claude) A formula with no figure in it, though it shows the vendor’s method; low value alone Ermos Edge A formula either way; a person must check it against the schedule Ermos Dominion A formula either way; a person must check it against the schedule Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case - 10The tab names
A tab called “Buyer dispute notes”. The name alone tells a reader that a dispute exists, and the tab behind it holds the firm’s analysis. Pasted workbooks carry every tab and not only the visible one. Legal privilege guide.
Frontier Models (ChatGPT, Claude) A tab name that reveals the dispute transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Earn-out calculation workbook agent. Builds the earn-out workbook from the sale agreement schedule and each period's accounts, showing every adjustment and listing disputed items for the solicitor. See the use case
What happens in Frontier Models (ChatGPT, Claude)
- The whole document is transmitted to the provider’s servers. On personal plans the user cannot choose where it is stored or processed, and for the major providers that has generally meant outside Australia, under that country’s legal process. Some business plans offer storage in Australia, but the provider still receives the content.
- On consumer tiers, prompts can be retained and used to train future models.
- The provider’s staff and systems can reach the content under the provider’s own policies.
- Once sent, the firm no longer controls it. Retention and deletion happen on the provider’s terms.
The same document on Ermos
Ermos Dominion
The document is drafted on a unit in your office, from your own templates and the matter file. Every marked item stays on the unit, which keeps working with the internet switched off. Nothing in it is transmitted to an AI provider, so there is no disclosure to analyse: the confidentiality work is the same as for your file server.
Ermos Edge
Your documents, the index and your access boundaries stay on your own instance in an Australian data centre. When a staff member asks for this draft, only their question and the excerpts they are permitted to see go to a named Australian provider, who is contractually barred from keeping the content or training any model on it. Nothing is processed outside Australia.
| Frontier Models (ChatGPT, Claude) | Ermos Edge | Ermos Dominion | |
|---|---|---|---|
| Where the document is processed | Provider servers, generally offshore on personal plans | Your instance in an Australian data centre; answers generated in Australia | The unit in your office |
| Who can read it | Provider staff and systems, under policy | Your staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothing | Your staff only |
| Is it kept | On the provider’s terms | Kept on your instance; the provider is barred from retaining it | Stays on the unit |
| Can it train a model | On consumer tiers, yes | No, by contract | Only your own unit learns from it, on your hardware |
Part of Use cases in law firms. See how this works in practice: Agreement review on Ermos.
Common questions
Do ChatGPT and Claude use the information in an earn-out calculation spreadsheet?
Can we use ChatGPT or Claude for an earn-out calculation spreadsheet if we remove the names?
What travels with an earn-out calculation spreadsheet when it is uploaded to ChatGPT or Claude?
How can a law firm use AI for an earn-out calculation spreadsheet without sending it to ChatGPT or Claude?
What is an earn-out in a business sale?
Can a buyer set off a warranty claim against an earn-out payment?
Why do EBITDA adjustments cause disputes?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo