Financial Analyst interview questions and answers

The income statement shows revenue, expenses and net income for a period. Net income is the first line of the cash flow statement under the indirect method. There I add back non-cash items like depreciation and adjust for working capital changes, such as higher receivables using cash, to get operating cash flow. Investing cash flow shows capex and asset sales, and financing cash flow shows debt raised or repaid, equity issued and dividends paid. The net change in cash is added to opening cash, and the closing cash must equal the cash line on the balance sheet. On the balance sheet itself, retained earnings increase by net income less dividends, fixed assets increase by capex and fall by depreciation, and debt moves with borrowings and repayments. If the balance sheet balances after these links, the model is usually wired correctly.

Working capital is current assets minus current liabilities. For analysis I usually focus on operating working capital: trade receivables plus inventory minus trade payables. It matters because it is cash tied up in running the business. A company can be profitable and still run out of cash if customers pay slowly or stock piles up. When a business grows, receivables and inventory usually grow too, so growth consumes cash even before any capex. I track it with DSO, DIO and DPO and combine them into the cash conversion cycle. For example, if a distributor collects in 60 days but pays suppliers in 30, it needs to fund 30 days of sales, often through a bank working capital limit. Reducing DSO by ten days can release a lot of cash without any new borrowing.

First I check the data is right: was anything posted to the wrong cost centre, or is it a timing issue, such as a campaign invoice booked this month that the budget phased for next month. Then I break the variance into drivers. For marketing that might be more campaigns than planned, a higher cost per lead, or a one-off event. I talk to the marketing owner to understand the business reason, because the ledger only shows what happened, not why. Then I explain it simply: for example, costs were 4 lakh over budget, of which 3 lakh is a festival campaign moved from next month and 1 lakh is a real overspend on digital ads. Finally I say what it means for the full year and whether the forecast should change, so the sales head knows if action is needed.

I start with gross margin, which shows how well the company prices its products against raw material and direct costs. For a manufacturer, raw material price swings show up here first. Next is EBITDA margin, which adds overheads such as employee costs and power, and is useful to compare companies with different debt and depreciation. Net profit margin shows what is left for shareholders after interest and tax. Margins alone are not enough, so I also look at return on capital employed, which tells me how much operating profit the business earns on all the capital in plants and working capital, and return on equity for shareholders. I always compare these with the company over the last few years and with close peers, because a 10% EBITDA margin is strong in some industries and weak in others.

I start with the targets and strategy from leadership, such as revenue growth and margin goals, so the budget is not just last year plus 10%. Then I build it from drivers. Revenue comes from volume and price by product or region. Costs come from drivers too: headcount times average salary, rent from signed leases, and marketing as a cost per acquisition times planned new customers. I collect inputs from each budget owner, but I challenge them with history and benchmarks. I phase the numbers by month, taking seasonality into account, such as festival demand in India or Ramadan and summer patterns in the Gulf. I also budget the balance sheet and cash, not just profit. Finally the draft is reviewed with management, changed where needed and approved, and it becomes the baseline for monthly variance reporting.

The income statement uses accrual accounting, so profit includes sales not yet collected, non-cash expenses like depreciation and many estimates such as provisions. The cash flow statement shows what actually happened to cash. It answers whether profit is turning into cash, how much the business is spending on capex and working capital, and whether it is relying on new debt or equity to keep going. A company can show strong profit while customers delay payment, and then struggle to pay salaries or suppliers. That is why lenders and investors compare operating cash flow with EBITDA or net income over several years. If cash consistently lags profit, I would look closely at receivables, inventory and revenue recognition. In short, profit is an opinion, cash is a fact, and I need both to understand a business.

I start with structural checks: the balance sheet must balance in every period and closing cash on the cash flow must equal balance sheet cash. I build these as check rows that show zero, so any break is visible. Then I look for hard-coded numbers inside formulas, which are a common source of errors, and make sure inputs are in one place, coloured blue, with formulas in black. I check that formulas are consistent across each row, using trace precedents or Ctrl and backtick to view formulas. Next I sense-check the outputs: does revenue growth, margin or working capital look reasonable compared with history and peers, and do results move in the right direction when I change a key input. Finally I scan for #REF or #N/A errors and get a colleague to review anything important.

EBITDA is earnings before interest, tax, depreciation and amortisation. It is popular because it strips out financing choices, tax differences and non-cash charges, so you can compare the operating profit of companies with different debt levels or asset ages. It is also used in EV/EBITDA multiples and in bank covenants like net debt to EBITDA. But it has real limitations. It ignores capex, which for a telecom or cement company is a large and recurring cash need. It ignores working capital, so a company with growing receivables can show strong EBITDA and weak cash. It also ignores interest and tax, which must be paid. And many companies report an adjusted EBITDA that removes costs they call one-off but which recur. So I use EBITDA as a starting point, then always look at free cash flow.

Variable costs move with volume, while fixed costs stay the same within a normal range of activity. In a restaurant, food ingredients and delivery packaging are variable, while rent, the chef salary and equipment leases are fixed for the month. The split matters because it gives contribution margin: price minus variable cost per unit. Contribution is what pays for fixed costs and then creates profit. From it I can calculate break-even, for example how many covers a night the restaurant needs to stop losing money. It also shows operating leverage: a business with high fixed costs gains profit quickly when volume rises but loses quickly when it falls. And it helps decisions like whether to accept a bulk order at a discount: if the price is above variable cost and capacity is spare, the order adds contribution even if it looks loss-making on a full cost basis.

I start with the one message that matters, for example: we made 2 crore less profit than planned, mainly because of lower volumes in the Sharjah stores. Then I support it with a few rounded numbers instead of a dense table. I avoid jargon or explain it once, saying cash tied up in unpaid customer bills rather than receivables days. I link the numbers to things the manager controls, such as footfall, conversion, discounts or overtime, because that is how they run the business. A simple bridge chart from plan to actual is often clearer than any table. I keep the detail in an appendix for anyone who wants it. Finally I end with what it means for them and what action is needed, and leave time for questions, since good questions from operations often reveal the real cause behind the numbers.

On the income statement, depreciation is an expense, so pre-tax income falls by 10. At a 25% tax rate, tax falls by 2.5, so net income falls by 7.5. On the cash flow statement, I start with net income down 7.5 and add back the extra depreciation of 10, because it is non-cash. So operating cash flow goes up by 2.5, which is the tax saving. On the balance sheet, cash is up 2.5 and net fixed assets are down 10, so total assets fall by 7.5. On the other side, retained earnings fall by 7.5 because of the lower net income. Assets and equity both fall by 7.5, so the balance sheet still balances. The key idea is that depreciation itself is not cash, but its tax effect is real cash.

For mutually exclusive projects I go with the higher NPV, as long as it is computed at the right cost of capital. NPV tells me how much value, in rupees or dirhams, a project adds to the company. IRR is a percentage, so it ignores scale: a small project can earn 40% on 1 crore while a larger one earns 20% on 50 crore and creates far more value. Conflicts also appear when cash flow timing differs, because IRR implicitly assumes cash is reinvested at the IRR itself, which is often unrealistic, while NPV assumes reinvestment at the cost of capital. To check, I can compute the IRR of the incremental cash flows between the two projects; if it is above the cost of capital, the bigger project is better. I still report IRR because managers like it, but the decision rests on NPV.

A budget is set once a year and acts as a target. A rolling forecast is my best current estimate and always looks the same distance ahead, for example 12 months. Each month, when actuals close, I drop the finished month and add a new month at the end. To make that practical, the model has to be driver-based: revenue from pipeline, conversion and price, costs from headcount plans and unit rates, so each update is a change of a few drivers rather than rebuilding everything. I agree a short calendar with business owners to collect updates and I track forecast accuracy, comparing what we predicted three months ago with what happened. The forecast feeds cash planning, hiring decisions and early warnings to management. I keep the budget for performance measurement, and show actual versus budget and actual versus latest forecast side by side.

I start by defining the unit, which for grocery delivery is usually one order. On the revenue side I look at average order value, the gross margin on the products, delivery fees and any advertising income from brands. Then I subtract the variable costs of that order: rider cost, packaging, payment gateway fees, discounts and the variable part of the dark store or warehouse cost. What remains is contribution per order. I check how this changes with order density, because more orders per store and per rider usually lower the cost per order. Then I move to the customer level: what it costs to acquire a customer, how many orders they place a month, and how many are still ordering after three or six months. Combining contribution per order with frequency and retention gives lifetime value and the CAC payback period, which tells me if growth is creating or destroying value.

Sensitivity analysis changes one input, or two at a time, while keeping everything else fixed, to see how much the output moves. For a DCF I might show value per share across a grid of WACC and terminal growth using a two-way data table. It tells me which drivers matter most. Scenario analysis changes several assumptions together in a consistent story, such as a downside case with lower volume, weaker prices and higher raw material costs at the same time, because in real life these often move together. In Excel I keep base, upside and downside assumptions in columns on an input sheet and use a scenario switch cell with CHOOSE or INDEX so the whole model picks up the selected case. I present the results as a small table of key outputs per scenario, so management sees both the range and what would have to happen for each case.

I would build it as an MRR waterfall. I start with this month closing MRR. Each month I add new MRR from new customers, estimated from the sales pipeline, win rates and average deal size, or from marketing leads and conversion for self-serve plans. I add expansion from upsells and price increases and subtract contraction and churn, using historical rates by customer segment or cohort, because small customers usually churn more than enterprise ones. That gives closing MRR each month. Then I convert to recognised revenue, which depends on billing terms: annual upfront billing creates deferred revenue that is released monthly, so cash and revenue differ. I would add one-time services revenue separately. Finally I run base, upside and downside cases on new bookings and churn, and each month compare actuals with the forecast to improve the driver assumptions.

First I confirm the numbers: was there a one-off such as an inventory write-down, or a change in how costs are classified, for example freight moved into COGS. Then I break the margin down by product, channel, region and key customer to see where the drop is concentrated. I separate three effects. Price: did we give more discounts or promotions. Mix: did sales shift towards lower-margin products or channels, which can reduce total margin even if each product margin is unchanged. Cost: did raw material, freight or packaging costs rise, or did the rupee or dirham move against a supplier currency. I quantify each effect in a bridge from 38% to 33%, for example 2 points from mix, 2 from input cost and 1 from discounts. Then I talk to sales and procurement to confirm causes and suggest actions, such as price increases or renegotiating suppliers.

I would first understand why the line is needed: to meet demand growth, cut costs or replace old equipment, and what the alternatives are, such as outsourcing or upgrading the existing line. Then I would build incremental cash flows only: the 25 crore capex and its timing, extra sales or cost savings, extra operating costs like power and staff, working capital for more inventory, tax effects including depreciation, and any salvage value. I would ignore sunk costs and allocated overheads that do not change. I would calculate NPV at the company hurdle rate, IRR and payback. Then I would test the key drivers, especially volume and capacity utilisation, selling price and ramp-up time, because projects often take longer to ramp up than planned. Finally I would summarise risks, a recommendation, and agree a post-investment review to compare actual results with the business case.

I would look at the three parts of the cash conversion cycle. On receivables, I would check credit terms by customer, overdue ageing, invoicing delays and disputes, and set up collection follow-ups and possibly early payment discounts for slow payers. On inventory, I would find slow-moving and obsolete SKUs, improve demand forecasting, and agree safety stock levels with supply chain. On payables, I would review whether we pay suppliers earlier than terms require and negotiate longer terms or use supply chain finance, while being careful not to damage key suppliers, especially smaller ones. I would quantify each lever: for a business with 365 crore of sales, cutting DSO by 5 days releases about 5 crore of cash. Then I would set targets, track DSO, DIO, DPO and the cash conversion cycle monthly, and report the cash released to the CFO.

I separate the model into inputs, calculations and outputs. All assumptions sit on one input sheet with clear labels, units and sources, coloured blue. The calculation sheets build supporting schedules: revenue drivers, operating costs, a fixed asset and depreciation schedule, working capital using days or percentages of sales, and a debt schedule with interest and repayments. These feed the income statement, balance sheet and cash flow statement, which sit on their own sheets with one consistent timeline across the columns. I keep one sign convention and one formula per row so that it can be copied across. I add checks for the balance sheet balancing and cash reconciling, plus a summary dashboard with key outputs and scenarios. Finally I add a short cover sheet explaining the structure and version, so a colleague or auditor can follow the logic without asking me.

I first forecast the business for five to ten years: revenue from volume and price drivers, margins, capex and working capital. From that I calculate unlevered free cash flow each year: EBIT less tax, plus depreciation, minus capex, minus the increase in net working capital. Next I estimate WACC, using CAPM for cost of equity and the after-tax cost of debt, weighted by a target capital structure. I discount each year of free cash flow at WACC. Then I calculate a terminal value, either with the perpetual growth method, where growth should be no higher than long-run nominal GDP, or with an exit multiple, and discount it back from the final year. The sum is enterprise value. I subtract debt and similar claims, add cash, to get equity value, and divide by diluted shares. Finally I run sensitivities on WACC, growth and margins and cross-check the result with trading comparables.

I would use CAPM for the cost of equity. The risk-free rate comes from the 10-year Indian government bond yield, because cash flows are in rupees, so currency and inflation are consistent. Since the company is unlisted, it has no beta of its own, so I collect betas of listed peers, unlever them using each peer debt to equity ratio and tax rate, take the median, and relever at the target company capital structure. I then add an equity risk premium for India, and often a small size or company-specific premium for an unlisted mid-sized business, explaining the judgment. For cost of debt I use the rate it currently pays or would pay on new bank loans, not old historical rates, and apply the tax shield. The weights should reflect a target or peer-based capital structure at market values, not book values. Finally I show a WACC range and test valuation sensitivity to it.

I start with the business model, not just the industry label. A D2C beauty brand should be compared with consumer brands of similar growth and margins, not with every retail company. I then filter by size, growth, profitability and geography, and accept I may need a few global peers if Indian or Gulf listed peers are limited. I make the numbers consistent: same period, either last twelve months or next year forecast, and the same accounting basis, for example adjusting EBITDA for lease accounting and removing one-off gains or restructuring costs. I use EV-based multiples like EV/EBITDA or EV/Sales with operating metrics, and P/E with net income. I look at the median and the range rather than the average, which outliers can distort. Finally I explain why the target should sit above or below the median, for example faster growth or higher customer concentration risk.

I would start with the business: what it trades, who its main customers and suppliers are, how concentrated they are, and how experienced the owners are. Then I would review at least three years of audited financials and focus on cash, not just profit: how operating cash flow compares with EBITDA, and how receivables and inventory ages are trending, because trading companies often get stuck with slow-paying customers. I would calculate leverage, such as net debt to EBITDA, interest coverage and DSCR including the new loan repayments. Next I would project cash flows over the loan life in a base case and a stress case, such as a 15% fall in sales or a 30-day increase in collection period, and see if DSCR stays above the bank threshold. Finally I would look at security, like receivables or property, personal guarantees, and suitable covenants and repayment structure.

Boards dislike surprises more than bad news, so I would lead with the message on the first slide: we now expect EBITDA of 85 against a forecast of 100. Then I would show a bridge from 100 to 85 by driver, for example volume shortfall, price pressure, raw material inflation and a one-off provision, each with a number. I would separate one-off items from structural issues, because the board needs to know if next year is also at risk. I would show the impact on cash, debt and any bank covenants, since that is often the real risk. Then I would present the management actions, such as cost savings or pricing changes, with owners, timelines and the value expected, and a revised outlook with an upside and downside range. I would pre-brief the CFO and audit committee chair, and keep the detail in an appendix.

Standard P/E or EV/EBITDA does not work when earnings are negative, so I would combine methods. First, a DCF with a longer forecast, often ten years, showing how revenue grows and margins move to a steady-state level similar to mature peers, with capex and working capital. Most value will be in the terminal period, so I would be clear about that. Second, relative valuation with EV/Revenue or EV/ARR multiples from listed peers and recent private funding rounds, adjusted for growth and gross margin. Third, I would test the path to profit with unit economics: contribution per order or customer, CAC payback and cohort retention. If these are weak, scale alone will not fix it. Because outcomes are wide, I would use scenarios with probabilities. Finally I would account for future funding needs and dilution, and for preference terms that change what each share class receives.

My first test is cash: if net income keeps growing but operating cash flow does not, something needs explaining. I look at receivable days and inventory days; if they rise faster than sales, revenue may be pulled forward or stock may be unsaleable. I check for recurring one-off items, because restructuring costs every year are not one-off, and for changes in accounting policies or estimates, such as longer asset lives that reduce depreciation. I look at what is being capitalised, for example development costs or interest, which moves expenses off the income statement. Related-party sales and loans, especially in promoter-led groups, need careful review. Finally, I read the auditor report and notes for qualifications or emphasis of matter, and watch for delayed filings or frequent changes of auditor or CFO. Any one flag is not proof, but several together justify deeper due diligence.

I would start by understanding the business model with leadership and finding the five to ten drivers that explain most of the numbers, for example store count, footfall, conversion and basket size for a retailer, or pipeline, win rate and churn for SaaS. Then I would build a driver-based model where revenue and major costs come from these drivers and map to the chart of accounts, so actuals can be compared line by line. I would set a monthly calendar: books close by day 5, flash results by day 7, forecast update by day 12, with named owners for each driver. The board pack would be short: a one-page summary, actual versus budget and forecast, a profit bridge, cash and runway, and five to eight KPIs with targets and trends, plus commentary on what changed and what we are doing. Over time I would automate data from the ERP into a BI tool.

I would have each business forecast in its own currency, rupees for India and dirhams for the UAE, because that is how managers run their operations. Then I would translate to dollars at fixed budget rates agreed at the start of the year. When reporting actuals, I would show results at both actual rates and budget rates, so I can split performance into a constant-currency operating variance and an FX translation variance. That stops managers being blamed or praised for currency moves. I would note that the dirham is pegged to the dollar, so most of the translation risk comes from the rupee, which floats. Separately I would look at transaction exposure, such as Indian entities buying imports in dollars, and follow the group hedging policy for forward contracts. Finally I would show a sensitivity, for example the effect on group EBITDA of a 5% move in the rupee.

I would start with the market: size, target customers, competitors and realistic share, with sources such as industry reports and conversations with potential clients. Then I would model a revenue ramp, since new markets take time: number of customers won per quarter, pricing in local currency and sales cycle length. On costs, I would include one-time set-up costs like trade licences, office fit-out, visas and hiring, plus ongoing salaries, rent, marketing and any local sponsor or partner fees. I would include working capital, since government and corporate clients in the region can pay slowly. I would add local corporate tax, VAT and transfer pricing points to confirm with tax advisers. The outputs would be NPV, payback, and especially peak funding need. I would show base and downside cases and propose milestones, such as first five clients within a year, that decide whether to invest further.