Real Estate Modeling Test

Based on the most helpful WSO content, here are some insights and tips for preparing for a real estate modeling test, particularly for a role with JPM's real estate asset management team:

1. Core Focus Areas:

   • Expect to work on cash flow projections, return metrics, and sensitivity analyses.
   • Be prepared to handle valuation exercises, such as comparing two identical properties or determining where to allocate a hypothetical investment (e.g., $100M).
   • Familiarize yourself with waterfall structures and tax implications in real estate deals.

2. Practice Under Pressure:

   • A common challenge is performing under time constraints. Practicing with real-world examples in a timed setting can help you overcome this. You can find practice tests and templates on WSO's resources, such as the Real Estate Modelling Test Practice thread (https://www.wallstreetoasis.com/forum/real-estate/real-estate-modelling…</a">link here).

3. Technical Skills:

   • Brush up on Excel modeling skills, including shortcuts and formulas.
   • Review DCF (Discounted Cash Flow) and IRR (Internal Rate of Return) calculations, as these are often tested.

4. Preparation Resources:

   • Utilize WSO's Elite Modeling Package, which includes courses on financial statement modeling, DCF, M&A, LBO, and Excel modeling.
   • Practice with the 27 financial modeling templates available in the WSO swipe file.

5. Behavioral Component:

   • While the focus is on technical skills, be ready to explain your assumptions and thought process clearly. This demonstrates not only your technical ability but also your strategic thinking.

By focusing on these areas and leveraging the resources mentioned, you'll be better prepared to excel in the modeling test. Good luck!

Sources: Real Estate Modelling Test Practice, J.P Morgan Asset/Wealth Management Video Interview, JP Morgan Commercial Real Estate HireVue Questions