REPE Modeling Test Example

Anonymous Monkey's picture
Anonymous Monkey

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.

    • 17
REPE Modeling Test

Comments (11)

 
Nov 10, 2019

Thanks!

Hedge Fund Interviews
 
Nov 11, 2019

This is pretty good,

Personal opinion is that keep the inputs on top rows instead of to the right of cash flows.

 
  • RE
  • Investment Analyst in RE - Comm
  • Anonymous
Nov 11, 2019

Thank you and appreciate the feedback. I agree, for actual models everything is above

Toughest PE Interview Questions
 
Nov 11, 2019

following, and appreciate you sharing so openly

Certified Private Equity Pro
 
Nov 13, 2019

Thanks for this! Could you maybe share some of your other models/case studies?

Financial Modeling Training Self Study Courses
 
  • RE
  • Investment Analyst in RE - Comm
  • Anonymous
Nov 13, 2019

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.

Hedge Fund Interview Sample Pitches - Long and Short
 
Nov 13, 2019

Very nice! Can you share the initial data you had starting off the model so I can practice and build it myself with another approach? I'll post what I get afterwards.

Thanks.

Excel Model Templates and Training
 
Nov 14, 2019

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)

Hedge Fund Pitch for Interviews
 
  • RE
  • Investment Analyst in RE - Comm
  • Anonymous
Nov 14, 2019

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

Private Equity LBO Modeling Tests
    • 1
 
Nov 22, 2019

How is the sensitivity table at celll AG53 calculated? Was trying to figure out the inputs by following the logic but it looks like a function was used.

Thanks in advnace!

Certified Real Estate Pro
 
  • RE
  • Investment Analyst in RE - Comm
  • Anonymous
Nov 24, 2019
Comment

See All Comments - 100% Free

WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)

Modeling Training - Special for WSO Members
    • 1

Related Content

See more

Popular Content

See all