Sales Comparison Approach: Methodology

Hello! Welcome back to our course on real estate investment metrics.

In our last lesson, you built a powerful multi-year financial model in Python. That model, which calculates NPV and IRR, is based on the Discounted Cash Flow (DCF) method, a form of the "Income Approach" to valuation. However, the reliability of a DCF analysis hinges on its inputs, particularly the initial purchase price and the projected future sale price. How can we be confident those numbers are realistic?

Today, we'll answer that question by exploring the primary method used by appraisers and investors to determine a property's market value. This lesson kicks off our module on advanced valuation techniques. Your learning outcome is to describe the methodology of the sales comparison approach for property valuation. This approach anchors our financial models in the reality of the current market.

1. The Principle of Substitution: The Foundation of Market Value

The Sales Comparison Approach (SCA), also known as the Market Data Approach, is built on a simple, intuitive idea called the principle of substitution. It states that a rational buyer will not pay more for a property than what it would cost to purchase a comparable, equally desirable substitute property.

In essence, to find the value of a property (the "subject property"), we look at the recent sale prices of similar nearby properties (the "comparables" or "comps"). We then adjust the sale prices of those comps to account for any differences between them and our subject property.

To get a clear, visual introduction to this process, please watch the following video.

As the video explains, the core methodology involves four main steps:

1. Define the subject property's characteristics.
2. Find recently sold, comparable properties.
3. Adjust the comparables' sale prices to account for differences with the subject property.
4. Reconcile the adjusted prices to arrive at a final value estimate for the subject.

2. Finding Good Comparables: The "Testigos"

The validity of the SCA depends entirely on the quality of the comparables. A good comparable should be as similar to the subject property as possible. Key criteria for selection include:

• Recency of Sale: The sales should be recent to reflect current market conditions. In Spain, official appraisal standards are quite specific.
• Proximity: Comps should be in the same location or a very similar neighborhood.
• Similarity of Features: Properties should be similar in size, age, condition, quality, room count, and typology (e.g., apartment vs. detached house).

In the Spanish market, these comparables are often called "testigos" (witnesses). The formal valuation process is regulated, and for mortgage purposes, there are specific requirements.

As an investor, you'll find these "testigos" on major real estate portals. A companion guide for appraisers in Spain lists the most common sources.

3. The Art and Science of Adjustments: Homogenization

It's almost impossible to find perfect comparables. This is where adjustments become critical. The fundamental rule is:

You always adjust the price of the comparable, never the subject property.

The goal is to answer the question: "What would the comparable property have sold for if it had the same features as my subject property?"

• If the comparable is superior to the subject in some way (e.g., it has an extra bedroom), you must subtract value from its sale price.
• If the comparable is inferior to the subject (e.g., it lacks a garage that the subject has), you must add value to its sale price.

This process in Spain is formally known as homogeneización (homogenization). Instead of adding or subtracting currency amounts directly, the standard practice is to use coefficients.

• If a comp is superior, you apply a coefficient less than 1 (e.g., 0.95) to reduce its value.
• If a comp is inferior, you apply a coefficient greater than 1 (e.g., 1.05) to increase its value.

The following document provides an excellent overview of this coefficient-based approach.

This homogenization process is typically organized in a table. The image below shows a real example from a Spanish appraisal report.

4. Reconciling the Values for a Final Estimate

After adjusting each comparable, you will have a range of indicated values for your subject property—one for each comp. The final step is to reconcile these values into a single, defensible estimate of market value.

This is not a simple arithmetic mean. An appraiser gives more weight to the comparables that are most similar to the subject property and therefore required the fewest or smallest adjustments. This is often done using a weighted average, where the best comps receive the highest weight. You can see this in the "Peso Muestra (%)" (Sample Weight) column in the appraisal table image above.

The final output is often summarized in a Comparative Market Analysis (CMA) report.

Conclusion

You have now learned the complete methodology of the Sales Comparison Approach, the most fundamental valuation technique in real estate. It's a structured process that provides an objective, market-based estimate of a property's value, serving as a critical sanity check for the purchase and sale prices in your financial models.

Key Takeaways:

• The Sales Comparison Approach (SCA) determines value based on the principle of substitution.
• The process involves finding comparables ("testigos"), adjusting their sale prices for any differences with the subject property, and reconciling the adjusted values.
• In Spain, the adjustment process is called homogenization and typically uses multiplicative coefficients rather than simple additions/subtractions.
• Spanish regulations (like Orden ECO 805/2003) provide specific guidelines, such as requiring at least six comparables for mortgage appraisals.
• The final value is often a weighted average of the adjusted comparable prices, giving more importance to the most similar properties.

Preview of the Next Lesson:
Describing the methodology is the first step. The next is applying it. In our upcoming lesson, we will put this theory into practice. You will learn how to select appropriate comparable properties and apply adjustments to determine a property's value. We'll work through a detailed numerical example using the coefficient method and start thinking about how you could model this logic in Python.