Financial Analyst interview questions and answers

Net profit from the income statement is the starting point of the cash flow statement, and it also flows into retained earnings in the balance sheet's equity. The cash flow statement adjusts that profit for non-cash items like depreciation and for changes in working capital, then adds investing and financing flows; the net change in cash takes you from opening to closing cash on the balance sheet. Balance sheet items drive the other two: capex adds to fixed assets, debt creates interest expense, and changes in receivables and inventory change operating cash flow.

If you can explain how one change ripples through all three, interviewers usually move on to the harder version of this question.

Assuming the extra depreciation is also allowed for tax: in the income statement, operating profit falls by ₹100, tax falls by ₹25, so net profit falls by ₹75. In the cash flow statement, start with net profit, down ₹75, then add back the extra ₹100 of depreciation because it's non-cash, so operating cash flow rises by ₹25, the tax saved. In the balance sheet, fixed assets fall by ₹100 and cash rises by ₹25, so total assets fall by ₹75; on the other side, retained earnings fall by ₹75. Both sides drop by ₹75, so it balances.

The point interviewers look for: depreciation itself isn't cash, but the tax it saves is.

A common-size statement shows every line as a percentage of a base: each income statement item as a percentage of revenue, and each balance sheet item as a percentage of total assets. This is vertical analysis; horizontal analysis compares the same item across years, as growth rates.

It lets you compare companies of different sizes and see how a company's cost structure changes. For example, if raw material cost rises from 55% to 62% of revenue over three years while employee cost stays flat as a share, margins are being squeezed by input prices, not by hiring. Comparing a small FMCG company with a large one in rupees tells you little; in percentages, the differences in margins and spending stand out.

Look at working capital first. Calculate days sales outstanding, inventory days and payable days, and compare them with last year. If receivables grew much faster than revenue, the company may be giving longer credit to push sales, or recognising revenue early. Check whether inventory built up, perhaps unsold stock, and whether payables shrank because suppliers demanded faster payment.

Then read the notes: the revenue recognition policy, large one-off contracts, related-party sales and any change in the customer mix. Decide whether the gap is temporary, like a large order delivered in March and paid in April, or a trend over several years. A persistent gap between profit and cash is one of the strongest warning signs in analysis.

In the auditor's report: a qualified opinion, an emphasis of matter, the key audit matters, or a sudden change of auditor. In the notes: frequent changes in accounting policies or estimates, large related-party transactions, rising contingent liabilities, and costs being capitalised instead of charged to profit. In the numbers: profit growing without operating cash flow, receivables or inventory growing faster than sales, large and repeated exceptional items, and other income making up much of the profit. In the shareholding: a large share of the promoters' holding pledged.

No single item proves a problem. Present them as questions to investigate, and compare with peers in the same industry before drawing a conclusion.

The current ratio is current assets divided by current liabilities: whether short-term assets cover short-term obligations. The quick ratio removes inventory, and usually prepaid expenses, from current assets, because stock may take time to sell or may sell below its book value. So the quick ratio is the stricter test.

What counts as healthy depends on the industry. A supermarket chain may run below 1 because it sells stock for cash quickly and pays its suppliers later, while a capital goods maker with long projects needs more cushion. Always compare with peers and with the company's own history, and watch the trend: a falling quick ratio alongside rising inventory needs a closer look.

ROE, return on equity, is net profit divided by shareholders' equity: the return earned for shareholders. ROCE, return on capital employed, is EBIT divided by capital employed (equity plus debt, or total assets minus current liabilities): the return on all the capital in the business, whoever provided it. A company can raise its ROE simply by borrowing more, so ROCE is the fairer comparison between companies with different debt levels.

DuPont analysis splits ROE into three parts: net profit margin × asset turnover × equity multiplier (assets divided by equity). It shows whether a high ROE comes from good margins, efficient use of assets, or leverage. Two companies with the same ROE can carry very different risk.

First find out why: borrowing for an expansion that will earn returns is different from borrowing to fund losses or stretched working capital. Then check whether the company can carry it. Look at the interest coverage ratio (EBIT divided by interest) and net debt to EBITDA, which show whether earnings can service the debt; at when the debt falls due and whether it's at fixed or floating rates; and at how stable the cash flows are. A utility with steady income can carry far more debt than a cyclical business.

Also check the loan covenants in the notes and any credit rating actions. Compare with peers in the same sector, because acceptable leverage varies widely between industries.

The cash conversion cycle is the number of days between paying for inputs and collecting cash from customers: days inventory outstanding plus days sales outstanding minus days payables outstanding. For example, days sales outstanding is trade receivables divided by revenue, times 365.

If it rises from 60 to 90 days, the company's cash is tied up for a month longer, so it needs more working capital, often funded by short-term borrowing, which costs interest. Break it into its three parts to find the cause: slower collections, stock piling up, or suppliers being paid faster. Each points to a different problem, such as weaker customers, falling demand, or suppliers losing confidence in the company.

Start with three to five years of historical statements, cleaned and laid out the same way. Put the assumptions on a separate sheet: revenue growth or its drivers, margins, working capital days, capex, depreciation, tax rate and financing. Forecast the income statement down to EBIT, then build the supporting schedules: fixed assets and depreciation, working capital, and debt and interest. Complete the income statement, then the balance sheet, then the cash flow statement, built from the changes in balance sheet items.

The cash flow statement's closing cash feeds the balance sheet's cash, and a check row confirms that assets equal liabilities plus equity in every year. Mention the check; interviewers like to hear it.

Keep inputs, calculations and outputs separate, and put every assumption in one place so it's changed only once. Never hard-code numbers inside formulas; refer to the input cells. Use a colour convention, commonly blue for inputs and black for formulas, so anyone can see what can be changed. Keep one consistent formula across each row, with the timeline in the same columns on every sheet. Add checks, such as the balance sheet balancing and cash matching, that flag errors clearly.

Use functions others can follow, like XLOOKUP or INDEX-MATCH rather than long nested IFs, and avoid hidden rows and merged cells. A model someone else can audit quickly is worth more than a clever one.

Build it from drivers rather than a single growth rate wherever possible. For a retailer, that's the number of stores times revenue per store, with new openings; for a manufacturer, capacity times utilisation times price; for a subscription business, customers times average revenue per customer, after churn. Base each driver on the company's history, management's guidance in results calls and annual reports, industry growth and competitors' numbers.

Then sanity-check the result: does the implied market share or growth look believable against the market and against what the company has achieved before? Note the source of every assumption beside it, so a reviewer can challenge it. Interviewers usually follow up with, "What would make you change it?"

Start with the check row. Find the first year it goes wrong: if the historical years balance and the first forecast year doesn't, the error is in how the forecast links together. See whether the difference is constant or growing, and whether it equals a known number, or twice one, which points to an item with the wrong sign.

Then check that every balance sheet change appears in the cash flow statement exactly once, with the right sign: an increase in an asset uses cash, an increase in a liability provides it. Common culprits are a new balance sheet line not added to the cash flow, depreciation linked wrongly, and dividends missing from retained earnings. Never plug the difference with a hard-coded number.

For scenarios, keep base, upside and downside sets of the key assumptions on the inputs sheet, and use a scenario switch, a single cell that selects which set flows into the model, with CHOOSE or INDEX. The whole model, statements and valuation, then updates for each case. Make each scenario internally consistent: a downside usually means lower volumes, weaker pricing and slower collections together, not one number changed.

For sensitivity, use Excel data tables to show how one output, such as net profit or the DCF value, changes as one or two inputs move, for example the discount rate against terminal growth. Then present the drivers that move the result most, so decision-makers know where to focus.

A budget is the plan set before the year starts, approved by management, and it becomes the target that performance is judged against. A forecast is the current best estimate of what will actually happen, updated during the year as conditions change. If sales fall behind plan, the budget stays the same but the forecast is revised.

A static budget is fixed at one level of activity. A flexible budget adjusts costs to the actual activity level: if you sold 20% more units, variable costs are allowed to rise by about 20%. Comparing actual costs with a flexible budget is fairer, because it separates the effect of volume from genuine overspending.

Budgeted revenue was ₹5,00,000 and actual revenue ₹4,68,000, so the total variance is ₹32,000 adverse. Split it in two. The volume variance is (900 − 1,000) × ₹500 = ₹50,000 adverse: we sold 100 fewer units. The price variance is (₹520 − ₹500) × 900 = ₹18,000 favourable: each unit sold for ₹20 more. Together, −50,000 + 18,000 = −32,000.

Then explain the story behind the numbers: perhaps the price increase cost us some volume, or a competitor took share. Managers care about the cause and the action, so finish with a recommendation, such as checking whether the price rise was worth the lost volume once margins are included.

An annual budget is often out of date within a few months, and by mid-year it looks ahead only to March. A rolling forecast is updated monthly or quarterly and always looks the same distance ahead, say the next twelve months, so management keeps seeing a full year ahead and can react sooner to changes in demand or costs.

It works best when it's driver-based: forecast volumes, prices and headcount rather than re-guessing every expense line, so an update takes days, not weeks. The challenges are the effort of frequent updates, getting business teams to give honest inputs, and keeping a clear line between the target, which is the budget, and the expected outcome, which is the forecast.

Good uses: drafting Excel formulas or macros and explaining them, summarising a long annual report or earnings call transcript as a starting point, writing a first draft of variance commentary, and suggesting how to structure an analysis. A good prompt gives context, the data and a clear task: "You're helping a financial analyst. Using the table below, write three short points explaining the main variances against budget, with the numbers."

What I wouldn't do: use its figures without checking the source, treat it as the final word on an accounting or tax treatment, or paste confidential company data into a tool the company hasn't approved. It speeds up the first draft; the analysis and the responsibility stay mine.

Treat it as a claim to verify. Go to the source, the company's published results or annual report, find revenue and operating profit for both periods, and recalculate the margin yourself. AI tools can misread tables, mix up quarters and years, confuse standalone with consolidated figures, or simply state wrong numbers confidently.

Check the definition too: the tool may have used EBITDA where your report uses EBIT, or included other income. If it cites a page, open that page. If the claim holds, use your own calculation and cite the company's document, not the AI. A useful habit is to ask the tool for the exact figures and where it found them, which makes checking faster.

Unpublished results are confidential and, for a listed company, unpublished price-sensitive information under SEBI's insider trading regulations, so sharing them outside the people authorised to see them is a serious breach. A free public tool may store the text and, depending on its terms, use it to train the model, so the company loses control of the data.

The right step is to stop and report it to the manager or the compliance or IT security team, as company policy requires, so they can assess it and ask the provider to delete the data if possible. In future, use only the company's approved AI tools, which come with data protection agreements, and remove or mask sensitive figures before using anything else.

Pick a listed company you genuinely follow, ideally in the employer's industry, and prepare it properly. Structure: what the company does and how it earns, two or three numbers from its recent results, the reason behind them, and your view. "I follow [company], which earns most of its revenue from [segment]. In the last quarter its revenue grew [x]% but its operating margin fell, mainly because of [higher input costs]. Management expects [guidance]. I think [your view, with one risk]."

Use the latest published results, not memory. Expect follow-ups on its ratios, competitors and valuation, so don't pick a company you can't discuss for five minutes.

Show that you understand what the job really involves, a lot of Excel, checking data and explaining results, not stock tips. Structure: what attracts you, evidence you've acted on it, and what you want to build. "I like turning data into decisions. During my studies I [built a valuation model for a company / wrote short notes on a sector's quarterly results], and I enjoyed working out why margins moved more than calculating them. As an analyst I want to [support budgeting and business decisions], and over time develop the judgement to [lead a planning cycle]."

Avoid answers only about money or prestige; interviewers want genuine interest in businesses.

Show that you lead with the conclusion and use plain words. Structure: what it means for them, one or two numbers, then what to do. For example: "I'd say: our profit fell this quarter mainly because raw material costs rose faster than our prices. On every ₹100 of sales we kept ₹8, down from ₹11. If we [raise prices by x or cut a specific cost], we can recover most of it. Then I'd show one simple chart and keep the details ready in case they ask."

Interviewers look for clarity without jargon, so avoid terms like EBITDA unless your listener uses them.

Show a method: clarify, prioritise by impact and deadline, communicate early. "I'd first confirm what each person actually needs and by when, since sometimes a rough number today is enough. Then I'd rank the requests by business impact and real deadline; a board pack, for example, comes before an internal review. I'd tell each manager when to expect their report, and if two are equally urgent, I'd ask my own manager to decide rather than miss both. During [month-end close in my internship], I [example]."

Avoid suggesting you'll simply work all night; interviewers prefer someone who manages expectations.

Pick a real example that shows you check your work and take feedback well. Use STAR: "In my last role, I forecast that a cost-saving project would pay back in a year (situation). The plant head challenged my volume assumption in the review (task). Instead of defending it, I rechecked it against three years of actual production and found I'd used peak-month volumes; the payback was closer to eighteen months. I corrected the model and explained the change openly, and the project was approved with a revised target (action and result). Since then I review key assumptions with the business team before presenting."

Owning the correction is the point; don't blame the data.