The base amount from five years of pay, the present value of each payment, Q/A-24 for accelerated vesting, the three-times test, the excise tax, the lost deduction, and cutback, best-net and gross-up side by side, for one executive.
An executive hired on May 1, 2021 has a base amount of $261,000, so her threshold is $783,000. Her severance, bonus, health coverage and one tranche of accelerated options total $786,231: $3,232 over the line. That small overshoot makes $525,231 an excess parachute payment, costs her $105,046 of excise tax and costs the company $110,299 of deductions, while a cutback of $3,232 would remove all of it. The calculator lays the chain out for one executive, ready for your own figures.
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_280G_Golden_Parachute_Calculator.xlsx (14 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 280G Handbook, which follows one private company through its sale by merger: five people tested, five base amounts, every payment marked once, option tranches valued under the safe harbor, a covenant not to compete, the excise tax and its withholding, cutback, best-net and gross-up, and a shareholder vote.
Four tabs. Inputs are in blue; everything else is a formula; the Checks tab counts the failures. Empty input rows leave room for more payments and more tranches.
| Measure | Value |
|---|---|
| 2021 W-2 box 1 for 8 months, $160,000, annualized | $240,000 |
| Base amount, average of 2021 to 2025 | $261,000 |
| Three times the base amount | $783,000 |
| Cash severance at the change | $600,000 |
| Transaction bonus | $100,000 |
| Health coverage, 12 x $1,800, present value | $21,142 |
| 60,000 options worth $409,800, Q/A-24(c) contingent portion | $65,089 |
| Total counted in the test | $786,231 |
| Excess parachute payment | $525,231 |
| Excise tax at 20 percent | $105,046 |
| Lost deduction at 21 percent | $110,299 |
| Cutback needed to reach $782,999 | $3,232 |
| Net at 45 percent: full payment / cutback | $327,381 / $430,649 |
| Gross-up | $300,131 |
| Cost to the company: gross-up / full payment | $1,259,688 / $896,530 |
The example executive is fictional and every input is a teaching assumption, not a market figure; the discount rate of 4.00 percent is an assumption of the example, not a published rate. Here the cutback wins: $430,649 against $327,381, so a best-net clause keeps it, and 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.
Rules described as read in November 2026 (26 U.S.C. 280G, 4999 and 11(b), Treas. Reg. 1.280G-1 Q/A-24 and Q/A-34 to Q/A-38, Rev. Proc. 2003-68). Education only, not tax advice: the facts of your own company govern, and its tax advisers decide.
For one executive it rebuilds the base amount from five years of W-2 box 1 pay, annualizing a partial first year, takes each payment at its present value at the change, applies Q/A-24(c) to each tranche of accelerated vesting, runs the three-times test with its margin, and computes the excess parachute payment, the 20 percent excise tax, the lost deduction at 21 percent and the cutback needed. It then sets the full payment, the cutback, best-net and a gross-up side by side, with the executive's net and the company's cost.
As read in November 2026: the threshold of section 280G(b)(2)(A), the excess over one base amount of section 280G(b)(1), the 20 percent tax of section 4999, the 21 percent corporate rate of section 11(b), and Q/A-24(c) of Treas. Reg. 1.280G-1 for service-only awards. The discount rate is an input: 120 percent of the applicable federal rate for the change date, compounded semiannually.
The tests that make someone a disqualified individual, the small business and shareholder vote exemptions, several executives at once, Q/A-24(b) payments, the option valuation itself (the value at the change is an input, from Rev. Proc. 2003-68 or another permitted method), state rules and section 409A. The book's full workbook covers most of them on one case.
No. It is built for a first pass and for learning the mechanics. Withholding and reporting need the company's own records, and the 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 280G Handbook goes further: five people and the test that qualifies each, a base amount annualized for a recent hire, a retention bonus presumed contingent, the Rev. Proc. 2003-68 safe harbor, Q/A-24(b) payments, the base amount allocated payment by payment, a covenant not to compete, a shareholder vote and five sensitivities.