Financial modelling in consulting
Hi,
Does MBB consultants do any kind of financial modelling or other technical modelling / technical stuff in general? What is the most "technical" thing in management consulting?
Hi Gibbon@, don't worry, the WSO Monkey Bot is here.... I'm hoping one of these links will help find your answer:
More suggestions...
Fingers crossed that one of those helps you.
Yes, financial and other modeling is part of strategy consulting
In terms of the most technical stuff you'll have to do there's a high variance. I know people who are consistently using fairly advanced analytics platforms, and I also know people who have never opened Excel except to write down lists of names. I'd say the average is a mix of Excel, Tableau, and occasion Alteryx
Is there a particular reason you're asking?
Thank you for the reply. The reason of asking is that I am still in university and planning consulting as a future option. And I was thinking whether I should learn financial modelling or not beforehand.
Knowing how to use Excel and do some modeling is never a bad idea, but you aren't expected to have any particular technical skills before you join
Some companies will use Excel type tests in interviews, but I have not heard of MBB using them
Do learn excel / take an excel course if you can. I did this before starting and it has been immensely helpful.
Don’t take a financial modeling course. I’ve taken one of these as well as preparation for a previous finance internship. They focus on the kind of modeling you would do in banking. You would use these kinds of models very rarely if at all in consulting so the ROI would be low if not zero.
In general, I found the excel course helped me much more than the financial modeling course, even for financial modeling.
Thank you a lot. Any specific course would you recommend for example?
To answer your question about the ‘most technical’ thing in consulting, we have people who do work in /with Python / machine learning / data science. The ceiling on how ‘technical’ you can get in consulting is actually much higher than it is in banking, which I feel like is rarely acknowledged in these types of forums.
If you want to do that kind of work I would learn some of it before starting so it’s easier to get staffed in roles where you would be using those skills
yes, I am aware of that consulting firm have analytics, data scientist teams. However, I am more interested in generalist path
I'd challenge the idea that these are separate paths. They are to an extent, but our more technical teams are being brought on to projects with increasing frequency. Which makes intuitive sense-if you have methods of more rigorous / advanced analysis, you would want to break those out wherever possible.
Personally, I am working to develop a more technical toolkit so my staffing can be more flexible, not less. Someone who knows Python or SQL or any other technical skill can still be staffed on a more qualitative / slide heavy project where they don't use those skills, whereas someone without those skills is more limited
.
Solid argument. Can you name a list of technical skills which would be beneficial to learn?
Tough to provide a comprehensive answer given that what the tools use vary widely across companies and even across teams within companies.
Others have mentioned Tableau and Alteryx. At my company, I see a lot of ‘SQL preferred’ in our project staffing requests, and I had to use SQL on my first project despite not having a background in it. I’d bucked those in ‘I might have to use these at some point so learning them beforehand could be helpful’. But again, the preferred tools vary widely by company, so you might want to wait until you have an offer and then ask consultants at your specific firm what they use.
Learning something more complicated (Python, R, machine learning, whatever) would only be helpful if you want to do work using those skills. Unlike Tableau or SQL (or excel obviously), it is unlikely you will ever be asked to use something like Python on a project unless you already know it.
Yes, management consultants at MBB firms often do financial modeling as part of their work. This involves creating complex financial models to help clients make important business decisions. Other technical work that consultants may engage in includes data analysis, market research, and process optimization.
ChatGPT
Question: Is there financial modeling in consulting?
Yes, financial modeling is a common practice in management consulting. Financial modeling is the process of creating a quantitative representation of a real-world financial situation, typically using spreadsheet software.
Consulting firms often use financial modeling to help clients make informed decisions about complex financial situations, such as mergers and acquisitions, capital investments, pricing strategies, and cost-cutting initiatives. Financial modeling allows consultants to analyze data and make projections based on various assumptions and scenarios, which can help clients identify potential risks and opportunities and make better-informed decisions.
The level of financial modeling required in consulting can vary depending on the project and the client's needs. For example, some projects may require a basic financial analysis, while others may require more complex modeling, such as discounted cash flow analysis or scenario analysis.
Overall, financial modeling is a valuable tool for management consultants and is often used in combination with other consulting methodologies to provide clients with a comprehensive understanding of their financial situation and help them make strategic decisions.
Illum sed officia magni amet quas ipsum voluptas. Illo alias qui ab quia optio. Hic voluptate accusamus cumque voluptatem. Sunt quisquam enim voluptate non.
Quia vitae sit quia. Expedita error mollitia aspernatur itaque quas. Quo illum accusamus illo magnam dolore est. Accusamus ab facilis deserunt. Dolorum quis sint voluptatem iste. Perspiciatis enim sed et et. Dolorum ex optio magni qui expedita est.
Eos dolore ut et nostrum et. Nulla qui omnis reprehenderit qui aut corporis aspernatur. Aut eum veritatis voluptatem eveniet.
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...