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. 078Tell me about your Excel and Python skills. What do you use each for?Modelling, Excel and dataIntermediatetechnicalState StreetGlobal Data · Boston · 2024

    Say this

    Excel for anything a human has to read, review or change, which is most of finance. Python when the data is too big, too messy or too repetitive for Excel, so extracting and cleaning, reconciliations across large files, and anything I have to run every month.

    Then walk it

    1. Be specific about Excel level. Not 'advanced' but what you can do: three-statement models with circularity handled, driver-based revenue builds, power query transformations, pivot-based reporting packs, sensitivity tables and data validation.
    2. Then Python with named libraries and a real use. Pandas for joining and cleaning, openpyxl or xlsxwriter to write the formatted output back to Excel, requests for pulling from an API. The example is what counts: I built a script that reconciled a 400,000-row ledger extract against a bank statement and produced an exceptions file, which replaced two days of manual matching each month.
    3. Say where you draw the line, because that is the judgement they are testing. A model the CFO will change the assumptions in stays in Excel. A monthly data pull with 15 transformation steps goes into Python. Putting business logic in a script nobody else can read is a handover risk, not a win.
    4. Mention SQL if you have it, because in most GCC and shared service roles the data sits in a warehouse and being able to write your own query removes your dependence on a reporting team.
    5. Add the visualisation layer if it is real: Power BI or Tableau, and specifically whether you have built a data model with relationships rather than just charts.
    6. And be honest about the level. Claiming Python and then failing a simple list-comprehension question is far worse than saying you are comfortable with pandas and still learning object-oriented work.

    Where candidates lose it

    Saying 'advanced Excel and basic Python' with no evidence. Name the functions, name the libraries, and attach one before-and-after with a time saving. Overclaiming is fatal because these questions are usually followed by a live test.

    Expect next

    • What would you never do in Python that you would do in Excel?
    • Do you write SQL?
    • Walk me through the logic of your reconciliation script.

    Reported by candidates at State Street (Global Data, Boston, 2024). 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.