Feel like an idiot, lost on technical stuff

So I’m 5 months in to a Southern California IB role. I’ve gotten decently fast at updating decks, taking good notes, scheduling calls, rolling forward simple stuff. I got put on a mandate 5 months ago and it just came alive again and I got assigned dealing with part of the raw client data, cleaning/reconciling, etc. and I have no idea how to do it. I understand a DCF/LBO but I’m so far out of my wheelhouse with this stuff, just have been staring and asking dumb questions but feels really disheartening. Anyone been in this spot?

 

Hey there, don't beat yourself up! Everyone starts somewhere, and it's completely normal to feel out of your depth when you're thrown into the deep end with something new, like handling raw client data. Based on the most helpful WSO content, here are a few steps you can take to get a grip on the situation:

  1. Ask for Help: It's better to ask those "dumb" questions now rather than later. Most people are willing to help if you show that you're eager to learn. Remember, the only dumb question is the one not asked.

  2. Online Resources: WSO has a plethora of resources that can help you understand the technical aspects of finance. Dive into the WSO Courses or WSO Academy for tutorials and guides.

  3. Mentorship: Find someone in your firm who has been in your shoes and ask for guidance. A mentor can provide invaluable insights and tips on how to manage the data effectively.

  4. Practice: Get your hands dirty with the data. The more you work with it, the more comfortable you'll become. Practice makes perfect, or at least competent!

  5. Stay Organized: Keep your work and thoughts organized. This will help you manage the data more efficiently and make it easier to spot errors or inconsistencies.

  6. Take a Break: Sometimes stepping away for a moment can give you a fresh perspective when you return.

Remember, everyone feels incompetent at times, especially when facing new challenges. It's part of the growth process in any career, especially in high-stakes environments like investment banking. Keep pushing through, and you'll come out stronger on the other side. Swing from those vines with confidence—you've got this!

Sources: Anyone else get overwhelmed by their career sometimes?, Feeling incompetent because I can't code?, Help. Feeling Lost, From BO to FO and back again, or, how I learned to stop worrying and love technology, Life after PE - the other road

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 
Most Helpful

The default advice is spend time reviewing past models/analysis.  That is good, obvious, advice but can also sometimes exacerbate the issue of feeling overwhelmed and disheartened.  Opening v78 of a model for a business that you haven't spent anytime with isn't always the best spot to start as you are completely missing any business- or transaction- specific information that has informed what you're reviewing.  I liked to click through versions of the early drafts to get an idea of the starting point and how it evolved. 

That aside, if you're being tasked with cleaning up due diligence files, my advice is keep it simple and show your work.  For example, with the raw client data:

  • Have a "raw data" tab - completely as you received it from the client, untouched.
  • Create a "clean" tab - this is the raw file but you'd added headers, source notes, data tags (for sumif et al), checks vs prior tab
  • Create an "analysis" tab - this is your summary, you're using your tags from the prior tab to present findings or themes, checks vs. prior tab

There is a common misconception that fancy, complicated formulas drive good analysis but it is really good organization and structure that do that. 

 

Learn to use SumIF and start by building out a monthly schedule of all their sales / expense data, by product / service & geography. 

 

Why are you asking these moronic questions? Just stay an idiot, that's what I'd love to see in my analysts. Everyone is confused, noone has a clue what's going on, everyone slips and falls on their face, I laugh and tell people about it

 

Voluptas earum eius ut. Distinctio impedit facere possimus asperiores consectetur eveniet. Non laborum excepturi et voluptatem autem esse sint. Tempora veniam magnam temporibus quia expedita non at. Vel provident reprehenderit alias. Optio reprehenderit ut earum qui ipsum ipsum asperiores. Temporibus quis deserunt natus quas.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Lazard Freres No 98.9%
  • Harris Williams & Co. 25 98.3%
  • Goldman Sachs 17 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 04 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (91) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
CompBanker's picture
CompBanker
98.9
6
kanon's picture
kanon
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
bolo up's picture
bolo up
98.8
10
DrApeman's picture
DrApeman
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”