Free templates · US Corporate Tax
Six-tab live Excel model for Section 318 constructive ownership, Section 302(b) tests, Section 304(b)(2) E&P waterfalls, Section 1059 basis cuts, and Section 4501 Form 7208 excise tax (21 KB, .xlsx).
Built as the live companion model to The Section 302 and 304 Handbook. Pre-loaded with the complete Hartwell Group and Crestline Public Holdings dataset, 100% live formulas, zero macros, and a dynamic 13-check integrity Controls tab.
Direct download, no macros, no locked sheets. Compatible with Excel and LibreOffice Calc.
| Tab | Core Calculations |
|---|---|
| Inputs_CapTable | Editable 2026 tax rates, HIC/HLC/HFS E&P balances, and full cap table (1,000 shares, $40,000,000 FMV) |
| Sec318_Matrix | Direct, upward HFP (§ 318(a)(2)), family direct (§ 318(a)(1)), family via HFP, downward to HFP (§ 318(a)(3)), and option attribution (§ 318(a)(4)) |
| Sec302_Tests | Scenarios 2A/2B/2C (§ 302(b)(2) + min-shares formula), 3A/3B (§ 302(b)(3) waiver savings of $428,400), 5 (Partial Liquidation), and 6 (Zenz) |
| Sec304_Waterfalls | Scenario 7 (§ 304(a)(1) brother-sister) and Scenario 8 (§ 304(a)(2) parent-subsidiary) two-tier E&P waterfalls and carryover vs. cost basis |
| Sec303_306_311_4501 | Scenario 9 (§ 303 estate redemption), Scenario 10 (§ 306 bailout), Scenario 11 (§ 311(b) + § 312(n)(7)), and Scenario 12 (§ 4501 Form 7208) |
| Controls | 13 dynamic accounting & tax identities verifying 0 formula errors and 0 reconciliation drift on any input change |
Section 302(b)(2) Substantially Disproportionate Redemption Test
Section 318 Constructive Ownership and the Section 302(c)(2) Waiver
Section 304 Brother-Sister and Parent-Subsidiary Redemptions