The client, a Real Estate Private Equity Firm based out of the U.S., wanted the TresVista Team to prepare a comprehensive study on 50 major cities in the U.S, based on the weighted average score of 18 fundamentals, which would help them in evaluating these cities to further diversify their portfolio. The client asked the team to derive takeaways on how the specific cities were performing based on the latest macro fundamentals and rank the cities based on their performance.
To prepare a comprehensive study on fifty major cities in the U.S., derive takeaways on how the specific cities were performing, and provide rankings to each city based on the macro fundamentals.
The TresVista Team followed the following process:
The major hurdle faced by the TresVista Team was the unavailability of credible government sources for city-wise data, except for the population and discrepancies in the data provided by other private sources.
The team overcame the hurdle by broadening its scope to MSAs for the respective cities. MSAs serve to group cities into specific geographic areas for population censuses and the compilation of related statistical data.
The TresVista Team proposed a ranking system based on a weighted average score, emphasizing the importance of each parameter. Additionally, two layers of screening were provided:
The team also added the flexibility to provide a score based on quartile, quintile, or decile.