From a cap table at each testing date to the owner shift, the change date, the value and the annual limitation, the first prorated year, NUBIG and RBIG, NOL vintages used year by year, and what the limitation costs in present value.
Two issuances and a share sale over three testing dates, and on October 15, 2026 the owner shift of a small loss company reaches 51.351 points: an ownership change. Its stock was worth $100,000,000 just before; less a capital contribution of $6,000,000 inside the two-year window, at a rate of 3.95 percent, it may use $3,713,000 of its losses a year, and only $783,290 in 2026. The limitation costs $628,633 of present value at 10 percent. The calculator lays the whole chain out, ready for your own registry.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Section_382_Limitation_Calculator.xlsx (23 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This calculator is a simplified version of the companion workbook of The Section 382 Handbook, which follows one loss company through its financing rounds, a listing and an acquisition: a near miss at 49.230 points, the change, the reductions, 163(j) carryforwards and section 383 credits, a built-in gain, a separate chapter 11 scenario and the value an acquirer puts on the losses.
Six tabs. Inputs are yellow; everything else is a formula; the Checks tab counts the failures and shows the example's results beside yours so you can check the file before you change it.
| Measure | Value |
|---|---|
| Owner shift at October 15, 2026 (Investor 3 18.919 + Investor 4 32.432) | 51.351 points |
| Change date | October 15, 2026 |
| Value (12,500,000 shares x $8.00) | $100,000,000 |
| Capital contribution of February 1, 2025 | -$6,000,000 |
| Value after reduction | $94,000,000 |
| Annual limitation at 3.95 percent | $3,713,000 |
| Limitation of 2026 ($3,713,000 x 77 / 365) | $783,290 |
| Unused limitation carried out of 2026 | $466,852 |
| NUBIG ($150,000,000 - $110,000,000), threshold $10,000,000 | $40,000,000 |
| RBIG of 2028 | $1,500,000 |
| Present value at 10 percent, with the limitation | $4,886,552 |
| Present value without the limitation | $5,515,185 |
| Value lost to the limitation | $628,633 |
The example company is fictional and every input is a teaching assumption, not a market figure. The calculator is separate from the book's case: read its figures against each other, not against the book's company.
Rules described as read in November 2026 (26 U.S.C. 382 and 172, Treas. Reg. 1.382-2T and 1.382-6). Education only, not tax advice: the facts of your own company govern, and its tax advisers decide.
From a registry of 5-percent shareholders and public groups at each testing date, it measures the owner shift and finds the change date, then computes the value after the capital contribution and nonbusiness asset reductions, the annual limitation, the change-year proration, the NUBIG or NUBIL and its threshold, the use of NOL vintages year by year with the 80 percent rule, and the present value of the tax saved with and without the limitation.
The one you enter. The example uses 3.95 percent, the rate published for ownership changes in October 2026 (Rev. Rul. 2026-19); that rate is, as the ruling states, the highest of the adjusted federal long-term rates for October 2026 and the two prior months. Enter the long-term tax-exempt rate published for your own change month; do not take the highest of three such published rates.
163(j) carryforwards, section 383 credits, NUBIL losses, redemptions in connection with the change (382(e)(2)), consolidated groups, title 11 cases, options, the closing-of-the-books election, the exceptions to segregation of Treas. Reg. 1.382-3(j), state rules and successive changes. The book's full workbook covers the first two, the bankruptcy rules and the valuation.
No. It is built for a first pass and for learning the mechanics. A section 382 study needs the company's own registry and records, and its conclusions belong to the company's tax advisers.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The free workbook of The Section 382 Handbook goes further: six dated registries with one mark per line, the near-miss break-even, the redemption in connection with the change, 163(j) carryforwards and section 383 credits in the order of the regulations, the 338 approach as a sensitivity and the (l)(5) and (l)(6) runs.