Mortgage rates surged at an unprecedented pace in 2022, with the average 10-year fixed rate doubling between March and December of that year. In response to mounting inflation, the Bank of England implemented a series of rate hikes, pushing borrowing costs steadily higher. By October 2025, the average 10-year fixed mortgage rate stood at **** percent. As financing becomes more expensive, housing demand has cooled, weighing on market sentiment and slowing house price growth. How have the mortgage hikes affected the market? After surging in 2021, the number of residential properties sold fell significantly in 2023, dipping to just above *** million transactions. This contraction in activity also dampened mortgage lending. Between the first quarter of 2023 and the first quarter of 2024, the value of new mortgage loans declined year-on-year for five consecutive quarters. Even as rates eased modestly in 2024 and housing activity picked up slightly, volumes remained well below the highs recorded in 2021. How are higher mortgages impacting homebuyers? For homeowners, the impact is being felt most acutely as fixed-rate deals expire. Mortgage terms in the UK typically range from two to ten years, and many borrowers who locked in historically low rates are now facing significantly higher repayments when refinancing. By the end of 2026, an estimated five million homeowners will see their mortgage deals expire. Roughly two million of these loans are projected to experience a monthly payment increase of up to *** British pounds by 2026, putting additional pressure on household budgets and constraining affordability across the market.

Rental Affordability Analysis Based on Median Income

Trends in Tier-Based Affordability Across the U.S

By Zillow Data [source]

About this dataset

This dataset contains rental affordability data for different regions in the US, giving valuable insights into regional rental markets. Renters can use this information to identify where their budget will go the farthest. The cities are organized by rent tier in order to analyze affordability trends within and between different housing stock types. Within each region, the data includes median household income, Zillow Rent Index (ZRI), and percent of income spent on rent.

The Zillow Home Value Forecast (ZHVF) is used to calculate future combined mortgage pay/rent payments in each region using current median home prices, actual outstanding debt amounts and 30-year fixed mortgage interest rates reported through partnership with TransUnion credit bureau. Zillow also provides a breakdown of cash vs financing purchases for buyers looking for an investment or cash option solution.

This dataset provides an effective tool for consumers who want to better understand how their budget fits into diverse rental markets across the US; from condominiums and co-ops, multifamily residences with five or more units, duplexes and triplexes - every renter can determine how their housing budget should be adjusted as they consider multiple living possibilities throughout the country based on real-time price data!

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

Introduction

Getting Started

• First, you'll need to download the TieredAffordability_Rental.csv dataset from this Kaggle page onto your computer or device.

• After downloading the data set onto your device, open it with any CSV viewing software of your choice (ex: Excel). It will include columns for RegionName**RegionName** , homes type/housing stock (All Homes or Condo/Co-op) SizeRank , Rent tier tier , Date date , median household income income , Zillow Rent Index zri and PercentIncomeSpentOnRent percentage (what portion of monthly median house-hold goes toward monthly mortgage payment) .

• To begin analyzing rental prices across different regions using this dataset, look first at column four: SizeRank; which ranks each region based on size - smallest regions listed first and largest at last - so that you can compare a similar range of Regions when looking at affordability by home sizes larger than one unit multiplex dwellings.*Duples/Triplex*. Once there is an understanding of how all homes compare overall now it is time to consider home types Multifamily 5+ units according to rent tiers tier .

• Next, choose one or more region(s) for comparison based on their rank in SizeRank column –so that all information gathered about them reflects what portionof households fall into certain categories ; eg; All Homes / Small Home /Large Home / MultiPlex Dwelling and what tier does each size rank falls into eg.: Affordable/Slightly Expensive/ Moderately Expensive etc.. This will enable further abstraction from other elements like date vs inflation rate per month or periodical intervals set herein by Rate segmentation i e dates givenin ‘Date’Columns – making the task easier and more direct while analyzing renatalAffordibility Analysis Based On Median Income zri 00 zwi & PCISOR 00 PCIRO

Research Ideas

• Use the PercentIncomeSpentOnRent column to compare rental affordability between regions within a particular tier and determine optimal rent tiers for relocating families.
• Analyze how market conditions are affecting rental affordability over time by using the income, zri, and PercentageIncomeSpentOnRent columns.
• Identify trends in housing prices for different tiers over the years by comparing SizeRank data with Zillow Home Value Forecast (ZHVF) numbers across different regions in order to identify locations that may be headed up or down in terms of home values (and therefore rent levels)

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

See the dataset description for more information.

Columns

File: TieredAffordability_Rental.csv | Column name | Description | |:-----------------------------|:-------------------------------------------------------------| | RegionName | The name of the region. (String) ...

European Union EU27: DG ECFIN Forecast: General Government Budget: % of Nominal GDP: Net Lending/Borrowing: excl Interest: Cyclical Component Adjusted data was reported at -1.054 % in 2026. This records an increase from the previous number of -1.077 % for 2025. European Union EU27: DG ECFIN Forecast: General Government Budget: % of Nominal GDP: Net Lending/Borrowing: excl Interest: Cyclical Component Adjusted data is updated yearly, averaging 0.182 % from Dec 1995 (Median) to 2026, with 32 observations. The data reached an all-time high of 2.528 % in 1997 and a record low of -3.139 % in 2021. European Union EU27: DG ECFIN Forecast: General Government Budget: % of Nominal GDP: Net Lending/Borrowing: excl Interest: Cyclical Component Adjusted data remains active status in CEIC and is reported by European Commission's Directorate-General for Economic and Financial Affairs. The data is categorized under Global Database’s European Union – Table EU.DG ECFIN.AMECO: General Government Budget: % of Nominal GDP: Forecast.

The benchmark interest rate in Pakistan was last recorded at 11 percent. This dataset provides - Pakistan Interest Rate - actual values, historical data, forecast, chart, statistics, economic calendar and news.

Homeowners in financial distress can use bankruptcy to avoid defaulting on their mortgages, since filing loosens their budget constraints. But the 2005 bankruptcy reform made bankruptcy less favorable to homeowners and therefore caused mortgage defaults to rise. We test this relationship and find that the reform caused prime and subprime mortgage default rates to rise by 23% and 14%, respectively. Default rates rose even more for homeowners who were particularly negatively affected by the reform. We calculate that bankruptcy reform caused mortgage default rates to rise by one percentage point even before the start of the financial crisis. (JEL D14, G01, G21, K35)

European Union EU27: DG ECFIN Forecast: General Government Budget: Net Lending/Borrowing: excl Interest data was reported at -165.849 EUR bn in 2026. This records an increase from the previous number of -190.920 EUR bn for 2025. European Union EU27: DG ECFIN Forecast: General Government Budget: Net Lending/Borrowing: excl Interest data is updated yearly, averaging 28.994 EUR bn from Dec 1995 (Median) to 2026, with 32 observations. The data reached an all-time high of 233.667 EUR bn in 2007 and a record low of -715.078 EUR bn in 2020. European Union EU27: DG ECFIN Forecast: General Government Budget: Net Lending/Borrowing: excl Interest data remains active status in CEIC and is reported by European Commission's Directorate-General for Economic and Financial Affairs. The data is categorized under Global Database’s European Union – Table EU.DG ECFIN.AMECO: General Government Budget: Forecast.