Why ARV per square foot misleads
Price per square foot is a column on a comp sheet and a tempting shortcut. Divide the sold price by the comp’s living area, multiply by the subject’s living area, and you have a number that feels like an ARV. It is a different number from the median of the sold prices, and the report does not use it as the value. The median is taken on the adjusted sale price. Ordering or scaling by price per foot picks a different house whenever the comps differ in size. This page uses two invented comps and one invented subject so both methods are visible.
The two comps and the subject
The subject is 1,500 square feet. Comp A is 1,200 square feet and sold for $180,000. That is $150 per square foot. Apply $150 to 1,500 square feet and you get $225,000. Comp B is 1,600 square feet and sold for $200,000. That is $125 per square foot. Apply $125 to 1,500 square feet and you get $187,500. You now have two “ARVs,” $225,000 and $187,500, and neither one is a price anyone paid. Averaging those two implied values gives $206,250, which is a third number nobody paid.
The sold prices themselves are $180,000 and $200,000. An even count averages the two central prices, which is both of them, so the plain median is $190,000. That is $35,000 under the price-per-foot result from the smaller house and $2,500 over the price-per-foot result from the larger house. The smaller house looked “strong” at $150 a foot only because the denominator was small. Scaled up to 1,500 feet it became the aggressive number. The larger house looked “weak” at $125 a foot and scaled down to a figure near the median. Using the strong one because it is strong is how a small comp inflates a larger subject.
Why the report refuses this shortcut
The report stores price per square foot so you can see it. The weighted median still walks the adjusted sale prices, not the per-foot ranks. If it sorted by price per foot, the 1,200 square foot house would outrank the 1,600 square foot house even when the larger house is the closer match in beds, baths, and age. A similarity score already has a living-area slice. Scaling the whole price by the size ratio on top of that slice double-counts size. The similarity guide is that slice. This page is the shortcut it does not replace.
Bedroom adjustments are also in dollars on the sale price, not in dollars per foot. A per-foot ARV that you then “adjust” for a bedroom mixes two units. Keep the adjustment on the price, then take the median of prices. The hand-estimate guide sorts three sale prices and refuses the average. It would also refuse $225,000, because $225,000 was not one of the sales. It was $150 times a square footage the smaller house did not have.
The offer people build on the wrong base
An invented rehab of $40,000 on the median of $190,000 is a 70 percent offer of $133,000 minus $40,000, which is $93,000. The same rehab on the $225,000 per-foot figure is $157,500 minus $40,000, which is $117,500. The shortcut added $24,500 to the offer. That $24,500 is not a feature of the subject. It is the small comp’s high price per foot times 300 square feet the subject has and the comp did not. You can type $180,000 and $200,000 into the ARV and 70% rule calculator and see the $190,000 median. The form does not ask for square feet, on purpose. If you want the 25/5/3 line on $190,000, use the MAO calculator. Profit at 25 percent is $47,500, closing is $9,500, holding is $5,700, and the offer is $190,000 minus $40,000 minus those reserves, which is $87,300.
Check that last subtraction: $47,500 plus $9,500 plus $5,700 is $62,700, and $190,000 minus $40,000 minus $62,700 is $87,300. The 70 percent offer was $93,000. The gap is $5,700, which is 3 percent of $190,000. Same gap as every other 70 versus 25/5/3 comparison. The per-foot mistake was larger than the choice of screen. Fix the base before you argue about the percent. These sizes and prices are invented.
Questions
Is price per square foot useless?
It is context. It tells you the $180,000 house was $150 a foot and the $200,000 house was $125 a foot. It is not a rate you multiply by the subject’s square feet and call an ARV.
What number should I use instead?
The median of the sold prices, after you have decided the houses match. On this pair that median is $190,000. A full analysis uses a weighted median of adjusted prices, which is still a price, not a price per foot.
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.