Loan Structure - BANK 2018-BNK15
BANK 2018-BNK15 has 28.5% of its pool as Pari Passu.
Chart Summary
BANK 2018-BNK15 has 28.5% of its pool as Pari Passu, totaling $270,323,205 in unpaid principle balance according to Edgar sec.gov filings. The reporting period for this information begins 2024-11-13 and ends 2024-12-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, Google Bard, 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 BANK 2018-BNK15. 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 BANK 2018-BNK15 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 BANK 2018-BNK15, 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 BANK 2018-BNK15 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 BANK 2018-BNK15, 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 BANK 2018-BNK15. 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 BANK 2018-BNK15. 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 BANK 2018-BNK15 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 BANK 2018-BNK15 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.
Other Links
Get the data
Dataset used to create this chart
Exact curated dataset used to create this chart and other charts on this site.
XML datasets for CMBS deals
Raw XML filings from sec.gov that include this data and more for in-depth analysis.
CREFC IRP standardized datasets
Get the standardized dataset following the CREFC IRP format, ideal for advanced reporting and analysis.