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. 032How do you verify the validity of a client's pipeline to forecast revenue?Forecasting and budgetingHardcase studyHWHarris WilliamsInvestment Banking · Richmond · 2025

   Say this

   Test it against history rather than accepting the weightings. Take the pipeline as it stood 12 months ago, see what actually converted by stage, and apply those realised rates instead of management's. The gap between the two is your adjustment.

   Then walk it

   1. First, back-test. Pull the pipeline snapshot from four quarters ago, match it to closed business, and compute conversion by stage, by deal size and by sales rep. If stage-four deals converted at 45 percent while the model assumes 80, you have your answer.
   2. Second, check ageing. Deals that have sat in the same stage for three quarters are not pipeline, they are hope. I would strip or heavily discount anything past a normal cycle length.
   3. Third, look for hygiene problems: duplicate opportunities, deals with no close date or a close date that has been pushed four times, values entered as round numbers, and a bulge in the final quarter that mirrors the sales incentive calendar.
   4. Fourth, corroborate outside the CRM. Signed letters of intent, purchase orders, customer references, and for a diligence exercise, calls with two or three named prospects. Revenue that cannot be corroborated gets a haircut.
   5. Fifth, check coverage. Pipeline value over the target. Three times coverage on a 33 percent historical win rate is consistent; three times coverage on a 15 percent win rate is a miss waiting to happen.
   6. Then I would present it as a range: management case, back-tested case, and a downside using bottom-quartile conversion, with the bridge between them explained in one slide. The bridge is the deliverable, not the number.

   Where candidates lose it

   Accepting management's probability weightings and multiplying. Every CRM is optimistic near quarter end. The work is back-testing realised conversion by stage and stripping stale deals, and saying that is what gets you hired.

   Expect next

   • The sales head says your haircut is insulting. How do you handle it?
   • What if the CRM data only goes back two quarters?
   • How would this change for a business with three large customers?

   Reported by candidates at Harris Williams (Investment Banking, Richmond, 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.