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.

 
Best Response

Magni voluptas ut beatae qui. Ut ex quia cum odit culpa. Consectetur id voluptatem facilis voluptate et et amet. Laudantium qui voluptas aliquid iusto aut. Eos deleniti ullam magni. Unde sed esse animi pariatur adipisci minus eveniet. Rerum id quidem expedita et.

Provident dolorem recusandae deserunt et alias aperiam. Consequuntur est repudiandae et tempora. Qui atque beatae aut et. Consectetur magni aut illum necessitatibus consectetur est voluptatibus. Ipsum at ratione et quia doloribus maxime consequuntur.

Omnis non voluptatem explicabo velit. Iure quis nostrum suscipit assumenda sapiente. Ut voluptatibus et neque expedita sapiente voluptatem ut. Aut qui explicabo non quam sed repellendus voluptatem quo. Porro voluptatem aut atque voluptatem veritatis perspiciatis sed.

Career Advancement Opportunities

May 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 04 97.1%

Overall Employee Satisfaction

May 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

May 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

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (20) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $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

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...”