FM Interview Questions at a Glance
Financial modeling interviews test five question families: accounting mechanics, valuation, Excel/modeling process, LBO (leveraged buyout) & M&A (mergers & acquisitions) logic, and fit. Raw knowledge rarely decides who gets hired. What decides it is whether you can explain the mechanics cleanly, out loud, and survive the interviewer's follow-up.
Almost every technical round in India now includes a live Excel or case component, not just spoken Q&A. This holds at investment banks, Big 4 transaction advisory, and corporate FP&A (financial planning & analysis) desks alike. Interviewers care less about a "correct" final number. They care whether your logic is traceable — can you say why a cell moves the way it does?
This post runs all 22 questions we use in QuintEdge mock interviews, grouped by what's actually being tested. Each one comes with a model answer and the follow-up trap it sets up. Read it as a rehearsal script, not a glossary — the follow-up is usually where candidates lose the room.
How Do FM Interviews Work in India?
Most Indian financial modeling interviews run three to four rounds: an HR/screening call, one or two technical rounds, and a case or live-Excel test before a final fit conversation. The exact mix shifts depending on where you're interviewing — an investment bank, a Big 4 advisory practice, or a corporate finance team.
Investment banks and boutique M&A shops front-load technical depth. Expect DCF (discounted cash flow — a valuation method that values a business using its own projected future cash), comps (comparable-company analysis), and LBO mechanics from round one. There's often a timed Excel case too, where you build a mini three-statement or valuation model while someone watches.
Big 4 transaction advisory and valuation teams test similar mechanics. But they weight accounting rigor and documentation discipline more heavily, since their deliverables are reports, not pitch decks.
Corporate FP&A and treasury (cash management) desks ask fewer LBO questions. They ask more variance-analysis (actual-vs-budget), budgeting, and scenario-toggle questions instead — the modeling here is operational, not deal-driven. One constant holds across all three: you will be asked to walk through your own resume model if you've listed one. So know it cold before you list it. For the wider IB process — fit rounds, deal discussions, brain teasers — see our investment banking interview questions guide. This post stays on the modeling technicals.
Accounting & Three-Statement Questions
These questions test whether you can trace a transaction through all three statements in real time, not recite definitions. For the broader accounting question bank, see our accounting and finance interview questions guide. The five below are the ones modeling interviews lean on hardest.
Q1. Walk me through the three financial statements and how they link.
The income statement ends at net income (revenue minus all costs and taxes — the company's final profit for the period). Net income opens cash from operations on the cash flow statement. There, you add back non-cash items and adjust for changes in working capital (the cash tied up in day-to-day items like inventory and unpaid customer bills).
The ending cash balance then lands on the balance sheet. Net income also flows into retained earnings, which is what keeps assets equal to liabilities plus equity.
Follow-up trap: "If depreciation increases, what happens to each statement?" Have Q2's answer ready before you finish this one. It's the standard next move.
Q2. If depreciation increases by ₹10, walk me through all three statements (25% tax rate).
On the income statement, pre-tax income falls by ₹10. Tax falls by ₹10 × 25% = ₹2.5. So net income falls by ₹7.5.
On the cash flow statement, start at net income (−₹7.5) and add back the non-cash ₹10. Cash rises by +₹2.5 — purely the tax shield (the tax you save because depreciation is deductible), since depreciation itself moves no cash.
On the balance sheet, cash is up ₹2.5 and net PP&E (property, plant & equipment) is down ₹10. So assets fall ₹7.5 — matched by retained earnings falling ₹7.5. It balances.
Follow-up trap: "Prove the balance sheet balances." Say this out loud, in under 30 seconds: assets −7.5 (cash +2.5, PP&E −10) equals equity −7.5 (retained earnings). Hesitate and it reads as memorised, not understood.
Q3. Why does an increase in accounts receivable reduce cash flow?
Accounts receivable is revenue booked but not yet collected — money customers owe you but haven't paid yet. When AR rises, part of the period's net income is sitting in receivables rather than the bank. So the cash flow statement subtracts the increase when computing cash from operations.
Follow-up trap: "And if accounts payable rises instead?" That's the opposite direction. You've booked an expense but not paid it, so an AP increase is a source of cash, added back rather than subtracted.
Q4. What is negative working capital, and is it a red flag?
Negative working capital means current liabilities exceed current assets. This usually happens because the business collects from customers before paying suppliers, as in retail, FMCG (fast-moving consumer goods) and subscription models. It is not automatically a red flag — in those models, suppliers and customers finance operations, which is a structural advantage.
Follow-up trap: "When would it signal trouble?" It signals trouble when it comes from stretched payables under cash strain. That means a company delaying suppliers because it can't pay, not because its model is built that way.
Q5. What is goodwill, and when is it created or impaired?
Goodwill arises in an acquisition when the purchase price exceeds the fair value of the target's identifiable net assets. In plain terms, it's created when a buyer pays more than the target's assets are worth on paper. It isn't amortised (written down gradually) under most accounting standards. Instead it's tested for impairment at least annually (see IAS 36) and written down through the income statement if the acquired business has deteriorated.
Follow-up trap: "Does an impairment affect cash flow?" No — it's non-cash. It hits net income and is added back on the CFS (cash flow statement). But it usually signals the acquirer overpaid, which is the judgment point they want you to spot.
Valuation Questions
Valuation questions test whether you understand why a methodology works, not just its formula. The classic failure mode: candidates recite the DCF steps perfectly. But they can't explain why WACC (the weighted average cost of capital) pairs with unlevered cash flow, or why enterprise value and equity value diverge.
Q6. Walk me through how you'd build a DCF valuation.
Project unlevered free cash flow (FCF) for five to ten years. The formula: EBIT (operating profit) × (1 − tax) + D&A (depreciation & amortisation) − capex (spending on long-term assets) − increase in net working capital.
Discount each year at WACC — the blended return a company must offer all its investors. Add a terminal value for everything beyond the forecast (Gordon growth or exit multiple), and discount that back too. The sum of both is enterprise value.
Follow-up trap: "Why unlevered FCF and not levered?" Unlevered FCF is cash available to all capital providers. That's exactly what WACC — a blended cost of debt and equity — is built to discount. Levered FCF (cash flow after debt payments) pairs with cost of equity in an equity-direct DCF instead.
Q7. How do you calculate WACC, and why does it matter?
WACC = (E/V × cost of equity) + (D/V × after-tax cost of debt), using market values. Here E is equity, D is debt, V is the two combined, and cost of equity is the return shareholders expect.
WACC is the discount rate that converts future cash flows into today's money. Set it wrong and every downstream number is wrong, however good the forecasts.
Follow-up trap: "Why the after-tax cost of debt?" Interest is tax-deductible, so debt's true cost is the stated rate net of the tax shield. Using the pre-tax rate overstates WACC and undervalues the company.
Q8. What is terminal value, and what can go wrong with Gordon growth?
Terminal value captures all cash flows beyond the explicit forecast. Under Gordon growth it's final-year FCF × (1 + g) ÷ (WACC − g), where g is the assumed long-term growth rate. The formula breaks if g approaches WACC — the denominator collapses toward zero and the output turns absurd or negative.
Follow-up trap: "What g would you actually use?" Something near long-run GDP growth. No company outgrows the economy forever, and a higher g quietly assumes it eventually becomes the economy.
Q9. When would you NOT use a DCF?
Skip it when free cash flow is negative or unpredictable. Early-stage companies give you no stable base, so tiny assumption changes swing the value wildly. It also fits banks and financial institutions poorly: debt is their raw material, not financing, which breaks the WACC framework. Dividend discount or residual income models work better there.
Follow-up trap: "So how do you value a pre-revenue startup?" Use comps on a forward metric like revenue, or a venture-capital back-solve from a target exit. Precision DCF on guessed inputs is false comfort.
Q10. How do you select comparable companies for trading comps?
Start with the same industry and business model, then filter on size, growth, margins and geography. You want a peer set close enough that its EV/EBITDA (enterprise value to EBITDA) or P/E (price-to-earnings) multiples are a fair proxy for how the market would price your target. EBITDA is earnings before interest, tax, depreciation and amortisation — roughly, operating profit with depreciation added back.
Follow-up trap: "Only two or three true comps exist — now what?" Widen deliberately to adjacent sectors with similar economics and disclose the compromise. Or lean harder on a DCF or precedent-transaction cross-check (pricing evidence from past deals) rather than presenting a thin comp set as definitive.
Q11. What's the difference between enterprise value and equity value?
Enterprise value is the value of core operations, belonging to all capital providers. Equity value is what remains for shareholders. The bridge: equity value = EV − total debt − preferred stock − minority interest + cash.
Follow-up trap: "Why ADD BACK cash?" It's a non-operating asset that offsets the real cost of buying the operations. An acquirer can use the target's own cash to retire debt or part-fund the deal.
Run the bridge once with round numbers. Take an enterprise value of ₹1,000 crore. Subtract ₹300 crore of total debt. Subtract ₹50 crore of preferred and minority interest. Add back ₹100 crore of cash. Equity value: ₹750 crore. (Illustrative figures.)
Modeling & Excel Questions
This is where the live test happens. Interviewers grade how you structure a workbook under pressure: traceable logic and consistent formulas. They also watch how you handle the one mechanic almost every candidate fumbles — circularity, the formula loop explained below.
Q12. How would you structure a financial model from scratch?
Use three layers: inputs (hard-coded, blue font, one place), calculations (the three statements, formulas only), and outputs (a summary tab). The core rule: never hard-code a number inside a formula. Every assumption should live exactly once, so one change flows through the whole model.
Follow-up trap: "Why does that separation matter beyond neatness?" Auditability. Others can trace your logic without reverse-engineering it, and buried hard-codes are the most common source of errors that go undetected.
Q13. What is circularity in a model, and how do you break it?
Circularity is a closed formula loop, where two or more cells depend on each other so Excel can never settle on a final value. The classic case: interest expense depends on the debt balance. The debt balance depends on cash available for repayment or revolver draws (borrowing from a revolving credit line). And cash available depends on net income — which depends on interest expense. Excel can't resolve that in one pass.
There are three standard fixes. First, enable iterative calculation (see Microsoft's guidance) so Excel loops to a stable answer. Second, build a circularity switch that forces interest to zero to reset a broken model. Third, compute interest on the beginning-of-period balance only, which avoids the loop entirely.
Follow-up trap: "Which fix would you use in a live test?" Beginning-balance interest. It's fastest to build and it can't crash mid-interview, at the cost of slightly understating interest versus an average-balance calculation.
Q14. What Excel shortcuts or habits do interviewers actually check?
They check keyboard-first navigation, correct absolute-vs-relative referencing ($ locks) so formulas copy cleanly, and formatting conventions — blue inputs, black formulas — that make a model auditable at a glance. The table below covers the shortcuts worth drilling.
Follow-up trap: "Copy this formula across five years without breaking the assumption link." This is a pure $-lock test. Fail to anchor the assumption cell before dragging, and the model silently goes wrong.
Q15. How do you error-proof a model before presenting it?
Build check rows: a balance-sheet check (assets − liabilities − equity = 0) and a sources-equals-uses check where financing is involved. Then stress-test with an extreme input, like zero growth, and see whether the model breaks or behaves.
Follow-up trap: "Your balance check shows a small non-zero — first move?" Trace backwards: balance sheet → cash flow statement → income statement. Small residuals are almost always a broken link or stray hard-code, not rounding.
Q16. What is a scenario toggle, and how would you build one?
It's one input cell — a dropdown or a 1/2/3 — that switches the whole model between base, upside and downside scenarios. It works by driving a lookup formula (CHOOSE or INDEX) into the assumption rows. One cell flexes every output, instead of you re-keying dozens of assumptions.
Follow-up trap: "What if someone types 5?" Use data validation to restrict the cell to valid choices, plus an IFERROR or default case. That way a bad entry can't silently blank out the model.
| Shortcut / habit | What it does | Why interviewers check it |
|---|---|---|
| F4 (absolute reference lock) | Locks a cell reference with $ signs | Prevents formulas breaking when copied across rows/columns |
| Ctrl + Arrow keys | Jumps to the edge of a data range | Signals keyboard-first navigation, not mouse-dependent |
| Alt + E, S, V (Paste Special > Values) | Pastes only the value, not the formula | Standard way to break a circular reference manually |
| Ctrl + ` (show formulas) | Toggles formula view across the sheet | Lets you audit an entire model's logic at a glance |
| Named ranges | Assigns a readable name to a cell/range | Makes formulas self-explanatory to an auditor |
LBO & M&A Questions
LBO and M&A questions test deal intuition — where returns come from in a leveraged buyout, and whether an acquisition helps or hurts the acquirer's earnings per share. Depth expected here scales with how deal-focused the role is.
Q17. Walk me through the basic intuition of an LBO.
A sponsor (the investor buying the company) buys it using mostly debt and a slice of equity. They then use the company's own cash flow to pay the debt down over a three-to-seven-year hold (the years the sponsor owns the business). At exit, more of the sale price belongs to equity simply because less debt remains — even if the business itself never got more valuable.
Follow-up trap: "Name the return levers." There are three: EBITDA growth, multiple expansion (selling at a higher valuation multiple than you paid), and debt paydown. Interviewers expect all three unprompted — stopping at two reads as incomplete.
Q18. What is accretion/dilution analysis, and what's the rule of thumb?
Accretion/dilution analysis asks whether the deal raises or lowers the acquirer's EPS (earnings per share). For an all-stock deal, here's the rule: if the acquirer's P/E is higher than the target's, the deal is generally accretive (EPS goes up). That's because expensive stock is buying cheaper earnings, so the EPS gained per share issued exceeds the EPS given up.
Follow-up trap: "Does that hold for a cash or debt deal?" No. There you compare the target's earnings yield (the inverse of P/E — earnings divided by price) with the after-tax cost of the new debt or the interest forgone on cash. Yield above financing cost is accretive; yield below it is dilutive.
Q19. What goes into a sources and uses table for an LBO?
Uses (where the money goes): the equity purchase price, refinancing the target's existing debt, and transaction fees. Sources (where the money comes from): new debt tranches (slices of new borrowing), the sponsor's equity cheque, and sometimes management rollover (managers re-investing their own stake). By construction, total sources equal total uses.
Follow-up trap: "Your sources don't equal uses — what does that tell you?" It's a bug, full stop. The identity holds by design, so a mismatch means a missing plug or broken formula. That's the first thing an interviewer checks in a live LBO build.
Put illustrative numbers on all three. Buy a company at 8.0× on ₹125 crore of EBITDA — ₹1,000 crore, funded with ₹600 crore of debt and a ₹400 crore equity cheque. Exit in Year 5 at 10.0× on ₹150 crore of EBITDA — ₹1,500 crore, with the debt fully repaid. Your ₹400 crore came back as ₹1,500 crore — 3.75× the money. The split: ₹200 crore from EBITDA growth (25 × 8.0), ₹300 crore from multiple expansion (150 × 2.0), and ₹600 crore from debt paydown.
Fit & Judgment Questions
Fit questions get asked in every single round, not just at the end. This is where technically strong candidates most often lose ground, because they treat these as filler instead of preparing them as rigorously as the technicals.
Q20. Why financial modeling, and why this role specifically?
The strong version connects a specific experience — a project, an internship, a self-built model — to a concrete realisation about the work itself. You realised you enjoy building and stress-testing models, not the abstract idea of finance. "I like numbers" signals you haven't reflected. Interviewers hear that line daily.
Follow-up trap: "What exactly did you enjoy — the numbers or the story behind them?" Either answer works; having none is the failure. They're testing whether the interest would survive the grind of real modeling work.
Q21. Walk me through a model you've built.
Structure it as a mini case: the business context, your key assumptions and their sources, the output, and what you'd improve if you rebuilt it today. That last part matters most. It shows growth, not just a finished file.
Follow-up trap: "What's the single weakest assumption in it, and why?" Name a real one, not a humble-brag. Honest self-critique builds more credibility than claiming the model was flawless — intellectual honesty is what's being tested.
Q22. I disagree with one of your assumptions — defend it.
Don't cave instantly, and don't dig in either. Restate the logic behind your assumption, then concede the specific part of the challenge that has merit. Explain how the model would change if the interviewer's view were right — reasoning under pushback is the skill on display here.
Follow-up trap: "So which of us is actually right?" Often neither, definitively. They're checking whether you can hold a position with evidence while staying genuinely open to being wrong — exactly what a live deal team needs.
How to Prepare in the Final Week
In your last week, prioritize rehearsal over new learning. One more concept read is worth far less than saying your existing answers fluently, fast, under a clock.
- Rebuild one full model from a blank sheet. Try a three-statement model or simple DCF, timed, with no reference material. This is the single best rehearsal for the live Excel round.
- Say every model answer out loud, timed. Aim for 60–120 seconds on technical walkthroughs, and 30–45 seconds on short definitional answers. Silent reading doesn't train the speaking muscle.
- Drill the follow-up traps specifically. For each question above, answer the trap first. If you can defend it without hesitation, the base question is no longer a risk.
- Run a mock with someone who pushes back. A nodding friend doesn't replicate an interviewer who disputes your terminal growth rate or asks why your balance sheet doesn't balance.
- Know your resume model cold. If you've listed a project, assume it comes up first. Rehearse Q21's answer for it specifically, not generically.
One habit separates strong candidates from anxious ones: treat every "I don't know" as a chance to reason out loud rather than freeze. Structured, honest uncertainty consistently beats a confident wrong answer.
Frequently Asked Questions About Financial Modeling Interviews
It's designed to be finishable, not impossible — usually a mini three-statement build, a simplified DCF, or a small LBO case within 30–60 minutes. The difficulty is less about complexity and more about working cleanly under time pressure and a watching interviewer. Candidates who've rebuilt full models from scratch at home, untimed, consistently outperform those who've only studied templates.
Beyond basic arithmetic formulas, know INDEX/MATCH or VLOOKUP for pulling assumptions, IF and IFERROR for scenario logic and error-proofing, and absolute referencing ($ locking) so formulas copy correctly across years. Equally important is knowing how to structure a workbook — separating inputs, calculations, and outputs — since interviewers judge structure as closely as formula accuracy.
Yes. Freshers are mainly tested on whether they understand core mechanics cleanly — the three statements, basic DCF logic, and simple Excel structure. Experienced candidates face deeper follow-ups on judgment: defending assumptions under challenge, discussing deal context, and demonstrating they've actually built (not just learned) the models they claim to know.
Candidates with a structured modeling background typically need two to four weeks of focused revision and mock practice. Those learning the concepts for the first time should budget significantly longer, since the goal isn't memorizing answers but internalizing mechanics well enough to handle unpredictable follow-ups. The final week should shift entirely from learning to rehearsal.
Memorizing formulas without understanding the underlying logic. Candidates can usually state the DCF formula or the three-statement flow correctly. But they freeze the moment an interviewer asks "why" — why unlevered FCF, why add back cash, why does the balance sheet still balance. The follow-up question, not the original question, is where most candidates are actually eliminated.
No — LBO depth scales with how deal-focused the role is. Investment banks, boutique M&A advisory, and private equity-adjacent roles test LBO mechanics heavily. Big 4 valuation teams and corporate FP&A roles ask far fewer LBO questions, if any, focusing instead on accounting rigor or budgeting and scenario logic respectively.
Policies vary by firm, so always ask directly rather than assume. Regardless of the policy, treat the test as if notes won't help much — the constraint is usually time, not memory. Fumbling through a cheat sheet under a clock often costs more time than it saves. Genuine fluency built through untimed practice beforehand is the real preparation.
