Free Excel Templates · US Corporate Tax
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.
Direct download, no registration required. Compatible with Microsoft Excel, LibreOffice Calc, and Google Sheets.
Download Excel workbook (21 KB) → See the companion handbook
| Worksheet | What it computes |
|---|---|
| Inputs_Profile | Federal (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_Matrix | Gross 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_M3 | Rate 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_Scenarios | Quantifies 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. |
| Controls | Seven automated tie-out checks verifying zero variance across Form 1098-F boxes, ASC 740 provision, Section 461(h) invariance, and Schedule M-3. |
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