Skip to content

Financial Analyst interview questions

100 real questions with model answers and explanations for Junior Financial Analyst candidates.

See a Financial Analyst resume example

Practice with flashcards

Spaced repetition · Hunter Pass

Questions

financial-reportingincome

The income statement shows a company's revenue, expenses, and profit over a period.

  • Revenue minus cost of goods sold gives gross profit.
  • Subtracting operating expenses gives operating profit, or EBIT.
  • Interest, taxes, and other non-operating items bridge EBIT to net income.
  • Unlike the balance sheet, it covers a month, quarter, or year rather than one date.

Why interviewers ask this: The interviewer is checking whether the candidate understands the purpose, time frame, and main subtotals of the income statement.

financial-reporting

The balance sheet shows what a company owns, owes, and has funded with equity at a specific date.

  • Assets include cash, receivables, inventory, and property, plant, and equipment.
  • Liabilities include payables, accrued expenses, and debt.
  • Equity includes contributed capital and retained earnings.
  • The statement must satisfy Assets = Liabilities + Equity.

Why interviewers ask this: A strong answer identifies the point-in-time view and the accounting equation without confusing balances with period activity.

cash-flow

The cash flow statement groups changes in cash into operating, investing, and financing activities.

  • Operating activities cover cash generated or used by the core business.
  • Investing activities include purchases and sales of long-term assets or investments.
  • Financing activities include debt, share issuance, repayments, dividends, and buybacks.
  • The three sections reconcile beginning cash to ending cash on the balance sheet.

Why interviewers ask this: The interviewer wants the candidate to classify common cash movements and connect the statement to the cash balance.

financial-reportingincome

Net income links the income statement to both retained earnings and operating cash flow.

  • It is the bottom line of the income statement.
  • Net income less dividends increases retained earnings in equity.
  • Under the indirect cash flow method, operating cash flow starts with net income.
  • Non-cash items and working-capital changes then adjust net income to cash from operations.

Why interviewers ask this: The interviewer is testing whether the candidate can trace the main link from profit into equity and cash flow.

financial-reportingaccounting

Depreciation lowers accounting profit without creating a current-period cash outflow.

  • It reduces operating profit and net income on the income statement.
  • The indirect cash flow statement adds depreciation back in operating activities.
  • Accumulated depreciation reduces the carrying value of property, plant, and equipment.
  • The lower net income also reduces the addition to retained earnings.

Why interviewers ask this: A strong answer follows one non-cash expense through profit, cash flow, assets, and equity.

capital

A capital expenditure initially creates a long-term asset and an investing cash outflow.

  • Cash falls and property, plant, and equipment rises on the balance sheet.
  • The purchase appears as an investing outflow on the cash flow statement.
  • The full purchase price is not recorded as an immediate operating expense.
  • Depreciation spreads the asset's cost through future income statements.

Why interviewers ask this: The interviewer is checking that the candidate distinguishes capitalizing an asset from expensing a purchase immediately.

financial-reportingcredit

A credit sale records revenue before the customer pays cash.

  • Revenue and net income increase on the income statement, assuming recognition criteria are met.
  • Accounts receivable increases on the balance sheet instead of cash.
  • Retained earnings rises through the higher net income.
  • Under the indirect method, the receivables increase is subtracted from operating cash flow.

Why interviewers ask this: This question tests whether the candidate understands accrual revenue and the working-capital adjustment to cash flow.

financial-reportingincome

Selling inventory records both revenue and the cost of the units sold.

  • Revenue increases by the selling price.
  • Cost of goods sold increases by the inventory's recorded cost.
  • Inventory decreases on the balance sheet by that recorded cost.
  • The difference between revenue and cost of goods sold is gross profit.

Why interviewers ask this: The interviewer is checking that the candidate records both sides of an inventory sale rather than only the revenue.

financial-reportingcapital-structure

Issuing debt increases cash and debt by the amount borrowed.

  • Cash rises within assets and debt rises within liabilities.
  • The borrowing is a financing inflow on the cash flow statement.
  • Issuing principal does not create revenue on the income statement.
  • Interest expense affects future net income as interest accrues.

Why interviewers ask this: A strong answer separates the balance-sheet and financing effects of principal from the later income-statement effect of interest.

modeling

A linked model should balance and reconcile its major opening and closing balances.

  • Assets minus liabilities and equity should equal zero in every period.
  • Beginning cash plus net cash flow should equal ending cash.
  • Beginning retained earnings plus net income less dividends should equal ending retained earnings.
  • Debt and fixed-asset closing balances should match their supporting schedules.

Why interviewers ask this: The interviewer wants concrete model controls that catch broken links rather than confidence based on visual inspection.

accounting

Accrual accounting records economic activity when it is earned or incurred, while cash accounting records it when cash moves.

  • A credit sale creates accrual revenue before the customer pays.
  • An unpaid utility bill creates an accrual expense before payment.
  • Accrual accounting uses receivables, payables, prepayments, and deferrals.
  • This timing difference is why net income can differ from operating cash flow.

Why interviewers ask this: The interviewer is evaluating whether the candidate can explain the timing difference with concrete revenue and expense examples.

accountingrevenue

Revenue is recognized when the company satisfies its performance obligation, not simply when cash arrives.

  • A completed service can create revenue and a receivable before payment.
  • Cash collected before delivery is generally recorded as deferred revenue, a liability.
  • As the promised service is delivered, deferred revenue moves into revenue.
  • The recognition period should reflect when the customer receives the promised good or service.

Why interviewers ask this: A strong answer distinguishes earned revenue from billing and cash collection.

costs

A prepaid expense starts as an asset and becomes an expense as the benefit is consumed.

  • Paying a 12-month insurance policy upfront reduces cash and creates prepaid insurance.
  • Each month, one twelfth moves from the prepaid asset to insurance expense.
  • The monthly expense reduces net income in the period receiving the benefit.
  • This treatment matches expense recognition to the coverage period.

Why interviewers ask this: The interviewer is checking whether the candidate understands deferral and matching across reporting periods.

costs

An accrued expense is a cost recognized before the related cash payment or supplier invoice is settled.

  • Employee wages earned before month-end can create wages expense and an accrued liability.
  • The entry records the cost in the period when employees performed the work.
  • Paying the accrual later reduces cash and the liability without recording the same expense again.
  • Accruals help prevent understated expenses and liabilities at period-end.

Why interviewers ask this: The interviewer wants to see correct timing and an understanding of how the later payment clears the liability.

ap-araccounting

Accounts receivable is money customers owe the company, while accounts payable is money the company owes suppliers.

  • Receivables are current assets created by credit sales.
  • Payables are current liabilities created by purchases on supplier credit.
  • Collecting a receivable converts it to cash without creating new revenue.
  • Paying a payable reduces cash and the liability without creating a new expense.

Why interviewers ask this: A strong answer identifies each balance and avoids recognizing revenue or expense a second time when cash settles it.

ratioscapital

Net working capital measures short-term operating resources tied up in the business.

  • The broad formula is current assets minus current liabilities.
  • For operating analysis, analysts often exclude cash and short-term debt.
  • Receivables and inventory usually increase operating working capital.
  • Payables and accrued operating liabilities usually reduce it.

Why interviewers ask this: The interviewer is checking both the standard formula and awareness that operating working capital may use a narrower convention.

Days sales outstanding estimates how many days the company takes to collect credit sales.

  • A common formula is average accounts receivable divided by credit revenue, multiplied by days in the period.
  • For an annual calculation, the multiplier is usually 365.
  • A rise in DSO means more cash is tied up in receivables, all else equal.
  • The metric should use credit sales when that data is available.

Why interviewers ask this: A strong answer gives the formula, interprets the direction, and uses the matching revenue base.

Days inventory outstanding estimates how long inventory remains on hand before it is sold.

  • A common formula is average inventory divided by cost of goods sold, multiplied by days in the period.
  • Cost of goods sold is used because inventory is carried at cost, not selling price.
  • A higher DIO generally means cash stays tied up in stock longer.
  • The metric is most useful when compared with similar periods or businesses.

Why interviewers ask this: The interviewer is testing whether the candidate knows the cost-based denominator and can interpret a change in inventory days.

Days payable outstanding estimates how long the company takes to pay suppliers.

  • A common formula is average accounts payable divided by supplier purchases, multiplied by days in the period.
  • Cost of goods sold is sometimes used as a proxy when purchases are unavailable.
  • A higher DPO preserves cash longer because supplier liabilities remain unpaid.
  • Excessively high DPO can also signal late payment rather than better operations.

Why interviewers ask this: A strong answer states the preferred denominator and recognizes that a higher value is not automatically positive.

The cash conversion cycle estimates the days between paying for inputs and collecting cash from customers.

  • The formula is DSO plus DIO minus DPO.
  • DSO captures collection time and DIO captures inventory holding time.
  • DPO is subtracted because supplier credit delays the cash payment.
  • A shorter cycle generally means less cash is tied up in operations.

Why interviewers ask this: The interviewer wants the formula and a clear explanation of why payable days reduce the cycle.

Locked questions

  • 21

    How do you calculate gross profit and gross margin?

    profitabilitycss
  • 22

    What does operating margin measure?

    profitabilityoperatingcss
  • 23

    What does net profit margin measure?

    profitabilitycss
  • 24

    What is EBITDA, and what does it leave out?

    profitability
  • 25

    What is contribution margin?

    profitabilitycss
  • 26

    How do you calculate year-over-year revenue growth?

    revenue
  • 27

    What is the difference between the current ratio and the quick ratio?

  • 28

    What is the difference between return on assets and return on equity?

    capital-structureassetsreturns
  • 29

    How do you calculate inventory turnover?

  • 30

    What is the time value of money?

    valuation
  • 31

    How do you calculate present value and future value for a single cash flow?

    cash-flowvaluation
  • 32

    What does a discount rate represent?

  • 33

    What is net present value?

    valuation
  • 34

    What is internal rate of return?

    returns
  • 35

    What is the basic difference between NPV and IRR?

    valuation
  • 36

    What is the payback period, and what is its main limitation?

    period-end
  • 37

    What is the difference between a budget and a forecast?

    budgetingforecasting
  • 38

    What is a driver-based forecast?

    forecasting
  • 39

    What is a rolling forecast?

    forecasting
  • 40

    How do you build a basic revenue forecast?

    revenueforecasting
  • 41

    How are fixed and variable costs treated in a basic budget?

    budgeting
  • 42

    What is plan-versus-actual variance analysis?

    dispersionvariance-analysis
  • 43

    How do you calculate an absolute and percentage variance?

    dispersionvariance-analysis
  • 44

    What are price and volume variances?

    dispersionvariance-analysispricing
  • 45

    What is the difference between relative, absolute, and mixed references in Excel?

    excel
  • 46

    When would you use XLOOKUP instead of INDEX and MATCH in Excel?

    excelindexes
  • 47

    What does SUMIFS do in Excel?

    excel
  • 48

    What controls make an Excel financial model easier to audit?

    excelmodelingaudit
  • 49

    What should a basic monthly management reporting pack contain?

    financial-reporting
  • 50

    What basic checks improve the quality of data used in financial reporting?

    financial-reporting
  • 51

    The invoice export totals $1,245,000, but the general ledger shows $1,238,500. How would you reconcile the $6,500 difference?

    bookkeepingap-ar
  • 52

    A bank payment file has 500 rows while the accounts payable export has 498. What would you do before reporting a cash discrepancy?

    ap-araccountingfinancial-reporting
  • 53

    Your SQL export returns 12,430 sales rows, but the dashboard contains 12,180. How would you investigate?

    returnssql
  • 54

    A European sales export totals €900,000, while the consolidated report shows $990,000. How would you verify the currency conversion?

    fx
  • 55

    Revenue in the billing export is $40,000 higher than the general ledger at month-end. How would you check whether cutoff is the cause?

    revenuebookkeeping
  • 56

    How would you find customer IDs that exist in a revenue export but not in the customer master?

    revenue
  • 57

    A Power Query refresh reduces a monthly expense table from 8,200 to 7,950 rows. How would you check the refresh?

    costsqueries
  • 58

    Marketing spent $520,000 against a $400,000 budget. How would you explain the $120,000 unfavorable variance?

    budgetingvariance-analysisdispersion
  • 59

    Budgeted sales were 10,000 units at $50, but actual sales were 9,000 units at $52. How would you explain the revenue variance?

    budgetingvariance-analysisdispersion
  • 60

    Gross margin fell from 40% in budget to 35% actual even though revenue grew. How would you investigate?

    revenueprofitabilitycss
  • 61

    Payroll is $545,000 versus a $500,000 monthly budget. How would you build a simple explanation?

    budgeting
  • 62

    Travel expense is $18,000 below budget. Would you report that as good performance?

    costsperformancebudgeting
  • 63

    The company recognized $800,000 of revenue but collected only $620,000 in cash this month. How would you explain the gap?

    revenue
  • 64

    Inventory expense is $25,000 over budget because of a write-off. How would you present the variance?

    budgetingvariance-analysisdispersion
  • 65

    How would you update a 12-month rolling forecast after April actuals are closed?

    forecastingclose
  • 66

    Opening monthly recurring revenue is $200,000, with $20,000 new business, $5,000 expansion, and $15,000 churn. What do you put in the forecast?

    churnrevenueforecasting
  • 67

    A department has 10 employees at an average monthly cost of $6,000 and plans two hires starting halfway through next quarter. How would you forecast payroll?

    costsforecasting
  • 68

    A software vendor announces a 10% price increase starting next month. How would you update the rolling forecast?

    procurementforecastingpricing
  • 69

    A $1 million monthly sales forecast closes at $850,000. How would you update the next three months?

    forecastingclose
  • 70

    You need to extend a retail revenue forecast into a holiday month. How would you avoid using a flat monthly average?

    revenueforecasting
  • 71

    A customer order worth $120,000 moves from June to July. What should change in the forecast?

    forecasting
  • 72

    Revenue is $750,000 and cost of goods sold is $450,000. Calculate gross profit and gross margin.

    revenueprofitabilitycosts
  • 73

    A business has $2 million revenue, $1.2 million cost of goods sold, and $500,000 operating expenses before depreciation. What EBITDA and EBITDA margin do you report?

    revenueprofitabilityoperating
  • 74

    Actual operating expense is $92,000 against a $100,000 budget. How would you report the variance?

    operatingcostsbudgeting
  • 75

    Revenue increased from $1 million last year to $1.2 million this year. How do you calculate and present growth?

    revenue
  • 76

    Average accounts receivable is $240,000 and annual credit sales are $1.46 million. Estimate days sales outstanding.

    ap-araccountingestimation
  • 77

    Current assets are $600,000 and current liabilities are $400,000. What liquidity KPI would you report?

    ratiosassets
  • 78

    A product sells for $80, has $50 variable cost, and the business has $150,000 fixed costs. What is the break-even volume?

    costs
  • 79

    Monthly actuals are 100, 120, and 80, while forecasts are 90, 132, and 88. What is the mean absolute percentage error?

    forecasting
  • 80

    A project costs $100,000 today and returns $60,000 at the end of each of the next two years. What is its NPV at 10%?

    returnsvaluation
  • 81

    A project requires $150,000 now and produces $50,000, $70,000, and $80,000 over three years. How would you assess it at an 8% discount rate?

  • 82

    A machine costs $120,000 and saves $40,000 in cash each year. What is the simple payback period?

    period-end
  • 83

    Project A has NPV of $25,000 and four-year payback; Project B has NPV of $18,000 and two-year payback. Which would you recommend?

    valuation
  • 84

    A product sells 10,000 units at $100, with $60 variable cost and $250,000 fixed cost. What happens to operating profit if price falls 5%?

    operatingcostspricing
  • 85

    A $240,000 machine lasts four years, creates $90,000 annual pre-tax savings, and is depreciated straight-line with no residual value. At a 25% tax rate, what annual cash benefit would you model?

    taxvaluationmodeling
  • 86

    An XLOOKUP reconciliation suddenly returns #N/A for IDs that visibly exist in both files. How would you fix it?

    returnsreactexcel
  • 87

    Your forecast model shows a circular-reference warning after you add interest expense. What would you do?

    costsinterest-ratesforecasting
  • 88

    You find an 8% growth rate typed directly into formulas across 20 forecast columns. How would you improve the model?

    forecastingschemamodeling
  • 89

    After a new row is inserted, the annual total no longer includes December. How would you diagnose and correct it?

  • 90

    A three-statement model's balance sheet is out of balance by $25,000. Where would you start?

    financial-reportingmodeling
  • 91

    Power Query reports date-conversion errors after receiving a file from another country. How would you repair the import?

    queries
  • 92

    You are asked to assemble a monthly management report for three departments. What would you include and how would you control it?

    controls
  • 93

    A Power BI table shows correct product margins, but the total margin is wrong. How would you fix it?

    profitabilitycssbi
  • 94

    A source team will deliver data two hours after your reporting deadline. What would you do?

    financial-reportingestimation
  • 95

    Which visual would you use to show 12 months of actual revenue against budget and explain the monthly gaps?

    revenuebudgeting
  • 96

    What checks would you perform before sending a monthly financial report?

  • 97

    Your forecast assumes supplier prices will rise 7% next quarter. How would you validate that assumption?

    pricingvalidationforecasting
  • 98

    You have a board-pack update due at 3 PM and an ad hoc analysis requested for noon. How would you prioritize?

    prioritization
  • 99

    You discover that last month's report overstated expense by $18,000. What would you do?

    costs
  • 100

    You find a formula error 20 minutes before a finance meeting. How would you communicate it?

    financecommunication