Monthly Rental Stats

On the 5th of each month, we generate rental statistics for the previous month. This process involves analyzing data for single-family residences (SFRs) and duplexes. The data encompasses various key metrics and examines their trends and relationships over different time periods.

OC is responsible for this task. If the 5th falls on one of the OC's off days, then LC1 picks up this task.

Below is the structure and breakdown of key components

Structure of the Data:

Sheets: Each sheet corresponds to a specific month and year (e.g., "3-2025" for March 2025, "12-2024" for December 2024, etc.).
Rows: The rows include metrics such as Total Leases, New Listings, Average Sold Price, Median Sold price, and Average Days on Market. There are also columns for percentage changes over time.
Time Periods: This sheet shows a time period of 12 months.

Key Metrics:

Total Leases: The number of leases signed for SFRs and Duplexes.
New Listings: The number of new properties listed for rent.
Average Sold Price: The average price at which properties are leased.
Median Sold Price: The median price at which properties are leased.
Average Days on Market: The average number of days a property stays on the market before being leased.
Percentage Change: Calculated as the percentage change in each metric from one year to the next.

Trends and Observations:

The above charts show the relationship between SFR average and median rental rates of February 2025
The second chart shows the relationship between the SFR units leased and the new listings for February 2025.
Note: the image with average and median rates should have a $2k minimum on the associated axis. The image with unit leased and new listing rates should have a $1k minimum on the associated axis.

How to Generate the Stats

Note: When generating data for Avg Sold Price and Median Sold Price, make sure to set/check the MLS section to “Unlock MLS” to generate the most accurate data.

Please see the attached Loom for reference:

https://www.loom.com/share/833d7ffe20fd4b5da3bd006b2f95440b

Here is the sheet to use: https://docs.google.com/spreadsheets/d/1rxXz1tQoj3k-jkPychWyRedbHIpeHfGJssZOV-ZuLXI/edit?gid=1886743510#gid=1886743510

After doing it, send an email to Bilal (cc Adrienne) so he can create graphics out of that data.