Seeking advice for case study interview for real estate developer
Hi all, I have a case study interview with a real estate developer (residential) and was wondering if anyone has any experience with this type of interview and any advice on what I should expect and things I need to watch out for while solving the case.
Here is what the HR manager emailed me:
""You will have 2 hours to review the summary construction scenario and prepare the following:
Using Excel,
- Project Budget
- Sources and Uses Table
- Monthly Cash Flow statement
Using PowerPoint,
- Short presentation 3-4 slides outlining assumptions, profitability, sensitivity analysis, & supporting rationale for Empire to invest in the project.""
Many thanks!
I should also mention that the interview is for a Senior Financial Analyst opening.
Here's how I'd approach it:
Create the Excel templates before the interview. Don't waste time in the interview designing spreadsheets. Make templates for the Budget, Source & Use, Cash Flows, Sensitivity Tables and anything else you think you will need. Know how you want everything laid out and practice until you can create these quickly from a blank page.
Don't get lost in the details. Most case studies that I've done are not "tricky". They're fairly straightforward. It's more about pulling out the relevant information and piecing it together to arrive at a defensible course of action. Needless to say, you have to get the numbers right. But there may be a bunch of information that's provided that you'll never use. Pay attention to exactly what they are asking for and stay focused on that.
Identify risks. It sounds like the case is mostly to test your technical/number crunching ability. But after you crush the numbers, make it a point to identify all the risks you can find in the deal. When I say risk, I generally mean any factor that could result in a reality that deviates from your assumptions. You don't want some guy/gal grilling you saying "well what if xyz were to happen"..."did you underwrite for that"..."how does that affect the deal"...etc. Include a Risks & Mitigants page in your presentation even if they don't specifically ask for it.
Keep it simple. As far as the powerpoint, keep it simple. I see too many people make the mistake of putting way too much info on slides. Don't write paragraphs. Use bulletpoints when possible. Display info visually (charts, graphs, etc.) when possible. Similiar to the Excel, I would practice creating powerpoint templates before the interview so everything looks polished and you don't waste time designing stuff during the interview.
Good luck!!
RE Development Case Study (Originally Posted: 01/17/2018)
Have an interview with development firm. Anyone have any practice case studies? I'm not sure what to expect. I have been doing real estate acquisitions for the past couple of years and want to move to the development side. Not sure how the case studies may differ between acquisitions and development.
Thanks
Velit dignissimos blanditiis ad minus quo. Itaque distinctio repellendus dolores. Consequatur omnis culpa pariatur optio laboriosam nihil.
Et corrupti facilis ut et velit. Omnis eaque vero sed maxime porro nulla. Sunt consequatur ipsum vel reiciendis quo eligendi consequatur. Qui impedit quibusdam corporis vel. Perspiciatis magni placeat ipsa omnis. Ipsum est esse culpa iure.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...