Free Excel templates

A free HSR reportability calculator in Excel

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.

Get the calculator

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.

The book behind this calculator

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.

Paperback PDF edition, $19.99

What is in the file

Five tabs. Inputs are in blue; everything else is a formula; the Checks tab counts the failures. Empty inputs stay blank without errors.

1. Start here
What the calculator does, the conventions it applies, what it leaves out, and a note that the example figures are a teaching example, not market figures.
2. Thresholds
An editable table keyed by effective date: the 2026 thresholds, the six fee tiers, the maximum civil penalty per day and the legal public holidays, all dated. The figures are those in effect from February 17, 2026; the FTC revises them each year, so the table is meant to receive a new row when the next set is published.
3. Inputs
The acquisition price, an earnout and its estimate, the interest already held and its value, the kind of target and the percentage acquired, the annual net sales and total assets of both persons, whether the target is engaged in manufacturing, the investment-only box with the percentage held after the acquisition, the filing date and the number of days for the penalty line.
4. Calculator
The value held as a result, the thresholds of the filing date, the size-of-transaction test, the size-of-person test and the branch met, the exemption, the verdict, the fee, the 30th day and the end of the waiting period moved past weekends and holidays, and the maximum penalty.
5. Checks
The controls of the calculator, each showing a gap that must read 0, and a count of the failures.

What the worked example returns

MeasureValue
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 testMet (branch for an acquired person engaged in manufacturing)
Investment-only exemptionBox unchecked: not applied
ReportableYes
Filing fee$35,000
30th day after filingSunday, 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
Checks0 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.

How to use it on your own deal

  1. Check the Thresholds tab: if a new year's figures have been published since February 17, 2026, add their row with its effective date.
  2. Enter the price, the earnout estimate counsel accepts and any interest the same person already holds in the issuer.
  3. Enter the annual net sales and total assets of both persons, taken for the whole person from the last regularly prepared statements, and say whether the target is engaged in manufacturing.
  4. Tick the investment-only box only if the acquisition is solely for the purpose of investment and leaves ten percent or less; then enter the filing date and the penalty days.
  5. Read the Checks tab before any figure: a count above zero means a cell to fix.

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.

Questions people ask

What does the HSR reportability calculator do?

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.

Which thresholds does it use?

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.

What does it leave out?

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.

Can I rely on it to decide whether to file?

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.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

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.

See the book and its free files →

Related reading