Back to Blog

The Model Balances. Is the Analyst Deal-Ready?

16 November 20263 min readBy Surojit Chakraverti

Why a technically correct model does not always translate into effective deal work. Surojit Chakraverti of Third Wave Capital on making analyst training closer to a live deal.

Key takeaways

  • Why a technically correct model does not always translate into effective deal work.
  • Surojit Chakraverti of Third Wave Capital on making analyst training closer to a live deal.
  • For: Heads of L&D, analyst and associate programme managers, deal-team leaders Reading time: 4 minutes Case type: Illustrative training scenario (composite, not a client engagement) Author: Surojit Chakraverti, Founder, Third Wave Capital By the middle of an analyst programme, most participants can put together a three-statement model.

Written by the team at

Third Wave Capital

London, United Kingdom

4.9(149 reviews)

Third Wave Capital delivers practitioner-led corporate finance and investment training in financial modelling, three-statement modelling, LBOs (leveraged buyouts), DCF and valuation, M&A analysis and execution, private equity, leveraged finance, credit analysis, ECM and DCM.Led by a former Citi and

  • Graduates struggle to apply finance theory at work
  • Financial models lack accuracy and commercial insight
  • Teams lack confidence in valuation, M&A and LBOs
View provider profile

Why a technically correct model does not always translate into effective deal work.

  • For: Heads of L&D, analyst and associate programme managers, deal-team leaders

  • Reading time: 4 minutes

  • Case type: Illustrative training scenario (composite, not a client engagement)

  • Author: Surojit Chakraverti, Founder, Third Wave Capital

By the middle of an analyst programme, most participants can put together a three-statement model. The numbers reconcile, the feedback is good and the course has covered what it set out to teach.

On a deal, the work is rarely that tidy. A VP might ask an analyst to review £1.8m of seller EBITDA adjustments, update the financing and consider what the findings mean for the purchase price.

That requires more than Excel proficiency. Analysts need to understand the business, question the inputs and use the model to work through commercial decisions.

The difference between modelling and deal work

A modelling test shows that someone can build and link the statements. It does not necessarily show how they will deal with incomplete information, changing assumptions or numbers that need challenging.

An analyst could update every formula correctly yet miss the commercial significance of an unsupported EBITDA adjustment. The model works, but the underlying analysis does not.

Make the exercise closer to a live deal

Illustrative training scenario

A fictional exercise for an analyst programme; it is not based on a client engagement.

The group has built a model and simple LBO for a UK healthcare services company. The seller is asking £150m, or 10.0x its adjusted EBITDA of £15.0m.

New diligence findings raise questions about £1.8m of seller adjustments: £0.8m of supplier savings not yet agreed and £1.0m of expected earnings from an unsigned contract. The lender will size debt at 5.0x accepted EBITDA. Ahead of the next deal call, the analysts must update the financing and assess the implications for valuation and price.

The exercise brings together three parts of the job:

  • Modelling. If none of the £1.8m of proposed adjustments is accepted, EBITDA falls to £13.2m. At the unchanged £150m price, the implied multiple rises from 10.0x to about 11.4x. Assuming the lender uses the same 5.0x leverage limit, debt capacity falls from £75m to £66m, requiring £9m more equity before fees.

  • Commercial judgement. Savings that have not been achieved and earnings from an unsigned contract should not be treated as established EBITDA. The analyst needs to assess the evidence and distinguish current earnings from potential upside.

  • Practical application. A lower EBITDA figure affects both the apparent valuation multiple and the financing structure. The analyst must consider what the buyer can reasonably pay, rather than assume the reduction in debt capacity equals a reduction in value.

This is the distinction worth testing. Can analysts do the calculations, understand the commercial implications and produce work that helps the deal team move forward?

Build more realistic exercises

  • Use imperfect information. Include missing details, inconsistent figures and seller adjustments that need checking.

  • Change the facts partway through. New diligence findings or financing terms should lead to an updated analysis.

  • Ask for work the deal team would use. Have participants update the valuation and financing and explain what changed and why.

  • Revisit the skills. Use a short follow-up case and let supervising VPs know what analysts have covered.

Look at performance on the desk

Agree with deal teams what a new analyst should be able to do, then look for evidence of it:

  • Test the modelling and commercial reasoning on an unfamiliar case.

  • Ask VPs after 60 days whether analysts spot issues, make sensible assumptions and work through changes with less guidance.

  • Track errors and the number of review rounds on early work.

  • See how quickly analysts can produce models and analysis that the team can actually use.

These are more useful measures than a positive feedback form alone.

Train for the work ahead

Before the next programme, ask what an analyst should be able to handle after six weeks on the desk. Use that to shape the exercises. Building the model is important; knowing how to use it in a transaction is just as important.

About the author. Surojit Chakraverti is the founder of Third Wave Capital and a former investment banker at Citi and Rothschild & Co. He designs and delivers practitioner-led training in financial modelling, valuation, M&A and AI for finance teams at banks, funds and corporates.

Ready to find your training provider?

Search our marketplace of 8,000+ training providers.

Keep Reading

AI Training Should Change How Finance Teams WorkExpert Insights
16 Nov 20261 min read

AI Training Should Change How Finance Teams Work

The real opportunity is not better prompting. It is better financial analysis, supported by AI. Surojit Chakraverti of Third Wave Capital on training the workflow, not the tool.

Surojit Chakraverti
AI Training Effectiveness: What Sits Between AI Literacy and AI AdoptionExpert Insights
5 Oct 20261 min read

AI Training Effectiveness: What Sits Between AI Literacy and AI Adoption

Key Takeaways: AI literacy is only the starting point: knowing what AI tools can do does not mean employees will use them consistently in their work. AI learnability bridges training and adoption: employees need to test AI on real tasks, evaluate the output, retry when it fails, and adapt as the tools change. Training effectiveness goes beyond completion: active usage, task-level application, repeated attempts, and workflow changes reveal what happens after the training ends. Manager support can reinforce adoption: employees are more likely to sustain AI use when their managers support experimentation and help connect it to everyday work.

Bhuvana
Is Your Microsoft 365 Investment Delivering What You Expected?Expert Insights
17 Sept 20261 min read

Is Your Microsoft 365 Investment Delivering What You Expected?

Over 30 Years ago when Suzanne started delivering her Excel Courses using Excel 4.0 users would book a course – often for 2 days and the Course Profile was packed with information. Looking back, I’m still not quite sure how delegates managed to absorb all that information in 2 days, that’s if they did! Certainly in todays world of training Companies want Bite Sized Learning Sessions or Sessions designed around a specific project, business challenge or immediate need. 

Suzanne