BC Housing Affordability for Renters

ALY6070 ยท GROUP 1 ยท June 23rd 2026

BC Housing Affordability
for Renters

An analysis of 196 observations across 7 British Columbia (BC) Census Metropolitan Areas (CMA) from 2019 to 2025, examining the Rent-to-Income Ratio (RTIR) and affordability stress under the Canada Mortgage and Housing Corporation (CMHC) 30% standard.

7
CMAs Analyzed
28
Quarters 2019โ€“2025
45.6%
Peak RTIR โ€” Vancouver 2-Bedroom
30%
CMHC Affordability Limit
Jiayi Chen
Dashboard 1 โ€” Regional Rent Comparison
R SHINY
Tzu-Ying Yang
Dashboard 2 โ€” Rent Trends Over Time
R SHINY TABLEAU
Lissette Diaz
Dashboard 3 โ€” Affordability Analysis ยท EDA ยท Dataset
R SHINY TABLEAU

Business Question

Is renting becoming less affordable across BC's major cities โ€” and which regions are most at risk for renters?

6 Research Questions

  1. How have asking rents changed across BC CMAs from 2019 to 2025, and which unit types saw the greatest increases?
  2. Which CMAs are the most and least expensive, and how does market rent compare to quarterly rent paid?
  3. In which CMAs are renters spending more than 30% of income on housing, and how has this changed over time?
  4. Where in BC is renting least affordable?
  5. Is rent rising faster than income โ€” and is that what's driving the affordability gap?
  6. How has each CMA's affordability ranking shifted over time?
2

Data Cleaning & EDA

Lissette Diaz ยท EDA

Dataset Summary

Attribute Value
Source BC Data Catalogue โ€” Rental Market
Observations 196 (7 CMAs ร— 28 quarters)
Period Q1 2019 โ€“ Q4 2025
Unit types 1 Bedroom (1BR) ยท 2 Bedroom (2BR)
Key metric RTIR = (Rent ร— 12) / Income

Cleaning Decisions

โŒ 3BR dropped โ€” 57.7% missing values
โŒ Quarterly Rent dropped โ€” Asking Rent is the market signal
โœ… 0 impossible RTIR values after cleaning
โœ… Income verified against StatsCan benchmarks
โœ… Rentโ€“RTIR correlation: r โ‰ˆ 0.95
โœ… Only Vancouver crossed 30% RTIR for 1 Bedroom
๐Ÿ”ด 3 cities crossed 30% for 2 Bedroom: Vancouver, Kelowna, Victoria
EDA โ€” Rent vs. RTIR Correlation: Higher rents = Less affordable. How strong is the link?

3

Regional Rent Comparison

Jiayi Chen ยท Dashboard 1
Rent Distribution by City & Unit Type

๐Ÿ’ฐ Vancouver: widest rent range
Highest variability โ€” luxury units push upper quartile far above median
๐Ÿ  1BR vs 2BR gap
Two-bedroom units cost 45โ€“65% more across all cities throughout the study period
โœ… Kamloops & Chilliwack most affordable
Remain below $1,600/mo for 1BR โ€” consistently under median income stress
โšก Kelowna fastest growth
Overtook Victoria for 2BR median rent in 2022; driven by remote worker migration
RENT GROWTH 2019 โ†’ 2025 BY CITY

4

Rent Trends Over Time

Tzu-Ying Yang ยท Dashboard 2
Avg 1BR Asking Rent by City (2019โ€“2025)

Avg 2BR Asking Rent by City (2019โ€“2025)

1BR Rent: 2019 vs 2025

๐Ÿ™๏ธ Vancouver leads every year
Avg 1BR exceeded $2,000/mo โ€” highest across all 7 CMAs
๐Ÿ“ˆ Post-COVID surge 2020โ€“2023
All CMAs saw 26โ€“55% rent increases; Nanaimo grew fastest (+55%), followed by Abbotsford-Mission (+49%)
๐Ÿ™๏ธ Vancouver: highest absolute rent, smallest % growth
Rose from $1,882 to $2,368 (+26%) โ€” the lowest growth rate among all 7 CMAs, yet remains the most expensive by far
๐Ÿ“Š Smaller cities are catching up
Nanaimo, Abbotsford-Mission, and Kamloops all grew faster than Vancouver โ€” the rent gap between large and small CMAs is narrowing

Tableau T2 โ€” Rent vs.ย Income Over Time (1BR) ยท By City

Rent vs Income 1BR โ€” All BC
Rent vs Income 1BR โ€” Vancouver
Rent vs Income 1BR โ€” Victoria
Rent vs Income 1BR โ€” Kelowna
Rent vs Income 1BR โ€” Kamloops
Rent vs Income 1BR โ€” Chilliwack
Rent vs Income 1BR โ€” Abbotsford-Mission
Rent vs Income 1BR โ€” Nanaimo
๐Ÿ”ด Red = Asking Rent (1BR, monthly) ย ยทย  ๐ŸŸข Green = Implied Annual Income
The green line shows the annual household income implied by the RTIR (i.e.ย income = rent ร— 12 รท RTIR%). It is a derived benchmark โ€” not independently surveyed household income. When rent rises faster than this implied income, affordability is worsening.
5

Affordability Analysis

Lissette Diaz ยท Dashboard 3
2BR RTIR Heatmap โ€” Affordability by City & Year

Tableau T3 โ€” Affordability Ranking & RTIR Trend

๐ŸŸฅ Vancouver = #1 least affordable โ€” every year
2BR RTIR peaked at 45.6% in Q3 2023 โ€” renters spent nearly half their income
๐Ÿ“ 3 cities crossed 30% threshold for 2BR
Vancouver, Kelowna, and Victoria all exceeded the CMHC affordability limit
6

Conclusions & Call to Action

๐Ÿ 
Vancouver's 2BR RTIR peaked at 45.6% in Q3 2023 โ€” nearly 3ร— the CMHC 30% guideline
๐Ÿ“ˆ
Rents rose 26โ€“55% province-wide between 2019โ€“2025; implied household income grew 19โ€“30% by CMA โ€” the gap is widest in Nanaimo and Abbotsford-Mission
๐ŸŒ
Affordability stress is spreading โ€” Kelowna and Victoria crossed 30% RTIR for 2BR; smaller cities converging
๐Ÿ“Š
Rent growth, not income decline, is the primary driver of unaffordability (r โ‰ˆ 0.95)
๐Ÿ””
Policymakers should monitor RTIR thresholds โ€” not just median rents โ€” to target housing subsidies effectively

Story Across 3 Dashboards

โ‘  Rent Trends (Tzu-Ying)
Rents climbed steadily post-COVID in all 7 CMAs; Nanaimo grew fastest (+55%) while Vancouver remained most expensive

โ‘ก Regional Comparison (Jiayi)
Wide variation exists โ€” Kamloops remains affordable while coastal & resort cities surge

โ‘ข Affordability Analysis (Lissette)
Converting rent to % of income reveals the real crisis โ€” RTIR heatmap & Tableau Story show few cities remain under 30% for 2BR

"BC's rental affordability crisis is real, measurable, and spreading into secondary markets."
ALY6070 ยท Communication and Visualization for Data Analytics ยท Northeastern University ยท Spring B 2026 ยท Group 1