# The Section 163(j) Handbook: companion files

Julian R. Sterling, julianrsterling.com/section-163j

## What is here

- **Section_163j_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Draxmoor Packaging Technologies, Inc. and its consolidated group, followed from 2022 to 2030. Every figure is a teaching assumption, never a market figure.

## The thirteen tabs, in the order to read them

1. **Inputs**: every assumption, typed once (blue cells), with its source. At the top, the switches: the 2025 law (1 = as enacted), and the three sensitivities (reference rate change, EBITDA change, additional debt), all at their base values.
2. **Interest registry**: one row per interest line and per period, exactly one class per row; totals by class.
3. **ATI**: adjusted taxable income line by line, under the regime of the year in which the taxable year begins.
4. **Limitation**: business interest income + 30 percent of ATI (not less than zero) + floor plan financing interest; interest allowed, carryforward used, disallowed, closing carryforward.
5. **Carryforward**: one row per vintage, used earliest first, never in its own period.
6. **Taxable income**: taxable income and federal tax with and without the limitation, NOLs included.
7. **Gavelstone**: the partnership's own test and Draxmoor's 30 percent share (excess business interest expense, excess taxable income, basis).
8. **Capitalization**: 2026 and 2027, 263A(f) interest outside the limitation and 266 interest inside it.
9. **Sensitivities**: the recorded results of three reruns, each the base plus one declared change.
10. **Small business**: the gross receipts test of a separate scenario (Tolmarch and Wickerby).
11. **Real property election**: a separate scenario (Oxtenby), with and without the election, in present value.
12. **Form 8990**: lines 1, 2, 22, 30 and 31 for 2024 and 2025, each a link; lines 2 and 31 read the carryforward left in the vintage schedule, and the Controls tab tests line 31 against line 1 plus line 2 less line 30, so one of lines 1, 2, 30 and 31 keyed from the wrong period, or a vintage used twice, shows a residual (line 22 does not enter that test).
13. **Controls**: every residual must read 0; cell B2 of every tab shows the number of failing checks.

## How to use it

Change one input at a time on Inputs, read ATI, the limitation and the carryforward again, and look at B2 before reading any figure. To rerun a sensitivity, set its switch on Inputs, read the case, then set the switch back to 0.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel, LibreOffice or Google Sheets).

Rules are described as read in November 2026. This is education, not tax advice: the facts of your own company govern, and its tax advisers decide what applies to it.
