Adjusted taxable income under the rule of each year, the 30 percent cap, interest deducted and carried forward, federal tax with and without the limitation, two sensitivities and the small business test, for six years.
A company with $120,000,000 of floating-rate debt at 10.50 percent pays $12,600,000 of interest in 2024. Under the after-depreciation rule of that year, its adjusted taxable income is $26,000,000 and its limitation $8,000,000: $4,600,000 of interest waits. In 2025 depreciation is added back, ATI reaches $43,000,000, and the carryforward starts to come back; by the end of 2027 it is gone. The calculator lays the chain out year by year, ready for your own figures.
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_163j_Interest_Limitation_Calculator.xlsx (15 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.
This calculator is a simplified version of the companion workbook of The Section 163(j) Handbook, which follows one group through a leveraged buyout, two short taxable years, the 2025 law and the 2026 changes: an interest registry, ATI under three regimes, two vintages of carryforward, a partnership, a foreign subsidiary, capitalized interest, Form 8990 and the tax paid with and without the limitation.
Six tabs. Inputs are blue on a pale fill; everything else is a formula; the Checks tab counts the failures, and every other tab shows that count at the top.
| Measure | Value |
|---|---|
| 2024 (ATI after depreciation): ATI | $26,000,000 |
| 2024 limitation ($200,000 + 30 percent of ATI) | $8,000,000 |
| 2024 business interest expense | $12,600,000 |
| 2024 disallowed and carried forward | $4,600,000 |
| 2024 federal tax with and without the limitation | $3,822,000 / $2,856,000 |
| 2025 (depreciation added back): ATI | $43,000,000 |
| 2025 limitation | $13,100,000 |
| 2025 carryforward used | $1,100,000 |
| 2026 (CFC inclusion excluded): ATI | $44,000,000 |
| Carryforward at the end of 2026 | $1,500,000 |
| Carryforward at the end of 2027 | $0 |
| Sensitivity, rate +100 basis points: carryforward at the end of 2025 | $5,900,000 |
| Sensitivity, EBITDA -15 percent: carryforward at the end of 2029 | $450,000 |
| Gross receipts test for 2026: average against $32,000,000 | $190,000,000, not exempt |
The example company is fictional and every input is a teaching assumption, not a market figure. The calculator is separate from the book's case: read its figures against each other, not against the book's company.
Rules described as read in November 2026 (26 U.S.C. 163(j) as amended by P.L. 119-21, 448(c), Treas. Reg. 1.163(j)-1, -2 and -5, Rev. Proc. 2025-32). Education only, not tax advice: the facts of your own company govern, and its tax advisers decide.
For six taxable years it builds adjusted taxable income under the regime of the year in which each taxable year begins, computes the limitation (business interest income + 30 percent of ATI, not less than zero, + floor plan financing interest), deducts the current year's interest first and then the carryforward, carries the rest, and computes federal tax at 21 percent with and without the limitation. It also runs a rate sensitivity, an EBITDA sensitivity and the small business gross receipts test.
As read in November 2026: ATI after depreciation for taxable years beginning in 2022 to 2024, depreciation added back again from 2025 (P.L. 119-21, section 70303), CFC inclusions under sections 951(a), 951A(a) and 78 excluded from 2026 (section 70342), and the 2026 gross receipts threshold of $32,000,000 (Rev. Proc. 2025-32).
NOLs, partnerships and their excess taxable income, consolidated groups and intercompany interest, interest capitalization, short taxable years, the real property and farming elections, section 382, state rules and the sale adjustment. The book's full workbook covers most of them on one case.
No. It is built for a first pass and for learning the mechanics. Form 8990 needs the company's own records, and its conclusions belong to the company's tax advisers.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The free workbook of The Section 163(j) Handbook goes further: an interest registry with one class per line, a consolidated group with intercompany interest eliminated, NOLs after the interest deduction, carryforwards by vintage, a partnership's excess business interest expense and excess taxable income, interest capitalization from 2026, Form 8990 and switches to rerun the case.