I refused to take the Excel Modeling Test
I am sure you can notice this from other threads I have posted, but I am a well qualified applicant with around 4 years of experience, $3B+ of direct real estate experience, and hold prestigious degrees (Not ivy league, but target schools).
For this reason, I am told by experts (Recruiters, HR, and Employers) that I am a $100k base candidate (not NYC market).
A recruiter connected me with a brand new firm in the US with established Europe presence. They haggled me (before an offer came) to see if I would take a $90k base, then came back with $85k base. I agreed since its 1 mile from my house.
I was asked to build an over the top, complex and dynamic model that needed to be completed as the potential employers "Test". Argus not available. It required a full dynamic model (principal amortization, market leasing assumptions, CapEx schedule, TI/TA/LC, multi-property, multi-property tax ID's, Waterfall (IRR & EM driven), and even a full investment summary with sensitivity tables). Imagine the templates you create for your current employer to create efficiency when underwriting.
Crazy enough, they asked me to model an exact portfolio that I already modeled in my current job and put together a beautiful marketing package for major LP's ($150MM + deal). So, I sent them my underwriting and my dropbox of all my prior work through my career. They still asked for me to complete the model, I refused to do it.
Did I do the right thing?
That’s a wholly unreasonable ask on the potential employers end. And for 4 years out 85k base is laughable. I’d imagine that’s an awful place to work.
Here’s the deal, it doesn’t sound like you were on board to begin with. I think what the ask they gave you to do is ridiculous. A modeling test is fine, but to ask for what sounds like 10-20 hours of work is nuts. On top of that, they were haggling on the price. Besides that it is one mile from your house, considering how difficult they’ve been already, do you really want to work for them? You are interviewing them as much as they are interviewing you. If you think you are an $100K candidate (which I’m sure you are), and they are fighting you over $15K, just imagine how hard it’ll be to get a raise over time. I would move on and (1) find a firm that values you (pay), and (2) find a firm that recognizes the interview process times take and a modeling test should be a few hours tops. I always hated when firms would email me Monday morning and ask me to put a test together by Wednesday / Thursday. And when you viewed the prompt, it was 5-10 hours. It’s almost like they don’t care or forget that you are also holding a full time job. I had one firm tell me I needed to come into their office from 9-5 to take a modeling test and when I said I could do it on a Saturday, they had issues with it until my recruiter got involved. Needless to say I moved on and have since found out they have a rough reputation in the market. It’s about finding fit and if they don’t treat you well when you’re interviewing, just imagine how you’ll be treated when you’re working there.
Lmao it sounds like they're trying to farm out work and get the work done for free. You definitely dodged a bullet there.