9.3 Reconciling the Sales Comparison Approach

From Adjusted Prices to One SCA Indication (ECO IV.f)

After comparables are selected and adjusted, the sales comparison approach produces a set of adjusted sale prices—not yet a single value opinion for the assignment. AQB ECO IV.f Reconciliation to indicated value by the sales comparison approach is the step where the appraiser converts that array into one indicated value by SCA (or a tight supported range that is then resolved to a point when the assignment requires a single number).

Reconciliation here is within the approach. Later, in Content Area VII, you will reconcile SCA with the cost and income approaches into a final value opinion. Do not confuse the two levels:

What You Are Reconciling

Typical inputs:

1. Unadjusted sale prices of the comparables (context for market range)
2. Adjusted sale prices after transactional and property adjustments
3. Quality of each comparable — proximity, recency, similarity of rights, financing, motivation
4. Total adjustment burden — how hard you had to work to make the sale look like the subject
5. Bracketing — whether the subject sits inside the comp set on key traits and indications
6. Consistency with units of comparison (price per sq ft, per unit) when used as a check

Never Average Blindly

Blind averaging means adding adjusted prices and dividing by n without regard to quality. It is a classic exam wrong answer and a real-world credibility failure.

Why averaging fails:

• A poorly matched sale with large adjustments gets the same vote as a nearly identical next-door sale
• An outlier that should be discarded still pulls the mean
• Markets are not democracies of random comps

Exam stem pattern: “The appraiser averaged the three adjusted prices and reported that average as market value without discussion.” The correct critique is that reconciliation requires judgment and support, not automatic averaging.

Weighting Criteria

Weight each comparable’s adjusted indication by factors such as:

1. Similarity to the Subject

Same subdivision, same design, similar GLA, similar age/condition, same garage/bath package, same site utility → higher weight.

2. Recency and Market Conditions Reliability

Very recent sales in a changing market often outrank older sales that needed large time adjustments—unless the older sale is otherwise a near twin and the time adjustment is rock solid.

3. Transactional Quality

Arm’s-length, well-exposed listings with market financing beat odd motivations, even if the odd sale was adjusted “somehow.”

4. Magnitude of Adjustments

Two related ideas:

• Gross adjustment: sum of the absolute values of individual adjustments (sometimes expressed as % of sale price)
• Net adjustment: algebraic sum of adjustments (positive and negative can cancel)

A sale with small gross and net adjustments usually deserves more weight than one with a 35% gross adjustment package. Large net adjustments that “happen” to cancel (big plus and big minus) still indicate weak overall comparability—gross adjustment magnitude matters.

Reconciling toward about $410,000 (near Comp 1, with Comp 2 supportive) is more defensible than averaging to roughly $420,200 and ignoring that Comp 3 is a weak substitute.

5. Directional Consistency and Bracketing

If the best comps’ adjusted prices land between $405,000 and $415,000, an SCA indication of $480,000 is not “reconciled”—it is unsupported extrapolation.

Bracketing the Subject

Bracketing means surrounding the subject with evidence on both sides:

If all comps are superior in almost every way, the subject value may lie below the lowest adjusted price—possible, but the appraiser must say so and accept weaker support. Exam items often reward recognizing inadequate bracketing as a limitation.

Worked Reconciliation Scenario

Subject: 1,720 sq ft two-story, 3 bed / 2.5 bath, 2-car garage, average condition, built 2005, typical lot, suburban subdivision. Effective date: current.

Naive average: ($440,000 + $438,000 + $442,000) / 3 = $440,000 — happens to look neat, but the reasoning still matters.

Judgmental reconciliation:

• Comp A: best location match, moderate age of sale, low gross adjustments → primary weight
• Comp B: most recent, modest net adjustment, slightly superior finishes already adjusted → strong secondary weight
• Comp C: useful as a bracket on garage/GLA but high gross adjustments → least weight

Indicated value by SCA: $439,000 (or $440,000 if rounding to a meaningful increment), supported primarily by A and B, with C confirming the zone rather than driving the point estimate.

If Comp C’s adjusted price had been $470,000 with 30% gross adjustments, you would not average it in equally; you might treat it as a weak upper outlier and still conclude near $439,000–$440,000 from A and B.

Units of Comparison as a Reconciliation Check

After dollar adjustments, many residential appraisers also review price per square foot of GLA (unadjusted and/or adjusted) as a reasonableness test:

If you emphasize A/B around ~$250–$259/sq ft, 1,720 × $255 ≈ $438,600, consistent with the dollar reconciliation. If $/sq ft and dollar indications wildly disagree, re-check GLA adjustments and comparability.

Conceptual URAR Grid Reasoning

The Uniform Residential Appraisal Report (URAR) sales comparison grid is the form most residential candidates know. Conceptually (exam level, not form-filling trivia):

1. Sale price of each comparable is the starting number.
2. Transactional adjustments (property rights, financing, conditions of sale, concessions, expenditures immediately after sale, market conditions) are applied with market support.
3. Property adjustments (location, site, view, design, quality, age, condition, GLA, basement, rooms, functional utility, heating/cooling, energy, garage, porches/patio/fireplace, fences/pool, etc.) follow, each comparable → subject.
4. Net and gross adjustment totals are reviewed for reasonableness and weighting.
5. Adjusted sale prices feed reconciliation narrative / indicated value by SCA.
6. The appraiser does not treat the form’s blank “Indicated Value by Sales Comparison Approach” as an average button—it is a concluded figure.

Grid logic rules worth memorizing:

• Adjust comparables only
• Use plus when comparable is inferior; minus when superior
• Prefer market-derived amounts (pairs, trends, income, cost support)
• Explain large adjustments
• Reconcile with emphasis on best evidence

Stating the Indicated Value by SCA

A complete SCA reconciliation statement conceptually includes:

1. Which comps received the most weight and why
2. Which comps were down-weighted or excluded and why
3. How bracketing supports the conclusion
4. The indicated value by the sales comparison approach as a single figure (or justified range then point)
5. Any remaining limitations (thin market, dated sales, qualitative residual differences)

Example language (study model):
“Greatest weight was given to Comparable A due to its location on the subject street and minimal adjustments, with secondary weight to Comparable B as the most recent sale. Comparable C was given least weight because of larger gross adjustments for garage and GLA. The adjusted prices bracket a narrow range from $438,000 to $442,000. The sales comparison approach indicates a value of $440,000.”

Connecting SCA Reconciliation to Final Value

The SCA indication is often the most heavily weighted approach for owner-occupied residential property when the market is active with good comps (especially LR exam weighting). Still:

• Cost approach may support new or unique properties or insurance-type cost insights
• Income approach may matter for 2–4 units or investor-driven segments
• Final reconciliation (Area VII) explains approach weights; IV.f only settles the SCA number

High-Yield Traps for IV.f Items

1. Equal weight to unequal comps
2. Averaging including a non-arm’s-length sale that should have been rejected
3. Selecting the highest adjusted price without support (advocacy, not appraisal)
4. Ignoring gross adjustments because net adjustments look small
5. Concluding outside all adjusted prices without explaining extrapolation
6. Confusing SCA indication with final value when other approaches differ materially
7. Math-only reconciliation with no qualitative discussion of similarity

Chapter 9 Synthesis

• 9.1 Paired data isolates single differences to extract adjustments—garage, bath, GLA—and avoids confounded pairs.
• 9.2 Cost, income, regression, and qualitative comparisons fill gaps when pairs are thin: depreciated cost support, GRM/cap-rate math, trends/regression, ranking/bracketing, relative comparison, and interviews.
• 9.3 SCA reconciliation turns adjusted prices into one indicated value by weighing evidence, respecting bracketing, and refusing blind averages—URAR grid reasoning at the conceptual level the National Exam expects.

If you can extract a clean pair, support a second line with cost or income when needed, rank what you cannot dollarize, and then weight the best adjusted comps into one SCA indication, you have completed the quantitative and reconciliation core of Content Area IV.d–f and are ready to place that indication beside cost and income in the final reconciliation chapters.