The Fix-and-Flip Model: A Texas Foreclosure Deal Analyzer

A fix-and-flip lives or dies on a pro-forma you build before you buy. The model is simple in shape: buy below what the house is worth fixed up, add the renovation, sell, and keep the spread after every cost. What trips people up is the list of costs, which is longer than "purchase plus rehab," and the honesty of the resale number. This guide walks a full fix-and-flip pro-forma on a Texas foreclosure, line by line, so you can copy the structure onto your own deal.

This is general information, not legal or financial advice.

The numbers below are one illustration on one house. Change the market, the rate environment, or the scope of work and the outputs move. The framework is what carries over.

The four numbers that drive everything

Before any spreadsheet, four inputs decide whether a flip is real:

• After-repair value (ARV). What the renovated house sells for, from sold comparables.
• Purchase price. What you actually pay, ideally set by the max-bid model at a foreclosure auction.
• Rehab. The contractor's scope of work, padded for surprises.
• Time. How many months from purchase to a closed resale, because every month costs money.

Get the ARV and the purchase price right and the deal has room to absorb mistakes elsewhere. Get either wrong and no amount of cost control saves it. This is why a foreclosure is the natural source of flip inventory: it is one of the few ways to buy meaningfully below market, which is the entire premise of the model.

The pro-forma, line by line

Take the Dallas 3-bed, 2-bath from the max-bid model: an ARV of $320,000, a rehab of $45,000, and a winning auction price of $179,000. Assume an all-cash purchase, which is the norm at a Texas trustee sale, and a six-month hold from auction to closed resale.

On this deal the model returns a net profit of $64,600 on a resale of $320,000. Two ratios tell you whether that profit is worth the risk.

Margin and return: the two ratios that matter

A dollar profit means nothing without context. Two numbers give it context:

1. Profit margin. Net profit divided by the ARV: $64,600 divided by $320,000 is about 20%. A flip should clear a margin thick enough to survive a soft resale. When the margin drops toward 10%, a single bad comp or a two-month delay can erase the whole profit.
2. Return on cash. Net profit divided by the cash you put in. Before the sale you have $233,000 committed (purchase, rehab, holding, buy-side closing). A profit of $64,600 on $233,000 is a return of about 28% over roughly six months. Annualized, that is a strong number, but it is only real if the timeline holds.

Key takeaway. Judge a flip on margin and return on cash, not on the headline profit. A $64,600 profit at a 20% margin is a healthy deal. The same profit at a 9% margin on a bigger, slower project is a coin flip you should probably pass on.

Financing changes the return, not the profit

The example above is all cash, which matches an auction buyer. Many flippers use a hard-money bridge loan instead, and it is worth seeing what that does to the model. A bridge loan does not change the ARV, the rehab, or the selling costs, so the total project profit barely moves once you add points and interest as a financing line.

What it changes is the return on cash. By borrowing most of the purchase and rehab, you reduce the cash you put in, which raises your return on that smaller stake even though your dollar profit is a little lower after interest. Leverage magnifies the percentage return and the risk together: if the resale stalls, you are paying interest every month against a profit that is shrinking. Model both the all-cash and the financed version, and know which one you are actually running.

Stress-test the deal before you bid

The base-case pro-forma shows what happens if everything goes to plan. Everything rarely does. The two things that slip most often on a foreclosure flip are the resale value, which can come in soft, and the rehab, which can run over once the walls are open. So run the model a second time with both pushed against you: the ARV 5% low at $304,000 and the rehab $10,000 over at $55,000.

The stress case still makes money: a profit of $39,720 at a 13% margin. That is the mark of a deal worth doing. The purchase price left enough room that a soft resale and a rehab overrun together only trim the profit, they do not erase it. Compare that to a deal you bought at a thinner spread, where the same two hits would flip the profit negative. The stress test does not tell you what will happen; it tells you whether the deal can survive being wrong, which is the only protection you have once the auction is final and the money is spent.

If a candidate only clears your profit target in the base case and goes negative in the stress case, the honest read is that you would be bidding on hope. Pass, and point the model at the next property.

Where flips go wrong

The pro-forma is only as good as its inputs, and the same three inputs cause most losses:

• An optimistic ARV. Using active listings or the top comp instead of the median of true sold comparables inflates the exit and hides a thin deal. Anchor the ARV to closed sales.
• A soft rehab number. The scope you can see from the outside of a foreclosure is not the scope you find once the walls are open. Pad the rehab and keep a contingency line.
• A timeline that slips. Every extra month adds holding costs and, if you are financed, interest. Build the model on a realistic timeline, then ask what the profit looks like if it takes two months longer.

A disciplined flipper runs the pro-forma on every candidate and only chases the ones where the margin survives a stress test. Most properties will not clear that bar, and that is the point of the model: it is a filter, not a sales pitch.

The exit is not only a retail sale

The pro-forma above assumes you renovate and sell to a retail buyer, but that is not the only way out, and a good investor prices the alternatives before buying. If the flip margin looks thin once you are into the project, you have options that the single-exit model hides. You can list at retail and wait for the right buyer. You can sell the property in as-is or partly-renovated condition to another investor for a smaller, faster profit. Or, if the numbers support it, you can keep the house as a rental and let the rental cash-flow model take over, converting a marginal flip into a long-term hold rather than forcing a sale into a soft market.

Knowing your exits in advance changes how you bid. A property that works as both a flip and a rental is more forgiving than one that only pencils out as a flip, because a stalled resale is no longer a crisis. When you screen the foreclosure list, favor the deals that give you more than one way to make money, and run the pro-forma for each exit before the auction, not after.

From list to pro-forma

The workflow is simple once the model is built. Screen the live foreclosure list, reject anything that fails the max-bid math, then build a full pro-forma on the handful that pass. Every active listing on Fclosure carries the sale date, the original notice, the appraisal value, and an equity estimate, so you can run the four driving numbers on a property in minutes and reserve the deep analysis for the deals that deserve it. The model does not find the deal. It tells you the truth about the deal you found.

More reading: all guides · the blog