Evaluating Comparable Reliability
Key Takeaways
Lower gross adjustments can help when verification and support are otherwise comparable.
A small net adjustment can conceal large offsetting changes.
Explain the conclusion instead of using an unexplained average.
Evaluating Comparable Reliability
Important
Standards Rule 1-6 of the Uniform Standards of Professional Appraisal Practice (USPAP) mandates that an appraiser reconcile the quality and quantity of data available and analyzed within the approaches used, and reconcile the applicability and relevance of the approaches, methods, and techniques used to arrive at a value conclusion. Reconciliation is where the appraiser acts as an economic analyst, not a mathematical clerk.
The Analytical Mandate of Reconciliation
After applying market-derived adjustments to comparable sales, an appraiser is typically presented with a spread of indicated values. Even in well-defined suburban neighborhoods, adjusted sale prices rarely converge to an identical dollar figure due to minor unquantifiable variances, slight differences in buyer motivation, and market friction. The process of analyzing these differing indications, evaluating the reliability of each transaction, and synthesizing the findings into a single defensible point estimate or narrow value range is known as reconciliation.
Why Mathematical Averaging is Unacceptable in Professional Appraisal Practice
One of the most persistent misconceptions in residential valuation is that an appraiser should calculate the arithmetic mean (average) of the adjusted comparable sale prices. USPAP requires reasoned reconciliation. It does not categorically ban arithmetic or a supported weighted calculation; an unexamined average cannot replace analysis of unequal evidence.
The Fallacy of the Mean
Suppose an appraiser adjusts three comparable sales:
- Comparable 1 adjusted price: $509,050
- Comparable 2 adjusted price: $510,200
- Comparable 3 adjusted price: $540,625
Calculating an unweighted arithmetic mean yields:
Now consider the underlying market reality:
- Comparable 1 is located directly on the same street (0.1 miles away), closed one month ago, is the identical model built by the same builder, and required only 1.19% in gross adjustments.
- Comparable 2 is located within the same subdivision (0.4 miles away), closed three months ago, and required 6.29% in gross adjustments.
- Comparable 3 is located 1.2 miles away in a different competing neighborhood, closed five months ago, has an inferior condition rating (C4), and required 13.14% in gross adjustments with large offsetting positive and negative modifications.
To compute an arithmetic mean is to assign an identical 33.3% weighting to each sale. This practice elevates an inferior, heavily modified, distant transaction to the exact same level of credibility as an almost identical, proximate transaction. Averaging abdicates professional responsibility, substituting blind arithmetic for reasoned economic judgment.
Note
Professional appraisal practice requires the appraiser to select comparable sales that best reflect the subject's competitive position and assign relative weights based on data quality, adjustment magnitude, and physical similarity. Mechanical formulas, including arithmetic averages or automated spreadsheet weighting algorithms, cannot substitute for professional judgment.
Weighting Criteria for Comparable Sales
When evaluating which comparable sales provide the most reliable indication of the subject's market value, an appraiser analyzes six core criteria:
- Gross Adjustment Percentage: Gross adjustment percentage is one diagnostic measure, not a conclusive ranking of reliability. A lower gross adjustment indicates that the property required fewer total dollar modifications to simulate the subject, minimizing the potential for adjustment estimation error.
- Net Adjustment Percentage: While a low net adjustment is desirable, appraisers must examine whether a low net percentage is genuine or merely the result of large offsetting positive and negative adjustments. A sale with a 2% net adjustment but a 22% gross adjustment has undergone massive modifications and is inherently less reliable than a sale with a 5% net and 5% gross adjustment.
- Absolute Number of Line-Item Adjustments: Properties requiring adjustments on only one or two lines (e.g., GLA and contract date) are physically and legally more similar to the subject than properties requiring adjustments across six or seven categories.
- Proximity and Submarket Consistency: Sales situated within the subject's immediate subdivision or micro-neighborhood are influenced by identical municipal tax rates, school districts, utility providers, traffic patterns, and social dynamics. Proximity reduces the risk of unrecognized locational variances.
- Contract Date Recency: In fluctuating real estate markets, contract date (the meeting of minds between buyer and seller) represents current market conditions far more accurately than closing date. Recent transactions closed within 30 to 90 days carry higher evidentiary weight than older transactions requiring market condition adjustments.
- Data Reliability and Verification: Sales directly verified with active transaction participants (listing agent, selling agent, buyer, seller, or closing attorney) carry greater credibility than sales relying solely on unverified public tax records.
Verification Can Outweigh Superficial Similarity
Suppose two sales require the same total gross adjustment and sit equally close to the subject. The first has a verified contract, confirmed financing, and a recent interior data record. The second has an unverified reported price and conflicting information about an added dwelling unit. Their matching adjustment percentages do not make them equally reliable. Resolve the second sale’s price and legal-use issues before relying on it, or reduce its influence when adequate verification is unavailable.
Now suppose a more distant sale competes directly for the same buyers and has well-supported adjustments, while the nearest sale belongs to a different product segment. Distance alone should not decide the weight. Explain substitution and evidence quality in the market actually being analyzed. This is why a persuasive reconciliation addresses the facts behind each adjustment rather than ranking rows by one percentage or proximity measure.
Why would an unexamined average of adjusted sale prices be inadequate when the comparable evidence has substantially different reliability?
The Uniform Standards of Professional Appraisal Practice (USPAP) restrict valuation calculations exclusively to median and mode statistics
Arithmetic averaging treats all comparable sales as equally reliable, disregarding critical differences in data quality, gross adjustments, and proximity
Secondary mortgage market automated underwriting systems reject any appraisal report containing fractional dollar amounts resulting from division
Averaging always produces an indicated value that exceeds the highest unadjusted comparable sale price in the dataset
Assuming the adjustment support and verification are equally credible, which comparable would generally provide the strongest evidence?
The comparable with the highest contract sale price, as it reflects the upper economic capacity of the neighborhood
The comparable that closed most recently, regardless of distance, neighborhood boundaries, or required adjustments
The comparable requiring the lowest gross adjustment percentage, located within the subject's immediate subdivision, and verified via arm's-length terms
The comparable with a net adjustment closest to zero, even if it required substantial offsetting positive and negative line-item adjustments
Sections you finish are checked off in the contents.