1.Escrow Expansion and Housing Market Trends
KPI cards and line charts · 2026
A real estate finance analyst built a dashboard to visualize escrow deposit expansion and housing market trends from January 2015 to January 2026. The analysis features KPI cards showing a Median Sale Price of $403.2K, which is up 39.4% or $114.0K since 2015-01, and a Mortgage Rate of 6.11% that peaked at 7.30% in 2023-10. A dual-axis chart plots median sale price against mortgage rate, while an indexed comparison notes that rates nearly doubled vs 2015. This solved the challenge of aligning mismatched quarterly price and weekly rate data to visualize a 40%+ expansion in required escrow deposits.
What it shows:
How aligning mismatched frequency data reveals macroeconomic shifts impacting investment costs.




