CMBS Case Study

For a 4-hour CMBS case study, here's how you can approach it based on the most helpful WSO content:

1. Understand the Case Context (Hour 1):

• Review Materials: Start by thoroughly reading any provided SEC filings, offering memorandums, investor presentations, or sell-side research. Take detailed notes on the business, key metrics, and any standout information.
• Focus on CMBS-Specific Metrics: Pay attention to loan-level details, property types, DSCR (Debt Service Coverage Ratio), LTV (Loan-to-Value), and prepayment terms. These are critical in CMBS underwriting.
• Identify Revenue Drivers: Understand the cash flow drivers for the underlying properties or portfolios. This could include rental income, occupancy rates, or lease terms.

2. Build a Simplified CMBS Model (Hours 2-3):

• Loan-Level Analysis: Model out the cash flows for the loans in the CMBS pool. This includes:
  • Interest and Principal Payments: Calculate these based on the loan terms (fixed or floating rate).
  • Stress Testing: Build in functionality to adjust key sensitivities like interest rate changes, default rates, or prepayment speeds.
• Pool-Level Aggregation: Combine the individual loan cash flows to create a pool-level cash flow model.
• Tranche Analysis: If required, allocate cash flows to different tranches (senior, mezzanine, junior) based on the waterfall structure.
• Key Outputs: Ensure your model outputs metrics like DSCR, LTV, and yield for the pool and tranches.

3. Develop Your Recommendation and Pitch (Hours 3-4):

• Analyze Results: Compare your model outputs to any benchmarks or guidance provided. Highlight key risks (e.g., high LTV loans, low DSCR properties) and opportunities (e.g., strong property markets, stable cash flows).
• Draft Your Investment Thesis: Clearly articulate whether you would invest in the CMBS pool and why. Include:
  • Strategic rationale (e.g., diversification, yield enhancement).
  • Key risks and mitigants (e.g., geographic concentration, tenant quality).
• Prepare Exhibits: Create sensitivity analyses or charts to support your thesis.

4. Additional Tips:

• Focus on Articulating Assumptions: Be ready to explain your assumptions for cash flow projections, default rates, and prepayment speeds.
• Highlight Risks and Mitigants: CMBS pools often have diverse risks. Show that you understand these and can think critically about them.
• Time Management: Stick to the timeline. Avoid overcomplicating the model—focus on delivering a clear, concise analysis.

If you're looking for more structured preparation, consider WSO's Real Estate Master Program or Financial Modeling Resources, which include CMBS modeling and other relevant training. Good luck!

Sources: How would you approach a 4 hour case study?, Math behind pricing a CMBS loan, 2-hour Modeling Test for HF (Fundemental Equities) - What to expect?, Real Estate Modelling Test Practice, Q&A: Corporate Banking to FAANG CD