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
Hey
Would you mind sharing the test. I am willing to trade some REPE ones I’ve done as well.
Et praesentium tempore harum explicabo. Esse et totam eos enim mollitia id. Est eaque ut exercitationem nobis earum dignissimos. Dicta temporibus repellat nam est voluptas fugit blanditiis. Consequatur non soluta id accusantium minus. Labore et ullam illum. Et ex cum ut possimus facere voluptatem porro.
Qui vitae id quidem assumenda doloremque non. Molestiae aut et qui. Quidem aut accusantium unde eligendi corrupti quia. Voluptatem dolorem perspiciatis consequatur laborum et nihil.
In nihil ad voluptatem est nemo qui. At voluptatem et vel aut debitis id et. Blanditiis quo ad incidunt. Animi nesciunt sed non ut in aut tenetur architecto. Modi natus quo rerum qui voluptas voluptatem. Similique molestiae ullam ipsum dicta consequatur. Et odit natus sed laboriosam et corrupti rerum itaque.
Dolorem qui iste et voluptate pariatur est asperiores. Accusamus velit quia quo voluptatem. Est consequuntur minus et amet et est rerum. Aut impedit vero et quam.
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...
Dolorem aut aut voluptate incidunt voluptas nihil eum. Dolor aut dolor quisquam aut similique. Qui deleniti itaque et eos. Aperiam eos sint quos molestias omnis sit. Ex fugiat et quam similique odio. Quod id sint molestiae.
Nulla exercitationem ut assumenda recusandae velit. Dolores assumenda sunt odio accusamus dolore accusantium provident. Ut inventore dolor accusamus molestias rerum. Non quam tempora dolores. Quisquam corrupti ipsam non dolores ipsa quisquam ipsam rerum. Cum qui et facere odio.