Free Excel templates

A free Section 280G golden parachute calculator in Excel

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.

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_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.

The book behind this calculator

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.

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 payments and more tranches.

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 rate is an assumption, not a published rate.
2. Inputs
The change date; W-2 box 1 pay for the five years of the base period, with the months worked; each payment contingent on the change, by nature and date; each unvested award with its scheduled vesting date and its value at the change; the discount rate; any reasonable compensation retained; the executive's marginal rate.
3. Calculator
The base amount, the present value of each payment, the Q/A-24(c) portion of each tranche, the total, the three-times test and its margin, the excess parachute payment, the excise tax, the lost deduction, the cutback needed, and the full payment, cutback, best-net and gross-up with the executive's net and the company's cost.
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
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.

How to use it on your own case

  1. Confirm first that the person is a disqualified individual (officer, shareholder above 1 percent, or highly compensated) and that no exemption applies.
  2. Enter the change date and W-2 box 1 pay for the five years before it, with the months worked in a partial year; enter a once-a-year payment such as a signing bonus apart, so that it is not annualized.
  3. Enter each payment contingent on the change with its date, and each unvested award with its value at the change and its scheduled vesting date; enter the rate for the change date.
  4. 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. 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.

Questions people ask

What does the Section 280G calculator do?

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.

Which rules does it apply?

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.

What does it leave out?

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.

Can I rely on it for a filing?

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.

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 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.

See the book and its free files →

Related reading