Project: Market Data Consolidation, Filtering, and Analysis

(Demonstration Videos Below)

I built this model from scratch to evaluate investment opportunities faster and in more detail while also maintaining a national scope. Let me explain:

There are 69 Power-5 schools in the US, with most student housing data sources covering roughly 200 markets. Accuracy varies greatly between data sources, and even between types of data from the same source. Leasing patterns of each market evolve every year, affected by supply, enrollment, absorption, migration, and the operators within.

When an asset comes to market, it can be hard to know the real reason. What are the seller’s potential motivations? How are their other properties performing? Are they in need of capital? Is there an issue with the property? If there is an issue, is it operational or physical?

Truly understanding the dynamics affecting every opportunity can take time. Opportunities arise from dysfunction and dislocation, but underlying issues with a specific property, operator, or location are rarely fully disclosed. Like brokers, data services need to maintain relationships with operators, and are therefore prevented from offering many filters that could cause operators to lose leverage or strategic advantage.

This tool attempts address those challenges and more. It can answer most early questions efficiently (to the accuracy level of the primary data). It is designed to quickly combine property data from multiple sources to get a better idea of where to look, and who to look at. The tool allows the user to cover large amounts of ground quickly, which is particularly helpful for small investment teams. Currently using three primary sources, it combines over 1,000,000 data points from more than 20,000 properties and more than 1,600 universities. These data points are then converted into trends and performance metrics to understand the relationships between market drivers in any specific market selection, and to use in additional statistical analyses as required.

Searchable property data can be updated in 15-20 minutes each month, while university data updates should take no more than one hour on an annual basis. It can also be easily modified to incorporate other sources that allow large-scale data extraction in excel format.

Skip to Videos
  • Screenshot 2024-07-30 195958 - Copy.jpg

    Filter Customization Options

    A brief walkthrough of the basic search functions, filters, and output data covered by the tool.

    NOTE: All outputs are dynamic, including market and ownership rankings, supply and demand totals, and supporting charts. They repopulate each time a filter is modified.

  • Tally PL Pic.jpg

    Market Breakdown and Mapping

    Property list results are grouped and stacked by market and by owner for each property bucket (Student-Selection, Student-Markets, Conventional-Selection, Conventional-Markets). Combined performance metrics are given for each.

  • S&D Pic.jpg

    Supply & Demand Performance Analysis

    Perform an instant supply and demand analysis of a single market, group of markets, single portfolio, or group of owners. Includes separately displayed on-campus, student housing, and conventional market segments. Compare owner portfolio performance against surrounding market(s) - within custom filter parameters.

  • Editor Pic2.jpg

    Base Data Editor

    Allows for quick primary data modification of filtered characteristics, including owner, year of completion, bed total, and distance from campus. Modified data is then automatically incorporated into all other analyses.

  • BlackstoneACC Pic.jpg

    Putting It Together: Sample Competitive Analysis

    Example examination of current Blackstone/ACC portfolio and its distribution, characteristics, performance vs market, competitor breakdown, supply & demand trends, and performance projections.

Down The Road

  • Transaction Data and Cap Rate Data/Trends

  • Loan Maturities and Financing Information

  • Fund Data and Asset Composition

  • Administration Changes and Strategic Initiatives

  • University Budget Breakdowns

  • State Financial Health and Stress Testing

  • FRED Market Data on Income and Housing

  • BLS Data on Migration and Employment

  • Average Replacement Costs

  • Property Tax Rates, Methodologies and Common Practices

  • Municipal Zoning Data and Maps

Unique Advantages

  • Analyze Single or Combined Owner Portfolio Performance vs Surrounding Market(s)

  • Add or Remove Specific Markets, Owners, or Property Characteristics from Searchable Universe to Create More Relevant Analyses

  • Instantly Edit All Base Property and Map Data as New Information is Discovered In-Office or During Visits

  • Compare Historical Property, Owner, Market Performance to Custom Competitive Set

  • Overlay Map Types (Topo, Commercial, Etc) to Property Performance Maps

  • Compare Current and Historical Performance (10 Years) of Any Combination of Owners, Asset Types, Markets

  • Examine Development Trend Visualizations to Clue Into Potential Barriers in Unfamiliar Markets

  • Determine Correlation of Specific Asset Characteristics to Property Performance

  • Add Scraped Data, Incorporate Multiple Sources, and Add External and Internal Sources Easily

  • Build Additional Excel Statistical Tools and Reports Using Current Outputs and Custom Filters