In previous posts, we’ve discussed interviews, resumes, and the general recruiting process. Today, we want to touch upon one of the most important but often overlooked aspects of the interview process – the case interview, and even non-standard case interview questions.

Pdf To Excel Converter Online Free
Pdf To Word
Convert Pdf To Excel Spreadsheet

What is a case interview?

How can I learn the PowerPoint and Excel skills that top. Training in Microsoft Excel at a top management consulting. Case studies, etc.) To. Case Interviews 101: Why Consulting Firms use Case Interviews Case Interviews 101: What Consulting Firms are looking for in a Case Interview Case Interviews Overview. Finance Training Courses. Consulting Glossary; Consulting Case Study Training. Consulting Case Study 101: An Introduction to Frameworks. Visit the Vault Consulting Career Channel at www.vault.com/consulting — with. Vault Guide to the Case Interview C A R E E R. Customized for: Jessica.

If there’s one question on the mind of every aspiring consulting applicant, it is this: what is a case interview? How is it set up? What am I being asked to do? And most important, how do I master it?

Put simply, a case interview is where you are asked to solve a business problem, on the fly, with limited information. There will always be math involved, and you’ll be expected to talk your interviewer through your calculations and thought and decision-making processes. The goal of the case interview isn’t necessarily to get you to solve the business problem – it’s to see if you can think like a consultant, whether you can think on your feet, if the numbers you produce are logical, and if you can be trusted to communicate key insights in front of a CEO client.

There are four basic frameworks that all case interview problems can be categorized under:

Profitability, Market Sizing, Market Study, and Mergers & Acquisitions.

These are general frameworks, but do a good job of organizing the main kinds of problems consultants solve on a project-to-project basis, and thus the types of problems that are presented in case interviews.

Profitability cases generally deal with a client trying to decide what to with revenues, costs, or overall revenue. Market Sizing cases examine the size of a current market (usually in revenue), while Market Study cases examine whether a client should enter a new market or not, as well as the declining market share of a client. Finally, there are M&A cases. These are the big boys of case problems, as M&A cases include Profitability, Market Sizing, and Market Study concepts all in one case. These cases are all about whether Company A should merge with Company B, or whether Company Y should acquire Company Z. Remember the one overarching goal of both of these transactions, though: increased profitability for the client!

Why do consulting firms use case interviews?

Pdf To Excel Converter Online Free

Because doing well in cases requires the same skills that consultants use:

Understanding of basic business concepts (e.g., revenues and costs, suppliers and customers, market structure, etc.)
Analytical, structured-thinking
Business-oriented creativity and insight
Communication and presentation

A case study mirrors the work that consultants do day-to-day.

What Should I Do For My Case Interview Prep?

There’s no magic bullet for preparing for the case interview – it’s going to take grit, perseverance, and good old fashioned hard work. However, there are case study interview tips that will help you focus your approach:

Practice as much as possible with friends, colleagues, contacts within consulting firms. Even practice in front of a mirror to assess your communication style, body language, etc. Out loud practice is the key.
Review case study-specific resources – from the Vault Guides to Cosentino’s Case in Point. Don’t go overboard (in particular, Cosentino’s guide is helpful but not a must-have).
Go through our consulting-specific prep courses, and work with our expert MBB coaches.
Review general business problems – get your hands on as many case studies as possible. Most consulting firms post a few online, or at least give info like the McKinsey Interview page. The more exposure you have, the more familiar each question will seem. Even when you’re reading the Wall Street Journal, Fortune, etc. – put yourself into the CEO’s shoes at every opportunity.

Further reading:2 smartest case study techniques and case study interview tips

We released a guide on case studies and consulting interview questions. Click here to check it out! We also created a Complete Guide to Case Interview Prep article.

Case Interview Example Walkthrough:

I’m not that good at case interviews. Can I get an offer by conquering the “fit questions” and my resume?

Pdf To Word

No. Your performance on case studies accounts for at least 50% (and usually more) of your “score” in determining offers. It is the most underprepared area for candidates, but something the best applicants excel at. If you want an offer, you’ll practice, practice, practice.

So what does a case interview question look like, anyway?

Convert Pdf To Excel Spreadsheet

If you’ve never seen a case interview prompt before, the whole process can sound very intimidating. Bsa rifle serial number search. Let’s demystify it a little bit – here’s a sample case interview question you’d see for each basic framework:

Market Sizing:

Estimate the number of gas stations in Chicago.

Profitability:

Your client is a well-known beer company. The company manufactures and sells beer. It is sold in pubs/restaurants and in bottles/cans (supermarkets, grocery stores, etc.), but mainly in pubs/restaurants. Recently, the client has become aware that profits have been declining while those of their main competitors have been increasing. Where would you start to solve this problem?

Market Study:

A small life-science technology startup, One for the Road, Inc. (ORI), has invested a huge amount of money in R&D and was recently granted a patent for a new breakthrough patent. The client wants to know what approach it should take to commercialize the product.

M&A (Mergers & Acquisitions):

Companies All Liquorice (AL) and Black Delight (BD) are both in the candy industry in the UK. The candy industry produces chocolate, liquorice, and chewing gum. There are 4 players in the market. Besides AL and BD, there is Chewin, the market leader and most profitable company, and Devotion. The market is competitive and strong consolidation has taken place over the last years. Now the Board of All Liquorice wants to acquire Black Delight. Why do you think they want to acquire Black Delight?

Non-standard case interview questions

I’ve heard that some companies/interviewers don’t ask standard case questions. Instead, they ask questions like “How many golf balls would fit into a Boeing 747?” or “How would you rescue the auto industry today?”

That will happen, particularly in later rounds and with more senior interviewers. They may not be prepared to run you through a standard case, or they may want to see how you handle the unexpected. One question we faced (not at McKinsey but another firm) was the following:

Can you explain why Starbucks actively promotes the construction of locations that are so close to each other that they cannibalize sales?

If this happens, don’t panic. The interviewer is still looking for the same things – how crisp and logical is your thinking; how well do you communicate those thoughts; and how much do you understand the basic business underpinnings.

p2vsk.netlify.com

Consulting Case 101 Pdf To Excel