An unlocked four-tab Excel workbook for 2026 vs. 2027 ARPA Top 5 ranking, P.L. 119-21 controlled group pro rata cap allocation, partnership distributive shares, and Section 280G coordination.
Enter your officers, permanent covered employees, and high-earning non-officers across parent, subsidiary, and operating partnership entities. In the pre-loaded 10-employee example (25.00% tax rate, 80.00% partnership ownership), moving from 2026 to the 2027 Top 5 rule increases covered employees from 4 to 9, raises Section 162(m) disallowance from $5,700,000 to $10,100,000, and adds $1,100,000 in annual cash tax cost ($2,525,000 total).
One unlocked Excel workbook, zero macros, zero circular references. Free: enter your email address and the download opens at once, along with the other free tax and accounting models.
Section_162m_Deduction_Limit_Calculator.xlsx (12 KB)
You join the reader list: one email when a new free model or book comes out. Unsubscribe in one click. Already subscribed? Enter the same address. How your address is used.
This template is a standalone extract of the 11-tab workbook in The Section 162(m) Handbook, which works a complete publicly held controlled group across 2026 and 2027, including Section 414(b)/(c) aggregation under P.L. 119-21, Up-C partnership distributive shares, PEO-leased specialists, grandfathering, M&A predecessors, Section 280G coordination, and ASC 740 DTA ordering.
| Measure | Value |
|---|---|
| 2026 base case covered employees (officers + permanent) | 4 of 10 |
| 2026 Section 162(m) disallowed deduction | $5,700,000 |
| 2026 cash tax cost at 25.00% combined rate | $1,425,000 |
| 2027 covered employees (with ARPA Top 5) | 9 of 10 |
| 2027 Section 280G excess parachute disallowed (E03) | $400,000 |
| 2027 Section 162(m) disallowed deduction | $10,100,000 |
| 2027 cash tax cost at 25.00% combined rate | $2,525,000 |
| 2027 incremental impact vs. 2026 | +$4,400,000 dis. / +$1,100,000 tax |
Every figure in the calculator is an illustrative teaching example, independent of the book's main case. Employee 2 (CFO) receives $1,800,000 from Parent plus a $400,000 distributive share (80% of $500,000) from the operating partnership ($2,200,000 total), splitting the $1,000,000 cap pro rata: $818,181.82 to Parent and $181,818.18 to Partnership. Employee 3 (COO) has $400,000 disallowed under Section 280G, cutting the Section 162(m) cap to $600,000 and leaving $1,100,000 disallowed under Section 162(m). In 2027, five non-officers (Employees 5 through 9, earning $1,200,000 to $2,600,000) enter the Top 5, while Employee 10 ($1,100,000) ranks sixth and remains fully deductible.
Rules described as read in November 2026 (IRC Section 162(m), Treas. Reg. 1.162-33, Prop. Reg. REG-118988-22, and P.L. 119-21 Section 70603). Education only, not tax or legal advice.
Yes. Switching the tax year toggle from 2026 to 2027 automatically ranks all non-officer employees by otherwise-deductible compensation across the controlled group and applies the $1,000,000 cap to the top five.
Under IRC Section 162(m)(7) (added by P.L. 119-21 Section 70603), the calculator aggregates remuneration across Parent, Subsidiary, and the corporation's distributive share of an operating partnership, then allocates the $1,000,000 cap pro rata by entity.
Yes. Enter any Section 280G excess parachute disallowance for a covered employee and the calculator reduces that employee's $1,000,000 Section 162(m) cap dollar for dollar under IRC Section 162(m)(4)(F), floored at $0.
No. Blue cells are editable inputs, black cells are live Excel formulas with zero circular references, and the Checks tab verifies all reconciliations equal 0.