HSR Antitrust Filing HHI Concentration, Delta-HHI, GUPPI & SSNIP Calculator — Calculator, Excel Workpaper & API (BI-28)
Evaluates 2023 FTC/DOJ Merger Guidelines Sec. 2.1 Post-Merger HHI (>1,800) & Delta-HHI (>100) Test; 30% Combined Market-Share Presumption & 16 CFR Part 801 HSR Filing-Fee Schedule; Unilateral Gross Upward Pricing Pressure Index (GUPPI) & SSNIP Critical-Loss Test; Sec. 3.1 Failing-Firm Defense & Sec. 3.3 Cognizable Marginal-Cost Efficiency Offset. Submit: Firm1 Revenue M, Firm2 Revenue M, Transaction Value M, Price Firm1. Excel Tabs: Exec Antitrust Dashboard, HHI Market Share Matrix, SSNIP Critical Loss Test, Diversion And GUPPI Model. Calibrated across all 57 US States, Washington, D.C., US Territories, and Federal IRC § 11 baselines in sub-millisecond deterministic Python & NumPy CPU execution.
Official Statutory & Regulatory Workpaper Title: 16 CFR Part 801 HSR Act Submission & 2023 FTC/DOJ Merger Guidelines Sec. 2.1 / 3.1 / 3.3 Exhibit
Official Agency Form / Workpaper Standard: 16 CFR Part 801 HSR Filing / 2023 FTC-DOJ Merger Guidelines HHI & GUPPI
Governing Accounting, Tax & Statutory Authorities: 15 U.S.C. § 18 (Clayton Act § 7); 16 CFR Parts 801–803 (2025/2026 Revised HSR Premerger Notification Rules); 2023 FTC/DOJ Merger Guidelines (Guideline 1, § 3.1 Failing Firm, § 3.3 Procompetitive Efficiencies)
Common Practitioner & Search Aliases: HHI and Delta HHI Calculator, 2023 Merger Guidelines 1800 Test, GUPPI Diversion Ratio Calculator, SSNIP Critical Loss Analysis, HSR Size of Transaction Fee Tier
Interactive HSR Antitrust Filing HHI Concentration, Delta-HHI, GUPPI & SSNIP Calculator Calculator (BI-28)
Enter your trial-balance, schedule, or contract numbers below to verify headline statutory outputs in real time across 57 US jurisdictions (zero data stored).
Optional: Paste Advanced Custom Schedule / Array Overrides (JSON)
Computed Headline Statutory & Financial KPIs
Download 5-Tab Formula-Linked Excel Workpaper (.xlsx) — $19.00
Includes 5 formatted CPA/analyst tabs compiled from your exact inputs: 01_Executive_Summary, 02_Statutory_Rules (4 rules), 03_Workpaper_Schedule (5 rows + =SUM/=AVERAGE formulas), 04_Scenario_Sensitivity (=C-B variance formulas), and 05_Compliance_Audit_Flags (3 threshold gates).
1. Deterministic Statutory & Regulatory Laws Executed
Unlike prompt-only LLM skills that approximate multi-period schedules in token space, BI-28 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) 2023 FTC/DOJ Merger Guidelines Sec. 2.1 Post-Merger HHI (>1,800) & Delta-HHI (>100) Test [15 U.S.C. Sec. 18 (Clayton Act Sec. 7) & 2023 FTC/DOJ Merger Guidelines Guideline 1]
- (2) 30% Combined Market-Share Presumption & 16 CFR Part 801 HSR Filing-Fee Schedule [15 U.S.C. Sec. 18a (HSR Act), 16 CFR Part 801 & Merger Guidelines Sec. 2.1 Share Prong]
- (3) Unilateral Gross Upward Pricing Pressure Index (GUPPI) & SSNIP Critical-Loss Test [2023 FTC/DOJ Merger Guidelines Sec. 2.2 & Sec. 4.3 Hypothetical Monopolist SSNIP Test]
- (4) Sec. 3.1 Failing-Firm Defense & Sec. 3.3 Cognizable Marginal-Cost Efficiency Offset [2023 FTC/DOJ Merger Guidelines Sec. 3.1 (Failing Firm) & Sec. 3.3 (Procompetitive Efficiencies)]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Executed Merger / Acquisition Agreement, Deal Presentation Decks & HSR Item 4(c) / 4(d) Strategic Documents | Structured JSON object/array or CSV text |
FILE-2 | 36-Month Product- and Geography-Level Revenue, Unit Volume, Price & Variable Margin Dataset (Both Merging Parties) | Structured JSON object/array or CSV text |
FILE-3 | Customer Bid/Win-Loss Logs, Switching History & Third-Party Industry Market-Share Reports (NAICS 6-Digit) | Structured JSON object/array or CSV text |
FILE-4 | Merger-Specific Cost Efficiencies Model or Failing-Firm Liquidity & Alternative-Buyer Solicitation Dossier | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 00 Exec Antitrust Dashboard |
| Schedule 2 | 01 HHI Market Share Matrix |
| Schedule 3 | 02 SSNIP Critical Loss Test |
| Schedule 4 | 03 Diversion and GUPPI Model |
| Schedule 5 | 04 Sec3 3 Efficiency FailingFirm |
| Schedule 6 | 05 Remedy Divestiture Queue |
3. Quick Integration — REST API (cURL) & AI Agent MCP
A. Direct HTTP / REST API Call
curl -X POST "https://quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com/v1/suites/BI-28/compute" \
-H "Content-Type: application/json" \
-H "X-RapidAPI-Key: YOUR_RAPIDAPI_KEY" \
-H "X-RapidAPI-Host: quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com" \
-d '{
"jurisdiction": "NY",
"naics_or_sic": "541211",
"structured_inputs": {}
}'
B. Model Context Protocol (MCP) Tool Call
// Tool call inside Claude Desktop, Cursor, VS Code Copilot, LangGraph, or CrewAI:
execute_institutional_math_engine({
"engine_code": "BI-28",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})