# The Earnout Handbook: companion files

Julian R. Sterling, julianrsterling.com/earnout

Earnout_Workbook.xlsx rebuilds every figure of the book's case, from the payment curves to the roll-forward of the contingent consideration. Read its tabs in this order:

- Terms: the earnout schedule as cells, the period 1 straight line and the period 3 tiers, the catch-up and the global cap (chapters 3 and 4, exercises 1 and 2)
- Bridge: reported EBITDA to earnout EBITDA by year, scope first, then each adjustment once (chapters 5 and 6, exercises 3 to 5)
- Payments: each payment in date order, the period 2 award, fees and interest, the catch-up, the cap, the founders' share and the lender test (chapters 9, 11 and 12, exercises 6 to 8)
- Escrow: set-off, the retention ledger, the sales tax claim, the release and net cash to the sellers (chapter 10, exercises 9 and 10)
- Scenarios: five scenarios at closing, expected payment, present and fair value, the acquirer case net of retention, the roll-forward and the acceleration projection (chapters 8, 13, 14 and 16, exercises 11 to 13)

Each tab: inputs in blue, formulas in black, case values used by the checks in grey. Cell B2 of each tab counts the checks that fail; send no statement to the other side while a count is above zero.
If a cell does not return the printed answer, find the first failing check on the earliest tab and fix the input, never the output. Replace the case terms first and the results second.
The founders' compensation add-back on the Bridge tab is typed, not linked, because linking it to the payments would make the workbook circular; a check on the Bridge tab ties it to the Payments tab.

Wendhallow Hydrometrics, Corrimont Water Technologies and everyone in the case are fictional. Every term, threshold, cap, rate and probability is a teaching assumption, not a market norm. Education only; not legal, accounting, tax or investment advice.
