Free Excel Templates

CAMT Applicability and AFSI Calculator (Excel)

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.

Get the Excel calculator

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.

The handbook behind this calculator

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.

Paperback PDF edition, $19.99 Book page and full workbook

What is inside the workbook

1. Start
What the calculator does, the colour convention (blue inputs, black formulas) and a one-line guide to each tab. Prefilled with the book's fictional 2026 case in USD millions.
2. Applicability_Test
AFSI for 2022, 2023 and 2024 computed without the FSNOL deduction, the three-year average, the $1 billion threshold of section 59(k)(1)(B), and a flag against the $800 million Notice 2025-27 simplified threshold.
3. AFSI_Bridge
Sixteen lines from consolidated AFS net income to AFSI before FSNOL: federal and own foreign taxes added back, CFC and equity-method income removed, tax depreciation and IDC substituted for book amounts, pensions, the Notice 2026-7 research relief, the partnership distributive share, dividends and the pro rata CFC amount. Then the FSNOL deduction capped at 80 percent and AFSI.
4. CAMT_Liability
15 percent of AFSI, the CFC credit as the lesser of the CFC taxes and 15 percent of the section 56A(c)(3) adjustment, the domestic group's own foreign taxes, tentative minimum tax, regular tax after the section 27 credit (plus BEAT, if any), CAMT payable and the minimum tax credit created.
5. Checks
Three tests (a positive FSNOL deduction against negative AFSI, a CFC adjustment larger than AFSI before FSNOL, fewer than three years of AFSI) whose total must read 0.

What the prefilled example returns

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

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.

Questions corporate tax teams ask

What does the calculator test for applicability?

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.

How is the CAMT foreign tax credit on CFC taxes computed?

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.

Does it apply the FSNOL deduction?

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.

Are any cells locked or macros required?

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.