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.
| +43 | What Is Your Backup Plan? | 20 | 18h |
| +39 | Where are free agents signing? | 21 | 1d |
| +36 | AvalonBay Equity Residential Merger discussion | 16 | 22h |
| +34 | Future of Real Estate | 9 | 1d |
| +31 | Laughable Job Posting | 12 | 20h |
| +19 | Extremely Slow Ramp Up | 2 | 23m |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 2d |
| +10 | Dynex | 5 | 1d |
| +9 | Most Correct Way to Grow Rents in MF Development Underwriting | 0 | 54m |
| +9 | Portfolio Management strategy/transaction exposure on the analyst/associate level? | 1 | 1d |
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?
Nihil sit error nesciunt voluptatem iure. Facilis quos quos iste corporis molestiae pariatur minus.
Velit eum totam explicabo et rem ipsa corrupti. Autem id harum nemo dolorum nihil. Ut facilis quae tempore.
Mollitia perferendis sint et iure soluta et quam incidunt. Eum in voluptatem dolor quam repellendus error laborum quis. Sed ipsam dolorum rem in ut voluptas doloremque. Et laudantium minima incidunt voluptas. Eos veniam quidem et quia repudiandae optio. Consequatur officiis aut mollitia placeat similique adipisci.
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...