Financial and Business Analysis Interview Questions for Business Analytics

The income statement shows revenue, expenses and profit over a period. The balance sheet shows assets, liabilities and equity at a point in time. The cash flow statement shows cash from operating, investing and financing activities. They link together: net profit flows into retained earnings on the balance sheet and is the starting point of operating cash flow, and the closing cash balance from the cash flow statement equals cash on the balance sheet.

EBITDA is earnings before interest, taxes, depreciation and amortisation. It approximates operating profit generated by the core business before financing choices, tax rules and non-cash accounting charges. It is useful for comparing companies with different debt levels or asset ages and is used in valuation multiples such as EV/EBITDA. Its weakness is that it ignores capital expenditure and working capital needs, so a company can show strong EBITDA and still burn cash.

Working capital is current assets minus current liabilities, mainly receivables plus inventory minus payables. It is the money tied up in running daily operations. Too little means the company may struggle to pay suppliers and salaries; too much means cash is locked in slow inventory or unpaid customer invoices. Analysts track it because a growing business often needs more working capital, so fast growth can create cash shortages even when the business is profitable.

Both measure short-term liquidity. The current ratio is current assets divided by current liabilities; around 1.5 to 2 is often comfortable, though it varies by industry. The quick ratio excludes inventory and prepaid items: (cash plus marketable securities plus receivables) divided by current liabilities. It is stricter because inventory may not sell quickly. A retailer with a current ratio of 1.8 but a quick ratio of 0.4 depends heavily on selling its stock to pay bills.

Capex (capital expenditure) is spending on long-term assets that benefit several years, such as machinery, buildings or capitalised software development. It goes on the balance sheet and is expensed gradually through depreciation or amortisation. Opex (operating expenditure) covers day-to-day running costs such as salaries, rent and cloud subscriptions, and is expensed in the period it occurs. Moving from owned servers to cloud services shifts IT spending from capex to opex, which changes how budgets and business cases look.

The time value of money means a rupee today is worth more than a rupee in the future, because today's rupee can be invested to earn a return and future money carries inflation and risk. Future cash is converted to present value using PV = FV / (1 + r)^n. At a 10 percent discount rate, 1,10,000 rupees received after one year is worth 1,00,000 rupees today. It is the basis of NPV, IRR, loan EMIs and valuation.

Debt-to-equity equals total borrowings divided by shareholders' equity. It shows how much the company relies on borrowed money versus owners' funds. A ratio of 0.5 means 50 paise of debt for every rupee of equity. Higher leverage can boost returns but raises interest burden and risk in downturns. Acceptable levels depend on the industry: utilities and infrastructure carry more debt than software firms. Always read it with interest coverage, which is EBIT divided by interest expense.

Operating expenses here exclude depreciation. Gross profit is 50 - 30 = 20 crore. EBITDA is gross profit minus operating expenses: 20 - 12 = 8 crore. EBITDA margin is 8 / 50 = 16 percent. EBIT is EBITDA minus depreciation, 8 - 2 = 6 crore, which is a 12 percent operating margin. In an interview, state your assumption about whether operating expenses include depreciation, because that changes the answer.

Under accrual accounting, revenue is recorded when it is earned and expenses when they are incurred, regardless of when cash moves. Under cash accounting, transactions are recorded only when cash is received or paid. Companies in India report under accrual-based standards (Ind AS). Example: an annual software contract billed in April is recognised as revenue month by month over 12 months under accrual, even though all the cash came in April.

ROI (return on investment) is the gain from a specific investment divided by its cost and is used to judge projects or campaigns. ROE (return on equity) is net profit divided by shareholders' equity and shows the return to owners; high debt can inflate it. ROCE (return on capital employed) is EBIT divided by equity plus long-term debt and shows how efficiently all long-term capital is used. ROCE is better for comparing companies with different debt levels.

The cash conversion cycle measures how many days cash is tied up in operations. It equals days inventory outstanding plus days sales outstanding minus days payables outstanding. Example: inventory sits 40 days, customers pay in 30 days and suppliers are paid in 45 days, so the cycle is 40 + 30 - 45 = 25 days. A shorter cycle means less working capital is needed. Some marketplaces have a negative cycle because they collect from customers before paying sellers.

Horizontal analysis compares line items across periods, showing growth, for example revenue up 18 percent year on year while employee costs grew 30 percent. Vertical analysis expresses each item as a percentage of a base within one period, such as each expense as a percentage of revenue, or each asset as a percentage of total assets. Together they show both trends and structure, and vertical analysis also makes companies of different size comparable.

A business case justifies why an organisation should invest in a project. It usually contains the problem or opportunity, objectives and success measures, options considered including do nothing, costs and benefits of each option with a financial evaluation such as NPV and payback, risks and assumptions, impact on people and processes, a recommended option and an implementation timeline. A BA often builds it with finance, and it becomes the baseline for checking benefits after delivery.

Profit is an accrual figure, while cash depends on timing. Check working capital first: receivables may be growing because customers pay late, inventory may be piling up, or suppliers may be demanding faster payment. Then look at large capex, loan repayments, and dividends. Review the cash flow statement and compute days sales outstanding and inventory days over time. Fixes include tighter credit terms, collection drives, inventory reduction and renegotiating supplier terms.

Break the change into drivers. Price: were discounts or promotions deeper? Mix: did sales shift towards lower-margin products, channels or regions? Cost: did raw material, freight or supplier prices rise, or did currency movements raise import costs? Also check one-offs like inventory write-offs and accounting reclassifications. Build a margin bridge showing how many percentage points each driver contributed, then take the biggest driver to the business owner with a specific action.

Possible causes include falling sales against unchanged purchasing, poor demand forecasts, bulk buying for discounts, slow-moving or obsolete SKUs, or deliberate stock-building ahead of a festive season or expected price rise. Analyse by SKU, warehouse and age bucket to find where stock is stuck. Recommend clearing aged items, adjusting reorder points using recent demand, and reviewing supplier minimum order quantities. Also quantify the cash locked up and the carrying cost to show urgency.

Costs: software 12 lakh in year 1 plus 3 lakh per year support, and 4 lakh for implementation and training. Benefits: 60,000 invoices a year at 10 minutes saved each is 10,000 hours; at 400 rupees per hour that is 40 lakh, plus around 5 lakh from fewer late-payment penalties. Year-1 net benefit is 45 - 16 = 29 lakh and payback is under six months. Then test sensitivity, for example if only half the time saving is realised.

Situation: our support team handled order-status queries manually, about 9,000 a month. Task: I was asked to evaluate a self-service tracking page. Action: I measured handling time from ticket data, estimated deflection conservatively at 40 percent, worked with IT on build and run costs and showed best, base and worst cases with payback. Result: leadership approved the base case. Six months after launch, deflection reached 46 percent, and I presented the benefits review to the same committee.

Situation: monthly cloud and software subscription costs had grown 35 percent in a year without anyone tracking why. Task: my manager asked me to review them. Action: I combined invoices with user login data in Excel and found 140 licences unused for over 90 days and two tools doing the same job. Result: we cancelled unused licences and consolidated tools, saving about 18 lakh rupees a year, and I set up a quarterly licence review report.

IRR (internal rate of return) is the discount rate at which a project's NPV becomes zero, so it expresses the return as a percentage. NPV gives the value created in rupees at a chosen discount rate. Accept a project if IRR exceeds the cost of capital or NPV is positive. When comparing projects of different size or timing, NPV is more reliable, because IRR ignores scale and can give multiple answers when cash flows change sign more than once.

Operating leverage describes how much of a company's cost base is fixed. With high operating leverage, such as software or airlines, a small rise in revenue produces a large rise in operating profit once fixed costs are covered, but a fall in revenue hurts profit just as sharply. It is measured as percentage change in EBIT divided by percentage change in sales. Analysts use it to judge risk, set break-even targets and stress-test forecasts.

Compare total cost of ownership over the same period, usually 3 to 5 years. Include licence or subscription fees, implementation, data migration, integration, training, internal staff time, infrastructure, support and upgrade costs, and exit costs. Discount the yearly totals to present value if the timing differs. Then weigh the result against non-cost factors such as fit to requirements, scalability and vendor stability. Often the cheaper licence ends up costlier once customisation and support are added.

Incremental budgeting takes last year's budget and adjusts it by a percentage, which is quick but carries forward old inefficiencies. Zero-based budgeting starts every cost line from zero, and each activity must be justified by its value each cycle. ZBB uncovers waste and suits cost-reduction programmes, but takes much more effort and can create friction. Many companies apply ZBB to discretionary costs such as marketing and travel and use incremental methods elsewhere.

Separate contribution from allocation. If the product's revenue exceeds its variable and directly attributable fixed costs, it contributes to covering shared overheads, which will not disappear if it is closed and will be reallocated to other products. Check whether the overhead allocation key, such as revenue share, is fair. Also consider strategic links, like customers who buy it alongside profitable products. Recommend shutting it only if contribution is negative or the freed capacity has a better use.

Build a discounted cash flow comparison over the vehicle life. For buying: purchase price, financing cost, maintenance, insurance, tax benefit of depreciation, and resale value. For leasing: lease rentals, what maintenance is included, tax treatment and end-of-term conditions. Discount both at the company's cost of borrowing and compare present value of costs. Then add qualitative factors: flexibility if volumes drop, technology risk such as a shift to electric vans, and impact on the balance sheet.

Run a benefits review against the original baseline and assumptions. Check whether savings depended on actions that did not happen, such as reducing manual roles, retiring the old system or full user adoption. Check whether the baseline or volumes changed. Separate delayed benefits from lost ones. Then produce a recovery plan with owners, for example decommissioning the legacy licence or driving adoption. Also feed the lessons into how future business cases estimate benefits.