What types of interest rates do loans have in UBSCM 2017-C4?

Interest Rate Distribution - UBSCM 2017-C4

UBSCM 2017-C4 has 56.3% of its pool with interest rates 4.51 - 5.00.

2025-07-30

📊 Chart Summary

UBSCM 2017-C4 has 56.3% of its pool with interest rates 4.51 - 5.00, totaling $386,977,856 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 Interest Rate Distribution

Summarize the interest rates distribution chart for the UBSCM 2017-C4 collateral pool at issuance. Identify the range of interest rates (e.g., lowest, highest, and most frequent rates). Provide a brief explanation of what this distribution implies about the underlying loans and potential risk factors.

💡 Highlight Outliers

Identify and highlight any outliers in the interest rates distribution chart for UBSCM 2017-C4. Outliers could include unusually high or low interest rates compared to the majority of the pool. Discuss how these outliers could affect the overall risk and performance of the securitization.

💡 Cluster Interest Rates

Cluster the interest rates in the interest rates distribution chart for UBSCM 2017-C4 into three ranges: Low (<4%), Medium (4%-6%), and High (>6%). Provide the percentage of loans in each cluster and discuss how this distribution might impact the deal's expected cash flow and risk profile.

💡 Compare to Market Averages

Compare the interest rates distribution chart for UBSCM 2017-C4 to market averages for CMBS Conduits issued since 2017. Highlight any deviations in the interest rate distribution and explain what this might indicate about the underwriting or borrower quality.

💡 Visualize Weighted Average Interest Rate

Calculate and visualize the weighted average interest rate (WAC) for the interest rates distribution chart in UBSCM 2017-C4. Add an annotation to the chart showing the WAC and compare it to the median interest rate. Explain any differences between the two and their potential implications.

💡 Highlight Risk Concentration

Analyze the interest rates distribution chart for UBSCM 2017-C4 to identify any concentration of loans in higher risk categories (e.g., interest rates >6%). Highlight these in the chart and discuss how this concentration could impact prepayment risk and default likelihood.

💡 Create a Heatmap of Loan Counts

Create a heatmap visualization for the interest rates distribution chart of UBSCM 2017-C4 where the x-axis represents the interest rate ranges and the y-axis represents the count of loans. Use color intensity to represent higher or lower loan counts. Discuss which ranges dominate the collateral pool and their implications.

💡 Generate a Tail Risk Analysis

Perform a tail risk analysis on the interest rates distribution chart for UBSCM 2017-C4. Focus on the loans with the top 10% highest interest rates. Highlight their total percentage of the pool and discuss how these high-interest loans could influence cash flow volatility and default risk.

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