REPE Analyst Modelling Test

Based on the most helpful WSO content, REPE analyst modeling tests can vary significantly depending on the firm. While there isn't specific information in the knowledge base about the exact tests for Temasek, GIC, Henderson Park, or MARK, here are some general insights about what you might encounter:

1. Corporate Finance Real Estate Modeling Tests:

   • Some firms, especially those with a corporate finance focus, may include elements like financial statement modeling, DCF analysis, and M&A-style case studies. This could involve analyzing a real estate portfolio or a single asset acquisition.

2. Common Components in REPE Modeling Tests:

   • Property-Level Cash Flow Statement: Building a detailed cash flow model for a property, including revenue, operating expenses, and net operating income (NOI).
   • Debt Amortization Table: Constructing schedules for loan repayments, interest, and principal.
   • Sources and Uses Table: Outlining the capital stack for a transaction.
   • Equity Waterfall: Incorporating promote structures with IRR or equity multiple hurdles.
   • Return Metrics: Calculating IRR, cash-on-cash return, and equity multiple.
   • Sensitivity Analysis: Testing variables like cap rates, rent growth, or exit assumptions.

3. Granularity and Time Constraints:

   • Tests for top-tier firms like GIC or Temasek may be more granular, requiring you to build models from scratch within a limited timeframe (e.g., 2-3 hours). These could include solving for specific metrics like an 18% levered IRR or determining the maximum purchase price for a target return.

4. Development vs. Stabilized Assets:

   • Some tests may focus on development projects (e.g., office buildings or multifamily developments), while others may center on stabilized assets, requiring valuation using cap rates or discounted cash flow methods.

5. Preparation Tips:

   • Practice building models for both value-add and core real estate investments.
   • Familiarize yourself with equity waterfall structures and sensitivity analyses.
   • Review case studies and examples available on platforms like WSO or REFM.

If you're looking for specific examples or practice materials, WSO threads often mention resources like the REPE Modeling Test Library or other shared case studies. You can explore these for more targeted preparation.

Sources: Real Estate Modelling Test Practice, https://www.wallstreetoasis.com/forum/real-estate/megafund-repe-modeling-test?customgpt=1, Real Estate Modelling Test Practice, What can I expect: a REPE Top 5-10 modelling test?, REPE Modeling Test Example