Free Excel templates

A free passive activity loss calculator in Excel

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.

Get the calculator

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.

The book behind this calculator

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.

Paperback PDF edition, $19.99

What is in the file

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.

1. Start here
What the calculator does, the rules it applies with the date they were read, what it leaves out, and a note that every example figure is a teaching assumption, not a market figure.
2. Inputs
Filing status; wages and other income; for up to six activities: rental or business, the year's income or loss, any gain on a sale, the loss carried in, the hours of the taxpayer and the spouse and of the most active other individual, days rented and number of rentals for a short-stay property, active participation, and a flag for a sale of the entire interest to an unrelated buyer; the taxpayer's real estate hours and total working hours.
3. Calculator
The class of each activity, the material participation tests that hours can answer, the real estate professional test, MAGI, Part I and Part II of Form 8582, the allowance allocated to the rentals in loss, the unallowed loss spread over the activities still in loss, the losses allowed and carried activity by activity, and the losses released by a sale.
4. Checks
The controls of the calculator, each showing a gap that must read 0, and a count of the failures.

What the worked example returns

MeasureValue
Real estate professional testFailed: 610 hours, not more than 750, not more than one-half of 2,410 hours
Short-stay cabin104 days / 20 rentals = 5.2 days: not a rental; 130 hours against 90, test 3: nonpassive
Rental 3, sold in full to an unrelated buyerOverall 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 blockEvery 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.

How to use it on your own return

  1. List the activities as they are grouped on the return; one row per activity, and the same name every year.
  2. Enter each activity's result for the year and the loss carried in from last year's Form 8582, activity by activity.
  3. Enter hours from a log or calendar, by person; leave out time spent as an investor reading reports.
  4. Flag a sale only if it is the entire interest, fully taxable, to an unrelated buyer.
  5. Read the Checks tab before any figure: a count above zero means a cell to fix.

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.

Questions people ask

What does the passive activity loss calculator do?

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.

Which rules does it apply?

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.

What does it leave out?

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.

Can I rely on it to file Form 8582?

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.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

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.

See the book and its free files →

Related reading