Free Excel templates

A free section 163(j) interest limitation calculator in Excel

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.

Get the calculator

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.

The book behind this calculator

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.

Paperback PDF edition, $19.99

What is in the file

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.

1. Start here
What the calculator does, the rules it applies with their dates and sources, and what it leaves out.
2. Inputs
For six taxable years: the year in which each begins, EBITDA, depreciation, debt and rate, interest received, CFC inclusions and floor plan financing interest; the opening carryforward and the tax rate; three years of gross receipts, the threshold and the tax shelter question.
3. Calculator
The regime of each year, ATI, business interest expense, the limitation, interest allowed, carryforward used, disallowed and carried, taxable income and federal tax with and without the limitation.
4. Sensitivities
The same chain rerun with the rate 100 basis points higher, then with EBITDA 15 percent lower, one change at a time.
5. Small business test
The average of the three years against the threshold of the tested year, the tax shelter question, and whether the limitation applies.
6. Checks
Allowed plus disallowed equal to the interest, the carryforward roll-forward, deductions within the limitation, the bridge between taxable income with and without it, ATI recomputed by regime, and cells in error.

What the worked example returns

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

How to use it on your own company

  1. Run the gross receipts test first: enter the three years before the tested year for every company treated as one with yours, and the threshold of the tested year with its revenue procedure.
  2. Enter, for each taxable year, the year in which it begins: that year sets the ATI regime.
  3. Enter EBITDA on a tax basis, depreciation, the debt and the rate, interest received and any CFC inclusions; enter any carryforward from earlier years.
  4. Read the Checks tab before any figure: a count above zero means a cell to fix.

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.

Questions people ask

What does the section 163(j) calculator do?

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.

Which rules does it apply?

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

What does it leave out?

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.

Can I rely on it for a filing?

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.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

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.

See the book and its free files →

Related reading