# The Foreign Tax Credit Handbook: companion files

Julian R. Sterling, julianrsterling.com/foreign-tax-credit

## What is here

- **FTC_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Adrian and Selma Arvenford, United States citizens filing jointly for 2026 from an invented host country, with a salary, a design practice, host country dividends and interest, a let apartment and a partnership stake reported on Schedule K-3. Four scenarios sit apart: the deduction of the foreign taxes, a de minimis election, the next year and the foreign earned income exclusion. Every amount, rate of exchange and host country tax is a teaching assumption, never a market figure.

## The thirteen tabs, in the order the calculation runs

1. **Inputs**: every case fact typed once: incomes in marks and dollars, payment dates, holding periods and the carryovers brought in.
2. **Exchange**: the average rate for income and the rate of the day for each tax payment, kept on separate rows.
3. **Incomes**: gross income by source and by category, and adjusted gross income.
4. **Taxes**: the registry of foreign taxes and the creditable amount of each category.
5. **Allocation**: directly related expenses and the apportionment of the standard deduction (lines 3a, 3d, 3e and 3f).
6. **Tax**: the United States tax before credits, at the joint rates and the qualified dividend rates.
7. **Adjustment**: the qualified dividends adjustment, in the numerator and in the denominator.
8. **Limitation**: the limitation fraction of each category and the limitation it gives (lines 15 and 18).
9. **Credit**: the taxes credited, the excess or the excess limitation of each category.
10. **Carryovers**: a Schedule B (Form 1116) kept by year of origin: carryback, carryforward and expiry.
11. **Scenarios**: the deduction, the de minimis election, the next year and the foreign earned income exclusion, apart from the case.
12. **Sensitivities**: one input changed at a time, with its effect on the credit.
13. **Controls**: differences that must read zero before any figure is used.

## How to use it

Change one input at a time on Inputs, read the limitation and the credit of each category again, and look at Controls before reading any figure. File nothing while the Controls count is above zero.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel or LibreOffice).

Rules are described as read in November 2026. This is education, not tax advice: the facts of your own return govern, and your own tax adviser decides what applies to it.
