Free Excel templates

A free Section 381 & Section 384 Corporate Tax Attributes Calculator in Excel

Acquisition-year NOL and capital loss proration, 3-year E&P hovering deficit waterfall, Section 381(c)(4) Principal Method and Section 481(a) 4-year spread, 5-year Section 384 NUBIG/RBIG blocking, and Section 269 diagnostic.

Pre-loaded with Meridian Industrial Holdings, Inc. across its 2026 merger of Alder ($14,500,000 NOL, -$16,000,000 E&P deficit, $4,800,000 positive Section 481(a)), Section 332 liquidation of Crestline ($7,500,000 NOL), and Section 384 acquisition of Beacon ($24,000,000 NUBIG, $1,260,000 5-year incremental tax cost). Toggle the Section 382 switch or overwrite any blue input cell with your own deal figures.

Get the Excel calculator

One Excel workbook, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.

Section_381_384_Attributes_Calculator.xlsx (27 KB)

You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.

What is inside the 7-tab workbook

Tab NameStatutory ScopeLive Output Highlight (Meridian Case)
Inputs_SummaryAll editable blue inputs + DashboardCentralized switches (Sec. 382 toggle, dates, dividends, NUBIG)
NOL_Proration_381c1Sec. 381(c)(1)(B), Sec. 332, Sec. 381(c)(3)Alder 2026: $1,587,945.21 (w/ 382) vs $9,073,972.60 (no 382); Crestline: $5,983,561.64
EP_Hovering_381c2Sec. 381(c)(2)(B) Hovering DeficitTrap ($22,000,000 div): -$16,000,000 frozen; Mod ($10,000,000 div): $3,119,178.08 absorbed
Method_481a_381c4Sec. 381(c)(4) & Sec. 481(a)$4,800,000 spread at $1,200,000/yr ($98,677.38 PV savings at 8%)
Sec384_Preacq_LossSec. 384(a) & 15% / $10M Cliff$24,000,000 NUBIG blocks $22,000,000 RBIG; $1,260,000 5-yr extra cash tax
Sec269_AntiAbuseSec. 269(a) Principal PurposeMeridian+Alder 97.18% commercial (PASS) vs Shell 63.41% tax (DISALLOWED)
ControlsDynamic Conservation Audit10 live accounting/tax identities; 0 errors (PASS)

Related reading

Full handbook: The Section 381 Corporate Tax Attributes Handbook

Worked guide: Section 381(c)(2)(B) E&P Deficit Hovering Rule

Worked guide: Section 381(c)(4) Accounting Method Integration in Mergers

Worked guide: IRC Section 384 Limitation on Preacquisition Losses