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. 062Why is debt cheaper than equity, and why not fund everything with debt?Cost of capital and valuationCorephone / first roundCorporate financeCorporate FP&A

   Say this

   Debt is cheaper for three reasons: lenders rank ahead of shareholders so they take less risk, their return is contractual rather than residual, and interest is tax-deductible. You cannot fund everything with debt because beyond a point the risk of financial distress raises the cost of both debt and equity.

   Then walk it

   1. Seniority and security come first. A lender has a claim on cash flow before any dividend and usually a charge on assets, so the required return is lower. Equity gets what is left, which may be nothing.
   2. Then the tax shield. At a 25 percent tax rate, a 9 percent coupon costs you 6.75 percent after tax. That is a real cash subsidy and it is why leverage lifts returns on equity.
   3. So on paper more debt lowers WACC, and that is where Modigliani and Miller with taxes stops being useful. In the real world, leverage brings fixed cash obligations, covenants, loss of flexibility and eventually a risk premium on the debt itself.
   4. The distress costs are both direct and indirect. Direct is legal and restructuring cost. Indirect is worse: customers hesitate, suppliers tighten terms, good staff leave, and you cannot fund the capex that keeps you competitive. That is how leverage destroys operating performance, not just financial ratios.
   5. There is also the agency and flexibility argument. Debt capacity is an option worth holding. A company with headroom can buy a distressed competitor; a fully levered one cannot, and gets bought instead.
   6. So the practical answer is an optimal range rather than a point. For a stable Indian consumer business that might be 1.5 to 2.5 times net debt to EBITDA; for a cyclical commodity producer, materially less, because the same leverage is far riskier against volatile EBITDA.

   Where candidates lose it

   Stopping at the tax shield. The complete answer needs seniority, the tax shield, then distress costs and loss of flexibility as the offset. Naming a leverage range for a specific business type is what makes it sound practical.

   Expect next

   • What is the optimal capital structure for a cement company?
   • How do you know when a company has too much debt?
   • Does the tax shield still matter for a company paying MAT?
2. 068What is the current SOFR rate?Markets and ratesCoretechnicalBain CapitalGeneralist · Boston · 2023

   Say this

   Give the level, then show you know what it is. SOFR is the secured overnight financing rate, the overnight cost of borrowing cash against US Treasuries, and it replaced USD LIBOR as the benchmark for floating-rate loans. Know the number the week of your interview and know roughly where term SOFR sits.

   Then walk it

   1. What it is: a transaction-based rate calculated from actual overnight repo trades, published each morning by the New York Fed. Because it is secured and backward-looking, it is nearly risk-free, unlike LIBOR which embedded bank credit risk.
   2. That difference is why loan documents add a credit spread adjustment when they convert from LIBOR to SOFR, historically in the region of 10 to 26 basis points depending on tenor.
   3. It tracks the Fed's target range closely, so if you know where the federal funds range sits you can bracket SOFR within a few basis points. Say the range and then the number, so if your number is a week stale the answer still stands.
   4. Term SOFR, the one, three and six month forward-looking versions, is what leveraged loans actually price off. A credit priced at SOFR plus 500 has an all-in cost of term SOFR plus 5 percent.
   5. The Indian equivalents are worth having ready in the same breath: the RBI repo rate, MIBOR for overnight rupee funding, and the fact that Indian corporate loans are typically benchmarked to an external benchmark lending rate or to MCLR.
   6. And the reason they ask: it is a five-second check on whether you read anything. Also be ready for what the rate implies, because the follow-up is always what it means for leverage, deal volume or hurdle rates.

   Where candidates lose it

   Not having a number. This is pure preparation and there is no way to talk around it. Quote the Fed funds range alongside it so a slightly stale number still lands, and have the RBI repo rate ready for an Indian interview.

   Expect next

   • Why did the market move from LIBOR to SOFR?
   • What is the RBI repo rate right now?
   • What does the current level mean for leveraged lending volumes?

   Reported by candidates at Bain Capital (Generalist, Boston, 2023). Source: Wall Street Oasis.

3. 077What is your favourite Excel function?Modelling, Excel and dataCorephone / first roundSSState StreetTax · Boston · 2022

   Say this

   INDEX with MATCH, or XLOOKUP if the version supports it, because it looks up in any direction and does not break when a column is inserted. Give an actual function, then say what you built with it, because that is the part they are testing.

   Then walk it

   1. Why INDEX MATCH over VLOOKUP: VLOOKUP only looks right, it breaks silently when columns move, and it is slower on large ranges. That answer alone tells an interviewer you have maintained someone else's file.
   2. Then say where you used it. Something like: I used INDEX MATCH on two axes to map 400 cost centres to a reporting hierarchy, so a change in the hierarchy needed one table update rather than re-pointing 400 formulas.
   3. Have two more ready, because the real question is the breadth of your toolkit. SUMIFS for driver-based aggregation, which is the workhorse of any actuals-versus-budget pack. And a pivot table over a clean flat table, which is still the fastest way to interrogate a ledger extract.
   4. If they push further, the ones worth naming are power query for repeatable data cleaning, dynamic arrays like FILTER and UNIQUE, and OFFSET or CHOOSE for scenario switching, plus goal seek and data tables for sensitivity.
   5. And one thing to volunteer: I avoid volatile and hard-to-audit constructions. Nested IFs five deep, merged cells, and formulas that span sheets in long chains all make a model unmaintainable even when they work.
   6. The habit I would mention is building the data layer as one flat table with one row per transaction and no merged cells, because every reporting problem downstream gets easier if the source is clean.

   Where candidates lose it

   Naming VLOOKUP with no reason, or answering with a life philosophy instead of a function. Name one, say why it beats the obvious alternative, and attach it to something you actually built. That takes 30 seconds and passes the screen.

   Expect next

   • Why not VLOOKUP?
   • Show me how you would build an actuals-versus-budget pack.
   • What Excel habit do you consider bad practice?

   Reported by candidates at State Street (Tax, Boston, 2022). Source: Wall Street Oasis.

4. 085Tell me about a time you dealt with conflict, a time you showed leadership, and where you want to be in five years.Business partneringCorephone / first roundWolverine TradingOperations · Chicago · 2019

   Say this

   Three separate stories, 90 seconds each, all in situation, action, result form. Prepare them as a set so they do not all come from the same project, and make sure the conflict story ends in a resolution you contributed to rather than one that resolved itself.

   Then walk it

   1. Conflict: pick a disagreement on substance, not a personality clash. A good finance version is disputing a forecast or a cost allocation with someone senior to you. Show that you separated the person from the position, went to the data, and changed either their mind or yours.
   2. The failure mode in conflict stories is being either the hero or the victim. The best ones include what you got wrong, for example that you sent the challenge by email first and should have gone in person.
   3. Leadership: it does not require a title. Coordinating a close when the controller was on leave, taking over a stalled project, or training two new joiners all count. What they listen for is initiative without authority and a result you can measure.
   4. Five years: be specific enough to be credible and general enough to be plausible. Something like: leading a business finance team for a product line, having done a full cycle of close, planning and business partnering, and being the person the business head calls before making a decision.
   5. Do not say you want to move to investment banking or the buy side in an FP&A interview. Retention is a live concern in GCC and shared-service hiring, and that answer ends the process.
   6. And connect the five-year answer back to this seat with one concrete link: the specific exposure in their role that takes you there. That is what turns a generic ambition into a reason to hire you.

   Where candidates lose it

   Reusing one project for all three stories, and giving a five-year answer that implies you will leave. Prepare six stories covering conflict, leadership, failure, deadline pressure, teamwork and ethics, and make the five-year answer end inside their organisation.

   Expect next

   • What would you do differently in the conflict situation now?
   • Tell me about a time you led without authority.
   • What would make you leave a job?

   Reported by candidates at Wolverine Trading (Operations, Chicago, 2019). Source: Wall Street Oasis.

5. 090If you had infinite time and money, what invention would you make?Brainteasers and estimationCoresuperdayDED.E. ShawConsulting · New York · 2026

   Say this

   Pick one specific thing, explain the problem it solves, and then reason about it like an analyst: who benefits, what it would cost, what would be hard, and what could go wrong. The invention is a prompt; the thinking is what is being marked.

   Then walk it

   1. Specificity beats ambition. 'Cure all disease' is a non-answer. Something like a cheap, accurate soil-nutrient sensor that tells a smallholder farmer exactly what to apply, in the local language, from a phone, is answerable and testable.
   2. Then the problem size, with a rough number. Roughly a hundred million-plus smallholdings in India, most fertilising by habit rather than measurement, which wastes input cost and damages yields. That frames the value without pretending to precision.
   3. Then the mechanism and the hard part, because interviewers listen for whether you can identify the real constraint. The sensor is not the hard part; distribution, calibration across soil types and getting the recommendation trusted are.
   4. Then the economics: what it would have to cost per unit to be adopted, who pays, and whether the value is captured through hardware, subscription or through the input supplier.
   5. Then the second-order effects, which is where you can be genuinely interesting: it shifts bargaining power toward farmers, changes fertiliser demand mix, and has an environmental effect through runoff. Good answers hold both the upside and the unintended consequence.
   6. Keep it to two minutes and show some actual enthusiasm. This question is also a personality screen: they want to know whether you think about anything outside a spreadsheet.

   Where candidates lose it

   Giving a grand abstraction, or a joke answer. The point is structured curiosity: one specific invention, the problem, the hard constraint, the economics, and an unintended consequence. And do not choose something you cannot discuss for three minutes.

   Expect next

   • What would be the hardest part to actually build?
   • How would you fund it if money were not infinite?
   • What would be the unintended consequence?

   Reported by candidates at D.E. Shaw (Consulting, New York, 2026). Source: Wall Street Oasis.

6. 091Tell me about yourself.Fit and careerCorephone / first roundFTFranklin TempletonGeneralist · San Francisco · 2023

   Say this

   Ninety seconds, three beats: where you are from academically, the two experiences that turned into this interest, and why this specific role is the next step. It is not a biography, it is an argument for why you fit this seat.

   Then walk it

   1. Beat one, one sentence on background: degree, institution, and the one thing about it that is relevant. Commerce at a specific college, with a focus on accounting and costing, not your school or your hometown.
   2. Beat two, the turning point with evidence. A specific internship or project and what it taught you. 'In my FP&A internship I rebuilt the monthly variance pack and found that 40 percent of the margin gap sat in one channel. That is when I realised I liked the part where the number turns into a decision.'
   3. Beat three, the bridge to this role. Name what the seat involves and what you want from it: exposure to the full planning cycle, working with business heads, building the models rather than only reading them.
   4. Then stop. Silence after 90 seconds invites the interviewer to pick a thread, which is exactly what you want, because you have prepared the threads.
   5. The tone matters as much as the content. This is the only question where you control the agenda, so the details you choose determine the next ten minutes. Put in one thing you want to be asked about.
   6. What to leave out: chronology from school, a list of every certification, your family, and any negative reason for leaving your current role. Keep it forward-looking and concrete.

   Where candidates lose it

   Reciting your CV chronologically. It takes four minutes and lands nothing. Three beats, one concrete result, and end with why this role. Practise it aloud, because the unrehearsed version always runs long.

   Expect next

   • Why finance rather than consulting?
   • Which part of that internship did you find hardest?
   • Walk me through your resume in more detail.

   Reported by candidates at Franklin Templeton (Generalist, San Francisco, 2023). Source: Wall Street Oasis.

7. 092Walk me through your resume. Why us, and who do you see as our competitors?Fit and careerCorefirst roundOaktree Capital ManagementCorporate Finance · Los Angeles · 2022Oaktree Capital ManagementGeneralist · Los Angeles · 2023

   Say this

   Three questions in one, and the third is the real screen. The resume walk is a narrative of increasing relevance, 'why us' must name something only this firm has, and the competitor question tests whether you understand their business or just their brand.

   Then walk it

   1. Resume walk: chronological but with a thread, and 20 seconds per item, more on the last and most relevant one. Each stop answers 'what did I learn that makes me useful here', not 'what was I responsible for'.
   2. Why us: one specific, verifiable thing. Their position in a particular market, a strategy they are known for, a business they built recently, the structure of the role itself. If your answer would work for three other firms, it is not an answer.
   3. Competitors: name three, and place them. Not a list but a map. 'You compete with X on the same mandates, Y is larger but less focused on this segment, and increasingly the competition is Z from a different model entirely.' That last clause is what earns the marks.
   4. Then say something about how they differ, and be prepared to say where they are weaker, carefully. Interviewers respect a candidate who can say 'you are smaller in this segment, which is why the recent hires there caught my attention'.
   5. The research needed is one hour: their website's own description of the business, the most recent annual report or investor presentation, one news item from the last quarter, and the role description read closely.
   6. And connect it back to yourself in one line. 'That is why I want this seat rather than a generalist one' is the sentence that closes the loop and turns research into fit.

   Where candidates lose it

   Answering 'why us' with things that are true of every firm: prestige, culture, learning opportunity, great people. And guessing at competitors. Getting the competitive set wrong is worse than saying you are not sure, because it proves the research was decorative.

   Expect next

   • Where do you think we are weaker than them?
   • Which of our businesses would you want to work in?
   • What do you know about what we actually do day to day?

   Reported by candidates at Oaktree Capital Management (Corporate Finance, Los Angeles, 2022); Oaktree Capital Management (Generalist, Los Angeles, 2023). Source: Wall Street Oasis.

8. 095Why financial planning and analysis rather than investment banking?Fit and careerCorefirst roundCorporate FP&AGCC finance centres

   Say this

   Because the work is about running a business rather than transacting on one. In FP&A you own a forecast, see whether you were right, and sit with the people who have to act on it. That feedback loop is what I want, and it does not exist in a deal seat.

   Then walk it

   1. Frame it positively, not as an avoidance of hours. Interviewers in corporate finance and GCC roles hear 'better work-life balance' as the only real reason and it makes them worry about ambition.
   2. The substantive difference: banking is episodic and external, you value a company once and move on. FP&A is continuous and internal, you build a plan, watch reality diverge from it, explain why, and change the plan. You get corrected by outcomes, which is the fastest way to learn a business.
   3. Then name what you like about the specific work: driver-based forecasting, variance analysis, business partnering, pricing decisions, capital allocation on real capex proposals. Naming the tasks proves you know what the job is.
   4. Then the career argument, which senior people respect: FP&A is the path to a commercial finance or CFO track, because you learn the operations rather than only the capital markets. Say where you want that to lead.
   5. Acknowledge the trade-off honestly. Banking gives you transaction reps and a faster technical ramp. FP&A gives you ownership and breadth. You are choosing, and saying what you are giving up makes the choice credible.
   6. For an Indian GCC or shared-service seat, add one line about the specific opportunity there: global process exposure, working across entities and standards, and the fact that the centre often owns the analytics for a whole region. That converts the answer into 'why this seat' as well.

   Where candidates lose it

   Any version of 'the hours are better'. Even if true, it signals you would leave for a deal seat later. Lead with the forecast-and-feedback loop and name specific FP&A tasks, so it reads as a preference rather than a fallback.

   Expect next

   • Would you take an investment banking offer if you got one?
   • Which part of FP&A do you think you would be worst at?
   • Where do you want to be in five years?
9. 099Describe a project you have worked on, and a time you worked with data.Fit and careerCorephone / first roundWMWellington ManagementGeneralist · Boston · 2024BLBlackRockRisk Management · Atlanta · 2025

   Say this

   One project, told in four beats: the question you were answering, the data and what was wrong with it, what you did, and what changed because of it. The data half is really asking whether you have handled messy real data or only clean coursework data.

   Then walk it

   1. Lead with the business question, not the tools. 'We did not know which customers were unprofitable after discounts and freight' is a better opening than 'I used Python and Power BI'.
   2. Then be honest about the data, because this is the differentiator. How many rows, how many sources, and what was wrong: duplicate customer codes, inconsistent units, missing freight allocation, three systems that disagreed on the customer master. Anyone who has done real analysis can describe the mess.
   3. Then the method and one judgement call you had to make. For example, allocating freight by weight rather than by revenue, and why that choice changes the answer. Judgement calls are what interviewers probe, so bring one deliberately.
   4. Then the result with a number and a consequence. '14 percent of customers were loss-making after landed cost, and renegotiating the worst twenty moved gross margin 60 basis points.' No number, no story.
   5. Then what you would do differently, which is the most credible part. 'I should have validated the customer master with the sales team before building the model; I rebuilt a week of work because of it.'
   6. Have two versions ready, one where the project succeeded and one where it did not, because the follow-up is often about a project that failed. And keep the first telling to two minutes.

   Where candidates lose it

   Describing responsibilities instead of a result, or describing a clean dataset. The data question is specifically probing whether you have cleaned messy real data and made a defensible judgement call about it. Bring the mess and bring a number.

   Expect next

   • What was the hardest part of the data work?
   • Tell me about a project that failed.
   • How did you check that your answer was right?

   Reported by candidates at Wellington Management (Generalist, Boston, 2024); BlackRock (Risk Management, Atlanta, 2025). Source: Wall Street Oasis.

10. 100What do you do for fun?Fit and careerCorephone / first roundMillennium ManagementFinancial Planning and Analysis · New York · 2025

    Say this

    Answer it like a human. Name one or two real interests, give one specific detail that proves it is real, and stop. It is a genuine question about whether people will want to sit next to you for ten hours a day.

    Then walk it

    1. Pick something true and specific. Not 'reading' but the two books you finished last month. Not 'sport' but the league you play in on Sunday mornings and where your team finished.
    2. The specific detail is the whole answer. 'I run, I did the Mumbai half marathon in February and I am trying to get under two hours' is memorable. 'I enjoy fitness' is not.
    3. Two is enough. Something social and something solitary works well, because it shows range without turning into a list.
    4. It is also the question most likely to build actual rapport, so it is worth answering warmly rather than strategically. Interviews are long and interviewers remember the candidate they enjoyed talking to.
    5. What not to do: pretend a work skill is a hobby. 'For fun I read annual reports' is transparent and it makes the rest of your answers less believable. If you genuinely do invest personally, say it as an interest, not as a performance claim.
    6. And be ready for the follow-up, because there always is one. If you name a book, you will be asked what it was about. If you name a team, you will be asked about last weekend. Do not name anything you cannot discuss for two minutes.

    Where candidates lose it

    Giving a corporate non-answer or claiming a hobby that is really work. Both read as inauthentic and this is the one question where authenticity is the entire point. One or two real things, one specific verifiable detail, then stop talking.

    Expect next

    • What was the last book you read?
    • How did you get into that?
    • What do you do to switch off during close week?

    Reported by candidates at Millennium Management (Financial Planning and Analysis, 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.