Financial Analysis interview preparation

Questions

100

Traced to a firm

42

Firms

28

Updated

September 2026

Asked at

All firmsMoody's7Bain Capital3SSState Street3AMAres Management2BLBlackRock2DED.E. Shaw2MSMorgan Stanley2Oaktree Capital Management2S&P Global2Bridgewater Associates1Citadel1FTFranklin Templeton1Golub Capital1HWHarris Williams1Houlihan Lokey1J.P. Morgan1Jane Street1MWMarshall Wace1Millennium Management1Morningstar1PIMCO1Sycamore Partners1TSTruist Securities1Two Sigma1Vanguard1WMWellington 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

1. 074You inherit a model from someone who left last week and the CFO wants to use it on Monday. How do you audit it?Modelling, Excel and dataHardcase studyFinancial modellingBig Four

   Say this

   Work from the outside in. First sanity-check the outputs against reality, then trace the three or four numbers that drive them, then stress-test rather than read every cell. You cannot audit 40,000 formulas by Monday, so you audit the ones the answer depends on.

   Then walk it

   1. Start with the outputs. Does revenue growth, margin and cash flow look plausible against history and against the sector? An implied 45 percent EBITDA margin on a distribution business tells you more in ten seconds than an hour of cell tracing.
   2. Then the structural checks: does the balance sheet balance, does the cash flow tie to the cash movement, does historical data reconcile to the published accounts. Any break here and nothing downstream is trustworthy.
   3. Then mechanical scanning. Use formula view or a spreadsheet audit tool to find hard-coded constants inside formulas, inconsistent formulas within a row, broken links to external files, circular references and unintended ranges. A row that is consistent for eleven periods and different in the twelfth is exactly what you are hunting.
   4. Then stress tests, which are the fastest way to find logic errors. Set revenue growth to zero, set it to 50 percent, set price to nil. If EBITDA does not move sensibly, or the balance sheet breaks under a stress, you have found a hard-code or a broken link.
   5. Then trace the top three value drivers back to their source, and only those. For a DCF that is usually WACC, terminal growth and the revenue build. Verify each against a document, not against another cell in the same model.
   6. And I would tell the CFO on Friday what I had and had not verified, in writing, with a short list of numbers I do not yet trust. Presenting an unaudited model as clean is the career risk here, not the model itself.

   Where candidates lose it

   Saying you would check every formula. There is not time and it is the wrong method. Outputs first, structural checks, mechanical scan for inconsistencies, then stress tests. And say you would disclose what you could not verify.

   Expect next

   • What is the fastest way to find a hard-coded number?
   • You find an error that changes the answer 20 percent. What do you do?
   • How would you hand this model on properly?
2. 076Your model has a circular reference because interest depends on debt and debt depends on cash flow after interest. How do you handle it?Modelling, Excel and dataHardtechnicalFinancial modellingCorporate finance

   Say this

   Three options: calculate interest on the opening balance instead of the average, use average balances with iterative calculation and a circuit breaker, or resolve it with a small macro. For most work I use opening balances, because the accuracy gain from averages is not worth the fragility.

   Then walk it

   1. The loop: interest expense reduces net income, which reduces cash, which changes the revolver balance, which changes interest. With average debt balances the formula genuinely refers to itself.
   2. Option one, opening balance interest. Clean, no circularity, and typically understates interest slightly in a growing debt year. State the simplification in the assumptions and move on. This is what I would do nine times out of ten.
   3. Option two, enable iterative calculation and build a circuit breaker: a switch cell that forces interest to zero, which lets you break the loop and reset when the model blows up into errors. Without the breaker a single bad input propagates hash-value errors through the whole file and you cannot recover it.
   4. Option three, a macro that copies the calculated interest into the input cell and loops until it converges. Precise, but it means the model needs a macro run to be correct, which is a real handover risk.
   5. The reason it matters beyond aesthetics: circularity makes a model unstable, and an unstable model in a live diligence or board process is a liability. Precision that comes at the cost of reliability is a bad trade.
   6. And the sizing argument I would make out loud: on a 500 crore debt balance at 9 percent, opening versus average balances might move interest by 1 to 2 crore, which is inside the noise of every other assumption in the model.

   Where candidates lose it

   Just switching on iterative calculation with no circuit breaker. That is how models become unrecoverable. Also, pretending average-balance precision matters more than stability shows inexperience; say which trade-off you are making and why.

   Expect next

   • How would you build the circuit breaker?
   • How much does the approximation actually cost you?
   • When would you insist on average balances?
3. 080How would you make money with social media data?Modelling, Excel and dataHardcase studyTwo SigmaGeneralist · New York · 2024

   Say this

   Find a place where social data leads a number somebody pays for, and prove the lead is real before you monetise it. The two honest routes are forecasting revenue ahead of official data, and selling the cleaned signal to people who trade or plan on it.

   Then walk it

   1. Start from the decision, not the data. Who pays for being two weeks early? A consumer company deciding on promotional spend, a retailer planning inventory, an investor sizing a quarter. Each of those is a different product.
   2. The forecasting route: mention volume, sentiment and follower growth for a brand, mapped against reported quarterly revenue. If mentions of a product line lead revenue by four weeks with a stable relationship, you have a nowcast that beats consensus.
   3. Then validate it properly, because this is where the question is really marked. Back-test out of sample, check the relationship holds across at least two or three cycles, and control for the obvious confounders: a viral post is not demand, a paid campaign inflates mentions, and bot activity is a large share of raw volume.
   4. Then the monetisation models: sell the cleaned data feed, sell a derived index, or use it internally to trade or to plan. The data business scales better and is easier to defend legally; the internal use captures more of the value but only while the signal stays private.
   5. Then the hard constraints, which a good answer names unprompted. Platform terms of service and API restrictions, privacy law, no personal data, no material non-public information, and signal decay: any edge from public data erodes as more people buy the same feed.
   6. So my proposal would be a narrow pilot. One sector, five brands, six quarters of history, one testable claim: can we predict reported revenue better than consensus. If the back-test fails, stop, because most alternative data claims do not survive it.

   Where candidates lose it

   Jumping to 'sentiment analysis predicts stock prices'. Everyone says it and almost nobody validates it. The marks are in the back-test, the confounders such as bots and paid campaigns, the legal constraints, and naming who pays for the output.

   Expect next

   • How would you back-test that claim?
   • What would you do about bot-generated volume?
   • What happens to the edge once you sell the data?

   Reported by candidates at Two Sigma (Generalist, New York, 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.