What Students Think Investment Banking Analysts Do vs What They Actually Do

Expectation: ‘I will spend all day modelling’

Reality: Excel is only part of it. Analysts model valuation, operating cases, mergers, debt capacity, transaction scenarios, returns and sensitivities. They may also spend hours checking a presentation, finding one data point, updating a process document or making sure 15 pieces of information agree.

The glamorous model and the tiny footnote can both matter.

Expectation: ‘I will make investment decisions’

Reality: in banking, you are usually advising somebody else. You may analyse whether an acquisition makes financial sense, but the client ultimately decides whether to buy.

Bankers help clients make and execute decisions. Investors put capital behind their own decisions.

Expectation: ‘PowerPoint is just formatting’

Reality: the presentation is often the product. It may need to communicate the argument, valuation, market, transaction, risks and recommendation. Senior bankers may use those pages directly with CEOs, CFOs or investors.

Making complicated information clear, accurate and persuasive is part of the job.

Expectation: ‘The technical work is hardest’

Reality: managing ten moving things can be harder. A live process can combine senior comments, an updated model, new client information, an earlier deadline, lawyers’ questions, diligence workstreams and materials that all need to reconcile.

The strongest analysts are not only technically capable. They are dependable when the process gets messy.

Expectation: ‘Every day is a live billion-pound deal’

Reality: not every assignment completes. Some pitches are lost, deals pause, processes die and analysis never leaves the internal team. That is normal.

What does an analyst actually do?

The exact mix depends on the team and workload.

• Update valuation and maintain models.
• Prepare client presentations and meetings.
• Research companies, sectors and transactions.
• Pull trading data and check numbers.
• Coordinate information and support diligence.
• Respond to senior comments, manage trackers and turn work quickly and accurately.

A lot of the job is not just finance. It is execution.

What makes a good analyst?

Accuracy means the numbers tie. Speed means efficient, not reckless. Communication means flagging problems early. Prioritisation means knowing that not every ‘urgent’ task is equally urgent. Attention to detail covers names, dates, numbers, sources and formatting. Commercial understanding means eventually seeing the company behind the spreadsheet.

The real lesson

Do not prepare for banking interviews because you think the job is only doing valuation. Understand the wider role: helping a team analyse, communicate and execute complex transactions under pressure.

Excel is a tool. PowerPoint is a tool. Accounting is a tool. Execution is the job.