How recent a comp should be
A sale from last month and a sale from last year are not the same evidence, even when the houses match. The report multiplies each comp by a recency weight and then takes a weighted median of the adjusted prices. This page holds distance and similarity at 1 and uses invented prices so the date is the only thing that changes the weight. The distance rule is the same walk in miles. The full weight table stacks both.
The recency steps
Measure age in months from the sold date. A sale within 3 months is multiplied by 3. A sale older than 3 months and within 6 months is multiplied by 2. A sale older than 6 months and within 12 months is multiplied by 1.5. A sale older than 12 months is multiplied by 0.8. Nothing in that list is zero. An old sale is a quieter vote, not a deleted vote. If your habit is to throw out anything older than six months, you are using a stricter rule than this multiplier. Say so. Do not claim the 0.8 factor and also delete the sale.
An old high sale does not set the median
Comp A sold for $200,000 two months ago. The recency weight is 3. Comp B sold for $240,000 fourteen months ago. The recency weight is 0.8. Total weight is 3.8. Half is 1.9. Sort by price. Comp A at $200,000 comes first, and its weight of 3 is already past 1.9, so the weighted median is $200,000. The average of the two prices is $220,000. The average lets a 14 month old sale lift the value by $20,000. The weight lets that sale sit in the list and still lose the median, because it does not have enough votes to push the running total across the halfway point before the newer sale does.
A recent high sale can set the median
Comp A sold for $180,000 eighteen months ago, so the weight is 0.8. Comp B sold for $210,000 two months ago, so the weight is 3. Total weight is again 3.8 and half is again 1.9. Walk from the low price. Comp A contributes 0.8, which is short of 1.9. Comp B brings the running total to 3.8, which passes 1.9, so the weighted median is $210,000. The recent sale won, and it won while being the higher price. Recency is not a discount. It is a reason to trust one sale more. If the sale you trust is higher, the median is higher. Using the older cheaper sale because it “feels safer” is a different policy from the one this weight implements.
The month buckets are edges, not vibes. A sale at just inside 3 months gets 3. A sale just past 3 months gets 2, not 3. A sale just past 12 months gets 0.8, not 1.5. If you are hand-weighting, write the sold month down before you pick the factor. Guessing “pretty recent” and assigning 3 is how a winter sale and a spring sale get the same vote. The formula does not know your season. It knows the sold date.
From the median to an offer
Take the first median, $200,000, and an invented rehab of $35,000. The 70 percent offer is $140,000 minus $35,000, which is $105,000. That number is available on the ARV and 70% rule calculator if you type $200,000 as the only sold price, and on the 70 percent line of the MAO calculator. It ignores the $240,000 sale for the same reason the weighted median ignored it: that sale did not have the votes. If you instead type both prices into the plain-median calculator, with no weights, an even count averages them to $220,000 and the offer becomes $154,000 minus $35,000, which is $119,000. The $14,000 difference is the cost of forgetting the date. The plain median is a hand tool. The weighted median is the report. Do not call one by the other’s name.
How many dated sales you have is a separate question from how old the newest one is. Two sales, one of them fourteen months old, can still produce a clean median and a thin set. The count guide is the point table for how many comps you brought, not for how fresh they are. A single two-month-old sale has a recency weight of 3 and a count score of 6. The weight made it loud. The count still says you have one observation. These prices and dates are invented.
Questions
Does an old sale get deleted?
Not by this multiplier. A sale older than 12 months is multiplied by 0.8. It still has a vote. It stops controlling the median when a newer sale carries enough weight to cross half of the total.
Is the most recent sale always the ARV?
No. Recency is a multiplier on the way to a weighted median, not a rule that the last sale wins. If the recent sale is the low price and its weight crosses the halfway point first, the median is the low price.
run a full analysis free when the median you can do by hand is not enough. A full analysis weights the comps, adjusts beds and baths, and prices the repair tiers. The sample figures there are invented, the same way every dollar on this page is invented.