Financial Analysis and Planning - Ratio Analysis
Original descriptive practice: 30 saved, 2 at 3 marks, 17 at 5 and 11 at 10. Liquidity, debt and coverage, turnover/cycles, profitability, DuPont, market ratios and statement reconstruction. Original practice, not ICAI questions or official marking schemes. Native tables scroll on phones. Original preparation is not a live or complete official question bank.
Boundaries: Average/closing balances, sales/credit sales/purchases, debt/equity, day count and earnings/tax conventions are explicit. Working-capital variants are labelled. Dividend yield is separate from total return. Textbook benchmarks, higher ROE and Q are not automatic safe/value verdicts. Ratios are clues, not guaranteed cash payment.
FM-C03-D001 · 10 marks
Use the case-supplied current classification. Lumen has inventory 12, receivables 14, cash 4, current marketable securities 2 and prepaid expenses 3. Current liabilities include trade payables 10, accrued expenses 2 and short-term bank borrowing 4. No restricted cash or other current items exist.
Required: Compute current assets/liabilities, current ratio, quick ratio (exclude inventory/prepaids), cash ratio (cash plus securities), conventional CA-CL working capital and the separately requested bank-borrowing-exclusion working-capital variant. Explain why these do not guarantee every due payment. (10 marks)
Rs lakh unless stated otherwise; see scenario for definitions.
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 6FM-C03-D002 · 5 marks
A firm has CA 60 and CL 30, including cash 10. It pays 10 of current trade payables using cash, with no other changes. All figures are Rs lakh. Quick assets before payment are 45; the paid amount is from cash and no classification changes occur.
Required: Compare current/quick ratios and conventional working capital before/after, and assess "all liquidity improved without exception". (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 6FM-C03-D003 · 5 marks
Companies A and B each report CA 40, CL 20. A has inventory 28, prepaids 2; B inventory 10, prepaids 2. The remainder is cash/collectible receivables. All figures Rs lakh. A temporarily repays borrowing before year end but draws it back immediately afterward.
Required: Compare current/quick ratios and identify analytical limitations. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 6FM-C03-D004 · 5 marks
Liquid assets for this case consist of cash 5, marketable securities 3 and net collectible receivables 10. Annual operating charges are 90 including non-cash depreciation 18. Use 360 days. Ignore tax/interest and assume the case liquid assets are available; no extra financing/inflows.
Required: Compute cash operating expense/day and basic defense interval, and explain its limitation. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 7FM-C03-D005 · 10 marks
Helix closing assets are 160, with ordinary equity capital 60, ordinary reserves 20, preference capital 10, long-term interest-bearing debt 40, short bank borrowing 10 and non-interest trade liabilities 20. No fictitious assets/losses. All Rs lakh; amounts reconcile. Case definitions: total interest-bearing debt=long debt+short bank; total outside liabilities additionally includes trade; proprietary funds include ordinary equity, reserves, preference; capital employed=total assets minus all current liabilities (bank plus trade); gearing fixed-charge capital=preference+all interest debt divided by ordinary equity funds.
Required: Compute both debt-equity variants, interest-debt/assets, proprietary/assets, capital employed and gearing; explain why unlabelled ratios mislead. (10 marks)
Rs lakh unless stated otherwise; see scenario for definitions.
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 10FM-C03-D006 · 5 marks
Operating sales 120, COGS 72, operating expenses 24 (including depreciation), interest 6 and tax 4.5. All Rs lakh. No non-operating items. Interest coverage=EBIT/interest; profit margins must be labelled pre/post tax.
Required: Derive EBIT, EBT, PAT, coverage and post-tax margin with interpretation. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 12FM-C03-D007 · 10 marks
Case definition DSCR=(PAT+depreciation+interest)/(interest+principal due). P&L gives PAT 18, depreciation 6 already charged and interest 4 already charged. Principal instalment due 8. All Rs lakh; tax 6 means EBIT 28. No other adjustments. Current cash conversion information is incomplete.
Required: Calculate case DSCR, interest coverage and cash-earnings numerator; show effect of principal due rising to 12; explain limits and avoid adding tax to the specified numerator. (10 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 12FM-C03-D008 · 5 marks
PAT 16, preference dividend 2 and ordinary dividend 7 are supplied as valid declared amounts for the exercise. Ordinary shares 200000. All monetary values Rs lakh. No other changes. Preference coverage=PAT/preference dividend; ordinary earnings=PAT-preference dividend.
Required: Calculate coverage, EPS, DPS and payout. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 26FM-C03-D009 · 5 marks
Opening stock 10, closing stock 14, COGS 72 and sales 96. All Rs lakh. Required inventory turnover uses COGS/average stock and 360 days. A report uses closing stock and sales without disclosure.
Required: Compute the specified ratio/days and explain the report's inconsistency. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 16FM-C03-D010 · 10 marks
Opening/closing stock 8/12; opening/closing trade receivables 12/18; opening/closing trade payables 6/10. Sales 150 include 30 cash sales. COGS 100; net credit purchases 80, with no other purchase categories. All Rs lakh. Use 360 days; inventory=COGS/average stock, debtors=net credit sales/average receivables, creditors=net credit purchases/average payables. Gross operating cycle=inventory days+receivable days; net cash cycle subtracts payable days.
Required: Calculate all averages, turnovers, days and both cycles; explain why sales/credit-purchase bases cannot be interchanged. (10 marks)
Rs lakh unless stated otherwise; see scenario for definitions.
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 17FM-C03-D011 · 5 marks
Opening inventory 15, closing inventory 21, COGS 84. Assume all purchases are credit and no other stock adjustments. Average payables 14. Use 360 days and purchases/average payables. All Rs lakh.
Required: Derive purchases, creditor turnover/payment days and assess use of COGS as a substitute. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 17FM-C03-D012 · 5 marks
Raw-material opening/closing stock 6/10 and annual consumption 48. Finished-goods opening/closing stock 4/8 and annual COGS 60. All Rs lakh. Use respective cost flow/average stock and 360 days.
Required: Compute both turnover/days and explain why denominators/numerators differ. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 16FM-C03-D013 · 5 marks
Annual sales 200; average total assets 100, average net fixed assets 60, average current assets 40 and average capital employed 80. All Rs lakh. Use sales-based turnover consistently.
Required: Compute four turnover measures and explain why they are not interchangeable. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 15FM-C03-D014 · 5 marks
Opening capital employed 80, closing 120. EBIT 25, interest 5 and supplied 30% tax on EBT. No preference capital/non-operating items. Use average capital employed; pre-tax ROCE=EBIT/average capital; post-tax unlevered ROCE=EBIT(1-t)/average capital. All Rs lakh.
Required: Compute PAT and both ROCE measures, then distinguish PAT+gross interest from the specified post-tax numerator. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 24FM-C03-D015 · 10 marks
Coral reports sales 240, PAT 18, average assets 120 and average ordinary equity 60. No preference shares. Use PAT-based net margin, sales/average assets and assets/average equity; same averaging convention throughout. All Rs lakh.
Management claims any rise in equity multiplier proves improved operating efficiency. A separate comparable scenario keeps margin/asset turnover unchanged and raises multiplier from 2 to 3.
Required: Calculate all components/ROE, cross-check direct ROE, analyse the multiplier scenario and limitations. (10 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 26FM-C03-D016 · 10 marks
Comparable companies A and B use the same period/definitions with no preference shares. A:net margin 10%, asset turnover 1.5, equity multiplier 2. B:net margin 5%, asset turnover 2, equity multiplier 3. All components use matching average bases. A director says equal ROE means identical operating performance and financial risk.
Required: Calculate ROE and PAT/assets for each, identify differences and state an evidence-based comparison without a guaranteed investment recommendation. (10 marks)
Rs lakh unless stated otherwise; see scenario for definitions.
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 26FM-C03-D017 · 5 marks
PAT 24, preference dividend 4, average ordinary equity 100, preference capital 20. All Rs lakh. Requested ordinary ROE uses PAT less preference dividend/ordinary equity; total-shareholder return uses PAT/(ordinary equity+preference capital). No other claims.
Required: Compute both and explain correct matching. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 25FM-C03-D018 · 5 marks
Ordinary shares 200000 exist all year, with 100000 additional shares issued exactly halfway through a 12-month year. PAT 21 lakh, preference dividend 1 lakh. Use supplied simple weighted-average convention, ignore all other adjustments/dilution.
Required: Compute earnings available, weighted shares and EPS, compare closing-share shortcut and state limits. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 27FM-C03-D019 · 10 marks
Ordinary earnings 24 lakh; ordinary dividend 9.6 lakh; equity shares 400000 all year; ordinary net worth 80 lakh; current market price Rs 60. No preference shares. For a separate holding-period calculation, an investor bought at Rs 50, received Rs 2.40 dividend and sells at Rs 60; ignore costs/tax.
Required: Calculate EPS, DPS, payout, P/E, earnings yield, pure dividend yield, book value andmarket/book; separately calculate holding-period total return and distinguish it from dividend yield. (10 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 28FM-C03-D020 · 3 marks
A case defines Q as market value of equity plus debt 160 divided by estimated replacement cost of assets 100. All Rs lakh. A report callsQ>1 conclusive proof the shares should be sold as overvalued.
Required: CalculateQand assess the conclusion. (3 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 29FM-C03-D021 · 10 marks
All amounts Rs lakh. A company has conventional working capital 30, current ratio 2.5:1 and quick ratio 1.5:1. Quick assets exclude stock; there are no prepaids. Cash 5; remaining quick assets are receivables. Net fixed assets 60; long-term debt 30; no other assets/liabilities or preference capital. Current liabilities are non-interest trade liabilities only.
Required: Reconstruct the balance sheet, verify totals and compute long-debt/ordinary-equity and proprietary/assets ratios. Do not infer cash adequacy merely from current ratio. (10 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 38FM-C03-D022 · 10 marks
Use 360 days and Rs lakh. Gross profit is 25% of sales, COGS 90, inventory turnover 6 using COGS/average stock. Opening inventory 12. All sales and purchases are credit, with no stock adjustments. Debtor turnover 8 using sales/average debtors; opening debtors 10. Creditor payment period 45 days using purchases/average creditors; opening creditors 8.
Required: Reconstruct sales, gross profit, closing inventory, purchases, average/closing debtors and average/closing creditors, showing the flow identities. (10 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 17FM-C03-D023 · 5 marks
A trader reports sales 150 and a 25% markup on cost. All Rs lakh. Another report treats 25% as gross margin on sales and computes a different profit. Required: derive cost/profit, convert markup to sales margin and explain the mismatch. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 20FM-C03-D024 · 5 marks
Two years use comparable accounting policies/periods. Sales rise from 100 to 125, COGS 70 to 95, operating expenses 20 to 22; no other operating items. Rs lakh. Required: compute sales/gross-profit/EBIT changes and margins, then assess "25% sales growth means operations improved in every respect". (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 37FM-C03-D025 · 5 marks
Companies M and N report sales 200/100, COGS 120/55, operating expenses 50/30 and EBIT 30/15. Same period/definitions, all Rs lakh. Required: prepare common-size operating proportions, compare patterns and state limitations of absolute-profit ranking. (5 marks)
Rs lakh unless stated otherwise; see scenario for definitions.
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 37FM-C03-D026 · 5 marks
A seasonal firm has opening/closing stock 5/7, but its verified time-weighted annual stock average is 15 because most funds are tied up in a long seasonal peak. COGS 90. Use COGS/average stock. Required: compute the simple two-point and time-weighted turnover variants and assess comparisons. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 36FM-C03-D027 · 5 marks
A lender receives a high P/E ratio and current ratio but no debt-service schedule or cash-flow information. Supplier gets only ROE. The issuer has diversified divisions and changed depreciation policy, without explaining comparability.
Required: Recommend analytical evidence suited to both users and state comparability cautions. (5 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 31FM-C03-D028 · 3 marks
A firm has zero ordinary earnings and Rs 50 share price. A report gives P/E=0 by dividing price by zero and states it proves the cheapest stock. Required: correct the arithmetic and conclusion. (3 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 28FM-C03-D029 · 10 marks
Oak closing balance sheet: fixed assets 80; inventory 20; receivables 25; cash 5. Funding: ordinary capital 50; reserves 20; long interest debt 40; short bank 5; trade payables 15. No preference/other items. Opening/closing asset and equity balances are identical, so use these averages. Sales 180(all credit); COGS 120; operating expenses 30(including depreciation 6); interest 5; tax 5. No non-operating items. For current/quick ratios include short bank and trade in CL; quick excludes inventory. ROCE pre-tax uses EBIT/(assets-CL); ordinary ROE uses PAT/equity; DuPont uses PAT margin, sales/assets, assets/equity.
Required: reconcile balance sheet, derive profits, compute liquidity/coverage/ROCE/ROE and DuPont cross-check, and give a balanced diagnosis. (10 marks)
Rs lakh unless stated otherwise; see scenario for definitions.
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 26FM-C03-D030 · 10 marks
Pearl has CA 50(inventory 30, receivables 15, cash 5), CL 25 and conventional NWC 25. No prepaids/restrictions. ProposalA borrows 10 short-term and keeps it in cash. ProposalB sells inventory carrying 10 for 10 cash and repays 10 of CL. ProposalC collects 5 ofreceivables and holds cash. Each is independently considered from original position, lawful/no fees/profit/tax effects. Quick excludes stock; cash ratio=cash/CL. Rs lakh.
Required: calculate original and each proposal's current/quick/cash ratio, NWC; compare the drivers andwarn against headline improvement alone. (10 marks)
Show answer and marking
Original case; indicative capped allocation, not an official scheme. Equivalent reasoning credited; no duplicate credit. Ratios use the expressly stated case conventions.
Official concept source, PDF page 6