# The Section 382 Handbook: companion files

Julian R. Sterling. Book page and downloads: julianrsterling.com/section-382

## What is here

- `Section_382_Workbook.xlsx`: the workbook behind every figure of the book (appendix A). Nine tabs, in the order of the chapters:
  1. **Inputs**: every case choice typed once (dates, prices per share, the three assumed monthly adjusted federal long-term rates, the federal rate, the discount rate, assets, income and 163(j) room by year, the 23 attribute vintages).
  2. **Registry**: the six dated registries, one mark per line, exact and printed percents (largest remainder, three decimals).
  3. **Owner shift**: the five testing dates, the increase of each line over its lowest percent of the testing period, the owner shift and the break-even line of November 10, 2022.
  4. **Value and limitation**: the value immediately before the change, each reduction once, the rate (the highest of the three), the annual limitation and the change-year block.
  5. **Built-in gains**: NUBIG, the threshold, RBIG under the 1374 approach and under the 338 approach (sensitivity only).
  6. **Absorption**: one row per year from 2025 to 2036 in the order of Treas. Reg. 1.383-1(d)(2), then the roll-forward of every vintage.
  7. **Valuation**: tax saved and present value, with and without the limitation.
  8. **Bankruptcy**: the separate chapter 15 scenario, (l)(5) and (l)(6), read by no other tab.
  9. **Checks**: the failures of every tab, expected at zero.

Each tab ends with a block of checks; the cell B2 of each tab counts the checks that fail. Uses by vintage, the registries and the bankruptcy runs are values from the author's model; everything derived from them is a formula.

## How to read it

Open Checks first: every line must read 0. Then follow the chapters: Registry and Owner shift (chapters 3 to 8), Value and limitation (9 to 11), Built-in gains (12), Absorption (11 and 13), Valuation (16), Bankruptcy (15).

## Before you use it

The company, Brandrell Membrane Technologies, Inc., and every party in the case are fictional. Every price, rate, income figure and asset value is a teaching assumption, not a market figure. The rules are described as read in November 2026 and they change. This workbook is for education; it is not tax, legal or accounting advice. The facts of your own company govern, and its tax advisers decide how the rules apply to it.

A simpler, fill-in version for your own company, the Section 382 Limitation Calculator, is free at julianrsterling.com/templates/section-382-limitation-calculator/.
