# The Passive Activity Loss Handbook: companion files

Julian R. Sterling, julianrsterling.com/passive-activity-loss

## What is here

- **Passive_Activity_Loss_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Bertil and Saskia Morlaine, a married couple filing jointly for 2026, with a duplex, a single-family house, a townhouse sold during the year, a lake cabin rented for short stays, a building leased to the S corporation Bertil owns, and a limited partner interest in an apartment syndication. Every amount and hour count is a teaching assumption, never a market figure.

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

1. **Inputs**: one row per activity, with its class, its 2026 result, its gross rents, the loss carried from 2025 and the couple's interest; the K-1 lines as reported.
2. **Hours**: every hour once, by person, by activity and by kind of work (real estate, employee, investor), with its source.
3. **Tests**: the class of each activity first, then the material participation test relied on, named in a cell.
4. **Status**: the real estate professional test, one spouse at a time, with an edge block that moves one input to each threshold.
5. **Limits**: the K-1 loss through the basis step and the at-risk step, before any passive column.
6. **Form 8582**: MAGI term by term, the special allowance (Part II) and the parts of the form.
7. **Allocation**: the unallowed loss spread over the activities still in loss, largest remainder, activity by activity.
8. **Readings**: the same facts read three ways (status not established, status without the election, status with the election), the townhouse sale, AGI and taxable income.
9. **Sensitivities**: the base plus one declared change per line.
10. **Controls**: the conventions and the ties between tabs; every line must read zero.

## How to use it

Change one input at a time on Inputs or Hours, read the allowance, the losses allowed and the losses carried 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.
