Articles

How do you adjust comparable sales in a sales comparison grid?

Each comparable sale is moved to the subject's date and condition, one adjustment at a time. The sale that needed the smallest adjustment deserves the most weight.

Three recent warehouse sales are adjusted to a 50,000 sq ft subject with 28 ft clear height and a 12-year-old building. After adjusting for time, clear height, age and size, the comparables indicate $125.15, $110.10 and $114.76 a square foot. Weighting by the inverse of each sale's gross adjustment gives $115.53, a value of $5,776,391.

The assumptions

Subject and comparable sales, invented figures
ItemSubjectComp 1Comp 2Comp 3
Sale price$5,200,000$6,100,000$4,700,000
Building area, sq ft50,00046,00058,00042,000
Clear height, ft28242826
Age, years12151012
Months since sale492
Price per sq ft$113.04$105.17$111.90

The market adjustments are drawn from paired sales and are also invented: prices have risen 0.50% a month, each foot of clear height is worth $2.00 a sq ft, each year of age is worth $1.00 a sq ft, and a sale 1,000 sq ft larger sells for 0.25% less per sq ft.

Step 1: adjust the price per square foot

Time = price per sq ft × 0.50% × months. Comp 1 = 113.04 × 0.50% × 4 = +2.26

Clear height = (subject − comp) × $2.00. Comp 1 = (28 − 24) × 2.00 = +8.00

Age = (comp age − subject age) × $1.00. Comp 1 = (15 − 12) × 1.00 = +3.00

Size = (comp area − subject area) ÷ 1,000 × 0.25% × time-adjusted price. Comp 1 = (46,000 − 50,000) ÷ 1,000 × 0.25% × 115.30 = −1.15

Adjustment grid, $ per sq ft
ItemComp 1Comp 2Comp 3
Price per sq ft113.04105.17111.90
Time+2.26+4.73+1.12
Clear height+8.00+0.00+4.00
Age+3.00−2.00+0.00
Size−1.15+2.20−2.26
Adjusted price per sq ft125.15110.10114.76
Net adjustment10.7%4.7%2.6%
Gross adjustment12.8%8.5%6.6%

Net adjustment is the sum with signs; gross adjustment is the sum of the absolute values and measures how much work the comparable needed. Both are shown as a share of the unadjusted price. Comp 3 needed 6.6% gross, comp 1 needed 12.8%.

Step 2: weight the comparables

Weight = 1 ÷ gross adjustment. Comp 1 = 1 ÷ 0.1275 = 7.84; comp 2 = 11.78; comp 3 = 15.16; total 34.78

Weighted price = (125.15 × 7.84 + 110.10 × 11.78 + 114.76 × 15.16) ÷ 34.78 = $115.53

Value = 115.53 × 50,000 = $5,776,391

Excel: =SUMPRODUCT(adjusted,1/gross)/SUMPRODUCT(1/gross)*50000

A simple average of the adjusted prices is $116.67, or $5,833,632. Weighting moves the value by $57,241 towards the sales that needed the least adjustment.

What if: a flatter market, a faster one, one sale dropped

Indicated value when one input changes
CaseWeighted $ per sq ftValue
Base case, +0.50% a month115.53$5,776,391
No market change, 0% a month111.23$5,561,481
Faster market, +1.00% a month118.44$5,921,783
Comp 1 dropped, +0.50% a month112.73$5,636,316

The time adjustment is the one that matters most here. Moving it from 0.50% to 1.00% a month changes the value by $145,392, because the oldest sale, comp 2, is nine months old.

The common mistakes

Takeaway

Questions readers ask

How do you adjust comparable sales to a subject property?

Move each sale to the subject's date with a market-conditions adjustment, then add or subtract an amount for each physical difference such as height, age and size. Here comp 1 goes from $113.04 to $125.15 a sq ft.

What is the difference between net and gross adjustment?

Net adjustment adds the adjustments with their signs, gross adds their absolute values. Gross shows how much the sale had to be changed: comp 3 needed 6.6%, comp 1 12.8%.

Why weight comparables by their gross adjustment?

The sale that needed the least adjustment relies least on the appraiser's adjustment rates. Weighting gives $115.53 a sq ft against a simple average of $116.67.

The workbooks behind this article

The free companion files for Real Estate Appraisal rebuild the income approach, the sales and cost approaches and the reconciliation of a fictional property with live formulas. The warehouse sales in this article are invented and are not in them. No account and no email address.

Open the companion files →

Not on Amazon: 10 paperbacks by Julian R. Sterling on tax and incentives, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: real estate investing, finance and fund management → · All 1908 articles →