# The PFIC Handbook: companion files

Julian R. Sterling, julianrsterling.com/pfic

## What is here

- **PFIC_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Leander and Annelise Ellingrove, a married couple of United States citizens filing jointly for 2026, with four foreign holdings: Linnhaven (a distributing fund, default regime, four lots, the first lot sold on December 31, 2026), Corriemont (a QEF election from the first year), Selvane (listed shares, mark-to-market election from 2023) and Kettlemere (a holding company reached through Quillary, a foreign operating company the couple owns at 60 percent). Every amount, price, date and rate is a teaching assumption, never a market figure.

## The fourteen tabs, in the order to read them

1. **Inputs**: every typed value: lots, prices, distributions, statements, company figures, rates.
2. **Lots**: one row per lot: purchase date, shares, price, basis, sale.
3. **Tests**: the income test and the asset test for each company and year, with look-through.
4. **Holders**: direct and indirect ownership, and the chain from the couple to Kettlemere.
5. **Distributions**: distributions by lot, the 125 percent test, excess and nonexcess parts.
6. **Allocation**: each excess distribution and each gain spread by day over the holding period.
7. **Interest**: deferred tax at the highest rate of each prior year, interest to the due date.
8. **QEF**: Corriemont's inclusions, amounts already included, distributions and basis.
9. **Mark-to-Market**: Selvane's yearly mark, allowed and disallowed loss, unreversed inclusions.
10. **Comparison**: Linnhaven under the three regimes, year by year.
11. **Purge**: the purge scenario, kept apart from the case.
12. **Filing**: the lines of Form 8621, one form per PFIC.
13. **Sensitivities**: the base, then one declared change at a time.
14. **Controls**: checks that parts add up to their totals and that the tabs agree; every line must read zero.

## How to use it

Change one input at a time on Inputs, read the excess distribution, the deferred tax and the interest 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.
