Commercial Real Estate Modeling

Based on the most helpful WSO content, the level of modeling expected of analysts/associates on the REPE side can vary. Here are some key points:

1. Model Creation vs. Familiarity:

   • In REPE, knowing how to create an Excel model from scratch, including waterfall structuring and sensitivity analysis, is important. However, being very familiar with any model handed to you is also crucial. Many analysts tweak already-built models to their liking and use them for deal analysis.

2. Practical Application:

   • While job descriptions often mention "create" or "from scratch," in practice, many firms use standard models that can be modified or expanded as needed. This is similar to brokerage shops where templates are commonly used and adjusted for specific deals.

3. Skill Utilization:

   • Some professionals in REPE may not frequently build models from scratch. Instead, they might work with complex models built by third parties, focusing on operating and adjusting these models rather than creating new ones.

4. Value Drivers and Assumptions:

   • The critical aspect of modeling in REPE is understanding the value drivers and factors affecting assumptions. The model itself is a tool, but the real skill lies in comprehending and manipulating the underlying assumptions to reflect the deal's reality.

In summary, while the ability to build models from scratch is valued and sometimes necessary, much of the day-to-day work involves using and modifying existing models to fit specific deal requirements.

Sources: What do REPE and Developers look for in IS analysts/associates?, Excel Model Creation Vs. Modeling Experience Importance in REPE, Scared Shitless: How Did You Actually Learn How To Competently Build Financial Models, Q&A - IB Analyst > Development Analyst > REPE Associate / VP, Modeling as a professional vs. as a student