Financial Analysis interview preparation

The three statements, working capital, ratios, forecasting, variance analysis, costing, capital budgeting, valuation and the modelling and Excel work that fills the day, plus the fit questions about why this seat. Every question is either traced to a named firm from a public candidate report, or tagged at desk level when we could not trace it — we do not invent attributions.

Jump to the question bank
Question bank

100 questions, mapped to the firms that asked them

Questions
100
Traced to a firm
42
Firms
28
Updated
September 2026
Asked at
All firmsMoody's7Bain Capital3State Street3Ares Management2BlackRock2D.E. Shaw2Morgan Stanley2Oaktree Capital Management2S&P Global2Bridgewater Associates1Citadel1Franklin Templeton1Golub Capital1Harris Williams1Houlihan Lokey1J.P. Morgan1Jane Street1Marshall Wace1Millennium Management1Morningstar1PIMCO1Sycamore Partners1Truist Securities1Two Sigma1Vanguard1Wellington Management1Wells Fargo Securities1Wolverine Trading1
Topic
All topicsThree statements9Accounting policy and standards5Working capital and cash7Ratio analysis8Forecasting and budgeting9Variance and management reporting7Unit economics and costing8Capital budgeting7Cost of capital and valuation7Markets and rates5Modelling, Excel and data8Business partnering6Brainteasers and estimation4Fit and career10
Level
AnyCoreIntermediateHard
Type
AnyTechnicalCaseBrainteaserMarket viewFit
Showing 1–1 of 1 · filtered from 100Clear filters
  1. 079Tell me about a time you automated a process in a previous role.Modelling, Excel and dataIntermediatetechnicalCitadelCorporate Development · New York · 2025

    Say this

    Pick one process, quantify the before and after in hours and in error rate, and describe what you changed. The structure is: the manual process, why it was painful, what you built, what it saved, and what you would do differently.

    Then walk it

    1. Choose a process with a number attached. A monthly report that took six hours and now takes twenty minutes is a story. 'I made the file more efficient' is not.
    2. Describe the before properly: where the data came from, how many manual steps, what broke. For example, four exports from two systems, copy-pasted into a template, with a reconciliation done by eye.
    3. Then what you built and why that approach. Power query to pull and transform, a single flat data table, pivots for the output, and a check that flags any variance above a threshold. Say why you chose that over a script, because the reasoning is being assessed as much as the result.
    4. Then the quantified result: hours saved per month, errors eliminated, and the more interesting one, what the time was reinvested in. Saving six hours matters because it turned into analysis somebody read.
    5. Then the part most candidates skip: adoption and handover. Did anyone else use it after you left? I would say I documented it on one page and walked two colleagues through it, because an automation that only you can run is a dependency, not an improvement.
    6. And close with a limitation. Something like: it still needed a manual export because we had no database access, and the proper fix was a warehouse connection I could not get approved. That honesty reads far better than a flawless story.

    Where candidates lose it

    Telling a vague efficiency story with no numbers. And do not claim an automation that removed a control. Interviewers in finance care that the checks survived, so say explicitly what validation you built in.

    Expect next

    • How did you make sure the output was right?
    • Did anyone else keep using it?
    • What would you automate next?

    Reported by candidates at Citadel (Corporate Development, New York, 2025). Source: Wall Street Oasis.

Firm tags come from public, anonymous candidate reports on Wall Street Oasis: strong signal, not sworn testimony. Firms are named as the places a question was reported, not as partners of Fin Maverick. Answers are written for this page to show how to think out loud; they are not scripts to recite.