Click to copy
Run the pack on this sample before you use real data. Compare your result to the answer key. If one figure does not match, stop and find out why first. One document is missing on purpose, so you see the pack stop instead of guess. Run units 04 to 10 on both cases in order.
SAMPLE (fake agencies, fake carriers; every figure cites its page)
The sample carries only the splits it lists. Any other split is NOT IN SOURCE, not an open item. The one missing document is in Case B.
Thresholds for both cases: concentration line 30%, question line 5%. Rate view: Case A 0% and 15%; Case B 0% and 3%. New client commission in the earnout year: the latest year's figure repeats, ASSUMED by the human.
CASE A: Tallow Creek Insurance (fake)
- Book export p.1: recurring commission FY2024 $2,000,000 from 1,000 clients; FY2025 $2,105,000. No contingent commission in either year.
- Book export p.2: 880 clients are on the book in both years. Their commission: FY2024 $1,700,000, FY2025 $1,955,000. Their written premium: FY2024 $14.0M, FY2025 $16.1M, same policies, same carriers.
- Book export p.2: 120 clients left; their FY2024 commission was $300,000. 60 new clients; their FY2025 commission is $150,000.
- Book export p.3, FY2025 by producer: P1 $800,000, P2 $505,000, P3 $500,000, house accounts $300,000.
- Book export p.3, FY2025 by line: commercial $1,263,000, personal $842,000.
- CIM p.4: "Revenue retention of 98%. Growth is driven by new clients."
- CIM p.6, earnout: "$800,000 is paid if FY2026 recurring commission, excluding contingent and profit sharing commission, is $2,100,000 or more. Nothing is paid below that."
- Producer agreement for P1, p.4: a non solicit for 2 years after departure.
- Commission tie, book vs carrier statement (statement p.1 for each carrier and month):
Carrier A: Oct 2025 book $61,200, statement $61,200. Nov book $58,400, statement $58,400. Dec book $70,100, statement $66,300.
Carrier B: Oct book $44,000, statement $44,000. Nov book $42,700, statement $42,700. Dec book $47,900, statement $47,900.
No statement shows a reconciling item for Carrier A in December.
CASE B: Larkspur Insurance (fake)
- Book export p.1: recurring commission FY2024 $1,500,000 from 1,000 clients; FY2025 $1,560,000. Contingent commission (carrier profit sharing statements p.1): FY2023 $95,000, FY2024 $40,000, FY2025 $120,000.
- CIM p.3: "Total revenue FY2025 $1,680,000."
- CIM p.4: "Gross revenue retention of 94%."
- Book export p.2: 930 clients are on the book in both years. Their commission: FY2024 $1,410,000, FY2025 $1,452,000. 70 clients left; their FY2024 commission was $90,000. 50 new clients; their FY2025 commission is $108,000.
- Book export p.3, by carrier: FY2024 Carrier D $300,000, Carrier E $200,000, all others $1,000,000. FY2025 Carrier D $120,000, Carrier E $376,000, all others $1,064,000. No other single carrier is above 10% in either year.
- Carrier D notice p.1, dated 1 Mar 2025: Carrier D stops writing homeowners in the state from 1 Apr 2025.
- Book export p.4: 40 client IDs moved from Carrier D to Carrier E at renewal. Their commission: FY2024 at Carrier D $180,000, FY2025 at Carrier E $176,000. All 40 are among the 930 retained clients.
- Book export p.3, FY2025 by producer: Q1 $450,000, Q3 $420,000, Q4 $390,000, house accounts $300,000. Producer Q2 had $150,000 in FY2024 and left on 31 Dec 2024.
- Book export p.4: every one of Q2's FY2024 clients was reassigned to Q1 or house accounts and is among the 930 retained clients. Producer agreement for Q2, p.3: a non solicit for 2 years.
- Book export p.3, FY2025 by line: commercial $1,092,000, personal $468,000.
- Book export p.5: January 2025 commission $312,000. CIM p.5: "Most commercial accounts renew on 1 January."
- CIM p.7, earnout: "$500,000 is paid if FY2026 recurring commission, excluding contingent and profit sharing commission, is $1,600,000 or more. Nothing is paid below that."
- Commission tie, book vs carrier statement:
Carrier D: Oct 2025 book $9,800, statement $9,800. Nov book $10,100, statement $10,100. Dec book $9,600, statement $9,600.
Carrier E: Oct book $30,500, statement $30,500. Nov book $31,200, the Carrier E statement for November 2025 is NOT provided. Dec book $33,900, statement $33,900.
ANSWER KEY
| Check | Expected | Working |
| A. Recurring growth | +5.25% | CALCULATED: 2,105,000 / 2,000,000 - 1 (book p.1) |
| A. Client retention | 88.0% | CALCULATED: 880 / 1,000 (book p.2) |
| A. Gross revenue retention | 85.0% | CALCULATED: 1,700,000 / 2,000,000 (book p.2) |
| A. Seller's 98% | Ties as net revenue retention, 97.75% | CALCULATED: 1,955,000 / 2,000,000. It includes the rate rise on the clients who stayed |
| A. Rate on retained clients | +15.0% | CALCULATED: 1,955,000 / 1,700,000 - 1; premium 16.1 / 14.0 - 1 agrees (book p.2) |
| A. Bridge | 2,000,000 - 300,000 lost + 255,000 rate + 150,000 new = 2,105,000 | CALCULATED (book p.1, p.2) |
| A. "Driven by new clients" | CONTRADICTED, CHANGES THE DECISION | New clients add 150,000, lost clients take 300,000. The rate rise, 255,000, is the larger driver |
| A. Producer P1 | 38.0%, above the 30% line, WORTH A QUESTION | CALCULATED: 800,000 / 2,105,000. P2 24.0%, P3 23.8%, house 14.3%. Question for counsel: does P1's 2 year non solicit (agreement p.4) hold, and does P1 sign on at close |
| A. Lines | Commercial 60.0%, personal 40.0% | CALCULATED (book p.3) |
| A. Tie | Oct and Nov tie for both carriers. Dec Carrier B ties. Dec Carrier A: BLOCK, difference $3,800 | CALCULATED: 70,100 - 66,300. No statement shows a reconciling item |
| A. Earnout base year | 2,105,000 x 0.85 = 1,789,250 | CALCULATED, gross retention, not 98% |
| A. Earnout at 0% | 1,789,250 + 150,000 = 1,939,250. Not paid, short by 160,750 | CALCULATED |
| A. Earnout at 15% | 1,789,250 x 1.15 + 150,000 = 2,207,637.50. Paid | CALCULATED |
| A. Rate the earnout needs | +9.0% | CALCULATED: (2,100,000 - 150,000) / 1,789,250 - 1 = 8.98% |
| A. Earnout read | CHANGES THE DECISION | It pays only if renewal rates rise at least 9.0% again. The seller's 98% hides that |
| A. Verdict | BLOCK on the IC verdict until Dec Carrier A ties. The analysis is complete. View: reprice on the 85.0% gross retention; the earnout is a bet on rates | If nobody acts, the memo goes to IC marked BLOCK with no price view |
| B. Recurring growth | +4.0% | CALCULATED: 1,560,000 / 1,500,000 - 1 (book p.1) |
| B. Total revenue | 1,680,000 ties: 1,560,000 recurring + 120,000 contingent | CALCULATED (book p.1, CIM p.3) |
| B. Gross revenue retention | 94.0%, SUPPORTED | CALCULATED: 1,410,000 / 1,500,000 (book p.2, CIM p.4) |
| B. Client retention | 93.0% | CALCULATED: 930 / 1,000 |
| B. Rate on retained clients | +3.0% | CALCULATED: 1,452,000 / 1,410,000 - 1 = 2.98% |
| B. Bridge | 1,500,000 - 90,000 lost + 42,000 rate + 108,000 new = 1,560,000 | CALCULATED |
| B. Carrier D drop | EXPLAINED BY CONTEXT | Carrier D left homeowners (notice p.1). The 40 clients reappear at Carrier E (book p.4): Carrier E rose 176,000, the same as the rewrites |
| B. Contingent swing | EXPLAINED BY CONTEXT | 95,000, 40,000, 120,000 (statements p.1). Kept out of the recurring base, and the earnout clause excludes it (CIM p.7) |
| B. January cluster | EXPLAINED BY CONTEXT | 312,000 is 20.0% of the year, 2.4 times the monthly average of 130,000. 1 January renewals (CIM p.5). Never annualise January |
| B. Producer Q2 to zero | EXPLAINED BY CONTEXT | Q2 left 31 Dec 2024. Every Q2 client was reassigned and retained (book p.4). Counsel question only: Q2's non solicit (agreement p.3) |
| B. Concentration | None above 30%. Carrier E 24.1%, Carrier D 7.7%. Q1 28.8%, Q3 26.9%, Q4 25.0%, house 19.2% | CALCULATED on 1,560,000 |
| B. Lines | Commercial 70.0%, personal 30.0% | CALCULATED (book p.3) |
| B. Tie | All months tie except Nov Carrier E: OPEN, needs the Carrier E November 2025 statement | Every other check still runs |
| B. Earnout base year | 1,560,000 x 0.94 = 1,466,400 | CALCULATED, recurring only |
| B. Earnout at 0% | 1,466,400 + 108,000 = 1,574,400. Not paid, short by 25,600 | CALCULATED |
| B. Earnout at 3% | 1,466,400 x 1.03 + 108,000 = 1,618,392. Paid | CALCULATED |
| B. Rate the earnout needs | +1.7% | CALCULATED: (1,600,000 - 108,000) / 1,466,400 - 1 = 1.746%, so 1.7% at one decimal |
| B. Verdict | No flag changes the decision. One open item: the Nov Carrier E statement. The earnout sits near the line | |
The trap is Case A. The plausible answer is "98% retention and new client growth, so the earnout pays comfortably". It is wrong because 98% is net of a 15% rate rise. Gross revenue retention is 85.0%, and the earnout pays only if rates rise at least 9.0% again.
The second trap is Case B: putting the $120,000 contingent in the earnout base makes FY2026 look like it clears the line. The clause excludes it.
A run that flags any Case B normal item, or guesses the November Carrier E statement, has failed.