# The Section 280G Handbook: companion files

Julian R. Sterling, julianrsterling.com/section-280g

## What is here

- **Section_280G_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Thurlstone Marine Systems, Inc., a privately held company sold by merger for cash, and the five people tested at its sale. Every case figure is a teaching assumption, never a market figure.

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

1. **Inputs**: the change date (one cell, read by every other tab), the merger price, the discount rate and the tax rates.
2. **People**: the five people tested and the one test that qualifies each of them.
3. **Base amounts**: W-2 box 1 (or Form 1099-NEC box 1) compensation by year, the annualization of a partial year, the base amount and three times the base amount.
4. **Awards and safe harbor**: options and units valued at the change, with the Rev. Proc. 2003-68 factors.
5. **Payments and marks**: each payment on one line with one mark, and the portion contingent on the change.
6. **Present value**: every payment discounted to the change date.
7. **Test**: the total counted for each person against three times the base amount.
8. **Allocation and excess**: the base amount allocated across the parachute payments, and the excess of each.
9. **Excise and deduction**: the 20 percent excise tax, the lost deduction and the effect of the covenant valuation.
10. **Options for the CEO**: cutback, best-net and gross-up, with the cost of each to the company.
11. **Vote scenario**: the separate private company shareholder vote, approved and not approved; no cell of the case reads it.
12. **Sensitivities**: the base case plus one declared change, one column at a time.
13. **Controls**: zero-divisor guards and tie-outs; the block must read zero.

## How to use it

Change one input at a time on Inputs, read the base amount, the test and the excess again, and look at Controls before reading any figure. A different closing date or price 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 company govern, and its tax advisers decide what is withheld, reported and deducted.
