Free Excel Templates · US Corporate Tax

Section 331 and 332 Corporate Liquidation Calculator (.xlsx)

Six dynamic, unlocked Excel tabs modeling taxable Sections 331/336 double taxation, Section 336(b) debt floors, Section 336(d) anti-stuffing limits, Sections 332/337 parent-subsidiary liquidations, Section 165(g)(3) ordinary worthless stock losses, and Check-the-Box vs. Section 367(e)(2).

Direct Download (No Macros, 100% Live Formulas)

Pre-loaded with the Meridian Industrial Holdings worked case ($3,472,196 taxable liquidation double tax, $147,000 Section 336(d)(3) minority optimization savings, $2,625,000 Section 165(g)(3) ordinary loss benefit, and $1,172,199 Granite Trust net benefit). Overwrite any blue cell to model your own entity.

Download Section_331_332_Liquidation_Calculator.xlsx ↓

What Is Inside the 6 Tabs

Tab NameStatutory Scope & Calculations
Sec331_336_TaxableAsset-by-asset Section 336(a)/(b) deemed sale, 21.0% corporate tax, 23.8% shareholder tax, double-tax wedge vs. stock sale, and 5-year Section 453(h) installment schedule.
Sec336d_AntiStuffingSection 336(d)(1) non-pro-rata vs. pro-rata 5-year disqualified property disallowance and Section 336(d)(2) 2-year built-in loss stuffing reduction.
Sec332_337_SubLiq85%/15% parent-subsidiary liquidation, Section 334(b)(1) carryover basis, Section 336(d)(3) minority loss trap vs. pre-liquidation sale savings, and Section 337(b)(1) / Reg. Section 1.332-7 intercompany debt.
Insolvent_165g3_GTInsolvent subsidiary Section 165(g)(3) >90% active gross receipts test, Section 166 bad debt, Section 108(a)(1)(B) COD exclusion, and Granite Trust pre-plan stock sale breakeven.
CTB_Sec367e2Domestic Check-the-Box deemed Section 332/337 liquidation vs. foreign parent Section 367(e)(2) outbound gain recognition.
Controls10 live structural accounting and tax identity checks (0 hardcoded constants; error counter must equal 0).

Companion to The Section 331 and 332 Corporate Liquidation Handbook

Every formula in this spreadsheet is explained line by line with full statutory citations, case law, and IRS compliance checklists in the 15-chapter handbook.

Explore the Handbook →