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.

Comments (6)

 
Aug 13, 2019 - 1:35pm

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?

 
Aug 18, 2019 - 11:09pm

Internship during* my MBA, in America they're two year programs and for the summer in between you do an internship. I better land a full time position after graduating haha, I'm not paying all this money for just an internship afterward!

Start Discussion

Popular Content See all

Life Hacks during WFH | How do you avoid burnout?
+52IBby 1st Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 1 in IB-M&A
Leaked EY Email
+48IBby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
I’ll never take WSO for granted again
+24OFFby Principal in Venture Capital">Principal in VC
Have any 1st year analysts actually quit?
+23IBby 1st Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 1 in IB-M&A

Total Avg Compensation

January 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (30) $350
  • Associates (139) $232
  • 3rd+ Year Analyst (18) $155
  • 2nd Year Analyst (84) $153
  • Intern/Summer Associate (89) $144
  • 1st Year Analyst (344) $134
  • Intern/Summer Analyst (297) $83

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Secyh62's picture
Secyh62
98.3
3
Jamoldo's picture
Jamoldo
98.3
4
CompBanker's picture
CompBanker
97.9
5
redever's picture
redever
97.7
6
frgna's picture
frgna
97.6
7
Addinator's picture
Addinator
97.5
8
Edifice's picture
Edifice
97.5
9
bolo up's picture
bolo up
97.5
10
NuckFuts's picture
NuckFuts
97.5