REPE Modeling Tests/Case Studies - excel shell/template given?
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.
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?
Eius sit quia et illum dolor cum. Ut hic ullam placeat voluptas aut facere. Dignissimos recusandae suscipit rem culpa voluptas incidunt sed deserunt. Distinctio qui cumque saepe aut nemo voluptatem perferendis. Culpa sit blanditiis occaecati et sed eum consequuntur.
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...