# The Section 199A Handbook: companion files

Julian R. Sterling, julianrsterling.com/section-199a

## What is here

- **Section_199A_Workbook.xlsx**: the workbook of the book's case (appendix A): the household from 2024 to 2030, the salary and aggregation scenarios and the business income sensitivity. The case is fictional: the Tessendine household, its S corporation, a sole proprietorship in actuarial science, a limited partner interest in a rental partnership, REIT dividends and PTP income, followed from 2024 to 2030. Every amount is a teaching assumption, never a market figure.

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

1. **Start here**: the order of the tabs and the conventions of the case, in words.
2. **Inputs**: every choice of the case, typed once (blue cells), with the dated rules: thresholds and ranges of 2024 to 2026, the 2026 minimum deduction, the joint rate tables of 2024 to 2026, and the indexation assumption used for 2027 to 2030.
3. **Activities**: each source of income, whether it is a specified service trade or business, and the passive activity convention.
4. **Elements**: the registry of income items, one class per row, reaching taxable income before the deduction, then the totals by class and the registry residue.
5. **Factors and property**: the end of each asset's depreciable period, the years it counts, and the W-2 wages and UBIA of each business.
6. **Suspended losses**: Ambreth's section 469 loss, the part freed each year, the amount allowed into taxable income, Ambreth's own QBI, and the freed loss that Year by year nets as negative QBI of a separate trade or business.
7. **Year by year**: one column per year, the seven steps of the calculation down to the deduction and its federal income tax effect.
8. **Form 8995**: the household's 2024 form, line by line.
9. **Carryforward**: the qualified business loss carryforward, opening, generated, used and closing.
10. **Scenarios**: the salary scenario and the aggregation scenario of 2027, separate from the case.
11. **Sensitivities**: the case rerun with business income plus 10 percent.
12. **Controls**: the registry residue and the carryforward residue of every year; the failure count must read 0.

## How to use it

Change one input at a time on Inputs, then read Controls before any other figure. The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel, LibreOffice or Google Sheets).

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