# The HSR Act Handbook: companion files

Julian R. Sterling, julianrsterling.com/hsr-act

## What is here

- **HSR_Act_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Sarrowfield Capital Partners and its Fund IV buy the founders' 80.00 percent of Quorrin Valve Technologies, LLC, a manufacturer, in 2026, while Fund IV's portfolio company Ebbmoor already holds 12.00 percent and the sponsor's earlier Fund III holds 8.00 percent. Every price, value, holding, date and estimate is a teaching assumption, never a market figure. The thresholds and fee tiers effective February 17, 2026, the civil penalty per day set in 16 CFR 1.98(a) as read in November 2026 and the legal public holidays are published figures, stored with their dates.

## The tabs, in the order to read them

1. **Entities**: each entity, its legal form, who holds its profits, assets on dissolution or votes, and its sales and assets with their date.
2. **Interests held**: each interest already held in the target, its holder, date and value basis.
3. **Transactions**: the case and each separate scenario, one row each, with a scenario flag.
4. **Thresholds and fees**: the thresholds, fee tiers, holidays and penalty per day, keyed by effective date, ready to receive next year's row.
5. **Documents**: the seven documents found in the search, their author, date, filing and classification.
6. **UPE and control**, **Value**, **Aggregation**, **Tests**, **Exemptions**, **Fee**, **Waiting period** and **Verdict**: one rule each, in the order of the chapters.
7. **Scenarios**: the add-on, the minority stake, the upper threshold, the pull and refile and gun-jumping, computed apart from the case.
8. **Sensitivities**: the base case plus one declared change per column.
9. **Controls**: the tests that must read zero before any figure leaves the file.
10. **Exercises**: the tasks of appendix A, each answered in the tab it names.

## How to use it

Change one input at a time, read the value held as a result, the verdict, the fee and the expiration date again, and look at Controls before reading any figure. When the next year's thresholds are published, add a row to the thresholds table with its effective date; never overwrite the row in force.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel or LibreOffice).

Rules are described as read in November 2026. This is education, not legal or antitrust advice: the facts of your own transaction govern, and deal counsel decides whether and how it is filed.
