22 Financial Modeling Interview Questions [With Model Answers]

FM Interview Questions at a Glance

Financial modeling interviews test five question families: accounting mechanics, valuation, Excel/modeling process, LBO & M&A logic, and fit. What separates a hire from a reject is rarely raw knowledge — it's whether you can explain the mechanics cleanly, out loud, and survive the interviewer's follow-up.

Almost every technical round in India — IB, Big 4 transaction advisory, or a corporate FP&A desk — now includes a live Excel or case component, not just spoken Q&A. Interviewers care less about a "correct" final number and more about 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 with a model answer and the follow-up trap that question 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 whether you're interviewing at 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, comps, and LBO mechanics from round one, often with a timed Excel case where you build a mini three-statement or valuation model under observation. Big 4 transaction advisory and valuation teams test similar mechanics but weight accounting rigor and documentation discipline more heavily, since deliverables there are reports, not pitch decks.

Corporate FP&A and treasury desks ask fewer LBO questions and more variance-analysis, budgeting, and scenario-toggle questions — the modeling is operational, not deal-driven. Across all three, one constant holds: 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. Net income opens cash from operations on the cash flow statement, where you add back non-cash items and adjust for working capital changes. The ending cash balance lands on the balance sheet, and 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, since depreciation itself moves no cash.

On the balance sheet, cash is up ₹2.5 and net PP&E down ₹10, so assets fall ₹7.5 — matched by retained earnings falling ₹7.5. It balances.

Follow-up trap: "Prove the balance sheet balances." 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. 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?" 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 — usually because the business collects from customers before paying suppliers, as in retail, FMCG and subscription models. It is not automatically a red flag: in those models, suppliers and customers finance operations, a structural advantage.

Follow-up trap: "When would it signal trouble?" When it comes from stretched payables under cash strain — 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. It isn't amortised 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. 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 can't explain why WACC 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 — EBIT × (1 − tax) + D&A − capex − increase in net working capital — for five to ten years. Discount each year at WACC. Add a terminal value for everything beyond the forecast (Gordon growth or exit multiple), discount it back too, and the sum is enterprise value.

Follow-up trap: "Why unlevered FCF and not levered?" Unlevered FCF is cash available to all capital providers, which is what WACC — a blended cost of debt and equity — is built to discount. Levered FCF 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. It's 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: final-year FCF × (1 + g) ÷ (WACC − g) under Gordon growth. 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?

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?" 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 or P/E multiples are a fair proxy for how the market would price your target.

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 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.

Modeling & Excel Questions

This is where the live test happens. Interviewers grade how you structure a workbook under pressure — traceable logic, consistent formulas, and how you handle the one mechanic almost every candidate fumbles: circularity.

Q12. How would you structure a financial model from scratch?

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 lives 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. The classic: interest expense depends on the debt balance, the debt balance depends on cash available for repayment or revolver draws, and cash available depends on net income — which depends on interest expense. Excel can't resolve that in one pass.

Three standard fixes: enable iterative calculation (see Microsoft's guidance) so Excel loops to a stable answer; build a circularity switch that forces interest to zero to reset a broken model; or 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 — 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?

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." 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?

One input cell — a dropdown or a 1/2/3 — that switches the whole model between base, upside and downside by driving a lookup (CHOOSE or INDEX) into the assumption rows. One cell flexes every output, instead of re-keying dozens of assumptions.

Follow-up trap: "What if someone types 5?" Data validation restricting the cell to valid choices, plus an IFERROR or default case, so a bad entry can't silently blank out the model.

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 buys a company using mostly debt and a slice of equity, then uses the company's own cash flow to pay the debt down over a three-to-seven-year hold. 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." Three: EBITDA growth, multiple expansion, 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?

It asks whether the deal raises or lowers the acquirer's EPS. For an all-stock deal: if the acquirer's P/E is higher than the target's, the deal is generally accretive — expensive stock is buying cheaper earnings, so EPS gained per share issued exceeds EPS given up.

Follow-up trap: "Does that hold for a cash or debt deal?" No — there you compare the target's earnings yield (inverse P/E) with the after-tax cost of the new debt or the interest forgone on cash. Yield above financing cost is accretive; below is dilutive.

Q19. What goes into a sources and uses table for an LBO?

Uses: the equity purchase price, refinancing the target's existing debt, and transaction fees. Sources: new debt tranches, the sponsor's equity cheque, and sometimes management rollover. 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 — the first thing an interviewer checks in a live LBO build.

Fit & Judgment Questions

Fit questions get asked in every single round, not just at the end — and they're 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 that you enjoy building and stress-testing models, not the abstract idea of finance. "I like numbers" signals you haven't reflected, and interviewers hear it 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. Restate the logic behind your assumption, concede the specific part of the challenge that has merit, and explain how the model would change if the interviewer's view were right — reasoning under pushback is the skill on display.

Follow-up trap: "So which of us is actually right?" Often neither, definitively — they're checking 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. A three-statement model or simple DCF, timed, no reference material — the single best rehearsal for the live Excel round.
• Say every model answer out loud, timed. Technical walkthroughs in 60–120 seconds; short definitional answers in 30–45. 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.