REPE Modeling Test Example

Saw a lot of posts on RE Modeling Tests & Case Studies and thought I'd give a shot on how I structured mine for interviews (on-site/take home) with anywhere between 30 mins to 1 hr of time allotted. The model enclosed typically takes ~30 mins to build (incl. formatting) with an extra ~5-10 for sensi's. To note, this is the exact model I sent in for a case study for an REPE MF (passed).

Link to Model:
REPE Modeling Test Example

Link to Image of Model:
https://ibb.co/KVtmLRy

*Simplified a lot of it (bells and whistles as well as P&L) but flexible for the time allotted
**Keep in mind Case Study had certain assumptions/objectives (Ex. all expenses reimbursed incl. vacancy loss), one size does not fit all. I wanted to provide a basic structure
***Missing waterfall but will make future post with one (Fees, Preff & Promote with IRR/EM Hurdles)

Let me know what you think and feel free to PM me with any questions (Also, have other models/case studies I could share). Would be interested to see other people's approaches too.

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 (23)

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
  • Investment Analyst in RE - Comm
Nov 13, 2019 - 6:56pm

Glad you guys like it, I'll try to add the case studies sometime this week to this post. Hope you all find the model helpful and feel free to reach out with any questions.

Nov 14, 2019 - 3:26am

Thanks for sharing. Is there any reason why you're not using the IPMT formula to calculate interest? As simply multiplying the rate by outstanding balance increases the total debt service over time (arguably not by much but still)

  • Investment Analyst in RE - Comm
Nov 14, 2019 - 3:45pm

Great question, it honestly was just a preference and got you in the same ballpark range which is pretty much the goal of these models.

In an actual model, I tend to make my debt dynamic (fixed (0) vs floating (1)) and combine a rate/spread in combination with 1-mo FWD Libor. I do the same, where I calculate interest on BOP Balance. For me, easier to model floating rate debt + other terms and run sensi's off of.

Hope that was helpful

Feb 7, 2020 - 8:00pm

I noticed that you applied your acquisition fee to the Total Costs to lever against - said another way, the 70% LTV was the purchase price and the acquisition fee.

Does this logic apply when you have debt origination fees, IS broker fees, etc.? I know the money has to come from somewhere, so it makes sense to loop them in.

  • Investment Analyst in RE - Comm
Feb 8, 2020 - 2:26pm

Broker fee (Purchase price )
Origination (total loan amount)
Sales costs (gross sale proceeds)

Apr 6, 2020 - 10:21am

Thank you for sharing.
i was doing a modeling ex. earlier & encountered some difficulties.. would be grateful if someone could give me some insights!

    • 10-year quarterly cash flow with rent roll that drive the top line of the cash flow
      (what does it "rent roll that drive the top line of the cash flow" mean ?)
  1. Leased-up Schedule: Leased to 4 tenants at future market rent; 25% of the area to each tenant; 3-year lease terms; Tenancy starts 3, 6, 9 and 12 months from acquisition in June 30, 2014; Tenant renewal probability 50%. Downtime for new leases 3 is months.
    (how to model the tenant renewal probability ?)

thank you so much

  • Investment Analyst in RE - Comm
Apr 28, 2020 - 5:23pm

Apologies for the late response, made a different account. Due to circumstance, I am not allowed to share the case study prompt.

Was pretty basic, a NNN industrial deal with some rollover/growth assumptions. Gave financing, cap rate, etc.

Asked you calculate Unlevered & Levered IRR, ROE, EMx, and Sensitivities.

Start Discussion

Total Avg Compensation

April 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (32) $350
  • Associates (180) $232
  • 2nd Year Analyst (102) $151
  • 3rd+ Year Analyst (25) $146
  • Intern/Summer Associate (95) $145
  • 1st Year Analyst (387) $131
  • Intern/Summer Analyst (315) $82