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.
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.
| Tab Name | Statutory Scope | Live Output Highlight (Meridian Case) |
|---|---|---|
| Inputs_Summary | All editable blue inputs + Dashboard | Centralized switches (Sec. 382 toggle, dates, dividends, NUBIG) |
| NOL_Proration_381c1 | Sec. 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_381c2 | Sec. 381(c)(2)(B) Hovering Deficit | Trap ($22,000,000 div): -$16,000,000 frozen; Mod ($10,000,000 div): $3,119,178.08 absorbed |
| Method_481a_381c4 | Sec. 381(c)(4) & Sec. 481(a) | $4,800,000 spread at $1,200,000/yr ($98,677.38 PV savings at 8%) |
| Sec384_Preacq_Loss | Sec. 384(a) & 15% / $10M Cliff | $24,000,000 NUBIG blocks $22,000,000 RBIG; $1,260,000 5-yr extra cash tax |
| Sec269_AntiAbuse | Sec. 269(a) Principal Purpose | Meridian+Alder 97.18% commercial (PASS) vs Shell 63.41% tax (DISALLOWED) |
| Controls | Dynamic Conservation Audit | 10 live accounting/tax identities; 0 errors (PASS) |
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