An unlocked five-tab Excel workbook for the $1 billion applicable corporation test, the bridge from AFS net income to adjusted financial statement income, the CAMT foreign tax credit and the CAMT payable.
Enter three years of AFSI, your consolidated AFS net income and the main section 56A adjustments, your CFC taxes and your regular tax. In the prefilled 2026 case (Corvane Industries, Inc., USD millions), average AFSI of $1,030.00 million meets the test, AFSI is $1,151.00 million, tentative minimum tax is $121.65 million after a $51.00 million CAMT foreign tax credit, and the CAMT payable over regular tax of $91.41 million is $30.24 million.
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.
CAMT_AFSI_Calculator.xlsx (9 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.
This template is a standalone extract of the 11-tab workbook in The Corporate Alternative Minimum Tax Handbook, which follows one group from its first applicable year through two years of CAMT and the first year of recovery: partnership and CFC adjustments, the CAMT foreign tax credit carryforward, the minimum tax credit and the general business credit, Form 4626, estimated taxes, sensitivities and ASC 740.
| Measure | Value |
|---|---|
| Average annual AFSI, 2022 to 2024 | $1,030.00 million |
| Meets the $1 billion test? | Yes |
| AFSI (2026, no FSNOL) | $1,151.00 million |
| 15 percent of AFSI | $172.65 million |
| CFC credit (lesser of $84.80 million or 15 percent of $300.00 million) | $45.00 million |
| CAMT foreign tax credit (with $6.00 million own foreign taxes) | $51.00 million |
| Tentative minimum tax | $121.65 million |
| Regular tax after the section 27 foreign tax credit | $91.41 million |
| CAMT payable | $30.24 million |
| Minimum tax credit created (section 53) | $30.24 million |
| Checks total | 0 |
The prefilled figures are the book's 2026 case for Corvane Industries, Inc., a fictional US-parented group. Its two CFCs earn pre-tax income of $260.00 million and $40.00 million, so the section 56A(c)(3) amount is $300.00 million and the CFC credit is capped at $45.00 million, leaving $39.80 million of CFC taxes to carry forward for five years. Regular tax of $91.41 million sits below TMT because the regular tax base carries deductions that AFSI does not, such as the FDDEI deduction and percentage depletion. For the full line-by-line explanation read how to calculate AFSI for the CAMT; for the three-year test, the CAMT applicable corporation test.
Rules described as read in November 2026 (IRC sections 55, 56A, 59(k) and 59(l), the proposed regulations published on September 13, 2024, Notices 2025-27 and 2026-7, and Public Law 119-21 section 70523). Education only, not tax or legal advice.
It averages three years of AFSI computed without the FSNOL deduction and compares the average with the $1 billion threshold of section 59(k)(1)(B)(i). It also flags whether the average sits below the $800 million interim simplified threshold of Notice 2025-27, with a reminder that simplified AFSI uses a narrower set of adjustments and must be computed separately.
The CFC credit is the lesser of the pro rata CFC foreign income taxes entered and 15 percent of the section 56A(c)(3) adjustment, which is a pre-tax amount because the CFCs' foreign income taxes are disregarded. The domestic group's own foreign income taxes are added on top. In the prefilled case the CFC taxes of $84.80 million are capped at $45.00 million.
Yes. Enter any FSNOL carryover and the AFSI_Bridge tab deducts the lesser of the carryover and 80 percent of AFSI before the deduction, as section 56A(d) provides. The prefilled case has no FSNOL.
No. Blue cells are editable inputs, black cells are live Excel formulas with no circular references, and the Checks tab total must read 0 before a figure leaves the spreadsheet.