Financial Analyst Interview Questions 2026

Sample Answer

A DCF (Discounted Cash Flow) values a company based on its projected future free cash flows discounted to present value. Steps: (1) Project free cash flows (FCF) for 5-10 years based on revenue growth, margins, capex, and working capital assumptions. (2) Calculate the terminal value using either the perpetuity growth method (FCF * (1+g) / (WACC-g)) or exit multiple method. (3) Discount all cash flows to present value using WACC (Weighted Average Cost of Capital). (4) Sum the present values to get enterprise value. (5) Subtract net debt and add cash to get equity value. (6) Divide by diluted shares for per-share value. (7) Run sensitivity analysis on key assumptions. DCF is most reliable for mature companies with predictable cash flows.

Sample Answer

The Income Statement shows revenue, expenses, and net income over a period. The Balance Sheet shows assets, liabilities, and equity at a point in time. The Cash Flow Statement shows cash inflows and outflows. They are linked: net income from the income statement flows to the cash flow statement as the starting point for operating cash flows and to retained earnings on the balance sheet. Capital expenditures on the cash flow statement increase PP&E on the balance sheet. Debt issuance appears in financing cash flows and on the balance sheet. The ending cash balance on the cash flow statement equals cash on the balance sheet. Understanding these linkages is fundamental to financial modeling and analysis.

Sample Answer

For unprofitable companies, traditional earnings-based methods do not apply. Alternative approaches: revenue multiples (EV/Revenue compared to profitable peers), user or subscriber-based valuations (common for tech startups), asset-based valuation (liquidation value for distressed companies), DCF with projected profitability (forecast when the company will become profitable and model long-term FCF), comparable transactions (what have similar companies been acquired for?), and venture capital method (work backward from expected exit value). Consider the stage: early-stage companies use risk-adjusted NPV or option pricing models. Always explain your choice of methodology and its limitations. Multiple methods provide a valuation range, not a single number.

Sample Answer

Enterprise value (EV) represents the total value of a company to all capital providers (debt holders, equity holders, preferred stockholders, minority interests). EV = Market Cap + Net Debt + Preferred Stock + Minority Interest. Equity value represents the value attributable only to common shareholders. The relationship: Equity Value = Enterprise Value - Net Debt - Preferred Stock - Minority Interest. Use EV-based multiples (EV/EBITDA, EV/Revenue) when comparing companies with different capital structures because EV is capital-structure-neutral. Use equity multiples (P/E ratio) when analyzing from a shareholder's perspective. A common mistake is comparing P/E ratios of companies with vastly different leverage, which makes direct comparison misleading.

Sample Answer

WACC (Weighted Average Cost of Capital) represents the average rate of return required by all capital providers. Formula: WACC = (E/V * Re) + (D/V * Rd * (1-T)), where E = equity value, D = debt value, V = E + D, Re = cost of equity, Rd = cost of debt, T = tax rate. Calculate cost of equity using CAPM: Re = Risk-free rate + Beta * Equity Risk Premium. Cost of debt is the yield on existing debt or the rate at which the company can borrow. Beta measures the stock's volatility relative to the market. Use the company's target capital structure, not current. WACC is used as the discount rate in DCF analysis. A lower WACC increases the present value of future cash flows and thus the company valuation.

Sample Answer

Income Statement: revenue increases by 10%. If margins remain constant, COGS and operating expenses increase proportionally. Taxable income and net income increase. Cash Flow Statement: higher net income flows through, but working capital changes may offset some cash benefit (higher receivables and inventory from increased sales). Capex may need to increase if the revenue growth requires additional capacity. Balance Sheet: accounts receivable increases (more sales on credit), inventory may increase, retained earnings increase by net income minus dividends. Cash position depends on the net cash flow effect. The key insight is that revenue growth does not automatically mean proportional cash flow growth due to working capital and capex requirements. This is why free cash flow analysis is more important than earnings alone.

Sample Answer

EV/EBITDA: most common for comparing companies, removes effects of capital structure, depreciation, and taxes. Typical range: 6-15x depending on industry. P/E ratio: quick equity valuation, useful for mature profitable companies, but misleading with different leverage. EV/Revenue: used for high-growth or unprofitable companies where earnings are not meaningful. P/B (Price to Book): used for banks and financial institutions where assets are marked to market. EV/EBIT: similar to EV/EBITDA but accounts for depreciation, better for capital-intensive businesses. PEG ratio: P/E divided by growth rate, adjusts for different growth rates. Always use multiples from comparable companies in the same industry, geography, and growth stage. Multiples provide relative value, not intrinsic value.

Sample Answer

Working capital = Current Assets (cash, receivables, inventory) - Current Liabilities (payables, accrued expenses, short-term debt). It measures a company's short-term liquidity and operational efficiency. Positive working capital means the company can meet short-term obligations. Negative working capital can signal trouble or, in some business models (Amazon), efficient operations where customers pay before suppliers are paid. Changes in working capital affect free cash flow: increasing working capital consumes cash (you are investing in receivables and inventory), decreasing working capital generates cash. Working capital management (days sales outstanding, days inventory outstanding, days payable outstanding) directly impacts cash conversion cycle. Analysts focus on working capital trends to assess operational efficiency and cash flow predictability.

Sample Answer

Follow a structured approach: (1) Gather historical financials (3-5 years) and normalize for one-time items. (2) Build the income statement model: forecast revenue by segment, model cost structure, and project margins. (3) Build the balance sheet: project working capital based on days metrics, model PP&E with capex and depreciation schedules, and project debt based on the capital structure. (4) Build the cash flow statement: derive from income statement and balance sheet changes. (5) Add a debt schedule for interest calculations (creates circularity, solve with iteration). (6) Build scenario analysis and sensitivity tables. Best practices: color-code inputs (blue) vs formulas (black), avoid hardcoding, use consistent time periods, document assumptions, and add error checks. A good model is transparent, auditable, and tells a clear story about the business.

Sample Answer

EBIT (Earnings Before Interest and Taxes) reflects operating profitability including depreciation and amortization. EBITDA adds back D&A, approximating cash operating earnings. EBITDA is widely used for comparing companies with different capital expenditure levels, in debt covenants (debt/EBITDA ratios), and in LBO analysis. EBIT is better for capital-intensive industries where depreciation represents real economic wear on assets (manufacturing, airlines). Use EBITDA with caution: it can overstate cash generation for companies with high capex requirements, as it ignores the investment needed to maintain assets. Neither metric accounts for working capital changes or actual cash taxes. For a true cash measure, use free cash flow.

Sample Answer

Evaluate across multiple dimensions: leverage ratios (Debt/EBITDA, Debt/Equity), coverage ratios (Interest Coverage = EBIT/Interest Expense, should be above 2-3x), liquidity ratios (Current Ratio, Quick Ratio), and cash flow metrics (FCF/Debt, DSCR). Review the debt maturity profile for refinancing risk. Assess business stability: revenue predictability, industry cyclicality, competitive position, and management quality. Compare against credit rating agency criteria (Moody's, S&P). Analyze covenant compliance and headroom. Review off-balance-sheet obligations (operating leases, pension liabilities, guarantees). Consider qualitative factors: industry outlook, regulatory risk, and management track record with capital allocation. Credit analysis requires a more conservative lens than equity analysis because debt holders care about downside protection, not upside potential.

Sample Answer

Core functions: SUMPRODUCT for weighted calculations, INDEX/MATCH for flexible lookups (superior to VLOOKUP), IFERROR for error handling, OFFSET for dynamic ranges, CHOOSE for scenario switching, and NPV/IRR for investment analysis. Date functions: EOMONTH, YEARFRAC for accurate period calculations. Data validation and conditional formatting for model integrity. Keyboard shortcuts are equally important: F2 (edit cell), F4 (toggle absolute reference), Ctrl+[ (trace precedents), Alt+= (autosum). Advanced: data tables for sensitivity analysis, Goal Seek for solving, and Power Query for data transformation. Build models that are audit-friendly: consistent formulas across rows, clear input sections, and no circular references without explicit documentation. Speed in Excel is a differentiator in financial analyst interviews.

Sample Answer

A merger combines two companies into a single entity (typically of similar size). An acquisition is one company purchasing another (the acquirer absorbs the target). Synergies are the additional value created by combining: revenue synergies (cross-selling, expanded market access, combined product offerings) and cost synergies (elimination of redundant functions, economies of scale, improved purchasing power). Cost synergies are more reliable and easier to quantify. Integration risks include cultural clashes, key talent departures, and technology integration challenges. Analyze synergies with conservative assumptions and a realistic timeline (12-36 months to realize). Common interview question: if the synergies are $500M, what is the maximum premium you should pay? Less than the present value of synergies, accounting for integration costs and risk.

Sample Answer

Use Porter's Five Forces and Warren Buffett's moat framework. Identify sources of competitive advantage: brand strength (pricing power), network effects (value increases with users), switching costs (high cost to change), cost advantages (economies of scale, proprietary technology), and regulatory barriers (licenses, patents). Quantify the moat: premium pricing sustained over time, market share stability, return on invested capital (ROIC) consistently above WACC, and customer retention rates. A wide moat allows companies to earn above-average returns sustainably. Evaluate moat durability: is it widening, stable, or narrowing? Technology disruption can rapidly erode traditional moats. Strong moats justify higher valuation multiples because of more predictable future earnings.

Sample Answer

Accrual accounting recognizes revenue when earned and expenses when incurred, regardless of when cash changes hands. Cash accounting recognizes revenue when cash is received and expenses when cash is paid. Accrual provides a more accurate picture of a company's financial performance by matching revenues with the expenses incurred to generate them. For example, a company delivers goods in December but receives payment in January: accrual records the revenue in December, cash accounting in January. GAAP requires accrual accounting for public companies. The gap between accrual earnings and cash flow is important: a company can show profits on the income statement while running out of cash, which is why cash flow analysis is critical alongside earnings analysis.

Sample Answer

Sensitivity analysis tests how changes in key assumptions affect the output (valuation, NPV, IRR). Create data tables showing how the result changes across a range of values for one variable (one-way) or two variables (two-way). For a DCF, the most sensitive inputs are typically the discount rate and terminal growth rate. Build tornado charts to show which assumptions have the greatest impact on the output. This is critical because: financial models are only as good as their assumptions, stakeholders need to understand the range of possible outcomes, and it identifies which assumptions deserve the most diligence. Always present valuations as a range, not a point estimate. Combine sensitivity analysis with scenario analysis (different assumption sets representing specific business conditions) for comprehensive risk assessment.