Selecting and adjusting comparable sales for commercial property
The sales comparison approach is only as strong as its comparables. Here is how to pick sales a reviewer will accept and adjust them in a way they can follow.
In the sales comparison approach, the value of a property is indicated by the prices paid for similar properties, adjusted for their differences. For commercial property, finding truly similar sales is the hard part: there are fewer of them, and each building is different.
Step 1: define what "comparable" means for this property
Start with the characteristics a buyer of the subject would care about:
- property type and subtype: a medical office is not a general office; a cold-storage warehouse is not a flex building;
- location: same MSA at least, and ideally the same submarket;
- size: large buildings typically sell for less per square foot than small ones;
- age and condition;
- date of sale: recent sales reflect current conditions;
- income profile: for income property, similar NOI per square foot and tenancy.
Step 2: reject sales that are not arm's length
Some recorded sales should not be used, or only with great care:
- portfolio or multi-parcel sales, where one price covers several properties;
- related-party transfers, foreclosures and distressed sales;
- sale-leasebacks, where the price reflects the new lease more than the real estate;
- partial interests;
- duplicates: the same sale recorded twice.
Valnow removes duplicate sales from its data and excludes multi-account county sales, because their price is not the price of a single property.
Step 3: choose the unit of comparison
Commercial sales are compared through units rather than total price:
- price per square foot of building area for office, retail and industrial;
- price per unit for multifamily;
- income multipliers or the overall cap rate when income is known for each sale.
Step 4: adjust in a consistent sequence
The traditional sequence applies transaction adjustments first, then property adjustments:
- property rights conveyed (fee simple, leased fee);
- financing terms;
- conditions of sale;
- expenditures right after purchase, such as planned repairs;
- market conditions (time);
- location;
- physical characteristics: size, age, condition, quality;
- economic characteristics, such as tenancy and lease terms;
- use and zoning, and non-realty components.
Support each adjustment with data where possible: a market trend for time, paired sales for size or location. A large total adjustment is a sign that the sale is not very comparable.
Step 5: how many comparables?
Three to six good sales is typical. Fewer, well-chosen and lightly adjusted sales are better than many distant ones. When local sales are thin, widen the search in a documented order: first time, then distance, then size, and explain the choice.
Step 6: document the source of every sale
Each comparable should show its address, sale date, price, size, unit price and source. A reviewer who cannot trace a sale will discount it.
In a Valnow Evaluation
Valnow Evaluation proposes comparable sales from Valnow's verified database and, in supported counties, qualified public sales of the same type over three years. You can add your own sales by hand or by CSV import with their source. For each sale, the report computes the differences in date, size and age, shows the city, county and MSA, and writes out the adjustments.
This article is general information, not legal or regulatory advice. Check your institution's policies and your regulator's current guidance before applying it to a loan.