Free Excel Templates

Section 162(m) Deduction Limit Calculator (Excel)

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

Get the Excel calculator

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.

The handbook behind this calculator

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.

Paperback PDF edition, $19.99 Book page and full workbook

What is inside the workbook

1. Start here
Quick-start instructions, color coding conventions (blue inputs, black formulas), and statutory rule summary.
2. Inputs
Statutory cap ($1,000,000), tax year toggle (2026 or 2027), combined tax rate (25.00%), operating partnership ownership percentage (80.00%), and the 10-employee compensation grid.
3. Calculator
Live ranking of non-officers for the 2027 Top 5, Section 280G dollar-for-dollar cap reduction, pro rata entity allocation across Parent, Subsidiary, and Partnership, disallowed deduction, and cash tax cost.
4. Checks
Automated reconciliation block whose cell B2 must equal 0 before any number leaves the spreadsheet.

What the pre-loaded example returns

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

Questions corporate tax teams ask

Does this calculator handle the 2027 ARPA Top 5 expansion?

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.

How does the workbook allocate the $1,000,000 cap across entities?

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.

Does it coordinate with Section 280G excess parachute payments?

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.

Are any cells locked or macros required?

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.