# The Section 162(m) Handbook - Companion Files

Thank you for reading *The Section 162(m) Handbook* by Julian R. Sterling.

## Included Workbooks

1. **`Section_162m_Workbook.xlsx`** (11 tabs)
   The complete Alderbrook Holdings, Inc. case study workbook behind every number in Chapters 1 to 14 and Appendix A:
   - `Inputs`: statutory cap ($1,000,000), federal/state tax rates (21% / 4% / 25% combined), and policy toggles.
   - `Entities`: IRC Section 414(b)/(c) vs. Section 1504 entity scope for E1 through E5 under P.L. 119-21 Section 70603 (IRC Section 162(m)(7)).
   - `Year 2026`: 14 tracked employees, 8 permanent covered employees, $12,600,000 disallowed deduction, $3,150,000 cash tax cost.
   - `Year 2027`: 2027 ARPA Top 5 expansion (IRC Section 162(m)(3)(C) and Prop. Reg. REG-118988-22), 12 covered employees, $20,740,000 disallowed deduction, $5,185,000 cash tax cost.
   - `Entity Allocation`: Pro rata allocation of the $1,000,000 cap across E1, E2, E3 (90% partnership distributive share), and E4 for 2026 and 2027.
   - `Top 5 Ranking`: Dynamic ranking of otherwise-deductible compensation across all non-officer and overlapping employees.
   - `Section 280G CIC`: IRC Section 162(m)(4)(F) dollar-for-dollar cap reduction scenarios (partial reduction and full elimination).
   - `ASC 740 DTA`: Cash-First vs. Pro-Rata deferred tax asset ordering ($250,000 vs. $1,040,162.66) and 2027 ARPA Top 5 DTA write-downs.
   - `Sensitivities`: All eight one-change-at-a-time sensitivity scenarios (S1 through S7).
   - `Summary`: Executive summary and Form 1120 Schedule M-3 permanent difference bridge.
   - `Controls`: Automated audit tab. Cell `B2` must read `0` before any figure leaves the workbook.

2. **`Section_162m_Deduction_Limit_Calculator.xlsx`** (4 tabs)
   A clean standalone calculator (`Start here`, `Inputs`, `Calculator`, `Checks`) pre-loaded with an illustrative 10-employee worked example (2026 vs. 2027 Top 5, controlled group allocation, 80% partnership distributive share, and Section 280G cap reduction) that you can populate with your own company's data immediately.

## Modeling Conventions
- Blue font: hardcoded inputs you may edit.
- Black font: live unlocked Excel formulas (zero macros, zero circular references).
- Always check the `Controls` (or `Checks`) tab cell `B2 = 0` after modifying any input.

Education only; not tax, legal, or accounting advice. Companion page: https://julianrsterling.com/section-162m/
