Free Excel Templates · US Corporate Tax

Section 162(f) Settlement Deductibility Calculator (Excel)

Six-tab working model for IRC Sections 162(f), 162(g), 162(q), Form 1098-F reconciliation, and ASC 740 / Schedule M-3

Evaluate the real after-tax cost of government and antitrust settlements before you sign. Pre-loaded with the Vanguard BioIndustrials, Inc. four-settlement portfolio ($112,000,000.00 gross principal, $52,500,000.00 permanent disallowance, 35.74% Effective Tax Rate), every tab updates automatically when you change your federal/state tax rates or settlement allocations.

Download the Excel workbook (Section_162f_Settlement_Deductibility_Calculator.xlsx)

Direct download, no registration required. Compatible with Microsoft Excel, LibreOffice Calc, and Google Sheets.

Download Excel workbook (21 KB) → See the companion handbook

What is inside the 6 worksheets

WorksheetWhat it computes
Inputs_ProfileFederal (21.00%), net state (4.50%), and combined (25.50%) tax rates, Form 1098-F threshold ($50,000.00), MACRS/book rates, and editable inputs for DOJ, SEC, EPA, Antitrust, and Section 162(q).
Settlement_MatrixGross principal, deductible/recoverable split, permanent disallowances, defense and relator counsel fees, Year 1 vs. lifetime tax shields, and net after-tax cash cost.
Form_1098F_Recon$50,000.00 threshold test, Boxes 1 through 4 ($97,000,000.00 total), Box 9 Codes, and full bridge to total enforcement cash outlays ($122,000,000.00).
ASC740_Schedule_M3Rate reconciliation (25.50% statutory to 35.74% ETR), Schedule M-3 Part III Line 12, current vs. deferred tax split, and Section 461(h) payment-deferral DTA ($4,590,000.00).
Stress_Audit_ScenariosQuantifies DOJ Identification failure (+$4,590,000.00), SEC Treasury disgorgement (+$4,590,000.00), total failure (+$13,897,500.00, 46.38% ETR), Section 162(q) NDA trap, and FIN 48 UTB reserves.
ControlsSeven automated tie-out checks verifying zero variance across Form 1098-F boxes, ASC 740 provision, Section 461(h) invariance, and Schedule M-3.

Related guides

Section 162(f) Identification and Establishment Requirements: Restitution & Remediation Guide

Form 1098-F Reporting Threshold ($50,000) and Corporate Tax Reconciliation Guide

False Claims Act, SEC Disgorgement, and Section 162(g) Treble Damages Tax Deductibility