# The Section 338(h)(10) Handbook: companion files

Julian R. Sterling, julianrsterling.com/section-338h10

## What is here

- **Section_338h10_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Tavistrell Composites, Inc., an S corporation owned by its two founders and bought for cash by a corporate buyer, with a joint Section 338(h)(10) election. Every case figure is a teaching assumption, never a market figure.

## The twelve tabs, in the order to read them

1. **Inputs**: the price at closing, the working capital true-up, the costs of each side, the liabilities, and the published rules the model applies with the date each was read.
2. **Registers**: the nine assets (class, fair value, old basis, depreciation taken, built-in gain at the S conversion) and the two shareholders.
3. **ADSP and AGUB**: two columns from one price, the seller's number and the buyer's number, each element entered once.
4. **Allocation**: Classes I to VII on each side, every asset capped at its fair value, the rest to Class VII.
5. **Gain**: the gain asset by asset, split into inventory, section 1245 recapture and capital gain.
6. **Built-in gains**: the recognized built-in gain per asset, the remaining limit and the tax.
7. **Founders**: the stock sale without election against the deemed asset sale and deemed liquidation with it, founder by founder.
8. **Step-up**: the step-up per asset, the deductions year by year and their present value.
9. **Gross-up**: the resolution table (no circular reference), the gross-up put back into the price, the buyer's net gain and the breakeven gross-up.
10. **Routes**: stock sale, election, F reorganization and the rollover variants side by side.
11. **Sensitivities**: the base case plus one declared change, one column at a time.
12. **Controls**: tie-outs and zero-divisor guards; every line must read zero.

## How to use it

Change one input at a time on Inputs, read ADSP, AGUB, the extra tax and the gross-up again, and look at Controls before reading any figure. A different price, date or rate belongs in Sensitivities, run against the base case.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel or LibreOffice).

Rules are described as read in November 2026. This is education, not tax advice: the facts of your own transaction govern, and the deal's tax advisers decide what applies to it.
