I some how managed to get an interview with a RE PE firm after submitting my resume online. I think the interview went well, connected with the interviewer and what not. As the title states, I was asked to send something quantitative that I’m proud of...whether it be a spreadsheet or whatever.
I don’t have any financial analysis experience or ever held any type of analyst role....which they clearly know based off my resume.
Help?
| +48 | Being asked to stay behind and train my replacement | 14 | 3d | |
| +45 | New Comp Database - Google Form (Now with Data Validation) | 24 | 16h | |
| +35 | Leave brokerage to be GP | 7 | 21m | |
| +30 | What does REPE actually do? | 12 | 1d | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 18h | |
| +24 | Public Homebuilders | 9 | 1d | |
| +22 | REPE/Development GPA | 15 | 2d | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 3d | |
| +16 | Fisher Brothers | 5 | 3s | |
| +16 | UC Berkeley MRED vs Columbia MSRED? | 2 | 5d |
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.
I would just find a case study or offering memo for a deal online and put together a basic acquisition profroma. Make a pretty summary sheet that formats and prints well. Based on the fact you don't have any analyst experience I'd imagine they aren't looking for a fully-dynamic waterfall model... Check out adventuresincre if you need some model examples (probably goes without saying, but I wouldn't plagiarize anything)
Thanks for your help man!
I couldn't produce anything. Quite frankly, I don't know anything about RE. I just applied online thinking I wouldn't get a callback. I tried reading up a few things online and watched a few tutorials but no luck. Thanks once again.
As bolo up said, I would check out AdventuresinCRE, they have some great introduction material. Try to make a model simple, but dynamic to show an understanding of basic concepts like how NOI is calculated, basic loan concepts, rental rate/expense growth, cap rate, and DSCR. Ultimate these REPE firms want to make sure you have a foundation in real estate private equity even if you won't be in a focused financial analyst position.
Be careful - this may not be the case but small PE shops fish for models all the time. Make sure you aren't sending something you do not own the IP to...
No way in hell this guy can put together a model from Adventures in CRE unless he knows how to do VBA or advanced excel formulas. The fact that he has no CRE experience makes me wonder how the hell he can build a model for commercial or multifamily. I am surprised this so called REPE didn't give you an excel test (every decent size shop I have interviewed at has given an excel test). Anytime someone asks me to send them a model, I always say "no" but I am happy to do an excel exercise. Too many boutique shops looking to collect models or add on to new best practice. I am happy to spend a few hours building out a model at a company's shop if they want to test out my excel modeling skills or do a take home assignment. If I discuss a model I already have with a shop, I will bring a USB drive with the file and discuss it onsite. Too many sneaker mother fuckers looking for free labor or tools in CRE.
You are damn right. Literally zero experience, I'm not sure what that firm was expecting tbh. I browsed AdventuresinCRE with no luck; I even watched some of the beginner tutorials. I never considered that some smaller firms may be looking for free shit, good point.
Anyways, I emailed the guy back and told him I didn't have shit. No answer lol Whatever, you win some and lose some. It's life, what can ya do.
Deleniti voluptas vel ad voluptates. Et placeat nihil quaerat voluptatibus. Et aut ut quos delectus ab. Ducimus qui laboriosam voluptatem.
Rerum minima est veniam est vero molestiae aut. Pariatur doloremque aspernatur accusantium et. Quo ea unde expedita hic ut rerum esse. Ipsa officiis sit commodi ratione nostrum molestias natus. Consectetur ut sapiente illum voluptatem voluptate nisi vel atque. Iste voluptatem labore velit officiis ut aliquam.
Blanditiis qui velit pariatur sint eos at. Nemo est excepturi earum modi repellat consequuntur. Quia veniam esse facilis sunt et.
Nihil similique dolor assumenda neque enim et corrupti. Soluta sint voluptatem tempore qui vero repellat.
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...