1,092 deals

Why and How We Made the Geographic Distribution by State for CMBS Deals

Explore the CMBS collateral distribution chart to understand the distribution of multifamily collateral in CMBS deals. See how we use a metadata-first approach to compare collateral levels across deals and provide actionable insights for investment and risk assessment.

How we made this chart

The following chart uses the CREFC Property Type code and the Report Period End Actual Balance Amount from the Reg AB II Asset-level Requirements, Form ABS-EE for this deal. If you are keen to see distribution by most recent valuation, property size or another metric,  email us.

See all available CMBS deals  with this chart.

Why we made this chart

The SEC.gov ABS-EE filing is freely available to everyone and contains extremely valuable information about loans and properties in Commercial Mortgage Backed Securities (CMBS) deals. We discuss some of the ways to access this information on the Data Sources page. Dealcharts.org is able to leverage our data pipelines to produce charts from this free data that you can download and re-use in your work. These charts are fairly simple but hopefully they can provide value in a number of possible ways:

  1. Save you time from creating the chart yourself if you just need a super quick confirmation.
  2. A place where you can double check your work. Verify a chart you have created against one of ours - data from two sources is better than one!
  3. Discover new datasets and their capabilities to answer questions - then go get the dataset and do your own analytics!
  4. Discover new styles of charts and new visualization techniques - get inspired by our talented Creators.
  5. Re-use our charts in your own committee documents or investor presentations. We can make the simple charts for you so you have more time to make the hard ones.

How We Made This Chart Our geographic distribution chart highlights the top 5 states for CMBS deals based on the percentage of the pool. Here’s a detailed look at how we created this chart using our metadata-first data strategy:

Collecting Metadata:

We began by collecting metadata from the Reg AB II Asset-level Requirements. Specifically, we focused on the state of each property and its corresponding balance within the CMBS deal. This involved gathering data schemas and identifying key data points such as property location and their share of the total pool. Curating Metadata:

After collecting the raw metadata, we curated it to focus on the most relevant information for visualizing geographic distribution. This involved filtering the data to include only the states with the highest percentages of the total pool. We organized the data to highlight the top 5 states, making it easy to compare their contributions to the overall pool of the CMBS deal. Operationalizing Metadata:

Using our advanced data pipelines, we transformed the curated metadata into a visual format. This process involved automating the creation of tables that clearly represent the top states by percentage of the pool. We also created versions for the top 10 states and all states within the deal, ensuring comprehensive coverage and flexibility for different analytical needs. If you want to see distribution by other metrics such as property type or loan size, feel free to email us.

You can also explore all available CMBS deals with this chart.

Why This Chart Is Valuable This geographic distribution chart provides a clear view of which states have the highest concentration of properties within a CMBS deal. This can help answer questions like, "Which states are most prominent in this CMBS deal?" By offering this insight, the chart can be particularly useful for:

Investment Decision-Making: Quickly assess the geographic concentration of properties to inform investment strategies and risk assessments. Portfolio Management: Evaluate how the geographic distribution of properties within individual deals fits within the broader context of your investment portfolio. Risk Assessment: Identify states with high concentrations of properties, which may indicate higher regional risks or opportunities. Market Analysis: Understand broader trends in the CMBS market regarding geographic distribution and property concentration. Real-World Applications To illustrate the practical applications of this chart, consider the following scenarios:

Investment Analysis: An investment manager uses the chart to compare the geographic distribution of properties in a potential new deal against existing CMBS deals in the market, aiding in investment decisions. Regulatory Reporting: A compliance officer examines the chart to ensure that the geographic distribution of properties in the bank’s CMBS deals aligns with regulatory expectations and industry standards. Market Research: A research analyst includes the geographic distribution chart in a market report, providing clients with insights into the prominence of different states in CMBS deals. By following a metadata-first data strategy—collecting, curating, and operationalizing metadata—we can efficiently produce valuable insights and visualizations. This approach allows us to autogenerate detailed geographic distribution charts, saving you time and providing reliable verification.

We hope this chart saves you time, inspires new insights, and provides reliable verification.

Meta Description: "Explore the geographic distribution of CMBS deals with our Top 5 States chart. Learn how we used a metadata-first approach to create valuable insights into property concentration and regional trends."

Alt Text: ""

This draft should highlight the unique aspects of the geographic distribution chart while avoiding overlap with previous posts. Let me know if there are any other details you’d like to add!