Free templates · US Corporate Tax

Section 302 & 304 Redemption Calculator in Excel

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.

Download Section_302_304_Redemption_Calculator.xlsx (21 KB)

Direct download, no macros, no locked sheets. Compatible with Excel and LibreOffice Calc.

Download Excel workbook (.xlsx) See the full handbook →

What is inside the six tabs

TabCore Calculations
Inputs_CapTableEditable 2026 tax rates, HIC/HLC/HFS E&P balances, and full cap table (1,000 shares, $40,000,000 FMV)
Sec318_MatrixDirect, 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_TestsScenarios 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_WaterfallsScenario 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_4501Scenario 9 (§ 303 estate redemption), Scenario 10 (§ 306 bailout), Scenario 11 (§ 311(b) + § 312(n)(7)), and Scenario 12 (§ 4501 Form 7208)
Controls13 dynamic accounting & tax identities verifying 0 formula errors and 0 reconciliation drift on any input change

Related guides

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