Real Estate Model Test

I am interviewing for an acquisitions role and they have notified me that I will be given a modeling test. However, I have never modeled a shopping center before. What should I expect? Does anyone have any examples of case studies that they could send me way?

Thank you

 

when you model shopping centers, its a little bit different than office or industrial. obviously it is done on argus, and the differences are: percentage rent - most tenants have a % rent clause in their leases by which if they reach a certain $ amount in sales, the LL gets some kick back. there can either be a hard stop or natural break point over a certain amount in sales. secondly are reimbursements. there are sometimes clauses in retail leases in which the in-line tenants reimburse after the anchor tenants (like a supermarket). So, in argus, you would need to make a tenant group called "anchor" and when you have specific reimbursement methods for each tenant, you select the "reimburse after" option in argus. basically what this does is that if the anchors don't reimburse for some year because maybe their base year is higher than the current amount in opex or RET, then the in-lines don't reimburse either. some tenants have this and some don't, just like % rent.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
kanon's picture
kanon
98.9
9
DrApeman's picture
DrApeman
98.8
10
numi's picture
numi
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...”