Accounting for Managers: Principles and Standards, Financial Statements and their Analysis, Cost Sheet, Marginal Costing, CVP and Variances
2. Financial statement analysis: ratios, funds flow, cash flow and DuPont
| Group | Ratio and formula | Norm and reading |
|---|---|---|
| Liquidity | Current ratio = current assets ÷ current liabilities; quick (acid-test) ratio = (current assets − stock − prepaid) ÷ current liabilities; cash ratio | Conventional norms 2:1 and 1:1; too high means idle funds |
| Solvency (leverage) | Debt-equity = long-term debt ÷ shareholders' funds; debt ratio; proprietary ratio = equity ÷ total assets; interest coverage = EBIT ÷ interest; capital gearing | Debt-equity norm 2:1 in Indian lending practice; coverage below 1.5 is stressed |
| Activity (turnover, efficiency) | Inventory turnover = cost of goods sold ÷ average stock; debtors turnover = credit sales ÷ average debtors, and collection period = 365 ÷ turnover; creditors turnover and payment period; fixed-asset and total-asset turnover = sales ÷ assets; working capital turnover | Higher turnover means faster conversion; operating cycle = inventory days + debtor days; cash cycle subtracts creditor days |
| Profitability | Gross profit ratio = GP ÷ sales; operating ratio = (COGS + operating expenses) ÷ sales; net profit ratio; return on capital employed = EBIT ÷ capital employed; return on equity = PAT ÷ equity; return on assets; earnings per share = (PAT − preference dividend) ÷ number of equity shares | Operating ratio plus operating profit ratio equals 100%; ROCE is the overall test of efficiency |
| Market (valuation) | Price-earnings = market price ÷ EPS; earnings yield; dividend yield = DPS ÷ price; dividend payout = DPS ÷ EPS; price-to-book = price ÷ book value per share; market capitalisation | High P/E means growth expected or over-pricing; retention ratio = 1 − payout |
Ratio analysis compares within the firm over time (trend), against the industry (cross-section) and against standards, and its limits are historical data, window dressing, price-level changes, differing accounting policies and the absence of a single correct norm. Common-size statements express every item as a percentage of sales or total assets; comparative statements show absolute and percentage change; trend percentages index each year to a base year. Funds flow analysis (AS 3 before 1997) explains the change in working capital between two balance sheets: a schedule of changes in working capital is prepared from current items, and a funds flow statement lists sources (funds from operations — net profit adjusted for non-fund and non-operating items such as depreciation, goodwill written off, loss on sale of assets — issue of shares and debentures, sale of fixed assets, long-term borrowing) and applications (purchase of fixed assets, redemption, repayment of loans, dividend and tax paid); only transactions between a current and a non-current item are 'flows'. Cash flow analysis (AS 3 revised, Ind AS 7) explains the change in cash and cash equivalents under three heads — operating (from the main revenue activities, by the direct method listing cash receipts and payments or the indirect method adjusting profit before tax for non-cash items and working-capital changes), investing (purchase and sale of long-term assets and investments, interest and dividend received by a non-financial company) and financing (equity and debt raised or repaid, interest and dividend paid). Funds flow is broader and accrual-based; cash flow is narrower, cash-based and mandatory. DuPont analysis (developed at Du Pont in the 1920s by Donaldson Brown) decomposes return on equity into three drivers: ROE = net profit margin (PAT ÷ sales) × asset turnover (sales ÷ total assets) × equity multiplier (total assets ÷ equity), so profitability, efficiency and leverage can be judged separately; the five-step version splits margin into tax burden, interest burden and operating margin.
3. Cost sheet, marginal costing and cost-volume-profit analysis
- Prime cost = direct materials consumed (opening stock + purchases − closing stock of raw material) + direct labour + direct expenses (chargeable expenses).
- Factory (works) cost = prime cost + factory overheads (indirect materials, indirect labour, power, depreciation of plant, factory rent) + opening work-in-progress − closing work-in-progress.
- Cost of production = factory cost + office and administration overheads (salaries, office rent, audit fees, depreciation of office equipment).
- Cost of goods sold = cost of production + opening stock of finished goods − closing stock of finished goods.
- Cost of sales (total cost) = cost of goods sold + selling and distribution overheads (advertising, salesmen's commission, carriage outward, warehousing); sales = cost of sales + profit. Items excluded from cost: income tax, dividends, interest on capital, donations, goodwill written off, abnormal losses, cash discount, capital expenditure.
Costs are classified by nature (material, labour, expense), by function (production, administration, selling, distribution, research), by traceability (direct and indirect), by behaviour (fixed, variable, semi-variable, step), by controllability, by normality (normal and abnormal), by time (historical, predetermined) and for decisions (sunk, opportunity, relevant, differential, imputed, out-of-pocket, shut-down, marginal). Marginal cost is the change in total cost from one more unit — the variable cost per unit in the short run — and marginal costing (variable costing, direct costing) charges only variable costs to products and treats fixed costs as period costs written off against contribution: contribution = sales − variable cost, and contribution − fixed cost = profit. Absorption costing, by contrast, charges fixed production overhead to products, so stock carries fixed cost and profit differs between the two methods whenever production differs from sales — absorption profit is higher when stock rises. Marginal costing's decision uses: fixing selling prices (including below total cost in a recession, so long as price exceeds variable cost), make or buy, accepting a special order or export order at a lower price when spare capacity exists, product mix under a limiting (key) factor by ranking contribution per unit of the scarce resource, shut-down or continue, and choice of technique; its limits are the difficulty of separating semi-variable costs and the undervaluation of stock, which Ind AS 2 does not permit for external reporting.
| Measure | Formula | Example: sales 10,00,000, variable cost 6,00,000, fixed cost 3,00,000, price 100 a unit |
|---|---|---|
| Contribution and P/V ratio | Contribution = sales − variable cost; P/V (contribution-sales) ratio = contribution ÷ sales = change in profit ÷ change in sales | Contribution 4,00,000; P/V ratio 40%; contribution per unit 40 |
| Break-even point | In units = fixed cost ÷ contribution per unit; in value = fixed cost ÷ P/V ratio; where total cost line cuts total revenue line on the break-even chart | 7,500 units; 7,50,000 rupees |
| Margin of safety | Actual sales − break-even sales; as a ratio, ÷ actual sales; = profit ÷ P/V ratio | 2,50,000 rupees, or 25%; profit 1,00,000 ÷ 0.40 confirms it |
| Sales for a target profit | (Fixed cost + desired profit) ÷ P/V ratio, or ÷ contribution per unit | For 2,00,000 profit: 12,50,000 rupees, 12,500 units |
| Angle of incidence and operating leverage | The angle between the sales and total-cost lines above break-even — larger means higher profit rate; degree of operating leverage = contribution ÷ EBIT | DOL = 4,00,000 ÷ 1,00,000 = 4: a 10% rise in sales lifts profit 40% |
| Assumptions and limits | Costs split cleanly into fixed and variable; linearity; constant price and mix; production equals sales; a single product or constant mix; the relevant range | Multi-product break-even uses the weighted-average P/V ratio; cash break-even excludes non-cash fixed costs such as depreciation |
4. Standard costing and variance analysis
Standard costing sets predetermined costs — what a unit should cost under efficient conditions — and compares them with actual costs, so that the differences, the variances, direct management's attention to where performance departed from plan: management by exception. Standards may be basic, ideal, attainable (currently attainable, the usual choice) or expected. Setting them needs technical studies of material specification and usage, time and motion studies of labour, and overhead budgets with a normal capacity. A variance is favourable when actual cost is below standard and adverse (unfavourable) when above, and each is split so that the responsibility can be located — the purchasing manager for price, the production manager for usage. Variance analysis compares budgeted profit with actual profit through cost variances (material, labour, overhead) and sales variances (price and volume); in a flexible-budget system the fixed-overhead volume variance is the part that arises from producing more or fewer units than the budget assumed. Standard costing works best in repetitive manufacturing and is criticised in lean and JIT environments for rewarding volume and hiding quality.
| Variance | Formula | Sub-variances and notes |
|---|---|---|
| Material cost variance | (SQ × SP) − (AQ × AP) | = price variance + usage variance |
| Material price variance | AQ × (SP − AP) | Purchasing's responsibility; computed on quantity purchased or used |
| Material usage (quantity) variance | SP × (SQ − AQ) | = mix variance SP × (revised standard quantity − AQ) + yield (sub-usage) variance SP × (SQ − revised standard quantity); production's responsibility |
| Labour cost variance | (SH × SR) − (AH × AR) | = rate variance + efficiency variance + idle time variance |
| Labour rate variance | AH paid × (SR − AR) | Personnel or wage-agreement driven |
| Labour efficiency variance | SR × (SH − AH worked) | Idle time variance = SR × idle hours, always adverse; mix (gang) and yield sub-variances as for material |
| Variable overhead variance | Recovered (SH × standard rate) − actual | = expenditure (spending) variance + efficiency variance |
| Fixed overhead variance | Recovered (actual output × standard rate) − actual | = expenditure (budget) variance (budgeted − actual) + volume variance (recovered − budgeted); volume splits into efficiency, capacity and calendar variances |
| Sales variances | Value variance = actual sales − budgeted sales | = price variance AQ × (AP − SP) + volume variance SP × (AQ − budgeted quantity), volume splitting into mix and quantity; on the margin (profit) basis the same split uses standard margin |
Key takeaways
- Going concern justifies cost less depreciation; conservatism values stock at the lower of cost and realisable value; Ind AS applied from 1 April 2016 in phases and is converged with, not identical to, IFRS; Schedule III prescribes the statements and NFRA oversees.
- Current ratio 2:1, quick ratio 1:1, debt-equity 2:1 are the conventional norms; operating ratio plus operating profit ratio is 100%; EPS excludes preference dividend; P/E is price over EPS.
- Funds flow explains working-capital change with funds from operations; cash flow explains cash change under operating, investing and financing; dividend paid is always financing; DuPont's ROE = margin × turnover × equity multiplier.
- The cost sheet builds prime cost, factory cost, cost of production, cost of goods sold, cost of sales, sales; contribution = sales − variable cost; break-even = fixed cost ÷ P/V ratio; margin of safety = profit ÷ P/V ratio; absorption profit exceeds marginal profit when stock rises.
- Material price variance is AQ × (SP − AP), usage is SP × (SQ − AQ); labour rate is AH × (SR − AR), efficiency SR × (SH − AH); idle time is always adverse; cost variances are standard minus actual, sales variances actual minus standard.
Practice questions (9)
Attempt each one before opening the answer. Every explanation names the tempting wrong option as well as the right one, because that is where marks are lost.
Valuing closing stock at the lower of cost and net realisable value follows the accounting convention of:
Show answer
Answer: A — Conservatism (prudence)
Prudence anticipates no profit but provides for all possible losses, so stock is written down when its realisable value falls but never written up. Consistency requires the same method each year, materiality lets trivia be ignored, and going concern supports valuing fixed assets at cost less depreciation.Indian Accounting Standards (Ind AS), converged with IFRS, became applicable to the first phase of companies from:
Show answer
Answer: A — 1 April 2016
The Companies (Indian Accounting Standards) Rules 2015 made Ind AS mandatory from FY 2016-17 for listed and unlisted companies with net worth of 500 crore rupees or more, extending to 250 crore from 2017-18; 2011 was the original, deferred target date.The acid-test (quick) ratio excludes from current assets:
Show answer
Answer: A — Inventories and prepaid expenses
Quick assets are those convertible to cash quickly — cash, marketable securities, receivables — so stock and prepaid expenses are removed. The conventional norm is 1:1 against 2:1 for the current ratio.In DuPont analysis, return on equity is decomposed as net profit margin × asset turnover × :
Show answer
Answer: A — Equity multiplier (total assets ÷ shareholders' equity)
(PAT ÷ sales) × (sales ÷ assets) × (assets ÷ equity) cancels to PAT ÷ equity. The multiplier captures financial leverage; a higher one raises ROE at the cost of risk. Debt-equity is a related but different leverage measure.In a cash flow statement prepared under Ind AS 7 by a manufacturing company, dividend paid to shareholders is classified under:
Show answer
Answer: A — Financing activities
Dividends paid are a cost of obtaining equity finance. Interest and dividends received by a non-financial company are investing inflows; a bonus issue is the non-cash item that appears in no head.In a cost sheet, prime cost plus factory overheads (adjusted for work-in-progress) gives:
Show answer
Answer: A — Factory (works) cost
The build-up is prime cost, factory cost (adding factory overhead), cost of production (adding administration overhead), cost of goods sold (adjusting finished stock) and cost of sales (adding selling and distribution overhead).A firm has fixed costs of 3,00,000 rupees and a P/V ratio of 40%. Its break-even sales are:
Show answer
Answer: A — 7,50,000 rupees
Break-even sales = fixed cost ÷ P/V ratio = 3,00,000 ÷ 0.40 = 7,50,000. At that level contribution of 3,00,000 exactly covers fixed cost. Multiplying instead of dividing gives the 1,20,000 distractor.Under marginal costing, fixed costs are:
Show answer
Answer: A — Treated as period costs and charged against contribution, not to products
Only variable costs attach to products; fixed costs are written off in the period. Absorption costing charges fixed production overhead to products and carries part of it in stock, which is why absorption profit exceeds marginal profit when stock rises.Standard: 10 kg of material at 5 rupees per kg. Actual: 12 kg used at 4 rupees per kg. The material usage variance is:
Show answer
Answer: A — 10 rupees adverse
Usage variance = SP × (SQ − AQ) = 5 × (10 − 12) = −10, adverse: two extra kilograms at the standard price. The price variance is AQ × (SP − AP) = 12 × 1 = 12 favourable, and the total cost variance is 50 − 48 = 2 favourable, the sum of the two.