I have an excel test next week for an Analyst role. This is more of a consultant type firm for an entry level role. They mentioned it is just a short excel test to test skills and some basic RE principle type stuff. Any idea what I can expect? Prior interview they asked me to tell me about NPV so I'm guessing one on that. Any help appreciated. I have never had to do one so also might be a stupid question, but I do come in wearing a suit?
| +48 | Being asked to stay behind and train my replacement | 14 | 1d | |
| +32 | Best CRE brokerage firms | 22 | 20h | |
| +30 | What does REPE actually do? | 11 | 14h | |
| +30 | New Comp Database - Google Form (Now with Data Validation) | 15 | 20h | |
| +24 | Thoughts on joining an early-stage REPE fund | 7 | 5d | |
| +22 | Starting University LP Fund | 5 | 10h | |
| +22 | REPE/Development GPA | 15 | 14h | |
| +21 | Public Homebuilders | 7 | 4d | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 1d | |
| +17 | What would your strategy be? | 14 | 4d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
I would wear a suit if they were wearing one at the first interview. I had one instance where the person I was interviewing told me to come in as comfortable as I wanted for he next round - series of tests, intelligence and psych evaluation.
If you have zero excel experience I would start learning now. I do not run NPV frequently in excel, I do remember there was an issue with it not calculating properly vs a financial calculator. Go to the formulas tab and try to see what you can familiarize yourself with under financial. Also, try and gain some experience with some of them logic items, IF, AND, OR, SUMIF, vlookup, hlookup and the stat functions.
He's right. But, it's easy an easy metric to include, i just do it out of habit.
Use XPNV to get the propert period 0 sum. Make sure you include a dynamic discount rate on the overview tab and dates to draw the xnpv function from.
Make sure your assumptions are clearly in a separate area, and try not to hardcode - try to refer to the assumptions.
Just make sure you can run a dcf and a debt table. Depending on how long the test is it would also be good to know how to run a waterfall.
Thanks guys.
I don't think it's going to be that complicated. It's mainly just an excel test with some RE questions tied to it. Does anyone have any examples of a straight Excel test? I am good with IFs, vlookups, Hlookups, pivots, SUMIFs, etc
Excel test - anyone have experience? (Originally Posted: 01/18/2017)
Anyone ever have to take one of these for interviews? What did it entail? Friend of mine is interviewing now for a couple firms and was notified he has to take one.
"excel test" .. classic, I guarantee that language came from HR
BNP tested one of my friends on a VBA but it wasn't an IBD role.
I had to do an "excel test" for a boutique. It was 95% extracting relevant numbers and putting them onto some PowerPoint template, which was fairly easy.
Upcoming Excel Test Help (Originally Posted: 02/22/2015)
Hey,
I have an interview coming up at a real estate focused investment bank. I’ve already done a modeling test, but it will involve an excel test. Can you guys give me any info on what this would include?
Every excel test I have taken as part of a job interview has been really simple stuff. Without using a mouse they asked me to do a bunch of things like format different cells, print, and change print settings, set up a pivot table, take a data sheet and create a Vlookup, create charts and graphs adjusting to their different formatting and data requests.. It has never really never been very difficult especially if you already passed their modeling test. Most excel tests I have taken have been untimed and very straight forward. One caveat is that sometimes I would go to use a shortcut and the test wanted to see you do it the long way, and would mark me wrong, very frustrating.
Dolorem quia consequatur dolorum. Quisquam sint vero dolor sed aliquid non. Illum non consectetur quae. Ea vel nisi nulla architecto qui odio. Omnis vero autem fuga quaerat.
Ratione quaerat delectus quas totam quas. Adipisci mollitia dolores cumque ut odit alias et et. Dolorem nulla rem minus quae voluptas repudiandae vero. Rerum assumenda deleniti totam omnis.
Eius nam veritatis quae iure et qui quis. Voluptatum voluptatem tempore voluptatem laborum eaque blanditiis quod.
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...