2 Hour Modeling Test in Person- What to Expect, Top Capital Markets Team Miami

Hey guys,

Have a two hour in person modeling test for an analyst role for a capital markets team in Miami. Test is this Wednesday in their office, they said it's going to be multifamily. Assuming they will give me an OM and historic cash flows. Want me to model down to levered and unlettered IRR. Provide certain debt assumptions and add those in, maybe come up with one or two sensitivity tables. 

Thoughts? What to expect in a two hour test? Role is very modeling heavy for an analyst, was asked for an example to make sure we could pass the test so guessing not just an easy 1 hour test but again it is a brokerage so not sure if I'm overthinking.

Real Estate Modeling Course

  • Real-life RE Modeling Tests from actual Interviews
  • Various asset classes including multi-family, commercial and more
  • Huge discount - until more tests and cases added

Comments (7)

  • Analyst 2 in RE - Other
May 11, 2021 - 1:03am

I've encountered two types of tests. One is where you build a cash flow from scratch, then calculate IRR, EM, etc. Do a sources & uses table, sensitivity tables, and waterfall. Then answer some questions about the "deal". The other is a combination of Excel skills check (SUM, SUMPRODUCT, AVERAGE, etc.) and short prompts/questions with parts of the cash flow already provided. Either one could take up two hours, so I'd say be prepared for both. 

I think if you're comfortable with one type, you can handle the other. Given that this is a brokerage and it's only 2 hours, I doubt there will be a waterfall. If you have time and feel like your skills are otherwise solid, maybe practice a simple, 2-tier one just in case. 

  • Analyst 1 in RE - Comm
May 11, 2021 - 8:43pm

Great thanks, I don' t think it's ground up development more existing multifamily.

  • Analyst 1 in RE - Comm
Jun 8, 2021 - 3:05pm

Hey guys OP, have another test 1.5 hours and they're going to give me a cashflow and want me to answer questions. It's for an owner seems pretty easy, it's early next week. Any input into what I might face? I was thinking it's simple like give me cash flows ask me to project out 1-2 years and down to levered IRR. And ask questions like what's the cap rate going in, what's the DSCR, etc - to clarify it was emphasized some excel skills are needed so seems very basic especially with time limit.

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Start Discussion

Total Avg Compensation

June 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (35) $364
  • Associates (202) $234
  • 2nd Year Analyst (114) $151
  • Intern/Summer Associate (97) $145
  • 3rd+ Year Analyst (27) $145
  • 1st Year Analyst (419) $131
  • Intern/Summer Analyst (337) $82