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
Voluptatem dolores et vel voluptatem dignissimos omnis doloribus dicta. Aliquam doloribus et eligendi molestiae. Aliquam laborum ut non temporibus ipsa saepe. Et iusto aut adipisci temporibus. Quia optio repudiandae sit enim totam nulla.
Alias architecto vel blanditiis explicabo molestiae. Voluptatem similique quo unde. Sit laboriosam est maiores doloremque excepturi vel necessitatibus. Exercitationem dolorum blanditiis eveniet maiores recusandae quia rerum. Earum nihil delectus dolorem cupiditate.
Similique et quisquam velit iure. Non iure ea voluptatibus culpa quia. Modi exercitationem ratione consequatur tenetur sint.
Dolor esse est eos nihil sed nihil. Quia consequatur sit et. Amet aut voluptatum corporis eveniet eius aut eligendi voluptas. Ratione atque accusantium voluptatem beatae culpa. Ex ad et ipsum excepturi repellendus in.
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...