When given a REPE excel modeling test as part of a case study - do you usually have to create your model completely from scratch? or do they give you some sort of shell/template with the line items to work with?
This could be obvious but I've never had any of these yet, and just want to prepare as best as possible.
| +79 | LP coming into deal at higher land basis. How to model returns to GP? | 17 | 18h | |
| +70 | Major Decisions | 13 | 17h | |
| +65 | Increasing RE Industry's Cash Compensation, Collectively | 41 | 2h | |
| +28 | Niche down to an operator or stay an allocator | 9 | 2d | |
| +24 | Breaking into CRE late 20s | 7 | 3d | |
| +22 | Self Storage ECRI | 9 | 2d | |
| +20 | Doom Loop or Creative Urban Reemergence? | 3 | 5d | |
| +19 | Thoughts on joining an early-stage REPE fund | 6 | 11h | |
| +18 | How to get good at RE Modelling? | 14 | 22h | |
| +18 | 3 Hour Condo/Rental Excel Test - What Can Be Expected | 2 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Expect to create a model from scratch but for it to be very simple in terms of the assumptions and line items. Feel free to PM me if you want a few sample ones that I have taken over the years from several REPE firms.
Thanks man, will do. Appreciate it.
What kind of time line did the firms give you to create the model? I assume if they only give you a couple hours it couldn't get to complex. Also what did they expect you create in your models? besides the regular line items, did they expect an debt/amortization schedule, waterfall, sensitivity analysis, etc?
Typically 3 to 4 hours. It won't get too complex in terms of assumptions / line items but you had to create debt / amort schedule along with waterfall and sensitivity analysis in the majority of my excel tests I have done.
Hello RealEstateAK I came across this discussion when I was looking for resources to prep for my upcoming model test. I was wondering if you still have a few samples I could look at? Anything is appreciated!
Anyway you could send them to me as well? I am looking for some practice case studies to prepare for FT recruiting/to sharpen up my skills. I tried pm’ing, but received an error message.
Much appreciated!
Hi -
I know this post is from years ago. Trying to make a transition from leasing finance to REPE. Would you mind providing the samples you mention?
Thanks in advance.
In a similar boat, for an analyst position at a megafund REPE group out of undergrad. What are some good ways to go about preparing technicals and how might the modeling test differ than for an associate position/someone interviewing from IBD?
In my experience it varies substantially - PM me and I can send examples
REPE Practice Models (Originally Posted: 02/25/2018)
I'm looking to transition to REPE and need to be a competent modeler for upcoming interviews. Based on my research, I've realized there is a shortage of full-on models available online. Does anyone have a detailed REPE model to share?
I suggest the biws course, maybe find someone to swap with for those models
message me,
Anyone care to share the BWIWS real estate modeling course. I can venmo as well.
Sent you a PM..
Can you share?
Please can you share the modelling case with me as well?
Sed laboriosam eos velit. Autem cupiditate qui ullam ut explicabo nobis. Quod cumque rem est sint veritatis inventore soluta. Vel aut est unde.
Et libero itaque ducimus placeat nihil. Et quae magnam officia quibusdam quae.
Deserunt assumenda sit eum ratione et alias et. Qui sint quaerat laborum sit exercitationem ut deserunt beatae. Aliquam nam voluptatibus assumenda sit.
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)
or Unlock with your social account...