Decoding Supply & Demand Indicators

Hello! Welcome back to our module on Market Analysis.

In our last lesson, we focused on the fundamental drivers of housing demand: population, job, and income growth. You learned how to analyze these key demographic indicators and even wrote a Python script to start pulling this data directly from Spain's National Statistics Institute (INE).

Today, we move to the other side of the equation. Demand is only half the story; we must also understand supply and, crucially, the dynamic balance between the two. This lesson fulfills the learning outcome: Calculate and interpret supply/demand indicators like absorption rate, months of supply, and price-to-rent ratio.

These metrics act as a barometer for market pressure. They tell you how quickly properties are selling and whether prices are justified by underlying rental values. By the end of this lesson, you'll be able to diagnose a market's health, determining if it's a hot seller's market, a balanced market, or a cool buyer's market.

1. Market Pace: Months of Supply & Absorption Rate

Two of the most important indicators for gauging the pace of a market are Months of Supply and Absorption Rate. They are essentially two sides of the same coin, measuring the relationship between the available inventory of homes and the rate at which those homes are being sold.

To dive into these concepts within the Spanish market, we'll use an excellent article that explains them with local context.

As you've just read, these two metrics give us a powerful snapshot of market liquidity. Let's consolidate the key ideas.

Months of Supply (Meses de Inventario)

This metric answers the question: "If no new properties were listed, how long would it take to sell all the current homes for sale at the current sales pace?"

• Formula: $$\text{Months of Supply}=\frac{\text{Total Homes for Sale (Inventory)}}{\text{Number of Homes Sold per Month}}$$
• Interpretation (Spanish Market Rule of Thumb):
  • 0-3 Months: A Seller's Market (Mercado Vendedor). Demand outstrips supply. Prices are likely rising, and properties sell quickly.
  • 4-6 Months: A Balanced Market (Mercado Neutro). Supply and demand are roughly in equilibrium. Prices are stable, and negotiations are fair.
  • > 6 Months: A Buyer's Market (Mercado Comprador). Supply exceeds demand. Prices may be stagnant or falling, giving buyers more leverage.

Absorption Rate (Tasa de Absorción)

This metric is the inverse and answers the question: "What percentage of the available inventory is sold each month?"

• Formula: \text{Absorption Rate (%)}= \frac{\text{Number of Homes Sold per Month}}{\text{Total Homes for Sale (Inventory)}} \times 100
• Interpretation:
  • > 20%: Very high liquidity (Seller's Market).
  • 10% - 20%: Healthy liquidity (Balanced Market).
  • < 10%: Slow sales (Buyer's Market).

The relationship is simple and inverse: a market with an absorption rate of 10% has approximately 10 months of supply (100 / 10 = 10).

The image below provides a great visual summary of these concepts. Note that the exact month ranges can vary slightly by analyst, but the underlying principle is the same. The ranges from the Spanish resource we just read are your best guide for the local market.

The Practical Challenge: Data Sourcing

Calculating these metrics is straightforward; getting the data is the hard part. The Parlantia article provides a good roadmap for this process.

As the article highlights, this is where your data engineering skills become a significant advantage.

• Inventory Data: This is the "easier" part. You can scrape data from major Spanish portals like Idealista or Fotocasa (always respecting their terms of service and robots.txt). The key challenge is data cleaning: deduplicating listings for the same property announced by multiple agencies.
• Sales Data: This is much harder to obtain in real-time. Official sources like Registradores de España or the Ministerio de Transportes publish this data with a time lag. Some professional real estate analytics platforms provide this data, but often at a significant cost. For now, you can rely on published reports from these sources or major real estate consultancies.

2. Market Value: The Price-to-Rent Ratio

Now let's shift from the pace of the market to its value. The Price-to-Rent Ratio, often called the PER (Price-to-Earnings Ratio) in a real estate context, helps answer the question: "Are property prices in this market cheap or expensive relative to what it costs to rent here?"

This metric is invaluable for deciding whether it's financially more sensible to buy or rent in a given area and for spotting potentially overvalued or undervalued markets.

Let's break down the core concept from the article.

• Formula: $$\text{PER}=\frac{\text{Property Purchase Price}}{\text{Annual Gross Rent}}$$
• Intuition: The PER tells you the number of years of gross rent required to cover the property's purchase price. A higher PER means it's more expensive to buy relative to renting.
• Interpretation: You compare a specific property's or market's PER to a benchmark, such as the national average. The Bankinter article uses data from the Banco de España to calculate a national average PER of 32.2.
  • If PER_property < 32.2: The property is relatively cheap to buy compared to the Spanish average. The numbers suggest buying is favorable.
  • If PER_property > 32.2: The property is relatively expensive to buy. The numbers suggest renting might be more financially prudent.

Example from the article: A property is for sale at €400,000 and can be rented for €1,000/month (€12,000/year).

• PER = €400,000 / €12,000 = 33.3
• Conclusion: Since 33.3 is higher than the national average of 32.2, this property is considered expensive to buy. You'd need more than 33 years of rent to pay for it, which is longer than the average.

This is a powerful, quick valuation tool. When you see a property for sale, you can immediately find comparable rental listings in the area, calculate the PER, and see how it stacks up against the market average.

Conclusion

Today you've added three essential market analysis indicators to your toolkit, moving from the macro demand drivers to the dynamic balance of supply and demand.

Key Takeaways:

• Months of Supply and Absorption Rate measure the pace of a market, helping you identify whether it favors buyers or sellers. A low supply (< 6 months) indicates a fast-moving seller's market.
• The Price-to-Rent Ratio (PER) measures the relative value of buying versus renting. It helps you judge if prices in a market are justified by the rents they can command.
• Data for these metrics in Spain can be found through portals, official registrar publications, and reports from the Banco de España, though real-time sales data can be challenging to source.
• These indicators should be used in tandem. A market with a low PER and a high absorption rate is a very different investment proposition than one with a high PER and a low absorption rate.

Preview of the Next Lesson:
Numbers don't tell the whole story. A market can have great metrics on paper, but what is it actually like to live there? In our next lesson, we will move beyond the quantitative to assess qualitative neighborhood factors like school ratings, crime statistics, and walkability scores. These factors are crucial drivers of desirability and can have a major impact on a property's long-term value and your ability to attract high-quality tenants.