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. 066Terminal value: perpetuity growth or exit multiple? Which do you trust?Cost of capital and valuationHardtechnicalCorporate financeKPO research support

   Say this

   I compute both and use them as a check on each other. Perpetuity growth is theoretically cleaner because it is built from the same assumptions as the rest of the model; exit multiple is more intuitive but imports today's market sentiment into a value ten years out.

   Then walk it

   1. Gordon growth: final year free cash flow times one plus g, divided by WACC minus g. It is very sensitive to the spread between WACC and g. At a 12 percent WACC, moving g from 4 to 5 percent raises terminal value by about 14 percent.
   2. Exit multiple: apply a normalised EBITDA multiple to the final year. The problem is you are assuming what the market will pay a decade from now, and today's multiple reflects today's rates and today's mood.
   3. So the discipline is to run both and reconcile. Take the perpetuity terminal value and back out the implied EBITDA multiple. If a 4.5 percent growth rate implies 19 times EBITDA for a business that has always traded at 11, something is wrong upstream, usually an unrealistic terminal margin.
   4. The internal consistency check that most models fail: at steady state, growth requires reinvestment. Terminal growth of 6 percent with capex set equal to depreciation implies infinite returns on new capital. Either fund the growth with reinvestment or lower the growth.
   5. Also check that terminal-year return on capital is plausible. If the model assumes the company earns 30 percent ROIC forever, you are assuming competitive advantage with no decay, which almost never survives.
   6. My practical rule: perpetuity growth capped at long-run nominal GDP, cross-checked against the implied multiple, with a sensitivity table over WACC and growth. And I would say plainly that terminal value is where two-thirds of the answer lives, so it deserves more scrutiny than the year-three revenue assumption people spend their week on.

   Where candidates lose it

   Picking one and not cross-checking. The mark of a good answer is backing out the implied exit multiple from the perpetuity method, and noticing that terminal growth without reinvestment is internally inconsistent.

   Expect next

   • Back out the implied multiple from a 4 percent perpetuity at a 12 percent WACC.
   • How much reinvestment does 5 percent terminal growth require?
   • What terminal ROIC would you assume?
2. 070What would you think if a company like Google began paying dividends?Markets and ratesHardtechnicalS&P GlobalDebt Capital Markets · Chicago · 2022

   Say this

   I would read it as a signal about the growth runway, not as a return of value. A company initiating a dividend is telling you it has more cash than it has projects earning above its cost of capital. That is maturity, and sometimes it is good news.

   Then walk it

   1. The signalling logic: dividends are sticky. Cutting one is punished, so initiating a dividend is a commitment to a permanent cash outflow, which management only makes if it is confident about the base cash flow and out of high-return reinvestment ideas.
   2. So the first question is what it says about reinvestment. If ROIC on incremental capital is 25 percent, paying cash out is value-destructive versus reinvesting. If the marginal project is earning single digits, the dividend creates value by stopping empire-building.
   3. Second, why a dividend rather than a buyback. Buybacks are flexible and tax-efficient for shareholders; dividends attract a different investor base, income and index funds, which can broaden the shareholder register and lower the cost of equity slightly.
   4. Third, the credit view, which is the angle a rating analyst would want: a dividend is a new permanent claim on cash ahead of debt reduction. For a company with a fortress balance sheet that is immaterial; for a levered issuer it is a negative, and a debt-funded dividend is a clear credit negative.
   5. Fourth, the market reaction is usually mixed for exactly this reason. Income investors buy, growth investors read it as a deceleration signal and sell. Watch which register turns over.
   6. For India there is a specific wrinkle worth adding: since dividend distribution tax was abolished, dividends are taxed in the investor's hands at slab rates, which makes buybacks relatively more attractive for high-bracket promoters and changes the payout preference.

   Where candidates lose it

   Answering as if it is simply shareholder-friendly. The insight is that it signals a shrinking set of high-return projects. And in a ratings or DCM interview you must give the credit angle: a new permanent claim on cash ahead of the lenders.

   Expect next

   • Dividend or buyback, and why?
   • When would a dividend be a credit negative?
   • How would you model a dividend policy change?

   Reported by candidates at S&P Global (Debt Capital Markets, Chicago, 2022). Source: Wall Street Oasis.

3. 072What is an appropriate IRR range and valuation multiple for the software industry?Markets and ratesHardtechnicalMoody'sAnalytics · New York · 2018

   Say this

   Sponsors in software typically underwrite to a 20 to 25 percent IRR, and the sector trades on revenue multiples rather than EBITDA because so much profit is reinvested in growth. But I would refuse to give a single multiple without knowing growth, retention and margin, because the dispersion inside software is enormous.

   Then walk it

   1. On IRR: private equity underwrites mid-20s and reports something lower. For software specifically the return is driven by revenue growth and multiple expansion rather than deleveraging, because these are asset-light businesses that carry debt against recurring revenue rather than against assets.
   2. On multiples: enterprise value to forward revenue is the working metric while a company is reinvesting through the P&L, and enterprise value to EBITDA once it matures. Quoting an EBITDA multiple for a company at 3 percent margin is meaningless.
   3. The three variables that set the multiple: revenue growth, net revenue retention and gross margin. Growth above 30 percent with retention above 115 percent commands a multiple several times that of a 10 percent grower with 95 percent retention, and the market re-rates that spread aggressively with the rate cycle.
   4. So the honest answer is a range with a condition attached. Mature, slow-growth, profitable software has traded in the mid to high single digits of revenue; high-growth has traded anywhere from 6 to 20 times forward revenue depending on the rate environment. Any point number I quote is wrong within a quarter.
   5. The rule of 40, growth plus margin above 40, is the shorthand the market uses to compare across the growth-versus-profit trade-off. It is a screen, not a valuation, and its weakness is that it treats a point of growth and a point of margin as equal when growth compounds.
   6. For an Indian angle: listed Indian IT services is a different business and trades on price to earnings in the low-to-mid twenties, because it is people-leveraged services revenue, not product. Conflating SaaS and IT services multiples is the mistake to avoid.

   Where candidates lose it

   Quoting a confident single multiple. The sector's dispersion is the answer, and so is naming the drivers, growth, retention and margin, that set the multiple. Also be ready to say why revenue multiples are used at all, which is reinvestment through the P&L.

   Expect next

   • Why revenue multiples rather than EBITDA?
   • What is net revenue retention and what level is good?
   • How does the rate environment move software multiples?

   Reported by candidates at Moody's (Analytics, New York, 2018). Source: Wall Street Oasis.

4. 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?
5. 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?
6. 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.

7. 081You are the lead analyst in a meeting with the CFO. What questions would you ask?Business partneringHardsuperdayMoody'sCorporate Finance · New York · 2018

   Say this

   I would ask about the things I cannot get from the accounts: the quality and durability of the revenue, the margin and operating leverage outlook, the financial policy, and the liquidity plan. Questions a CFO cannot answer with a number from the annual report are the ones worth asking.

   Then walk it

   1. Revenue quality: how much of next year's revenue is already contracted, what the renewal or repeat rate is, what the top five customers represent, and where pricing has actually held when input costs moved.
   2. Margin and operating leverage: what proportion of the cost base is fixed, what volume decline takes EBIT to zero, and what the plan is if volumes fall 15 percent. That last question tells you more about management than any strategy slide.
   3. Financial policy, and I would press on it because it is a commitment, not a forecast: what is the leverage ceiling you will not cross, what would you do with a large acquisition opportunity that broke it, and what is the dividend and buyback intention.
   4. Liquidity and maturities: what is the refinancing schedule, how much undrawn committed facility is there, what covenants apply and what headroom exists at the last test date. Headroom, not the ratio, is what tells you about risk.
   5. Then the accounting questions I would want explained rather than assumed: the gap between EBITDA and operating cash flow over three years, the recurring 'exceptional' items, related-party balances, and any change in estimate or policy.
   6. And one open question at the end, because it usually produces the most useful answer: what keeps you awake at night about this business that the market has not focused on? Then listen rather than fill the silence.

   Where candidates lose it

   Asking questions answered in the annual report. The whole test is whether you know what is not in the filings: financial policy intent, covenant headroom, the downside plan. Also, ask about the EBITDA to cash gap specifically, because that is the credit analyst's question.

   Expect next

   • Which of those would you ask first if you had five minutes?
   • The CFO deflects on the covenant headroom. What do you conclude?
   • How would you verify the answers afterwards?

   Reported by candidates at Moody's (Corporate Finance, New York, 2018). Source: Wall Street Oasis.

8. 082The sales director says your variance report is wrong and that finance does not understand the business. How do you handle it?Business partneringHardtechnicalCorporate FP&ABusiness finance

   Say this

   Separate the two claims. If the numbers are wrong I want to know today, so I would sit with them and reconcile line by line. If the numbers are right and the interpretation is disputed, that is a more useful conversation and I would let them define the alternative view and test it.

   Then walk it

   1. First, take the challenge seriously and go to them, not with them over email. Nine times out of ten there is a definitional gap: they measure bookings, I report recognised revenue; they think gross of discount, I report net.
   2. Do the reconciliation together on one page, from their number to mine, with each bridging item named. That page ends the argument permanently, and it is worth more than any amount of persuading.
   3. If the error is mine, fix it, tell everyone who received the original, and say what I changed so it cannot recur. Owning it fast buys more credibility than never being wrong.
   4. If the numbers hold, shift the conversation from accuracy to cause. 'The revenue number is agreed. The question is why realisation fell 4 percent. Here are the three customers where it happened; is that a deliberate commercial decision?' Now you are partnering rather than policing.
   5. Then deal with the real grievance underneath, which is usually that finance reports on them rather than to them. I would offer to change the pack: their KPIs, their cuts of the data, delivered before their weekly meeting rather than after.
   6. And I would not trade accuracy for peace. If the number is right, it stays in the pack and goes to the CFO unchanged, and I would say that plainly and without heat. Business partnering is not the same as agreement.

   Where candidates lose it

   Either caving on the number or getting defensive. The strong answer is a shared reconciliation page, then moving the conversation from accuracy to cause, while making clear the number does not change to keep the peace.

   Expect next

   • What if they escalate to the CFO before you finish?
   • How would you rebuild the relationship over a quarter?
   • What would you change in the pack?
9. 083Two days before the board meeting you realise the quarter is going to miss by a wide margin. What do you do?Business partneringHardsuperdayDED.E. ShawStrategy and Operations · New York · 2025

   Say this

   Tell my manager immediately, before I have the full explanation. Then in parallel verify the number, build the bridge from the last forecast to the new one, and prepare the two or three actions being taken. Bad news travels first, analysis follows.

   Then walk it

   1. Escalate within the hour, with what I know and what I do not. The cardinal sin is waiting until you have a tidy story, because the value of the warning decays by the hour and a CFO surprised in a board meeting will never trust you again.
   2. Then verify before it goes anywhere else. Is it a genuine shortfall, a timing slip, a cut-off error or an unposted accrual? A miss that turns out to be a data problem, after the board was warned, is its own kind of damage.
   3. Then the bridge, which is the actual deliverable: from the last communicated forecast to the new expectation, broken into volume, price, mix, cost and timing, with each item owned by a name. Boards can absorb a miss. They cannot absorb a miss you cannot explain.
   4. Then the forward view, because the board's first question is never about the quarter, it is about the year. What does this mean for the full-year forecast, for cash, and for covenant headroom at the next test date.
   5. Then the actions. Two or three concrete things being done, with expected impact and timing. Not a promise to make it up; a credible statement of what is and is not recoverable.
   6. And I would flag anything with a disclosure or covenant consequence to the controller and, if listed, to the company secretary, because a material shortfall can carry obligations that are not FP&A's call to make.

   Where candidates lose it

   Trying to fix or soften it before telling anyone. That is the instinct and it is the wrong one. Escalate first, then verify, then bridge. Also remember the full-year and covenant implications, because that is what the board actually asks about.

   Expect next

   • What if your manager tells you to hold it until after the meeting?
   • How do you present a miss without sounding defensive?
   • What would you change in the forecast process afterwards?

   Reported by candidates at D.E. Shaw (Strategy and Operations, New York, 2025). Source: Wall Street Oasis.

10. 086Tell me about a time you faced an ethical decision.Business partneringHardsuperdaySSState StreetGlobal Data · Boston · 2024

    Say this

    Pick a real dilemma with a cost to you, describe how you decided, and say what you actually did. The story has to involve pressure, otherwise it is not an ethical decision, it is just a correct one.

    Then walk it

    1. A usable finance example: being asked to push a cost accrual into the next period to hold a quarterly margin. Small, plausible, and everybody in finance recognises it.
    2. Describe the pressure honestly. It came from someone senior, the amount looked immaterial, and there was a defensible-sounding argument, that the invoice had not arrived. That is exactly how real accounting issues begin, as a judgement rather than a lie.
    3. Then how you reasoned: is the expense incurred in this period, yes, so the accrual belongs here. Then the test I would name out loud, would I be comfortable explaining this to the auditor and having it in the file. If the answer is no, the decision is made.
    4. Then the action, which is where it matters: I raised it with my manager first, in private, with the supporting documentation rather than an accusation, and asked how they wanted it handled. It was booked in the correct period.
    5. Then the outcome and cost, including if it was awkward. If the result had gone the other way, the next step is the controller, and being able to say you know the escalation path matters more than having a triumphant ending.
    6. Keep it proportionate. You do not need a whistleblowing epic. A small, well-handled accrual question with a clear principle applied is more credible than a dramatic story, and interviewers hear the invented ones immediately.

    Where candidates lose it

    Choosing an example with no cost or no pressure, which shows you have not thought about it. Equally bad is making your manager the villain. Show that you escalated with documentation, privately and proportionately, and that you know the next escalation step.

    Expect next

    • What if your manager had insisted?
    • Where is the line between judgement and manipulation in an accrual?
    • Have you ever seen something you did not report?

    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.