RE Modeling Exam General Questions

I'm going to have to complete a case study/modeling exam for a small repe firm. The firm invests in hospitality, office, condos, and mixed-use assets. I was told the exam isn't very complicated, that i should build a cash flow and be familiar with return multiples, and i don't need to do a waterfall. Any idea what to expect?

For something like this -- is it expected that you do a monthly cash flow or is yearly acceptable? I ask this because in my current role, I am not underwriting anything as most of the work I do is post-transaction/advisory/financial reporting work and all of our cash flows are yearly.. ANY guidance would be appreciated. I've never had to do a modeling exam for a job before so I don't really know what to expect at all.

6 Comments
 
Most Helpful

I did one for an internship at a REPE (didn't get the internship, but there were lots of applicants for one summer opening, take that as you may). It was a pretty simply setup, purchase a building all cash with a GP/LP structure, after 2 years refi and distribute the cash. Simple waterfall structure and the debt was limited by either leverage or DSCR (you had to determine which one was the limiting factor). The answer they were looking for was the IRR and equity multiple afer a hold of 5 years.

I did it with a monthly setup since you want to make sure the refi and cash flows happen at the right time in the year for discounting. It's also not that tough to go between monthly and annual, Monthly gives you better control of timing (say you're doing an 18-month construction development) and if you really need to roll it up into an annual cash flow just get good at sumifs and index-match.

Have you done any financial modeling for real estate assets before?

 

Voluptate pariatur et itaque sed incidunt recusandae minima. Et voluptatum id totam voluptatem repellendus et dolore qui. Adipisci quisquam est dolor sed. Ab et qui minus veniam. Sed sit itaque et vero tenetur corporis. Alias impedit labore voluptatem adipisci.

Quia voluptates non fugiat. Tenetur laudantium quis libero. Accusantium eaque est quas deserunt earum sint atque eveniet.

Accusantium neque et consequatur minima aspernatur inventore error. Dicta consequatur doloremque sed aliquid aliquid consequatur rerum. Corrupti reiciendis quia sapiente exercitationem. Inventore dolores libero quos nostrum et excepturi. Nisi minima iste et assumenda. Explicabo numquam iure labore provident qui. Dolore rerum hic eius consectetur omnis voluptate ut debitis.

Ut quis distinctio ut iusto quod debitis eum. Dolore quas facilis ut quia dolores. Totam in ullam omnis voluptatem ea nihil similique.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
DrApeman's picture
DrApeman
98.9
7
CompBanker's picture
CompBanker
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
dosk17's picture
dosk17
98.9
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”