The participation tests, the real estate professional test, the $25,000 allowance after its phase-out, Form 8582 netting, and the losses allowed and carried activity by activity, for one return with up to six activities.
A couple filing jointly earns $104,000 of wages and holds six activities: four long-term rentals, a cabin rented for short stays and a limited partner interest. The real estate professional test fails, the cabin is a business they materially participate in, and the sale of one rental gives a nonpassive overall loss of $2,300. MAGI is $100,700, so the allowance after the phase-out is $24,650, and the special allowance on line 9 is $20,700. 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.
Passive_Activity_Loss_Calculator.xlsx (17 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 Passive Activity Loss Handbook, which follows one couple and six activities through a full tax year: grouping and classification, the seven tests on a logged year of hours, a real estate professional status won by 75 hours, the aggregation election, a self-rental, a K-1 loss through basis, at-risk, passive and excess business loss limits, Form 8582 in full and three readings of the same return.
Four tabs. Inputs are in blue; everything else is a formula; the Checks tab counts the failures. Unused activity rows stay empty and change nothing.
| Measure | Value |
|---|---|
| Real estate professional test | Failed: 610 hours, not more than 750, not more than one-half of 2,410 hours |
| Short-stay cabin | 104 days / 20 rentals = 5.2 days: not a rental; 130 hours against 90, test 3: nonpassive |
| Rental 3, sold in full to an unrelated buyer | Overall loss $2,300, nonpassive |
| Modified adjusted gross income | $100,700 |
| Form 8582, line 3 (net passive loss) | -$27,700 |
| Form 8582, line 4 | $20,700 |
| Form 8582, line 8 (allowance after phase-out) | $24,650 |
| Form 8582, line 9 (special allowance) | $20,700 |
| Carried to next year: rental 1 / limited partner interest / rental 6 | $1,947 / $4,667 / $386 |
| Control block | Every check at 0 |
The example return is fictional and every input is a teaching assumption: a joint return with wages of $104,000 and other income of $3,000; rental 1 with a loss of $14,200, $6,000 carried in and 210 hours; rental 2 with income of $3,500 and 60 hours against a paid manager's 90; rental 3, sold in full to an unrelated buyer, with income of $2,200, a gain of $4,500 and $9,000 carried in; a limited partner interest with a loss of $5,000 and $2,000 carried in; a short-stay cabin rented 104 days in 20 rentals with a loss of $4,000; rental 6 with a loss of $2,600, $1,400 carried in and 20 hours; and 610 hours of real estate work against 1,800 hours of other work. 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. 469, Treas. Reg. 1.469-1T, 1.469-5T and 1.469-9, and the IRS Instructions for Form 8582 (2025)). Education only, not tax advice: the facts of your own return govern, and your tax adviser decides.
For one return and up to six activities, it classifies each activity, runs the material participation tests that can be computed from hours, runs the real estate professional test, builds MAGI, computes the special allowance after the phase-out, nets passive income and losses as Form 8582 does, allocates the allowed and unallowed losses activity by activity, releases the carried losses of an activity sold in full, and gives the losses carried to the next year.
As read in November 2026: section 469 with the $25,000 allowance reduced by 50 percent of MAGI above $100,000, the 750-hour and more-than-one-half conditions of section 469(c)(7), the tests of Treas. Reg. 1.469-5T that can be read from hours, the 7-day average stay that takes a short-stay rental out of rental activity, section 469(g) for a sale of an entire interest, and the parts of Form 8582 described in the IRS instructions.
Grouping and the aggregation election, the facts and circumstances test, prior-year tests, self-rentals and other recharacterizations, basis, at-risk and excess business loss limits, credits, separate returns 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 its own file of hours, 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 Passive Activity Loss Handbook goes further: hours by person and kind of work, the status tested as one real property trade or business and property by property, the aggregation election, a self-rental, a K-1 loss through basis and at-risk, Form 8582 in full for three readings of the same return, and sensitivities.