House Flipping Dealer Status Tax Calculator: Price the Flip on After Tax Dollars

Two investors buy the same three bedroom ranch, spend the same $52,000 on the rehab, sell it seven months later for $349,000, and both book exactly $60,000 of profit. One keeps $35,351. The other keeps $45,720. Nothing about the construction was different. The difference is a tax classification decided the day they bought, and a house flipping dealer status tax calculator in Excel is the only way to see it before you sign the purchase agreement.

The IRS does not have a checkbox for this. Dealer status falls out of Section 1221(a)(1), which defines a capital asset as anything you own except, among other things, property held primarily for sale to customers in the ordinary course of a trade or business. If your flip is inventory, the profit is ordinary income and it carries self employment tax. If it is a capital asset held more than twelve months, it is a long term capital gain. Same house, same profit, two tax bills about $10,000 apart.

Most articles stop there and tell you to hold for a year. This one shows why that advice loses money in every bracket once you charge yourself for the carry.

Dealer status is not a holding period test

The most expensive misconception in flipping is that twelve months and a day buys you long term capital gains treatment. It does not. Holding period only matters if the property is a capital asset to begin with. If you are a dealer as to that property, the gain is ordinary at month seven and it is still ordinary at month twenty six.

Courts decide it on facts. The standard factor list comes from United States v. Winthrop, a 1969 Fifth Circuit case, and the factor that carries the most weight, per Biedenharn Realty in 1976, is the frequency and substantiality of your sales. Four closings in a calendar year is not a hobby. It is a trade or business, and the file you built to get the loan says so in your own handwriting: an offer worksheet with an ARV, a scope of work, and a target exit date.

Three consequences follow, and only the first one gets discussed:

• The profit is ordinary income, taxed at your marginal rate instead of 0, 15, or 20 percent.
• It is self employment income, so it carries 15.3 percent up to the Social Security wage base and 2.9 percent above it.
• Dealer property is excluded from Section 1031, and dealer dispositions are excluded from the installment method under Section 453(b)(2)(A).

There is a fourth consequence that cuts the other way, and almost nobody models it: a dealer's losses are ordinary losses, and an ordinary loss is worth several times what a capital loss is worth. That gets its own section below.

One thing dealer income does not carry is the 3.8 percent net investment income tax. Income from a trade or business you materially participate in is not net investment income. You pay self employment tax or you pay NIIT, not both. That single fact narrows the gap more than most spreadsheets show, and leaving it out is the fastest way to build a model that overstates the penalty.

Build the after tax profit sheet

The model has four blocks: the deal, your tax profile, the dealer path, and the investor path. Everything downstream reads from the first two, so you change one input and both tax bills move.

Selling costs come off the sale price, not off a guess. Put =B4*B8 in B9 and you get $24,430 at 7 percent, which covers a 6 percent commission plus title, transfer tax, and the concession you will end up giving at inspection. Net profit before tax in B10 is =B4-B5-B6-B7-B9, which lands on $60,000.

Cell B18 is an input, not a constant. The wage base indexes every year, and hard coding last year's figure is how a model drifts without telling you. Cell B19 matters if you or a spouse already draws a salary: the 12.4 percent Social Security piece stops once the combined total crosses the base, so a flipper with a $150,000 day job pays materially less self employment tax on the same flip than one without.

The dealer path

Self employment income is not the whole profit. Start with =B10*0.9235 in B23, which gives $55,410 on a $60,000 flip. The 92.35 percent factor exists because the employer half of the tax is not itself taxed.

Split the two halves of the tax, because they cap differently. Put the remaining Social Security room in B24 with =MAX(0,B18-B19), then the Social Security piece in B25 with =MIN(B23,B24)*0.124, which is $6,871 here.

Medicare has no cap. B26 is =B23*0.029 for $1,607, and total self employment tax in B27 is =B25+B26, or $8,478.

Half of that is deductible above the line, so B28 holds =B27*0.5 for $4,239. That deduction is the reason the ordinary income base is never the same as the profit.

If the Section 199A deduction is available, B29 carries the qualified business income base and B30 takes twenty percent of it with =B29*0.2. Leave B20 at zero for the base case. At real flip volume the deduction is frequently limited, and the model that assumes it is the model that surprises you in April.

Ordinary taxable amount in B31 is =B10-B28-B30, and federal income tax in B32 is =B31*B13, or $13,383 at 24 percent with the QBI switch off.

State tax runs on a different base, because Section 199A is a below the line deduction that does not reduce adjusted gross income. B33 is =B10-B28 and B34 is =B33*B17, or $2,788 at 5 percent.

Total dealer tax in B35 is =B27+B32+B34, which is $24,649. After tax profit in B36 is =B10-B35, or $35,351.

The investor path

This side is shorter. B39 holds the holding period in months, B40 tests it with =IF(B39>12,1,0), and B41 picks the rate with =IF(B40=1,B14,B13). Federal tax on the gain in B42 is =B10*B41, or $9,000 at the long term rate.

NIIT applies on this side, because a passive investor is not materially participating in a trade or business. B43 carries the gain subject to the surtax and B44 is =B43*B16, or $2,280.

State tax in B45 is =B10*B17 for $3,000. Total investor tax in B46 is =B42+B44+B45 at $14,280, and after tax profit in B47 is =B10-B46, or $45,720.

The number you actually care about lives in one cell: =B47-B36. On this deal, at this bracket, dealer status costs $10,369.

The same $60,000, taxed two ways

Run the model across brackets with the state rate held at 5 percent, the QBI switch off, and the investor holding thirteen months.

Two things in that table matter more than the headline. First, the gap stops widening at the top, because the long term rate steps up to 20 percent once taxable income clears roughly $600,000 for a joint filer. The 37 percent row is a smaller penalty than the 35 percent row.

Second, and this is what should change your underwriting: if you flip in under twelve months, there is no rate difference at all. Short term capital gains are taxed at ordinary rates. An investor who sells at month seven pays the same 24 percent the dealer pays. The entire cost of dealer status on a fast flip is the $8,478 of self employment tax. The $10,369 headline exists only because the investor column assumes a thirteen month hold.

Which raises the obvious question. The obvious answer is wrong.

The hold it longer trap

Holding costs on this deal were $14,570 over seven months. Let the sheet derive the monthly carry in B51 with =B7/B11, which is $2,081, and the extra months in B50 with =B39-B11, which is six.

Extra carry in B52 is =B50*B51, or $12,489. That is the cash price of converting a seven month flip into a thirteen month hold, and every dollar of it is hard cost: interest, property tax, insurance, utilities, and the lawn.

The last column decides it. You do not get the tax saving by holding longer. You get it by holding longer and then winning the dealer status argument, and a taxpayer with four closings in the same calendar year does not win that argument. Put your honest odds in B55, compute the weighted saving in B56 with =B53*B55, and net the carry in B57 with =B56-B52. Every bracket goes negative.

That table is generous, too. It charges nothing for six more months of market exposure on a $349,000 asset, nothing for the $80,000 of equity you cannot redeploy into the next purchase, and nothing for the fact that a kitchen finished in March photographs worse in September. Price those in and the strategy is not close.

Score the deal before you write the offer

Since you cannot fix the classification after the fact, price it in at acquisition. Build a seven row scoring block, zero to three per factor, with the frequency row counted twice because that is how the courts weight it.

Total the block in B70 with =SUM(B62:B68)+B62, which double counts frequency and gives 21 out of a possible 24 here. Flag it in B71 with =IF(B70>=12,"DEALER","INVESTOR ARGUABLE").

A score of 21 does not mean you did anything wrong. It means you should stop modeling this deal at long term capital gains rates, because you are going to pay ordinary rates plus self employment tax, and the offer you write should say so. Underwriting this house at investor rates overstates your take home by $10,369, which is most of a rehab contingency.

Three moves that actually change the number

Holding longer is not a lever. These three are.

Pay yourself a salary through an S corporation

A sole proprietor or single member LLC pays self employment tax on 92.35 percent of everything. An S corporation pays payroll tax only on reasonable compensation, and distributions above that amount are not subject to it. On this single flip, $30,000 of reasonable W-2 compensation carries $4,590 of combined FICA against $8,478 of self employment tax, a $3,888 difference. Subtract roughly $1,700 for a payroll service and the extra 1120-S return and you net about $2,188.

The lever gets much better with volume and then flattens. At $240,000 of annual net profit, self employment tax runs $28,264, while $90,000 of reasonable compensation costs $13,770 of FICA, a $14,494 spread that clears the compliance cost easily. Above roughly $180,000 of profit the 12.4 percent Social Security piece is already capped, so the only remaining benefit is the 2.9 percent Medicare piece and the curve goes flat. The S election earns its keep in the middle, call it $80,000 to $180,000 of net profit a year.

Treat the ordinary loss as an asset

Dealer status is a put option on your bad flips, and no underwriting model prices it. Compare a $38,000 loss under both treatments at a combined 29 percent federal and state rate.

If one flip in five goes wrong, that $10,150 of accelerated benefit is a real offset against the ordinary income cost on the four that worked. It does not close the gap, but it is worth roughly a fifth of it, and it belongs in the model instead of in the footnotes.

Keep the flips away from the rentals

This is the expensive one. Section 1031 excludes real property held primarily for sale. If flips and a long term rental sit inside the same entity and you are a dealer, the argument that the rental is also dealer property is available to an examiner. A dead 1031 is not a rate difference. It is an entire deferral.

On a rental with $180,000 of gain, $60,000 of which is unrecaptured Section 1250 depreciation, the bill runs about $15,000 at 25 percent on the recapture, $18,000 at 15 percent on the rest, $6,840 of NIIT, and $9,000 of state tax. Call it $48,840 that a working exchange would have deferred. That is nearly five flips worth of the dealer penalty, triggered by an entity decision that costs a few hundred dollars to get right at formation.

The estimated tax that arrives before the next closing

Ordinary income with self employment tax attached is due quarterly, and a flip that closes in April creates a June 15 obligation. On this deal that is $24,649 of federal and state tax, chasing a wire that already went out the door as the down payment on the next house.

The underpayment penalty is the federal short term rate plus three points, which has run 7 to 8 percent in recent years. Miss $18,000 of federal tax for nine months at 8 percent and you paid $1,080 for the privilege of not modeling it.

Build the safe harbor test into the same sheet. Prior year total tax goes in B80 and prior year AGI in B82. The multiplier in B81 is =IF(B82>150000,1.1,1), the prior year safe harbor in B83 is =B80*B81, and the quarterly payment is =B83/4.

The current year test in B85 is =B35*0.9, and what you have to pay in to stay penalty free is =MIN(B83,B85).

With $31,000 of prior year tax and $205,000 of prior year AGI, the prior year harbor is $34,100 and the current year test is $22,184, so the current year number governs. That is the practical rule for lumpy income: recompute the 90 percent test after every closing rather than wiring a fixed quarter of last year's tax into a year that may look nothing like it.

One caveat worth stating plainly. Dealer status is decided on facts and circumstances, the figures above are federal rules layered with a flat 5 percent state rate for illustration, and the entity and compensation decisions here are the ones your CPA signs off on before you file. This model is for pricing the offer, not for preparing the return.

Price the offer on after tax dollars

Here is the recommendation as a number. Underwriting this deal at long term capital gains rates says you make $45,720. Dealer treatment says $35,351. If your minimum acceptable profit is $40,000, this is a deal at investor rates and it is not a deal at dealer rates, and the scoring block says you are a dealer.

So run the score first, take the honest answer, and work backward. At a $40,000 after tax target in the 24 percent bracket, you need about $67,890 of pre tax profit. On this ARV and this rehab budget, that puts your maximum purchase price at $190,110 rather than $198,000. That $7,890 is what the tax model is actually for. It is not a filing question. It is an offer question, and by the time your CPA sees the deal in March, the offer was written ten months earlier.

The Flip and BRRRR Calculator already carries the deal block: purchase, rehab, holding costs broken out by month, selling costs, and the maximum allowable offer that falls out of a target profit. Add the tax profile block and the dealer path from this article and it stops being a pre tax model. The maximum allowable offer it prints becomes a number you can actually sign, because it is net of self employment tax and net of your real bracket. Every flipper underwrites to a profit target. Very few underwrite to a profit target they get to keep.