Excel Test in an Interview
Hey guys, as I've posted on here before, I've been laid off for a few months now. I have an interview coming up where I'm going to have to take a 20 minute excel test. Since I've been out of work for a few months, I want to brush up on my excel skills. Anyone have any templates I could use to get some practice ? Also, any tips ? The interviewer mentioned VLookup and formatting as some of the stuff they would test.
excel test for interview
The excel test will include key functions that are used within your sector. However, there are some basic functions in excel that are standard across most industries. Focus on the basics of Excel, then more industry-specific functions. The only way to become proficient at this is to practice within the program. Here's an example of an Excel test for two different sectors.
from certified user @acrew09"
I've taken 2 of these for F50s, one for tech and one for manufacturing.
The tech one, they gave you a bunch of random data on prices and click-through rates. They wanted you to then come up with recommended pricing and a sales forecast. This might be useful for an FP&A role? However it seemed like they intentionally left out key information to see what assumptions you would make and whether you could deal with the ambiguity.
The manufacturing one, they provided an investment scenario and gave key inputs (initial investment, cost of production, etc) and wanted a go or no-go decision. You needed to build out an income statement and cashflow and account for things like changes in FX. From what I've heard, this is a much more standard type of excel test for corp fin.
Ready to improve your modeling skills? Hone your financial modeling skills and ace your interview. Click the button now to start your training.
Sounds like you're interviewing for some kind of BO role... otherwise I can't see why they would care as much about vlookup/pivot table skills vs. actual modeling skills.
Brush up on what they told you you'll be tested on and a little bit more.
Well, its a PE/VC FoF role, so not sure if too much actual financial modeling will be involved.
"Microsoft Excel data analysis and business modeling" by Wayne Winston is useful.
Thanks. Any online templates I could also look at ?
www.mrexcel.com
Here are some WallStreetPrep excel shortcuts and useful references. http://www.wallstreetprep.com/blog/excel_resources.php
Thanks Kanon. The macro one is pretty useful. I'm trying to find an Excel test I took during the Wall St. Prep training program during my analyst training, anyone have an ideas where I could find it online ?
Hi everyone,
I'm a newbie here. Would any of you please explain what type of position in a PE sector would test for Excel skills?
The reason I'm asking is my background is accounting, pretty good at Excel and have some VB programming experiences. However, I'm stuck in a very laid-back industry, trying hard to get out. Want to see where I should try to get a shot.
Thanks.
corporate finance Excel Testing (Originally Posted: 06/25/2014)
HI, I have cleared the first round for a Corp Finance Analyst at a large Energy/Utility company, but the next step is a excel test. Any clue what they will ask? Anyone has given such test before or has any examples to share
Thanks
I have no experience with these tests, but being in Corp Fin for a while the most useful Excel functions are:
Vlookup Sumif Sumifs Pivot Tables
Other than that, obviously know linking and working within a workbook and maybe light modeling of financial statements.
Again, I don't have direct experience with these tests, but this would be a good (relevant) place to start if you're looking for direction.
If it's anything like Excel tests I have taken in the past, then it is a joke. Mine was 30 questions of basic formatting with one question on pivots. But that was for low level accounting jobs. I'm sure this one would be much more advanced.
I've taken 2 of these for F50s, one for tech and one for manufacturing.
The tech one, they gave you a bunch of random data on prices and click-through rates. They wanted you to then come up with recommended pricing and a sales forecast. This might be useful for an FP&A role? However it seemed like they intentionally left out key information to see what assumptions you would make and whether you could deal with the ambiguity.
The manufacturing one, they provided an investment scenario and gave key inputs (initial investment, cost of production, etc) and wanted a go or no-go decision. You needed to build out an income statement and cashflow and account for things like changes in FX. From what I've heard, this is a much more standard type of excel test for corp fin.
Thanks Guys, that's really helpful.
@acrew - Yes, they want me to build a Model for Impairment testing - Now that is when i am hired, but before that they would want to test my excel as well as corp fin knowledge.
Again ambiguity is the key in Corp fin and they always want to test you on that. so it may involve making some assumptions.
Any more inputs are welcome.
Thanks
I took one for my corpdev position which was actually building a 3 statement forward projection model from scratch and then adding an IRR model for an investment property.
Allday - What were your key takeaways from it ? was it like growth figures for next year were given and based on it you keep building P&L and BS and CS statmnt.?
Also i now have a bit more clarity - They will take a Case study and later followed by modelling exercise.
Any idea on corporate finance case study guys ?
Thanks.
I had my case study interview today. Its a utility company so it had a case of company trying to raise capital and then suddenly receives 3 different set of news and how the analyst would want to adjust their valuation based on this new information.
It also had questions on what part of analysis would change and basically testing how i would approach problem and try resolving it along with some technical knowledge.
Thanks everyone...now over to excel modelling
Excel test during super day? (Originally Posted: 10/21/2015)
I was informed via email that during an upcoming interview "part of your interview will consist of an in-house financial exercise in excel." Does anybody have any experience/insight to something like this? It is for an iB analyst position at a boutique. Any resources to fine tune my skills going into it?
I had this once for a MM bank, but I had to do it before the superday and then email them the Excel file. I was given a company and asked to creating an operating model and a DCF. I also had to put together some trading and M&A comps.
I can't add much in the way of answers for you, but I think people will be better able to help out if you give some more detail. What industry/group is it for?
Healthcare boutique. Interviews are only from noon-5 i believe, so I won't be doing anything like creating a model I don't think.
Then don't sweat it. Brush up on some Excel shortcuts and basic modeling skills, but a boutique (assuming this is not a "boutique" like Lazard or Moelis) won't have the time to spend an hour testing on modeling.
For the banks I interviewed with, this did not happen too often (maybe can recall once when it happened). Sil's comment is apt for what the exam would consist of.
Excel Test during second round interview (Originally Posted: 02/28/2013)
Hey everyone,
I have a second round interview with an ER group coming up and on the phone they asked if I would be willing to take an excel test, to which I obviously said yes. Does anyone have experience with excel evaluations? What might one of these entail?
Thanks in advance!
Had one for a similar interview. Basically just checked whether you could handle large raw data sets in a limited amount of time. Just had to use very basic functions like VLOOKUP and implement some conditional statements.
Be familiar with VLOOKUP and HLOOKUP, the basic finance functions (PMT, RATE, NPER, etc), be familiar with pivot tables tables and charts. If it involves large data sets then matrix functions are incredible useful.
Personally think the index(match function is much more efficient than the v and h lookups..
Just learn how to index, sumif, countif, iferror, multiple layered if statements, min/max functions and indirect if you want to get fancy.
I had a different experience with an excel test, it was long enough that no-one had ever finished it, involved reversing out netbacks and calculating cash flows from a set of financials. The last question had two data sets and asked you to make a graph that showed the data effectivley (two axis, one line, one column).
Whats a vlookup?
I prefer index(match())
JK
One thing about vlookups() I always use the columns() funciton instead of actually trying to count out columns if it is a truly big data set as that gets tiring... Also super easy
vlookup(x,A1:AD300,clumns(a1:ad300),0)
super day Excel Test help - Public Finance (Originally Posted: 10/04/2007)
Hi, I am an arts major and need some guidance to prepare for this aspect of the super day. It is in the Public Finance division.
"Please note that in addition to one-on-one interviews, you will be given an Excel based test that includes present value, etc. Additionally, you will have to complete the test using actual formulas. You will not be allowed to use Excel functions other than those you could type in a calculator."
Thank you so much in advance.
Kind Regards.
Wow.
I do not even understand the question...are you asking how to do present value in Excel?
If so I am agahst and here you go:
B C D
5 Future Value ("FV") $1000.0 6 Interest Rate ("I") 0.05 7 Period ("N") 2.00 8 Payment ("PMT") 0.00
10 Present Value ("PV") =D5/(1+D6)^D7
I cant think of what firm would find this a useful way to judge candidates --- i guess it works similar to those pointless consulting firm interviews where it becomes more like "Read my mind so that we can go to slide 2" lol..... But yea what tbroker put is correct.... Present Value = Value in Future / [(1+ interest rate) ^ number of periods] Future value is just solving for value in future from that formula Future Value = Present Value * [(1+ interest rate) ^ number of periods] If its a terminal value (the present value of a stream of cash flows that grow at the same rate forever) Then you are dealing with a perpituity which is usually done like this Present Value of Perpituity = Amount of first cash flow / Interest rate - growth rate Where interest rate is the rate of interest (a WACC in a DCF) and the growth rate is the constant rate of growth of the cash flow that goes on forever. WACC = a weighted average of the type of capital and its rate of interest Equity typically higher rate maybe like 14 or 15 % Different debt amounts should be weighted by their percent of capital structure..... works kinda like this Equity / [Equity + Debt (total market cap) ] * rate of return on equity + Debt / [Equity + Debt (total market cap)] * rate of return on debt (interest rate) As you can see, this is exactly what the name implies -- weighted average cost of capital
I dont remember off the top of my head the formulas for annuities (present value of a constant payment) but if its excel just create the same discount formula and copy it across and then add all the discounted cash flows to get the present value of all the separate cash flows.
This is most of what I could see them asking..... good luck --- that sux that they are doing pointless shit like that in their interviews
Thank you... yes I was quite surprised when I read it myself... just wanted to be sure to take people's inputs who go to super days and deal with this stuff day in and day out.
Kind Regards
Excel test help (Originally Posted: 11/24/2013)
I was told I'd be given a financial modeling test as apart of my interview. What can I expect for this and what's the best way to prepare for this? I have very little experience in this area so would appreciate the help.
Can you build a 3 statement financial model, DCF etc? If not (those are the basics) you should probably learn how to.
Does anyone have some practice models that they wouldn't mind sending my way?
Yeah the BIWS modeling courses are good, I used them and liked them.
Sorry if it wasn't clear. Does anyone working in banking have a sample model that I could practice off of?
Try building your own, it'll be a much better learning experience than just looking and playing with someone's model- especially if you'll be tested on it. Check out macabacus, I haven't been there but have heard they have good (free) practice.
I have access to BIWS so working off that for now. If anyone else can provide some helpful assistance I'd appreciate it. Thanks btw
Neque perferendis quibusdam tempore. Mollitia dolores similique rerum ut qui. Consequuntur voluptatibus quo amet labore quia dolor magni. Reprehenderit voluptas neque odio enim est. In nostrum doloribus velit earum perspiciatis quis.
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...
Et aut assumenda laudantium. Consequatur sit aut soluta consequuntur est.
Vero et blanditiis excepturi. Quo dolores ut cupiditate sit delectus numquam. Sed voluptatem voluptatem accusamus ut vel iste blanditiis commodi. Nam veritatis aut numquam dolorem dolores inventore.
Voluptatem reiciendis quis reiciendis et. Natus odit et error nulla. Eveniet est iusto sint sit. Et molestiae occaecati velit animi veritatis quis facere. Voluptatem quod minus rerum cum maiores.
Est minus minus aliquid. Doloribus aut dignissimos molestias voluptatem id ducimus explicabo.
Ut iure accusamus ut inventore necessitatibus. Id fuga at et eveniet itaque et. Dolorum deserunt doloremque architecto illum. Dolorem et eos ut iste ut. Corrupti qui sed omnis architecto quis quisquam. Sed excepturi tenetur soluta et.