💻Technical Questions
Q1Walk me through a DCF valuation model.
💡Project FCF → discount at WACC → sum to enterprise value → subtract debt, add cash → equity value. Key assumptions: terminal growth rate, WACC components, projection period.
Q2What is the difference between EBITDA and free cash flow?
💡EBITDA: earnings before interest, taxes, D&A — proxy for operating performance. FCF: cash after capex and working capital — what's actually available to investors. Bridge: EBITDA → EBIT → NOPAT → FCF.
Q3How do you build a 3-statement financial model?
💡P&L → Balance Sheet → Cash Flow Statement. Circular reference (debt/interest). Revenue drivers → COGS → operating expenses → D&A. CapEx → PP&E. Working capital cycle. Balancing the model.
Q4What is WACC and how do you calculate it?
💡Weighted average of cost of equity (CAPM: Rf + β × market premium) and cost of debt (after-tax). Weights = market cap and market value of debt. Common errors: book vs market weights, risk-free rate selection.
Q5What are the main differences between GAAP and IFRS?
💡Revenue recognition, inventory (LIFO allowed in GAAP, not IFRS), lease accounting, R&D capitalization, goodwill impairment. Key for financial statement analysis of global companies.
🧠Behavioral Questions
B1Tell me about a complex financial analysis you performed. What was the impact?
💡The business question, your methodology, assumptions you made, key insights, and how the analysis was used in a business decision.
B2Describe a time you found an error in a financial model or report. How did you handle it?
💡Error detection process, impact assessment, communication (how quickly, to whom), correction, and what you changed to prevent recurrence.
🎯Situational Questions
S1The CFO needs a quick estimate of a company's value in 2 hours. What do you do?
💡Comparable company analysis (trading comps) is fastest — public comparables + EV/EBITDA multiples. Get the right comparable universe, adjust for size/growth/margin differences.
S2Actual EBITDA came in 20% below forecast. How would you analyze this variance?
💡Revenue variance (volume vs price) + cost variance (COGS, OpEx). Bridge from budget to actual. Identify one-time vs structural issues. Recommendations.
Must-Know Topics
- ✓Financial Modeling (3-statement model)
- ✓Valuation (DCF, comps, precedent transactions)
- ✓Accounting Fundamentals (GAAP/IFRS)
- ✓Excel / Google Sheets (advanced formulas, pivot tables)
- ✓Financial Statement Analysis
- ✓Budgeting & Forecasting
- ✓Capital Structure
- ✓Ratio Analysis
Common Interview Mistakes to Avoid
- ✗Confusing enterprise value with equity value
- ✗Circular references in financial models without resolving them
- ✗Ignoring working capital changes in cash flow
- ✗Using book value instead of market value for WACC
- ✗Not stress-testing key assumptions (sensitivity analysis)
Frequently Asked Questions
What Excel skills are tested in finance analyst interviews?▼
VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, pivot tables, financial functions (NPV, IRR, XNPV, XIRR), data validation, named ranges, and basic VBA/macros for automation. Speed and accuracy matter — practice with real financial models.
Is CFA required for finance analyst roles?▼
CFA is highly valued for investment management, equity research, and corporate finance. Level 1 shows commitment; all 3 levels open senior doors. For FP&A and corporate finance at operating companies, CFA is preferred but not mandatory — strong modeling skills often matter more.
What valuation methods are most commonly tested in finance interviews?▼
DCF (intrinsic value), comparable company analysis (trading comps), and precedent transaction analysis. Private equity interviews add LBO modeling. For corporate finance roles: NPV/IRR for capital budgeting, not full company valuation.
How do I prepare for a financial modeling test in an interview?▼
Practice building 3-statement models from scratch under time pressure. Know keyboard shortcuts (avoid mouse). Common tests: 1-hour model build, case study with variance analysis, or a DCF from given assumptions. Resources: WSP, Breaking Into Wall Street, CFI.
What's the difference between FP&A and investment banking analyst roles?▼
FP&A (Financial Planning & Analysis): internal, forward-looking, budgeting/forecasting, business partnership. IB: external, deal-oriented, M&A, capital markets, high hours culture. FP&A offers better work-life balance; IB offers higher pay and faster exits to PE/hedge funds.
Ready for your Finance Analyst interview?
Make sure your resume gets you to the interview stage first. Get a free ATS score.
Score My Resume Free →