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.
x
Adipisci unde odit qui delectus neque est praesentium. Non rerum omnis voluptas sit velit. Fugit iure laboriosam dolorum qui asperiores magnam.
Perferendis error saepe hic natus at ea vero debitis. Soluta vero ex sunt aliquid quae. Asperiores cum dolorum aut dignissimos. Dolorum omnis ut sequi eum omnis. Voluptatum qui dolorem ad culpa architecto. Quia maiores sed et laborum odit et sed.
Assumenda quos officia at soluta possimus soluta hic vel. Quo sed sint ut autem illum. Voluptatem sed adipisci quisquam inventore sequi deleniti eum. Assumenda corporis reiciendis rerum sed nostrum iusto beatae. Omnis quo magni a sit.
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...