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.
| Item | Subject | Comp 1 | Comp 2 | Comp 3 |
|---|---|---|---|---|
| Sale price | $5,200,000 | $6,100,000 | $4,700,000 | |
| Building area, sq ft | 50,000 | 46,000 | 58,000 | 42,000 |
| Clear height, ft | 28 | 24 | 28 | 26 |
| Age, years | 12 | 15 | 10 | 12 |
| Months since sale | 4 | 9 | 2 | |
| 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.
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
| Item | Comp 1 | Comp 2 | Comp 3 |
|---|---|---|---|
| Price per sq ft | 113.04 | 105.17 | 111.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 ft | 125.15 | 110.10 | 114.76 |
| Net adjustment | 10.7% | 4.7% | 2.6% |
| Gross adjustment | 12.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%.
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.
| Case | Weighted $ per sq ft | Value |
|---|---|---|
| Base case, +0.50% a month | 115.53 | $5,776,391 |
| No market change, 0% a month | 111.23 | $5,561,481 |
| Faster market, +1.00% a month | 118.44 | $5,921,783 |
| Comp 1 dropped, +0.50% a month | 112.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.
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.
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%.
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 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.
Not on Amazon: 10 paperbacks by Julian R. Sterling on tax and incentives, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: real estate investing, finance and fund management → · All 1908 articles →