Top Financial Analyst Interview Questions & Answers

A DCF values a company by projecting free cash flows, discounting them at the WACC to their present value, and adding a terminal value. Key assumptions are the revenue growth rate, EBIT margins, capex, working capital, and the discount rate.

EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization) approximates operating cash flow and allows comparison across companies with different capital structures, tax rates, and depreciation policies. It is commonly used in EV/EBITDA valuation multiples.

Use revenue or gross profit multiples (EV/Revenue, EV/Gross Profit), EV/EBITDA on a forward basis if profitability is expected, or a DCF based on projected free cash flows — especially for high-growth companies where current losses reflect investment, not structural weakness.

Enterprise value (EV) represents the total value of the business to all capital providers: EV = Market Cap + Debt + Preferred + Minority Interest − Cash. Equity value represents only the value to common shareholders. Use EV for metrics that accrue to all holders (EBITDA, EBIT); use equity value for per-share metrics.

Income Statement: EBIT decreases by $10, tax decreases by $10×tax rate, net income decreases by $10×(1−tax rate). Cash Flow Statement: Net income decreases, but depreciation (a non-cash add-back) increases by $10, so operating cash flow is unchanged. Balance Sheet: PP&E decreases by $10 (net), retained earnings decreases by $10×(1−tax rate).

INDEX/MATCH for lookups (more robust than VLOOKUP), OFFSET and INDIRECT for dynamic ranges, SUMIF/SUMIFS and COUNTIFS for conditional aggregation, IFERROR for clean error handling, and array formulas for complex multi-condition calculations. For financial modeling specifically: NPV, IRR, XNPV, XIRR.

Use a Data Table (What-If Analysis). For a one-variable table, place the input variable in a column and link the output formula at the top-right. For a two-variable table, link the row and column input cells to the input cells in the model. Format the output with conditional color scales to make the relationship visible.

Circular references most often arise from interest expense calculations (debt × interest rate, where debt depends on cash which depends on net income which depends on interest). Solutions: use an iterative calculation toggle, break the circularity with a prior-period debt assumption, or use a revolver sweep model that handles the debt schedule in a separate step.

Use the STAR format. Describe discovering the error (ideally during review rather than after delivery), the steps you took to trace the source — typically by auditing formula references and checking key linkages — and how you communicated the correction to stakeholders. Emphasize the process and what you learned.

The strongest answers are specific: cite a particular aspect of the role (deal exposure, capital allocation decisions, financial modeling depth) and connect it to a concrete experience or academic interest. Avoid generic "passion for numbers" — explain what specifically about financial analysis interests you.