Excel Test / Data Analysis (vs. Investment Modelling)
Hi everyone,
Looking for a role atm at an associate level and obviously facing modeling test / case study from 1h to 48h...
Came across a modeling test from Savills OCM (M&A, Financing, blablabla...) basically the RE "IB" from Savills, I guess that it could make sense to move there and then back to REPE at a nice shop due to the nice deal-flow they have across Europe. They ask their candidates to take a 45 min excel data analysis + 1h30 multifamily modelling test. (Any thoughts on this role would be much appreciated)
Modelling test: super easy, probably the easiest I came across, basic assumptions, I/O Debt, IRR/EM output, 3 sensitivities and that's all.
Data test was horrible, extremely messy doc composed of 8 tabs of demographics numbers related to London Boroughs some with dates some without (Age, House Price, Employment, Earnings...)
You're supposed to assume we're in 2023, some data is from 2003 to 2015 some 2003 to 2027... Proper mess. It is asked to advise a client entering London's multifamily market, giving him the best Borough using at least 2 of the 8 tabs: create 3 graphs + write 3 bullet points (that's all).
That being said, I'm starting to fear these excel tests vs. investment modeling which I'm comfortable with. I've been told by a REPE shop after an interview with the partner that he would send me a 1h excel test tomorrow that will require 20 min of my time based on my CV... Potentially CF modelling which would be fine, but I'm starting to dread receiving a weird excel test not really linked to an investment/development.
Anyone in a position to share excel test / data test??? Happy to trade with modelling tests I have from different funds (Living, Industrial, Office).
Thanks
Up, would be great to train on something before tomorrow! Thanks all
Nisi ab ut molestiae consequuntur consequuntur ex consequatur quisquam. Vero incidunt animi adipisci.
In repudiandae quia dolorum nam quo. Deserunt nemo vel et. Assumenda dicta corporis expedita enim rem necessitatibus necessitatibus.
Voluptas dolores et libero omnis voluptas architecto incidunt. Unde qui ut architecto cumque. Officiis cum dignissimos sapiente odio nihil accusamus dignissimos. Delectus fuga praesentium ut odio et eius aperiam quam.
Ullam accusantium harum qui atque accusantium non omnis. Perspiciatis quo harum a est corrupti voluptates. Nihil facilis distinctio officiis. Optio velit eveniet blanditiis voluptatem esse.
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...