Is the deal reportable under the HSR Act, at what value and for what fee? The calculator builds the value, runs both tests against the thresholds in force on the filing date (to retest on the planned closing date), and counts the waiting period to the day.
A buyer pays $150,000,000 for the voting securities of a privately held manufacturer, adds an earnout estimated at $8,000,000 and already holds an interest worth $20,000,000. The value held as a result is $178,000,000: above $133.9 million, both persons meet the size-of-person test, the deal is reportable and the fee is $35,000. Filed on Friday, September 4, 2026, the waiting period expires on Monday, October 5, 2026. The calculator lays the chain out for your own figures.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
HSR_Reportability_Calculator.xlsx (15 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This calculator is a simplified version of the companion workbook of The HSR Act Handbook, which follows one sponsor through a full HSR file: the acquiring person and its ultimate parent entity, control of an LLC and of a fund, a value built from cash, an earnout and a stake already held, both tests, the exemptions, the fee tier, the documents, the waiting period and five separate scenarios.
Five tabs. Inputs are in blue; everything else is a formula; the Checks tab counts the failures. Empty inputs stay blank without errors.
| Measure | Value |
|---|---|
| Value held as a result: price + earnout estimate + interest already held | $150,000,000 + $8,000,000 + $20,000,000 = $178,000,000 |
| Size-of-transaction test (above $133.9 million, not above $535.5 million) | Met, size-of-person test required |
| Size-of-person test | Met (branch for an acquired person engaged in manufacturing) |
| Investment-only exemption | Box unchecked: not applied |
| Reportable | Yes |
| Filing fee | $35,000 |
| 30th day after filing | Sunday, October 4, 2026 |
| Waiting period expires (11:59 p.m. Eastern Time) | Monday, October 5, 2026 |
| Maximum civil penalty for 10 days at $53,088 | $530,880 |
| Checks | 0 failures |
The example is fictional and every input is a teaching example, not a market figure: voting securities of a privately held corporation engaged in manufacturing; acquisition price $150,000,000; earnout estimate $8,000,000; interest already held at fair market value $20,000,000; target annual net sales $41,000,000 and total assets $33,000,000; acquiring person annual net sales $520,000,000 and total assets $700,000,000; investment-only box unchecked; signing on August 3, 2026; filing on Friday, September 4, 2026; 10 days for the penalty line. Every check of the control block reads 0.
Read the conventions with the figures. The value adds the price, the earnout at its estimate and the interest already held at its value, each once. The thresholds are those of the row in force on the filing date; retest them on the planned closing date, and if a new set takes effect between the two, ask deal counsel. The size-of-person test is applied only between $133.9 million and $535.5 million. The fee is the amount of the single tier the value falls in. The waiting period ends on the 30th calendar day after filing, moved to the next regular business day if that day is a Saturday, Sunday or legal public holiday, at 11:59 p.m. Eastern Time. The penalty line is the number of days times the amount per day in force, a maximum and not a prediction of what a court would impose. The calculator is separate from the book's case: read its figures against each other, not against the book's deal.
Conventions explained in the book with the rules as read in November 2026 (15 U.S.C. 18a, 16 CFR 801.10, 801.13, 802.9, 803.9 and 803.10, and the FTC's notice of the 2026 thresholds and fees). Education only, not legal advice: the facts of your own transaction govern, and deal counsel decides whether and how it is filed.
For one acquisition of voting securities it computes the value held as a result (price, earnout estimate and interest already held), applies the thresholds in effect on the filing date (retest them on the planned closing date; if a new set takes effect between the two, ask deal counsel), runs the size-of-transaction and size-of-person tests, reads an investment-only box, returns the verdict, the filing fee tier, the end of the 30-day waiting period and the maximum civil penalty for a number of days, with a block of checks that must read zero.
Those in effect from February 17, 2026: $133.9 million, $26.8 million, $267.8 million and $535.5 million, with the 2026 fee tiers and the penalty of $53,088 per day set in 16 CFR 1.98(a) as read in November 2026. They sit in an editable table keyed by effective date: when the FTC publishes next year's figures, add a row; the calculator picks the row in force on the filing date; retest it on the planned closing date, and if a new set takes effect between the two, ask deal counsel.
Who the acquiring and acquired persons are and their ultimate parent entities, control of LLCs and partnerships, the exemptions other than investment only, listed-share pricing rules, Item 4(c) and 4(d) documents, second requests and early termination. The book's full workbook covers most of them on one deal.
No. It is built for a first pass and for learning the mechanics. Whether and how a transaction is filed is a decision for deal counsel on the facts of the deal.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The free workbook of The HSR Act Handbook goes further: entities traced to their ultimate parent entity, control tested on an LLC and a fund, the aggregation of every interest the same person holds, the exemptions condition by condition, seven documents classified for Items 4(c) and 4(d), a waiting period counted past a holiday, scenarios run apart from the case and sensitivities run one at a time.