Stale Comps in a Moving Market: How to Time-Adjust Sold Prices and Use Pendings to Check Your ARV

Why a Comp's Sale Date Matters as Much as Its Square Footage

Picture a flipper who buys a 1,500 square foot ranch using three comps that averaged $310,000. The comps looked perfect: same subdivision, same bed and bath count, all within a quarter mile. The problem was that they closed 6 to 9 months before the purchase, and by the time the flip listed, buyers had pulled back. The house sold for $291,000, and nearly $19,000 of projected profit vanished before a single repair ran over budget.

A sold price is a snapshot of one moment. It reflects what a buyer and seller agreed to on the contract date, usually 30 to 45 days before closing, under that period's rates and inventory. If the market has slipped 0.75% per month since then, an 8-month-old comp is roughly 6% stale. On a $310,000 sale, that works out to $310,000 x 0.94 = $291,400, almost exactly where our flipper landed.

Each listing status tells you something different. Sold comps show what buyers actually paid, but they lag the market. Pendings show what buyers agreed to in the last month or so, even though the final price stays hidden until closing. Actives show what sellers are hoping for, and a stack of actives with price cuts tells you the ceiling is dropping.

To time-adjust a comp, you need a monthly rate of change. There are three practical ways to estimate it:

• Repeat sales: find a house that sold twice with no major renovation in between, then divide the percentage change by the months between sales.
• Price per square foot trend: track median sold price per square foot in the area over the last 6 to 12 months and measure the slope.
• Paired sales: compare two very similar homes that sold at different dates and attribute the gap to time.

No single method is perfect, so use at least two and check whether they agree. If repeat sales suggest -0.6% per month and the price per square foot trend says -0.8%, a working figure of -0.7% is defensible. The next section applies exactly that kind of rate to three real comps.

Worked Example: Time-Adjusting Three Comps in a Cooling Market

Say you're analyzing a 3-bed, 2-bath ranch and you've pulled three renovated comps within half a mile. Comp A sold for $342,000 eight months ago, Comp B for $335,000 five months ago, and Comp C for $328,000 two months ago. The descending prices are already a hint. Local sold data shows values slipping about 0.6% per month, so each comp needs to be brought forward to today's market.

The math is simple. Multiply the months since sale by the monthly change, then apply that factor to the sold price. This example uses a straight-line adjustment, which is plenty precise over a window this short.

• Comp A: 8 months x -0.6% = -4.8%, so $342,000 x 0.952 = $325,584
• Comp B: 5 months x -0.6% = -3.0%, so $335,000 x 0.970 = $324,950
• Comp C: 2 months x -0.6% = -1.2%, so $328,000 x 0.988 = $324,064

Look at what happened. The raw sold prices spread across a $14,000 range, but after adjustment all three land within about $1,500 of each other. That tight cluster is a good sign your monthly rate is reasonable. The adjusted figures average $324,866, so call the time-adjusted ARV roughly $325,000. The unadjusted average is $335,000 ($342,000 + $335,000 + $328,000, divided by 3).

Now run both numbers through the 70% rule with a $55,000 rehab. Using stale comps, your MAO is ($335,000 x 0.70) - $55,000 = $179,500. Using time-adjusted comps, it's ($325,000 x 0.70) - $55,000 = $172,500. That's a $7,000 lower offer, and the lower number is the one that reflects what buyers are paying now.

Seven thousand dollars may not sound dramatic, but on a flip it often equals your entire contingency or a large share of your profit. If you offered $179,500 and resold into the market as it actually stands, you'd be absorbing that gap yourself. The adjustment takes five minutes with a calculator, and it protects you before you sign anything.

Worked Example: Projecting ARV to Your Resale Date and Checking It Against Pendings and Actives

The $325,000 ARV from the last section reflects the market today. You won't sell today. With a 5-month rehab and sale timeline, the house hits the market and closes roughly 5 months from now. If the market keeps sliding at the same -0.6% per month, that's about another 3% off, so $325,000 x 0.97 = about $315,250 at resale.

That $9,750 gap goes straight to your profit. Say you budgeted the deal for a $40,000 profit using the $325,000 figure. At $315,250, your selling costs (assume 6%) drop by about $585, so the net hit is roughly $9,165. Your $40,000 profit becomes about $30,835, a 23% haircut from a number that looked like a rounding error. Run it through the 70% rule with a $45,000 rehab and your MAO falls from $182,500 ($325,000 x 0.70 - $45,000) to about $175,675 ($315,250 x 0.70 - $45,000).

Now check that projection against the live market. You find one pending listing at $329,000 list. Pendings haven't closed, and in a cooling market they usually close below list, so assume something like $322,000 to $325,000. That lines up with today's adjusted ARV, which is what it should do. Remember that it's a snapshot of now, not 5 months from now.

Then look at the actives. Two renovated houses are listed at $339,000 and have sat 60+ days. Those are not comps. They tell you buyers have already looked at $339,000 and said no, which makes that number a ceiling. If your projected ARV ever lands above stale actives, treat it as a red flag.

Put it together and the picture is consistent:

• Stale actives at $339,000: the price buyers are rejecting
• Pending likely closing near $325,000: today's market
• Projected resale near $315,250: your exit 5 months out

Bet on the lower number. If the deal only works at $325,000 or above, it doesn't work.

Edge Cases: Rising Markets, Seasonality, and Thin Data

In a rising market, the temptation is to bake future appreciation into your ARV. Resist it. If a comp sold eight months ago for $300,000 and the data supports a 0.5% monthly gain, adjust it up to today: $300,000 x 1.04 = $312,000. Then stop. Projecting another six months of growth to your resale date turns your profit into a bet on the market, and if prices flatten, that cushion disappears before you list.

Seasonality is the next trap. Spring sales often close higher than winter sales in the same neighborhood, so comparing April closings at $330,000 to January closings at $310,000 can look like a 6% decline when nothing has changed. Compare the same months year over year whenever you can. If last January also ran about $20,000 below last April, you are looking at a seasonal swing, not a trend.

Thin data needs a different approach. When only 2 or 3 sales exist within 0.5 miles in 12 months, you cannot derive a reliable monthly rate from them. Use those sales to set value, but pull the rate from a wider source, such as median sold price trends for the zip code or a 1-mile radius. Lean conservative, and check your number against current pendings before you trust it.

Finally, keep new construction and single outliers out of your rate calculation. One new build selling at $425,000 next to renovated flips at $300,000 can make a block look like it jumped 40% overnight. The same applies to a distressed sale or a buyer who overpaid for a corner lot. Set your monthly rate from repeated, similar sales, never from one dramatic data point.

Tools like FlipSmrt pull adjusted MLS sold comps within 0.5 miles, which saves hours of searching and adjusting. You still need to read each comp's sale date and decide which way the market is moving. The software gives you the evidence. You make the judgment call on direction.

Common Time-Adjustment Mistakes That Inflate ARV

Most ARV errors in a cooling market push the number up, not down. Using a $300,000 ARV deal where values are slipping about 0.5% per month, here is what each mistake costs. Every $1 of inflated ARV raises your MAO by $0.70, so these errors land straight in your offer.

The most common one is averaging a year of sales with no date adjustment. If your comps average six months old, a 0.5% monthly decline means they overstate today's value by roughly 3%. That is $9,000 of phantom ARV and $6,300 of overpayment. The second mistake is borrowing a metro-wide or national trend. Suppose the metro is up 2% for the year but your subdivision is down 4%. Applying the metro number swings ARV by about 6%, which works out to $18,000 on this deal.

Treating active list prices as sold values is another trap. Actives show what sellers hope to get, not what buyers pay, and in a soft market that gap widens. If the nearby flips are listed at $315,000 and closing near $300,000, anchoring to the list prices adds $15,000 you will never collect. A related error is double-counting. You time-adjust every comp correctly and then pick the single highest result, say $312,000, instead of the cluster around $300,000. That optimism costs you $12,000 after you already did the careful work.

Date choice matters too. The contract date is when buyer and seller agreed on price. The closing date can trail it by 30 to 60 days. If you measure from closing on a deal that went under contract 45 days earlier, you under-adjust by about 0.75%, roughly $2,250 here. It looks small, but it stacks on top of the other errors.

Finally, watch concessions. A comp that sold for $305,000 with a $9,000 seller credit really netted $296,000. Recent sales in a cooling market often carry bigger credits, so the newest comps can look stronger than they were. Pull the concession field from the MLS on every comp before you trust it.

FAQ: Time-Adjusting Comps for ARV

How old is too old for a comp?

Aim for sales within the last 3 months, and stretch to 6 months only when recent data is thin. Past 6 months, the time adjustment often outgrows your size and condition adjustments, so you are guessing more than comparing. If you must use a 9-month-old sale, weight it less than fresher evidence.

Where do I find a reliable monthly market change for one neighborhood?

Pull median sold price per square foot for the subdivision or zip code from MLS (an agent can export it), then compare the last 3 months to the 3 months before. A drop from $210 to $204 per square foot over that span works out to roughly 1% per month. Cross-check against days on market and list-to-sale ratios, since those usually turn before prices do.

Should I ever adjust a comp upward for time?

Yes, but only when sold data clearly shows appreciation and you can document it. Even then, adjust the comp to today's value, not to where you hope prices will be at resale. Projecting gains forward is how flippers overpay right before a market flattens.

How should pending sales factor into ARV if the final price is unknown?

Treat a pending's list price as a ceiling, not a sale price. If your area typically closes at 97% of list, a pending listed at $340,000 points to about $329,800. Use pendings as a check on your adjusted ARV rather than as a primary comp.

How can I check this quickly on a specific address?

Run the address or Zillow link through FlipSmrt, then review the sale date on each comp in the report before accepting the ARV. If the comps skew older, apply your monthly adjustment and see how far the MAO moves. Your first 3 analyses are free, so test it on a live deal.

Every comp is a snapshot of a market that has already moved on. Adjust it to today, check it against pendings, and underwrite to the market you will sell into, not the one your comps sold in.