European Bank RE Debt Modeling Test – Senior Analyst

For a Senior Analyst/Associate role in a European Real Estate & Hospitality Finance team, based on the most helpful WSO content, here’s what you can expect in the modeling test:

1. Core Focus Areas:

   • Property-Level Cash Flow Analysis: Expect to build or analyze cash flow models for stabilized CRE assets. This could include calculating net operating income (NOI), debt service coverage ratio (DSCR), and loan-to-value (LTV) metrics.
   • Debt Sizing and Loan Economics: You might need to size loans based on DSCR or LTV constraints, and calculate interest coverage ratios or other key metrics.
   • Sensitivity Analysis: Be prepared to run sensitivities on key variables like cap rates, interest rates, and rental growth assumptions.
   • Construction Financing: Given your background, you might encounter questions on drawdowns, interest capitalization, and loan-to-cost (LTC) metrics.
   • Hospitality-Specific Models: If the test includes hotels, you may need to model operating metrics like average daily rate (ADR), occupancy, and revenue per available room (RevPAR).

2. Potential Advanced Scenarios:

   • Syndication and Loan Structuring: You could be asked to model scenarios involving loan syndication, including tranche structuring and pricing.
   • Mixed-Use or Multi-Asset Portfolios: Tests might include analyzing portfolios with diverse asset classes (e.g., logistics, retail, and office).
   • Detailed Loan Economics: This could involve calculating lender returns, break-even points, or stress-testing loan performance under adverse scenarios.

3. Preparation Resources:

   • Practice Models: The WSO Real Estate Modeling Course offers templates and practice cases that cover cash flow modeling, debt sizing, and sensitivity analysis.
   • Hospitality-Specific Practice: If you’re less familiar with hotel models, focus on understanding key operating metrics and how they flow into cash flow projections.
   • Financial Modeling Templates: Downloadable templates from WSO’s library can help you practice building and analyzing models efficiently.

4. Tips for Success:

   • Speed and Accuracy: Time constraints are common in these tests, so practice building models quickly while maintaining accuracy.
   • Focus on Key Metrics: Ensure you’re comfortable calculating and interpreting DSCR, LTV, LTC, and other critical ratios.
   • Scenario Analysis: Be ready to explain the impact of changes in assumptions on cash flows and loan metrics.

For additional practice, consider exploring the WSO Elite Modeling Package, which includes courses on Excel modeling, financial statement analysis, and real estate-specific modeling. This will help you refine your skills and prepare for the test comprehensively.

Sources: Can anyone review my modeling test answers? - Super Modelers Wanted, https://www.wallstreetoasis.com/forum/real-estate/megafund-repe-modeling-test?customgpt=1, What can I expect: a REPE Top 5-10 modelling test?