30 Financial Modelling Interview Questions Asked in IB Rounds

There is a specific moment that ends most investment banking interviews.

The candidate has answered "walk me through a DCF" smoothly. They listed the steps in order. The interviewer nods, then asks a second question: "Why did you discount unlevered free cash flow at WACC instead of levered cash flow at the cost of equity?"

And the candidate stops.

This is the pattern in IB technical rounds. The first question checks whether you memorised the process. The second checks whether you understand why the process is built that way. Candidates who prepared from a list of answers clear the first and fail the second.

So this guide is built differently. For the questions that matter most, you get the answer and the follow-up the interviewer is likely to ask next, because in banking the second question is the real one.

It covers 30 financial modelling interview questions across accounting, DCF, comparable company analysis, M&A, LBO and Excel mechanics, plus what to expect in a live modelling test.

What IB Interviews in India Actually Test

Before the questions, understand the shape of the process, because it varies by employer type.

Bulge bracket and global banks in India, such as JPMorgan, Goldman Sachs, Nomura, HSBC, Citi and Deutsche Bank, run the most technical process. Expect several rounds with deep modelling questions and sometimes a live Excel test.

Domestic investment banks such as Kotak Investment Banking, Axis Capital, ICICI Securities, Avendus and JM Financial run similar technical rounds with a stronger emphasis on Indian market knowledge and live deals.

Big Four deal advisory and valuation teams test the same technicals with more accounting depth, and often Ind AS specifics.

Financial services KPOs and research firms such as Evalueserve, Acuity Knowledge Partners and Moody's Analytics hire large numbers of India-based analysts. The technicals are real but usually a step less demanding, and these are often the most accessible entry points.

Across all of them, four things are being assessed: whether your accounting is sound, whether you understand valuation logic rather than valuation steps, whether you can actually build in Excel, and whether you can be corrected without becoming defensive.

Accounting and Three-Statement Questions

Everything in modelling rests on this. Interviewers start here because if your accounting is shaky, nothing built on top of it can be trusted.

1. Walk me through the three financial statements and how they connect

Answer: "The income statement shows revenue, costs and profitability over a period. The balance sheet shows assets, liabilities and equity at a point in time. The cash flow statement reconciles profit to the actual movement in cash.

They link in three places. Net income from the income statement flows into retained earnings on the balance sheet and forms the opening line of the cash flow statement. The cash flow statement adjusts net income for non-cash items and working capital movements, and its closing cash balance is the cash line on the balance sheet. Depreciation reduces both net income and the carrying value of fixed assets while being added back in the cash flow statement."

Follow-up to expect: "So which statement would you look at first to assess a company's health?" There is no single right answer, but the strongest response is the cash flow statement, because profit can be managed through accounting judgement while cash is harder to manufacture.

2. If depreciation increases by 10 crore, walk me through all three statements

This is the single most commonly asked accounting question in IB interviews. Assume a 25% tax rate.

Answer: "On the income statement, depreciation of 10 crore reduces EBIT by 10 crore. With tax at 25%, net income falls by 7.5 crore.

On the cash flow statement, net income starts 7.5 crore lower, but we add back the full 10 crore of depreciation because it is non-cash. So cash flow from operations rises by 2.5 crore, and cash increases by 2.5 crore.

On the balance sheet, cash is up 2.5 crore and net PP&E is down 10 crore, so total assets fall by 7.5 crore. On the other side, retained earnings fall by 7.5 crore. The balance sheet balances.

The point is that higher depreciation increases cash in the short run, because it reduces taxable income without consuming cash."

Follow-up to expect: "Why did cash go up if the company is less profitable?" Because depreciation is a tax shield. The company paid 2.5 crore less tax, and tax is a real cash outflow.

3. What is working capital and how does a change in it affect cash flow?

Answer: "Working capital is current assets minus current liabilities, though in modelling we usually focus on operating working capital: inventory plus receivables minus payables.

An increase in working capital is a cash outflow, because the company has tied up money in inventory or is waiting to be paid. A decrease is a cash inflow. So a fast-growing company can be profitable and still run out of cash, because growth consumes working capital before it produces collections."

4. What is deferred tax and why does it arise?

Answer: "Deferred tax arises from temporary differences between accounting treatment and tax treatment of the same item. The classic case is depreciation, where the rate allowed under tax law differs from the rate used in the accounts.

That means the tax expense recognised in the accounts differs from the tax actually payable in that year. A deferred tax liability arises when taxable income is currently lower than book income and the difference will reverse later. A deferred tax asset arises in the opposite case, including from carried-forward losses."

5. Can a company have positive net income and still go bankrupt?

Answer: "Yes, and it happens regularly. Net income is an accounting measure, not a cash measure. A company can report profit while cash is consumed by rising receivables, inventory build-up, large capital expenditure, or debt repayments that do not appear on the income statement. If it cannot meet an obligation when it falls due, it fails regardless of reported profit."

6. What is EBITDA and what are its weaknesses as a proxy for cash flow?

Answer: "EBITDA is earnings before interest, tax, depreciation and amortisation. It is used because it approximates operating cash generation before financing and accounting choices, which makes companies with different capital structures and asset bases more comparable.

Its weaknesses matter. It ignores capital expenditure, so a capital-intensive business looks better than it is. It ignores working capital movements. It ignores interest and tax, both real cash costs. And because it is not a defined accounting measure, companies adjust it inconsistently. So EBITDA is a starting point for comparison, not a substitute for free cash flow."

DCF Questions

DCF is the most heavily tested area in IB interviews, and the one where follow-up questions go deepest.

7. Walk me through a DCF

Answer: "First, project unlevered free cash flow for an explicit forecast period, usually five to ten years. Unlevered free cash flow is EBIT, less taxes on EBIT, plus depreciation and amortisation, less capital expenditure, less the increase in working capital.

Second, calculate the weighted average cost of capital as the discount rate.

Third, discount each year's cash flow back to present value at WACC.

Fourth, calculate terminal value, either using the Gordon growth method, which is the final year cash flow grown at a perpetual rate and divided by WACC minus that growth rate, or using an exit multiple applied to terminal year EBITDA. Discount that terminal value back as well.

The sum of discounted cash flows and discounted terminal value gives enterprise value. Then bridge to equity value by subtracting net debt, minority interest and preferred stock, and adding non-operating assets. Divide by diluted shares outstanding for value per share."

Follow-up to expect: the unlevered versus levered question in the next entry. It comes up almost every time.

8. Why do you discount unlevered free cash flow at WACC rather than levered cash flow at the cost of equity?

This is the question that separates prepared candidates from memorised ones.

Answer: "Because the cash flow and the discount rate must match the claimants they belong to.

Unlevered free cash flow is the cash available to all capital providers, both debt and equity, before any financing costs. So it must be discounted at the blended cost of all that capital, which is WACC, and it produces enterprise value.

Levered free cash flow is what remains after interest and debt repayments, so it belongs only to equity holders. It must be discounted at the cost of equity, and it produces equity value directly.

Mixing them double counts or omits the effect of leverage. The unlevered approach is used more often in practice because it separates operating performance from financing decisions, which makes the valuation comparable across capital structures."

9. How do you calculate WACC?

Answer: "WACC is the weighted average of the cost of equity and the after-tax cost of debt, weighted by their proportions in the capital structure at market values.

So it is the equity weight multiplied by the cost of equity, plus the debt weight multiplied by the cost of debt multiplied by one minus the tax rate.

The cost of equity is usually estimated using the capital asset pricing model: the risk-free rate plus beta multiplied by the equity risk premium. In India the risk-free rate is typically taken from long-dated government securities, and an additional size premium may be applied for smaller companies.

Cost of debt can be taken from the company's existing borrowing rate or the yield on comparable debt. We use the after-tax cost because interest is tax deductible, which is the tax shield."

Follow-up to expect: "Why do you use market value weights rather than book value?" Because WACC represents the return investors currently require, and that is set by what they would pay today, not by historical book entries.

10. What is beta and why do you unlever and relever it?

Answer: "Beta measures how much a stock's returns move relative to the market. A beta above one means the stock is more volatile than the market.

Observed beta for a comparable company reflects both its business risk and its financial risk from leverage. To isolate business risk, you unlever each comparable's beta using its own debt-to-equity ratio and tax rate. You then take the average unlevered beta across comparables and relever it using the target company's capital structure.

This gives a beta that reflects the industry's business risk adjusted for the specific company's leverage, rather than importing someone else's financing decisions."

11. What are the two methods of calculating terminal value, and which do you prefer?

Answer: "The Gordon growth or perpetuity growth method takes the final year's free cash flow, grows it at a perpetual rate, and divides by WACC minus that growth rate. The perpetual growth rate should be conservative, typically no higher than long-run nominal GDP growth or inflation, because no company grows faster than the economy forever.

The exit multiple method applies a multiple, usually EV/EBITDA, to terminal year EBITDA, based on where comparable companies currently trade.

I would use both and cross-check them. If the exit multiple implied by my Gordon growth calculation is wildly different from where comparables trade, one of my assumptions is wrong. In practice bankers often lead with the exit multiple method because it is grounded in observable market data, while academics prefer Gordon growth because it is internally consistent."

12. Terminal value is often 60 to 80% of the total DCF value. Is that a problem?

Answer: "It is a genuine limitation and worth stating openly. It means the valuation is driven mostly by an assumption about the distant future rather than by the forecast you carefully built.

Practically, it means two things. Terminal value assumptions deserve as much scrutiny as the near-term forecast, and sensitivity analysis across the growth rate, exit multiple and WACC is not optional. If small changes in terminal assumptions swing the value dramatically, a DCF should be presented as a range alongside other methods rather than as a single number."

13. What is the mid-year convention and why use it?

Answer: "The standard DCF discounts each year's cash flow as though it all arrives on the last day of the year. In reality cash flows arrive throughout the year. The mid-year convention discounts each year's cash flow using a period of n minus 0.5 instead of n, which assumes cash arrives evenly and on average at mid-year. It produces a slightly higher valuation and is generally more realistic."

14. When would a DCF not be appropriate?

Answer: "Several cases. For banks and insurance companies, because debt is part of operations rather than financing, so free cash flow is not meaningful. There you would use a dividend discount model or residual income approach.

For early-stage companies with no positive cash flows and no forecastable path to them, since almost all the value sits in terminal value built on guesswork.

For highly cyclical companies valued at the peak or trough of a cycle, where a forecast anchored on current conditions misleads.

And in distressed situations, where the relevant question is asset recovery value rather than going-concern cash flows."

15. How would a change in the tax rate affect your DCF?

Answer: "It works through two channels in opposite directions. A lower tax rate increases after-tax operating cash flow, which raises value. But it also reduces the value of the interest tax shield, which increases the after-tax cost of debt and therefore raises WACC, which lowers value.

The cash flow effect is usually larger, so a tax cut typically increases DCF value, but a complete answer names both effects."

Comparable Company and Valuation Multiple Questions

16. Walk me through a comparable company analysis

Answer: "First, select comparables based on industry, business model, size, growth and geography, because a multiple is only meaningful against genuinely similar companies.

Second, gather financial data and calculate the relevant metrics, usually enterprise value, EBITDA, EBIT, revenue and net income, adjusting for one-off items so the numbers are comparable.

Third, calculate multiples such as EV/EBITDA, EV/Revenue and P/E, for both historical and forward periods.

Fourth, look at the range, median and mean rather than a single figure, and understand why any company sits far from the group.

Fifth, apply the appropriate multiple to the target's metric to derive an implied valuation range."

17. What is the difference between enterprise value and equity value?

Answer: "Enterprise value is the value of the operating business, irrespective of how it is financed. Equity value, or market capitalisation for a listed company, is the value attributable to shareholders only.

The bridge runs: enterprise value equals equity value plus total debt plus preferred stock plus minority interest, minus cash and cash equivalents. You subtract cash because a buyer acquiring the company effectively receives that cash, reducing the net cost.

The practical rule is that enterprise value metrics pair with pre-interest measures like EBITDA and EBIT, while equity value metrics pair with post-interest measures like net income."

Follow-up to expect: "Why is EV/Net income wrong?" Because enterprise value belongs to all capital providers while net income is after interest and therefore belongs only to equity. The numerator and denominator would represent different claimants.

18. Why is EV/EBITDA generally preferred over P/E?

Answer: "Because EV/EBITDA is capital-structure neutral. P/E is affected by how much debt a company carries, since interest reduces net income, so two identical businesses with different leverage will show different P/E ratios.

EV/EBITDA also strips out depreciation and amortisation, which removes distortion from differing asset ages and accounting policies, and it can be used for loss-making companies where P/E is meaningless.

That said, P/E is still relevant for financial institutions and for comparing returns to equity holders, and EV/EBITDA has the weakness of ignoring capital intensity entirely."

19. Which produces a higher valuation, precedent transactions or comparable companies, and why?

Answer: "Precedent transactions usually produce higher values, because acquisition prices include a control premium and often expected synergies. Comparable company multiples reflect minority stake trading prices in the public market.

Precedent transactions also carry a timing problem. A deal from two years ago reflects the market conditions of that time, not today's."

20. A company trades at a much lower multiple than its peers. Is it cheap?

Answer: "Not necessarily, and assuming so is the most common error in multiple analysis. A lower multiple usually means the market is pricing in something: slower growth, weaker margins, higher risk, governance concerns, customer concentration, or a structural decline in the business.

The right response is to investigate why rather than conclude it is undervalued. It is genuinely cheap only if you can identify something the market is getting wrong, and can say what that is."

M&A and Merger Model Questions

21. Walk me through a merger model

Answer: "Start with assumptions: the purchase price, the form of consideration between cash, debt and stock, expected synergies and transaction costs.

Value the target and determine the offer price, including any control premium.

Build the sources and uses of funds, showing where the money comes from and what it pays for.

Then create the pro forma combined income statement, adjusting for the financing effects. If cash is used, you lose interest income. If debt is used, you add interest expense. If stock is used, share count increases. Add expected synergies and any new amortisation from the purchase price allocation.

Finally calculate pro forma earnings per share and compare it to the acquirer's standalone EPS to determine whether the deal is accretive or dilutive."

22. What makes a deal accretive or dilutive?

Answer: "A deal is accretive if pro forma EPS is higher than the acquirer's standalone EPS, and dilutive if lower.

The simplest rule applies to all-stock deals: if the acquirer's P/E is higher than the effective P/E it pays for the target, the deal is accretive. Essentially, buying cheaper earnings than your own is accretive.

For cash deals, compare the target's earnings yield against the after-tax interest income being given up on the cash used. For debt-funded deals, compare it against the after-tax cost of the new debt.

One important caveat: accretion is not the same as value creation. A deal can be accretive and still destroy value if the acquirer overpays for a business with worse prospects, and dilutive while being strategically sound."

23. What are synergies and how do you treat them in a model?

Answer: "Revenue synergies come from cross-selling, pricing power or expanded distribution. Cost synergies come from eliminating duplicate functions, procurement scale and facility consolidation.

In practice, cost synergies are modelled with more confidence because they are more controllable, while revenue synergies are treated sceptically because they depend on customer behaviour. Both should be phased in over time rather than assumed from day one, and the integration costs required to achieve them should be modelled too.

A model that assumes full synergies immediately and no cost to achieve them is not credible."

24. What is goodwill and how does it arise in an acquisition?

Answer: "Goodwill arises when the purchase price exceeds the fair value of the identifiable net assets acquired. In the purchase price allocation process you write up acquired assets to fair value and recognise identifiable intangibles such as brands, customer relationships and technology. Whatever remains of the premium is recorded as goodwill.

Goodwill is not amortised under current standards, but it is tested for impairment. Identifiable intangibles with finite lives are amortised, which creates new amortisation expense in the pro forma income statement and reduces reported EPS."

LBO Questions

25. Walk me through an LBO

Answer: "Start with the entry assumptions: purchase price and entry multiple, the debt and equity mix, interest rates and transaction fees. Build the sources and uses to show total funding and what it pays for.

Project the company's operating performance over the holding period, typically three to five years, with a full debt schedule showing interest, mandatory amortisation and any cash sweep that uses excess cash to pay down debt.

At exit, apply an exit multiple to the terminal year EBITDA to get exit enterprise value, subtract the remaining net debt to get equity value at exit.

Then calculate returns: the internal rate of return and the multiple of invested capital on the sponsor's original equity cheque."

26. Why does leverage increase equity returns?

Answer: "Two mechanisms. First, the sponsor puts in a smaller equity cheque for the same asset, so any given increase in enterprise value produces a larger percentage return on that smaller base.

Second, the company's own cash flow is used to repay debt during the holding period. Every rupee of debt repaid transfers value from debtholders' claim to the sponsor's equity, even if enterprise value never changes.

The trade-off is that leverage amplifies losses equally. If performance disappoints, the equity is wiped out faster."

27. What are the main drivers of IRR in an LBO?

Answer: "Four, roughly in order of reliability.

EBITDA growth, through revenue growth and margin improvement, which is the operational driver the sponsor can actually influence.

Debt paydown, where the company's cash flow deleverages the balance sheet over the holding period.

Multiple expansion, exiting at a higher multiple than entry. This is the least controllable and depends largely on market conditions, so a model relying on it is fragile.

And time, because IRR is time-sensitive. The same money multiple achieved in three years produces a much higher IRR than in five."

28. What makes a good LBO candidate?

Answer: "Stable, predictable cash flows so debt can be serviced reliably. A strong market position with some barrier to entry. Low ongoing capital expenditure requirements, since capex competes with debt service for cash. Opportunities for operational improvement, so the sponsor can add value rather than just financing. Asset backing that supports borrowing. And a credible exit path, whether strategic sale, secondary sale or IPO.

Highly cyclical, capital-intensive or high-growth-but-cash-burning businesses are poor candidates."

Excel and Modelling Mechanics

Increasingly asked, because banks want to know whether you have actually built a model or only studied one.

29. What are your rules for building a clean model?

Answer: "Separate inputs, calculations and outputs, ideally on different sheets or clearly marked sections. Never hardcode a number inside a formula, because nobody reviewing the model can find it.

Use consistent colour coding, conventionally blue for hard-coded inputs and black for formulas, so a reviewer can see immediately what is an assumption.

Keep one consistent formula across each row so it can be copied without breaking. Avoid merged cells, which break ranges and copying.

Build in checks: the balance sheet must balance, sources must equal uses, and the cash flow statement's closing cash must tie to the balance sheet. A visible error check row at the top saves hours.

And use INDEX MATCH rather than VLOOKUP where possible, because it does not break when columns are inserted and can look leftward."

30. What is circularity in a model and how do you handle it?

Answer: "Circularity typically arises in the interest calculation. Interest expense depends on the average debt balance, the debt balance depends on how much cash is available to repay debt, and available cash depends on interest expense. Excel reports a circular reference.

There are three common approaches. Enable iterative calculation in Excel, which resolves it but can produce unstable models and propagate errors. Use the opening debt balance rather than the average, which removes circularity at the cost of slight accuracy. Or build a circuit breaker, a switch that forces interest to zero so the model can be reset when it breaks.

Most bank models use either the opening balance approach or iterative calculation with a circuit breaker, because an unrecoverable circular model is worse than a marginally less precise one."

What to Expect in a Live Modelling Test

Many IB and deal advisory processes in India include a practical Excel test, usually 60 to 90 minutes.

What you are typically given: historical financials for a company, a set of forecast assumptions, and instructions to build a three-statement model, sometimes with a DCF or simple LBO on top.

What is actually graded:
 

• Does the balance sheet balance? If not, most other marks are irrelevant.
• Is the model structured so someone else could follow it?
• Are formulas consistent and free of hardcoding?
• Did you finish something complete rather than leaving half a model?
• Are there checks built in?
   

The most common mistakes: spending too long formatting, building too much detail in the income statement and running out of time before the balance sheet, and not reading the instructions fully.

Practical advice: build the skeleton of all three statements first, even if roughly, then add detail. A complete simple model scores better than an elaborate incomplete one. And say your assumptions aloud or note them in the file, because unstated assumptions read as errors.

Six Mistakes That Cost Candidates IB Offers

• Memorising steps without understanding logic. The follow-up question always finds this out.
   
• Claiming to have built models you only watched someone build. Interviewers ask what broke and how you fixed it.
   
• Going silent when unsure. "I am not certain, but here is how I would reason it out" scores far better than a blank pause.
   
• Defending an error after being corrected. Bankers work in teams where being corrected daily is normal. Defensiveness is a bigger red flag than the mistake.
   
• Ignoring the Indian market. Know a few recent Indian deals, roughly where the Nifty is, and what your target bank has worked on.
   
• Neglecting the fit round. Technicals get you shortlisted; "why banking" and stamina questions still decide outcomes.
   

Final Thoughts

The candidates who do well in IB technical rounds are not the ones who memorised the most answers. They are the ones who built two or three models themselves and therefore understand why each line exists.
 

So before your interview, do this. Pick a listed Indian company, download its annual report, and build a three-statement model and a DCF from a blank sheet. It will break. Fix it. That process teaches you more than any question list, including this one, because it gives you something to say when the interviewer asks the second question.
 

And when you do not know something, say so and reason out loud. In banking, being corrected is a daily event. How you take it is part of what is being assessed.