What loan structures are in UBSCM 2017-C4?

Loan Structure - UBSCM 2017-C4

UBSCM 2017-C4 has 20.3% of its pool as Pari Passu.

2025-07-30

📊 Chart Summary

UBSCM 2017-C4 has 20.3% of its pool as Pari Passu, totaling $139,607,878 in unpaid principle balance according to Edgar sec.gov filings. The reporting period for this information begins 2025-06-12 and ends 2025-07-11.

Prompts

Explore a variety of thoughtfully crafted prompts below, each tailored for specific use cases. Each card includes a convenient copy-paste button that lets you seamlessly transfer the prompt into your favorite AI tool. Whether you're using ChatGPT, Microsoft Copilot, Gemini, Grok, Perplexity, or Claude, these prompts are designed to help you unlock new insights and ideas. Simply click 'Copy' to get started!

Summarize Loan Structure

Summarize the loan structure table for UBSCM 2017-C4. Break down the total number of loans, the total UPB, and the percentage of the pool for each loan structure category (Whole Loan, Pari Passu, Senior A/B, etc.). Highlight the dominant structure and its implications for risk and liquidity.

Highlight Concentration Risk

Analyze the loan structure table for UBSCM 2017-C4 and identify any concentration risks. Specifically, focus on categories that account for more than 50% of the pool, such as Whole Loans. Explain how such concentration might affect the deal's performance and diversification.

Calculate Weighted Average Metrics

Using the loan structure table for UBSCM 2017-C4, calculate the weighted average metrics for the pool based on the UPB (e.g., average loan size or percentage of pool per loan structure). Include these weighted averages in a summary table and explain how they provide insights into the pool composition.

Visualize Loan Structure Distribution (Bar Chart)

Create a bar chart visualization of the loan structure table for UBSCM 2017-C4 showing the percentage of the pool (% of Pool) for each loan structure. Use distinct colors for each category and annotate the chart with the exact percentages. Provide a brief explanation of which categories dominate and why.

Visualize Loan Count Distribution (Pie Chart)

Create a pie chart based on the loan structure table for UBSCM 2017-C4, using the "# Loans" column as the basis for the chart. Label each slice with the loan structure category and the corresponding number of loans. Provide insights into the distribution of loan structures by count.

Stacked Bar Chart for Loan Structure Metrics

Create a stacked bar chart based on the loan structure table for UBSCM 2017-C4. Each bar should represent a loan structure category (Whole Loan, Pari Passu, etc.), with segments showing the UPB ($) and the % of Pool. Use color coding to differentiate the segments and provide a legend.

Assess Structural Complexity

Assess the structural complexity of the loan structure table for UBSCM 2017-C4. Specifically, discuss the presence (or absence) of Senior A/B or Mezzanine loans and how this simplicity or complexity could affect investor confidence and deal execution.

Create a Heatmap of Loan Concentration

Create a heatmap visualization for the loan structure table of UBSCM 2017-C4 where the x-axis represents loan structures (Whole Loan, Pari Passu, etc.) and the y-axis represents their percentage of the pool. Use color intensity to indicate higher or lower concentrations of loans in each structure.

Risk Concentration by Loan Type (Column Chart)

Create a column chart for UBSCM 2017-C4 showing the UPB ($) for each loan structure category. Highlight the categories with the largest contributions to the pool. Use a different color to emphasize any structures that account for more than 50% of the total UPB.

Get the data

Dataset used to create this chart

Exact curated dataset used to create this chart and other charts on this site.

Go to Marketplace

Free

XML datasets for CMBS deals

Raw XML filings from sec.gov that include this data and more for in-depth analysis.

Go to Marketplace Data Dictionary

Paid

CREFC IRP standardized datasets

Get the standardized dataset following the CREFC IRP format, ideal for advanced reporting and analysis.

Go to Marketplace Data Dictionary

Paid