- Real Life Analyst Case Study adapted from case studies at actual real estate firms
- Case focuses on the acquisition of a hypothetical apartment building in the San Francisco Bay Area
- Case has two sections: Section 1 tests your model building / knowledge of real estate return metrics and Section 2 tests your analytical/critical thinking around an investment decision
- The answer key includes both a completed acquisition model in Excel(with some extra modeling tips) and a written answer key with suggested answers
- After completing this case you’ll be very well prepared for any case study that is part of your interview process!
Menu
Real Life Analyst Excel Test with 47 questions across three sections that takes roughly two hours to complete Sections include Rent Roll Analysis, Deal Analysis, and Cash Flow Modeling Practice the top ways that firms test analyst candidates during interviews (covers both Excel knowledge and real estate knowledge) Comes with two Excel files:1 with questions […]
41-page technical interview guide, learn to: Demonstrate fluency with each major sector and their core strengths and weaknesses Thoroughly explain the relationship between cap rates and risk Quickly compare and contrast two investment opportunities regardless of sector or geography Manipulate accounting and financial metrics common in real estate private equity Convincingly highlight the merits of […]
10-page Mental Math Guide with 20 real estate finance questions that are commonly asked in technical interviews for real estate firms Detailed explanations that show you how to approach these questions and explain the underlying concepts Supplement to our Technical Interview Guide, which covers real estate interview questions more broadly Material includes unlevered and levered […]
Reviews
There are no reviews yet.