Free Excel templates

A free Section 338(h)(10) gross-up calculator in Excel

ADSP and AGUB from one price, the allocation across Classes I to VII, the sellers' tax with and without the election, the gross-up that makes them whole, and what the step-up leaves the buyer, for one target.

An S corporation is bought for $9,000,000 with $1,000,000 of liabilities. ADSP is $9,750,000 and AGUB $10,175,000. The election costs the sellers $292,158 more than a stock sale, built-in gains tax included, so they ask for a gross-up of $365,198, more than the extra cost because the gross-up is taxed too. The step-up is then worth $900,479 to the buyer, which keeps $535,281 and would stop gaining above a gross-up of $964,271. The calculator lays the chain out for one target, ready for your own figures.

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_338h10_Gross_Up_Calculator.xlsx (13 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 338(h)(10) Handbook, which follows one S corporation through its sale to a corporate buyer: eligibility, ADSP and AGUB redetermined after a true-up, nine assets in seven classes, the built-in gains tax and its limit, the deemed liquidation founder by founder, the step-up valued year by year, the gross-up and its breakeven, and the F reorganization with a rollover.

Paperback PDF edition, $19.99

What is in the file

Four tabs. Inputs are in blue; everything else is a formula; the Checks tab counts the failures. Empty input rows leave room for more assets in each class.

1. Start here
What the calculator does, the rules it applies with their dates and sources, what it leaves out, and a note that the example rates and recovery periods are teaching assumptions, not published rates, except the 21 percent of section 11(b).
2. Inputs
The price for the stock, the liabilities taken over, the selling costs and the buyer's acquisition costs; the tax basis and fair value of the assets in each class, with the depreciation taken on equipment; the sellers' stock basis; the amount subject to the built-in gains tax and its rate; the sellers' ordinary and capital gain rates; the buyer's rate; the recovery periods and the discount rate.
3. Calculator
ADSP, AGUB, the allocation across Classes I to VII on each side, the gain and its ordinary part, the built-in gains tax, the sellers' tax in a stock sale and with the election, the extra cost, the gross-up solved in closed form and put back into the price, the present value of the step-up without and with the gross-up, the buyer's net gain and the breakeven gross-up.
4. Checks
The controls of the calculator, each showing a gap that must read 0, and a count of the failures.

What the worked example returns

MeasureValue
Price for the stock / liabilities taken over$9,000,000 / $1,000,000
Sellers' selling costs / buyer's acquisition costs$250,000 / $175,000
ADSP / AGUB$9,750,000 / $10,175,000
Class VII, seller / buyer$4,800,000 / $5,225,000
Gain on the deemed asset sale, of which ordinary$7,250,000, $950,000
Built-in gains tax, 21 percent of $800,000$168,000
Sellers' tax in a stock sale$1,450,000
Sellers' income tax with the election$1,574,158
Extra cost of the election, built-in gains tax included$292,158
Gross-up$365,198
Step-up value for the buyer, without / with the gross-up$861,591 / $900,479
Buyer's net gain after the gross-up$535,281
Breakeven gross-up$964,271

The example target is fictional and every input is a teaching assumption, not a market figure: cash of $300,000, receivables of $900,000, inventory with a basis of $700,000 and a fair value of $850,000, equipment with a basis of $600,000, a fair value of $1,400,000 and $1,600,000 of depreciation taken, a customer list worth $1,500,000 with no basis, sellers' stock basis of $1,500,000, rates of 37 and 20 percent for the sellers, 21 percent for the buyer, a 10 percent discount rate, equipment recovered over 7 years and intangibles over 15. Every check of the control block reads 0. 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 case

  1. Confirm first that the election is available: a corporate buyer, a qualified stock purchase and an S corporation or a member of a selling consolidated group.
  2. Enter the price, the liabilities and the costs of each side; keep the buyer's loan fees out, they belong to the loan.
  3. Enter each asset in its class with its basis and fair value, and the depreciation taken on equipment; leave goodwill to the residual.
  4. Enter the amount subject to the built-in gains tax only if the sale falls inside the recognition period, then the rates and the discount rate.
  5. Read the Checks tab before any figure: a count above zero means a cell to fix.

Rules described as read in November 2026 (26 U.S.C. 338, 1374, 1245, 197 and 11(b), Treas. Reg. 1.338-4, 1.338-5, 1.338-6 and 1.338(h)(10)-1). Education only, not tax advice: the facts of your own transaction govern, and the deal's tax advisers decide.

Questions people ask

What does the Section 338(h)(10) gross-up calculator do?

For one target it builds ADSP and AGUB from the stock price, the liabilities and the costs of each side, allocates both across Classes I to VII with the rest to Class VII, splits the gain on the deemed sale into ordinary recapture and capital gain, adds the built-in gains tax on the amount you enter, compares the sellers' tax with a stock sale, solves the gross-up without a circular reference, and values the step-up for the buyer with and without it, down to the breakeven gross-up.

Which rules does it apply?

As read in November 2026: ADSP and AGUB under Treas. Reg. 1.338-4 and 1.338-5, the residual method of Treas. Reg. 1.338-6, section 1245 recapture up to the depreciation taken, the 21 percent rate of section 11(b) for the built-in gains tax and the corporate buyer, and 15-year amortization under section 197. The sellers' rates, the equipment recovery period and the discount rate are inputs.

What does it leave out?

Eligibility (it assumes a valid election), partial purchases and nonrecently purchased stock, the built-in gains limit computed asset by asset, the deemed liquidation founder by founder, bonus depreciation choices, state taxes and the F reorganization. The book's full workbook covers most of them on one case.

Can I rely on it for a filing?

No. It is built for a first pass and for learning the mechanics. Form 8023, Form 8883 and the clause of the purchase agreement need the deal's own figures, and the conclusions belong to the deal'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 338(h)(10) Handbook goes further: two founders taxed one by one, the built-in gains limit asset by asset, ADSP redetermined after a true-up, bonus depreciation and 15-year amortization year by year, the gross-up reinjected to the dollar, the F reorganization with and without a rollover, and six sensitivities.

See the book and its free files →

Related reading