Analysis of Infonavit’s Mortgage Foreclosed Portfolio



Infonavit has a portfolio of several thousands of mortgage foreclosed properties. These properties concentrate disproportionately in several municipalities, so the way and the time Infonavit chooses to dispose of them will have a considerable effect on these communities. Beyond the specific approach Infonavit takes on placing its foreclosed properties back on the market, the only monitoring these dwellings receive centers around the legal procedures needed to claim the collateral. No further analysis is performed on this portfolio and the spatial dimension of the issue is hardly being considered. At the moment, Infonavit is unable to locate with reliable precision its foreclosed dwellings.

check New check Scoping check Scoping QA check Staffing check In progress check Final QA done_all Completed
This project is being scoped

Project scope (as of July 21, 2020, 11:08 a.m.)

Project goal(s)

Geocoding the records of the database to locate the houses that have been or are in the process of being mortgage foreclosed. Performing a cluster analysis to determine where the major concentrations of these properties are. Defining if there are any other factors with a strong spatial correlation that should be considered in future analysis.

Interventions and Actions

Will be defined during project scope


Currently, Infonavit tracks the procedural progress of every individual foreclosure with a system called SIAL (Legal Administration System). The SIAL database has approximately 1.4 million records which include the houses that have been foreclosed and can now be sold, those that were sold in the past, and the houses that are now in the process of foreclosure. So far, this system has been used solely for operational purposes, never for analysis meant to inform the Institute’s policies. And while the data gathering protocol could improve considerably, there is valuable information that could lead to significant findings. The databases gathered from SIAL could also be linked to other Institutional databases (underwriting, creditholder characteristics, etc.) and potentially reveal new correlations. This information could also be further analyzed using INEGI’s housing census. The Unified Housing Register (RUV) records the construction of every new house geared towards any government subsidy. RUV works closely with Infonavit; their databases could also be analyzed with SIAL’s.

Analysis Needed

While the full definition of the analysis needed will be decided during the project’s scope, we believe that geocoding and running cluster analysis to the SIAL databse is definitely necessary.

Validation Methodology

Will be defined during project scope


Will be defined during project scope

Scope version notes