Foreign income placed in its category, the standard deduction apportioned by gross income, the section 904(a) limitation of each category, the credit, and carryovers used oldest first with their last year.
A married couple earns foreign wages taxed heavily abroad, a little foreign investment income taxed lightly, and some United States interest and dividends. Their $8,432 of tax splits into a general limitation of $6,153, far below the $16,400 of tax on the wages, and a passive limitation of $825, above the $610 withheld, so the passive room absorbs $215 of an old carryover. The total credit is $6,978. The calculator lays the chain out for one return, 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.
Foreign_Tax_Credit_Calculator.xlsx (18 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 Foreign Tax Credit Handbook, which follows one couple through a full return: every foreign tax tested and translated at the rate of its day, incomes sourced and placed in their categories, a high-taxed rent moved to the general category, a Schedule K-3, the qualified dividends adjustment, two limitations, carryovers before and after the year, and four scenarios beside it.
Inputs are in blue; everything else is a formula; the checks count the failures. Unused rows stay empty and change nothing.
| Measure | Value |
|---|---|
| Taxable income (gross income less the standard deduction) | $88,400 |
| Tax before credits (qualified dividends at 0 percent) | $8,432 |
| Foreign qualified dividends under $20,000 | No adjustment entered (exception assumed met) |
| General category: limitation / foreign tax | $6,153 / $16,400 |
| General category: credit / excess carried back or forward | $6,153 / $10,247 |
| Passive category: limitation / foreign tax of the year | $825 / $610 |
| Passive category: credit, of which from the 2019 carryover | $825, of which $215 |
| 2019 carryover left, last usable year 2029 | $425 |
| Total credit | $6,978 |
| Control block | Every check at 0 |
The example couple is fictional and every input is a teaching assumption: a joint return with foreign wages of $88,000 (general category, foreign tax $16,400), foreign qualified dividends of $7,900 and foreign interest of $3,900 (passive category, foreign tax $610), United States interest of $14,700 and qualified dividends of $6,100, the $32,200 standard deduction, and a passive carryover of $640 from 2019. Every check of the control block reads 0. The calculator is separate from the book's case: read its figures against each other, not against the book's couple.
Rules described as read in November 2026 (26 U.S.C. 904 as applied by the IRS Instructions for Form 1116 (2025) and IRS Publication 514 (2025), and the 2026 joint rate schedule of Rev. Proc. 2025-32). Education only, not tax advice: the facts of your own return govern, and your tax adviser decides.
For one individual return, it takes incomes by category and by source, the foreign taxes of each category, the United States tax before credits and the carryovers by year of origin, apportions the deduction by gross income, and returns the foreign source taxable income, the limitation and the credit of each category, the excess carried and its last usable year.
As read in November 2026: the section 904(a) fraction computed separately for the passive and general categories, the apportionment of the standard deduction by gross income as in the Instructions for Form 1116 (2025), the qualified dividends adjustment with the factor 0.4054 when foreign qualified dividends reach $20,000, and carryovers used oldest first within their category for ten years.
The calculator then records, as a declared assumption, that the adjustment exception is met. For 2025 returns the exception also has a taxable income test; check it, and the 2026 figures, in the instructions for the year.
The creditability tests, the year a tax counts, translation into dollars, the high-taxed income kickout, losses and their recapture, Schedule K-3 detail, treaties, the alternative minimum tax and state rules. 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. The return needs its own figures and documents, and the conclusions belong to your tax adviser.
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 Foreign Tax Credit Handbook goes further: a registry of every foreign tax with its date and rate of exchange, the creditability tests, the high-taxed income test item by item, a Schedule K-3, the qualified dividends adjustment on both sides of the fraction, carrybacks on an amended return, and the deduction, de minimis and exclusion scenarios.