Free Excel templates

A free section 382 limitation calculator in Excel

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.

Get the calculator

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.

The book behind this calculator

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.

Paperback PDF edition, $19.99

What is in the file

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.

1. Start here
What the calculator does, the rules it applies with their dates and sources, and what it leaves out.
2. Inputs
The registry (up to eight lines and six dates), the value per share, capital contributions with their dates, nonbusiness assets, total assets and debt, the rate, the asset values and basis, taxable income and RBIG for ten years, and up to four pre-2018 and four post-2017 NOL vintages.
3. Owner shift
Percents at each date, the start of each testing period, the increase of each line over its lowest percent, the owner shift and the first date above 50 points.
4. Limitation
The change date, the value, each reduction, the annual limitation, the change-year days and proration, NUBIG or NUBIL and the threshold.
5. Absorption
Year by year, with and without the limitation: the limitation available, the unused carry, RBIG, pre-2018 and post-2017 NOLs used vintage by vintage with the 80 percent cap, expiries, tax saved and present value.
6. Checks
Percents adding up to 100, dates in order, losses within the limitation and the 80 percent cap, no negative carry, no vintage used beyond its amount.

What the worked example returns

MeasureValue
Owner shift at October 15, 2026 (Investor 3 18.919 + Investor 4 32.432)51.351 points
Change dateOctober 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.

How to use it on your own company

  1. Enter the registry after each owner shift: one line per 5-percent shareholder and per public group, new stock sold to the public on a new line, and one column per testing date.
  2. Enter the value per share immediately before the change, every capital contribution of the two years before it, and the nonbusiness assets, total assets and debt immediately after it.
  3. Enter the long-term tax-exempt rate of your change month from the IRS revenue ruling, with its date, and the asset values and basis immediately before the change.
  4. Enter the vintages oldest first and the taxable income from the change year on, then read the Checks tab before any figure: a check above zero means a cell to fix.

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.

Questions people ask

What does the section 382 calculator do?

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.

Which rate does it use?

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.

What does it leave out?

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.

Can I rely on it for a filing?

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.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

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.

See the book and its free files →

Related reading