Investment banking interviews in India test one thing harder than anything else: whether you can actually build and defend a financial model under pressure. The financial modelling skills for investment banking interviews in India need to go well beyond textbook theory. Interviewers at firms like Kotak, Avendus, ICICI Securities, and the Big 4 M&A practices want to see you work live in Excel, walk through assumptions, and catch your own mistakes.
Most candidates prepare for weeks and still freeze when an interviewer says, “Walk me through your DCF.” The gap is rarely knowledge it is practical. This blog covers every modelling skill that actually shows up in Indian IB interviews in 2026, what interviewers test at each stage, and how to get genuinely good at each one before your interview date.
Comprehensive Summary
- Financial modelling skills: The ability to build structured Excel-based models that project a company’s financials and support deal decisions.
- Basic skills for financial modelling: Linking the three financial statements correctly is the starting point that every interviewer tests before anything else.
- Excel financial modelling skills: VLOOKUP, INDEX-MATCH, data tables, and keyboard shortcuts separate slow candidates from sharp ones in timed rounds.
- DCF and LBO modelling: These two valuation methods appear in nearly every Indian IB technical interview, especially at boutiques and Big 4 M&A teams.
- Skills for financial modelling in practice: Clean model structure, clear assumptions, and auditable formulas matter as much as getting the numbers right.
- How to develop financial modelling skills: Building three to five original models before your interview is more effective than watching tutorials passively.
- How to boost your financial modelling skills fast: A structured course with live deal cases cuts preparation time far more than self-study alone.
Key Takeaways
- Financial modelling skills for investment banking interviews in India come down to three things: clean Excel structure, solid accounting fundamentals, and enough practice with DCF and comps to walk through them without notes.
- The DCF terminal value drives 60 to 80 per cent of the total model value. Candidates who get this wrong under interview pressure often fail the round on that one error alone.
- How to develop financial modelling skills fast means building original models from real company data, not filling in pre-built templates, and getting feedback on your structure before your interview.
Thinking about IB as a career?
What Are Financial Modelling Skills?
Financial modelling skills are the technical abilities needed to build, interpret, and stress-test quantitative models that represent a company’s financial performance and value. In an investment banking context, these models directly support deal pricing, client pitches, and internal credit or equity analysis.
Definition in Plain Terms
A financial model is a spreadsheet that connects a company’s past numbers to its projected future, and then translates that projection into a valuation or decision output. Financial modelling skills, meaning, in practical terms, is knowing which inputs drive which outputs, how to link statements without breaking circular references, and how to make a model that another analyst can audit without calling you.
Good financial modelling skills examples include:
Building a three-statement model from scratch, constructing a DCF with a terminal value, running a leveraged buyout scenario, and spreading comparable company multiples from Bloomberg or Screener data.
Why Banks Test These Skills in Interviews
Indian IB teams are lean. A first-year analyst at a boutique or Big 4 M&A team is expected to produce client-ready models within weeks of joining. There is no six-month ramp period. Interviewers test modelling skills because they need to know you can contribute from day one, not after a quarter of on-the-job training.
The test is also a proxy for your thinking. How you structure a model tells the interviewer how you structure a problem.
Why Financial Modelling Matters in Investment Banking
Financial modelling skills are not a nice-to-have in IB; they are the core of the job. Every mandate, whether it is an M&A advisory, a fundraise, or a restructuring, produces a model at some point. The analyst who builds and owns that model is the one who sits closest to the deal.
Role in Deal Execution and Transaction Support
In live deals, models get updated every time a new data room document drops or a buyer changes their offer assumptions. An analyst with strong financial modelling skills can turn around a revised model overnight. One who cannot slow the entire deal team down.
Models built during due diligence feed directly into Information Memorandums, fairness opinions, and credit approval notes. Every number a client or acquirer sees in a pitch started in someone’s Excel file.
How Models Drive Client Advisory Work
When a client asks, “What is my business worth?”, the answer comes from a model. When a CFO wants to know whether a potential acquisition is accretive or dilutive, that answer also comes from a model. Skills for financial modelling determine how quickly and reliably an analyst can answer those questions.
Interviewers know this. When they ask you to walk them through a valuation, they are not asking a textbook question; they are asking whether you could actually do this in a client meeting.
Impact on Career Growth and Salary in India
Analysts with strong modelling skills in India move up faster. At leading domestic banks and Big 4 M&A teams, first-year analyst salaries range from INR 8 lakh to INR 15 lakh per annum, and the ones who get to the higher end of that range consistently are those who become the go-to modellers on the team.
At the associate and VP level, modelling depth translates into deal ownership and, eventually, client relationships. The skill compounds over time.
Want to become an IB analyst?
Book a one-on-one session with an IB career counsellor.
Basic Skills for Financial Modelling You Must Know
Before any interviewer asks you about a DCF or LBO, they check whether your basic skills for financial modelling are solid. Most candidates who fail technical rounds do so here, not at the advanced modelling stage.
Reading and Linking Financial Statements
The three-statement model, Income Statement, Balance Sheet, and Cash Flow Statement, is the foundation on which everything else is built. You need to know, without hesitation, that net income flows into retained earnings on the balance sheet, that depreciation is added back in the cash flow from operations, and that capex hits the balance sheet as a fixed asset and the cash flow statement as a capital outflow.
Interviewers frequently ask candidates to trace a single line item through all three statements. Practice this until it is automatic.
- Net income links from P&L to equity on the balance sheet and to the top of the cash flow statement
- Depreciation appears in the P&L as an expense and is added back in the operating section of the cash flow statement
- Debt drawdowns and repayments affect both the balance sheet liabilities and the financing activities section of the cash flow statement
- Capex reduces cash on the cash flow statement and increases gross PP&E on the balance sheet
Core Accounting Concepts That Come Up in Interviews
You do not need to be a CA to do well in IB interviews, but you do need to understand:
- The difference between EBITDA and Free Cash Flow, and when each one matters more
- Why revenue recognition timing can differ from cash collection
- What do deferred revenue and accrued expenses represent on a balance sheet
- How goodwill arises in an acquisition and why it sits on the balance sheet
These come up constantly in screening calls, even before you get to a modelling test.
Excel Financial Modelling Skills Interviewers Expect
Excel financial modelling skills are tested directly in almost every IB interview process in India. Some firms send a timed modelling test before an interview. Others sit you down at a laptop during the interview itself. Either way, speed and structure in Excel matter.
Must-Know Functions and Shortcuts
The functions that appear most in IB models are not complicated, but you need to use them fast and correctly:
- VLOOKUP and INDEX-MATCH for pulling data across sheets
- SUMIF and COUNTIF for scenario-based aggregations
- IFERROR to keep models clean when lookups fail
- OFFSET and INDIRECT for dynamic range selection
- Data tables for sensitivity analysis outputs
On shortcuts: Alt + E + S + V for paste special values, Ctrl + Shift + End to navigate to the last used cell, and F2 to audit a cell’s formula are non-negotiable. Interviewers notice when a candidate reaches for the mouse constantly; it reads as slow and untrained.
Building Clean, Auditable Model Structures
A model that gets the right answer through a mess of hardcoded numbers and broken links is worse than no model at all in a professional context. Interviewers care about structure because real models get passed between analysts, associates, and MDs.
The standard conventions are: inputs in one colour (blue is common), formulas in another (black), hardcoded numbers avoided in formula cells, and row and column labels that make the sheet readable to someone who did not build it. Keep assumptions centralised in a dedicated input sheet. Never scatter them across tabs.
DCF Modelling: A Core Interview Skill
The DCF Discounted Cash Flow is the one model every IB interviewer expects you to build from first principles. Financial modelling skills for investment banking interviews in India candidates need to demonstrate almost always start with a DCF walkthrough.
How to Build a DCF from Scratch
A DCF has three parts: projecting free cash flows, calculating a terminal value, and discounting everything back at the WACC.
Free cash flow starts with EBIT, taxes it at the marginal rate, adds back D&A, subtracts capex, and adjusts for changes in working capital. The terminal value uses either the Gordon Growth Model (FCF in the terminal year divided by WACC minus the long-term growth rate) or an exit EV/EBITDA multiple. Both methods are valid; be ready to defend whichever you use.
WACC combines the cost of equity (via CAPM) with the after-tax cost of debt, weighted by the capital structure. Interviewers will ask you what each input means and how you would estimate it for a private Indian company where you have no market beta.
Common DCF Mistakes Candidates Make
- Using revenue growth as a proxy for FCF growth without modelling working capital changes
- Forgetting to add back non-cash charges like amortisation
- Using a terminal growth rate higher than nominal GDP growth without a strong reason
- Discounting the terminal value at the wrong number of years
- Confusing equity value and enterprise value when applying the WACC
The terminal value typically accounts for 60 to 80 per cent of the total DCF value. An error is not a small error.
Want to get interview-ready with live model building?
Comparable Company and Precedent Transaction Analysis
Comps are how markets actually price businesses. Knowing how to run them quickly and accurately is one of the most practical financial modelling skills an IB candidate can have.
Selecting the Right Peer Group
The peer group is the judgment call at the centre of every comps analysis. Criteria for peer selection include: similar business model, comparable revenue scale, same geography or at least the same macro environment, and similar growth and margin profile.
For Indian companies, you will often need to blend domestic peers from BSE/NSE-listed companies with global comparables, especially in sectors like pharma, IT services, or consumer goods where Indian-only peer groups are thin.
Spreading Comps Quickly Under Interview Pressure
Spreading comps means taking a set of comparable companies and calculating their key valuation multiples: EV/Revenue, EV/EBITDA, EV/EBIT, and P/E. In an interview setting, you may be handed a one-page financial summary and asked to spread three to four comps on the spot.
The sequence: calculate enterprise value first (market cap plus net debt), then pull EBITDA from the income statement, and divide. Keep decimal places consistent. Label everything. Speed comes from having done this enough times that you do not have to think about the mechanics.
LBO Modelling Basics for Interview Candidates
An LBO model values a company through the lens of a private equity buyer who finances most of the purchase with debt. It is tested more at PE-focused roles, but financial modelling skills for IB interviews in India increasingly include LBO basics, especially as domestic PE deal flow has grown.
Key Drivers of an LBO Model
Four things drive LBO returns:
- Entry multiple: What EV/EBITDA multiple you pay going in
- Leverage: How much debt you use and at what interest rate
- Operational improvement: How much EBITDA grows over the hold period
- Exit multiple: What EV/EBITDA multiple you sell at, typically assumed equal to entry, unless there is a specific reason
Changing one of these by a small amount can move the IRR by two to four percentage points. That sensitivity is exactly what interviewers probe.
What Interviewers Actually Test in LBO Questions
Most interviewers are not expecting a full five-year LBO model in a 30-minute slot. They want to know whether you understand the concept of return on equity through debt paydown, whether you know what makes an ideal LBO candidate (stable cash flows, hard assets, low working capital needs), and whether you can walk through the sources and uses of funds without getting confused.
Practice the mental math version: if a firm buys a company at 8x EBITDA using 60% debt, holds for five years, pays down debt, and exits at 8x, what is the equity return?
Ready to go deeper into deal modelling and PE fundamentals?
Sensitivity Analysis in Financial Modelling
No model is a prediction. Every model is a range of outcomes driven by assumptions. Sensitivity analysis in financial modelling is how you show that range, and interviewers expect you to know how to build it and present it clearly.
One-Variable vs Two-Variable Sensitivity Tables
A one-variable sensitivity table changes one input, say, WACC and shows how the output (implied equity value) changes across five to seven values. A two-variable table changes two inputs simultaneously WACC and terminal growth rate, for example and produces a matrix of outputs.
In Excel, both are built using the Data Table function. Two-variable tables are more common in actual deal work because they show how the interaction between two uncertain assumptions affects the result.
How to Present Scenarios Clearly to Interviewers
When walking through a sensitivity table, do not read the numbers out. Describe the range: “Under bear-case assumptions with a 13% WACC and 2% terminal growth, the implied equity value is around INR 850 crore. Under the base case, it is INR 1,100 crore.” That is what an analyst does in a real client meeting: they anchor the conversation on the range, not on a single point estimate.
Interviewers want to see that you understand that the output of a model is a range, not a number.
How to Develop Financial Modelling Skills Systematically
Watching tutorials and reading guides will not get you interview-ready. How to develop financial modelling skills that hold up under interview pressure requires active, repeated model building with progressively less guidance.
Practice Resources and Case Studies
The best free resources for Indian candidates in 2026 include:
- Annual reports of NSE-listed companies for three-statement modelling practice (Screener.in makes this fast)
- SEBI filings and RHP documents for precedent transaction data on Indian deals
- Public M&A announcements from Kotak, Avendus, and JM Financial for real deal context
- CFA Institute’s free financial modelling readings for framework coverage
Build models from scratch using real company data. Do not use pre-filled templates; they hide the parts of the model where most candidates make mistakes.
Building a Model Portfolio Before Your Interview
Three to five complete, well-structured models make a stronger impression than any certification alone. A good portfolio includes one three-statement model, one full DCF with sensitivity tables, one comps analysis with at least five peers, and one basic LBO.
Keep each model in a separate Excel file. Be ready to share your screen and walk through any of them in under ten minutes.
How to Boost Your Financial Modelling Skills Fast
If your interview is two to three months away, structured preparation beats scattered self-study every time. How to boost your financial modelling skills means building good habits daily, not cramming the week before.
Structured Courses vs Self-Study: What Works
Self-study works for candidates who already have a strong accounting base and at least some Excel experience. For everyone else, especially freshers and candidates from non-finance backgrounds, a structured course with live model walkthroughs, mock interviews, and feedback cuts preparation time significantly.
The difference is feedback. You can build a DCF that is technically wrong and not know it until an interviewer points it out. A good course catches those errors before interview day.
Strong financial modelling skills are built through repetition with correction, not repetition alone.
Daily Habits That Sharpen Modelling Speed
- Spend 30 minutes each day building or auditing one section of a model
- Practice keyboard shortcuts in Excel without touching the mouse for one full session per week
- Read one deal announcement or equity research note per day and trace the valuation logic back to a model structure
- Time yourself spreading comps. The target is a clean three-company comps table in under 20 minutes
Speed follows familiarity. The more you build, the less you think about mechanics, and the more you think about assumptions.
Conclusion
Financial modelling is the craft at the centre of investment banking, and interviewers in India test it hard. The candidates who get offers are not necessarily the ones with the highest GPAs; they are the ones who can sit down in front of Excel, build a clean three-statement model, run a DCF, defend their WACC, and explain why the terminal value is what it is. That level of comfort does not come from reading. It comes from building.
An investment banking course that includes live model walkthroughs, mock technical interviews, and real case studies built on Indian deal data will get you there faster than any self-study path. If you are serious about clearing IB interviews in India in 2026, structured preparation built around the financial modelling skills for investment banking interviews that Indian interviewers actually test is the most direct route to an offer.
Want to know exactly what an IB course covers?
FAQs
What financial modelling skills are needed for investment banking interviews in India?
Three-statement modelling, DCF, comparable company analysis, and basic LBO are the core areas tested. Excel speed and clean model structure matter as much as getting the numbers right; interviewers notice both.
Are financial modelling skills actually tested during investment banking interviews in India?
Most firms test them directly, either as a timed take-home exercise or a live on-screen walkthrough. Screening calls often include verbal modelling questions before you even reach that stage.
How do I build financial modelling skills for investment banking interviews as a fresher in India?
Start with the three-statement model using real company data from Screener, then move to DCF. Build at least five models from scratch before your interview date, and get each one reviewed by someone who has worked in IB.
What Excel skills are important for financial modelling in investment banking interviews?
INDEX-MATCH, SUMIF, IFERROR, data tables for sensitivity analysis, and paste-special shortcuts are what come up most. Know them fast enough that you never pause mid-model looking for a function.
What is the salary for an investment banking analyst with financial modelling skills in India?
First-year analyst packages at domestic banks and Big 4 M&A teams range from INR 8 lakh to INR 15 lakh per annum. Strong modellers reach the higher end faster because they get more exposure early and stay visible to senior team members.
What are the best financial modelling courses for investment banking interviews in India?
Look for courses that include live model building on Indian deal cases and mock technical interviews with practitioner feedback, not just recorded lectures. The quality of the practice environment matters far more than the certificate at the end.
