Test 4: Financial Analysis and Planning - Ratio Analysis: answer key

Question 1 · 2 marks · Financial Analysis and Planning - Ratio Analysis · medium

Scenario. Bharat Renewables Ltd. manufactures solar-power equipment and industrial energy-storage components. Its finance department has been asked to reconstruct the company's Balance Sheet and Statement of Profit and Loss from selected accounting figures and financial ratios for the year ended 31 March 2027. All amounts are in ₹ lakh. The following capital structure information is available: | Particulars | Amount | |---|---:| | Equity Share Capital | 400 | | Reserves and Surplus | 200 | | 10% Debentures | 300 | | Current Liabilities | 200 | There are no preference shares, fictitious assets, other non-current liabilities or prepaid expenses. The outstanding debentures have remained unchanged throughout the year. Current liabilities comprise trade payables. The company has the following financial ratios: Current Ratio 2.50:1; Quick Ratio 1.50:1; Fixed Assets Turnover Ratio (sales basis) 2 times; Gross Profit Margin 25%; and Net Profit Margin 8%. Additional operating and financial information: EBIT is ₹158 lakh, the corporate tax rate is 25%, and the debentures carry the stated annual coupon rate. Cash generated from operations before interest and tax is ₹220 lakh. Equity beta is 1.10. Working-capital information includes opening and closing inventory of ₹160 lakh and ₹200 lakh respectively; opening and closing trade receivables of ₹80 lakh and ₹100 lakh; and opening and closing trade payables of ₹176 lakh and ₹200 lakh. Annual credit sales are ₹900 lakh and annual net credit purchases are ₹940 lakh. Use a 360-day year. For reconstruction, assume that all current assets other than inventory are quick assets and that no extraordinary items or additional finance costs exist. The objective is to derive a balanced closing Balance Sheet and a consistent Statement of Profit and Loss while evaluating the reliability of the company's reported ratios.

Reconstruct the total assets and fixed assets of Bharat Renewables Ltd. using the available capital structure and liquidity information.

1. Total Assets ₹1,000 lakh; Fixed Assets ₹500 lakh
2. Total Assets ₹1,100 lakh; Fixed Assets ₹600 lakh (correct answer)
3. Total Assets ₹1,200 lakh; Fixed Assets ₹700 lakh
4. Total Assets ₹1,100 lakh; Fixed Assets ₹500 lakh

Answer: B — Total Assets ₹1,100 lakh; Fixed Assets ₹600 lakh

Explanation. Step 1: Total Funds = Equity Share Capital ₹400 + Reserves ₹200 + Debentures ₹300 + Current Liabilities ₹200 = ₹1,100 lakh. Therefore, Total Assets = ₹1,100 lakh. Step 2: Current Ratio = 2.5:1; Current Assets = 2.5 × ₹200 = ₹500 lakh. Step 3: Fixed Assets = Total Assets − Current Assets = ₹1,100 − ₹500 = ₹600 lakh. Option d incorrectly deducts only part of current assets when deriving fixed assets.

Where it goes wrong. Ignoring current liabilities while preparing the balance sheet or treating current assets as the only asset category.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 2 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Determine the closing inventory and quick assets of Bharat Renewables Ltd. using its Current Ratio and Quick Ratio.

1. Inventory ₹300 lakh; Quick Assets ₹200 lakh
2. Inventory ₹150 lakh; Quick Assets ₹350 lakh
3. Inventory ₹200 lakh; Quick Assets ₹300 lakh (correct answer)
4. Inventory ₹250 lakh; Quick Assets ₹250 lakh

Answer: C — Inventory ₹200 lakh; Quick Assets ₹300 lakh

Explanation. Current Liabilities = ₹200 lakh. Current Assets = 2.50 × ₹200 = ₹500 lakh. Quick Assets = Quick Ratio × Current Liabilities = 1.50 × ₹200 = ₹300 lakh. Since prepaid expenses are nil, Inventory = Current Assets − Quick Assets = ₹500 − ₹300 = ₹200 lakh. Option a reverses the inventory and quick-asset relationship, while option b uses an incorrect quick ratio. The reconstructed figures also agree with the balance sheet in Question 1.

Where it goes wrong. Confusing quick assets with inventory or failing to deduct inventory when deriving quick assets from current assets.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 3 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Reconstruct the annual sales revenue and Cost of Goods Sold of Bharat Renewables Ltd. using the Fixed Assets Turnover Ratio and Gross Profit Margin.

1. Sales ₹1,200 lakh; COGS ₹900 lakh (correct answer)
2. Sales ₹1,200 lakh; COGS ₹300 lakh
3. Sales ₹1,500 lakh; COGS ₹1,125 lakh
4. Sales ₹1,000 lakh; COGS ₹750 lakh

Answer: A — Sales ₹1,200 lakh; COGS ₹900 lakh

Explanation. Fixed Assets Turnover Ratio = Sales ÷ Fixed Assets. Therefore, Sales = 2 × ₹600 lakh = ₹1,200 lakh. Gross Profit Margin = 25%, so Gross Profit = 25% × ₹1,200 = ₹300 lakh. COGS = Sales − Gross Profit = ₹1,200 − ₹300 = ₹900 lakh. Option b confuses gross profit with cost of goods sold. Option c uses an incorrect fixed-asset base, while option d understates sales.

Where it goes wrong. Using gross profit as COGS or applying the Gross Profit Margin to fixed assets instead of sales.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 4 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Determine the Operating Expenses and Profit After Tax of Bharat Renewables Ltd. using the reconstructed Statement of Profit and Loss.

1. Operating Expenses ₹142 lakh; PAT ₹128 lakh
2. Operating Expenses ₹300 lakh; PAT ₹96 lakh
3. Operating Expenses ₹172 lakh; PAT ₹96 lakh
4. Operating Expenses ₹142 lakh; PAT ₹96 lakh (correct answer)

Answer: D — Operating Expenses ₹142 lakh; PAT ₹96 lakh

Explanation. Gross Profit = ₹300 lakh and EBIT = ₹158 lakh. Operating Expenses = Gross Profit − EBIT = ₹142 lakh. Annual Debenture Interest = ₹300 × 10% = ₹30 lakh. PBT = ₹158 − ₹30 = ₹128 lakh. Tax = 25% × ₹128 = ₹32 lakh. PAT = ₹128 − ₹32 = ₹96 lakh. Option a reports PBT instead of PAT, while option c incorrectly includes an additional expense.

Where it goes wrong. Confusing PBT with PAT or deducting interest and taxation twice when reconstructing the Statement of Profit and Loss.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 5 · 2 marks · Financial Analysis and Planning - Ratio Analysis · medium

Scenario. Zenith Industrial Systems Ltd. manufactures automated machinery and industrial power-control equipment. Its management has requested an independent reconstruction of its financial statements before presenting the annual performance report to the board. The following information relates to 31 March 2027. All monetary amounts are in ₹ lakh. Capital structure information: | Particulars | Amount | |---|---:| | Equity Share Capital | 500 | | Reserves and Surplus | 250 | | 8% Preference Share Capital | 50 | | 10% Debentures | 250 | | 12% Term Loan | 250 | | Current Liabilities | 200 | There are no fictitious assets or other liabilities. Current Ratio is 2.50:1, Quick Ratio is 1.75:1, Fixed Assets to Proprietary Fund Ratio is 1.25:1, Fixed Assets Turnover Ratio (sales basis) is 2.10 times and Gross Profit Margin is 30%. Proprietary Fund includes equity share capital, preference share capital and reserves and surplus. The company reports EBIT of ₹420 lakh and follows a corporate tax rate of 25%. The entire annual interest on debentures and the term loan is payable. Cash generated from operations before interest and tax is ₹560 lakh. Equity beta is 1.20. There are no exceptional gains or losses, and the preference dividend is not deductible for income-tax purposes. Additional working-capital information: opening and closing inventory are ₹144 lakh and ₹150 lakh; opening and closing receivables are ₹200 lakh and ₹220 lakh; opening and closing trade payables are ₹168 lakh and ₹160 lakh. Credit sales constitute 80% of total sales. Annual net credit purchases are ₹1,476 lakh. Other current liabilities are ₹40 lakh. Assume no prepaid expenses, write-offs or unusual financing arrangements. Use a 360-day year. The board is particularly concerned about whether the reconstructed financial statements reflect genuine operating strength or merely favourable closing balance-sheet ratios.

Calculate the Fixed Assets and Total Assets of Zenith Industrial Systems Ltd. using its Proprietary Fund and Fixed Assets to Proprietary Fund Ratio.

1. Fixed Assets ₹1,000 lakh; Total Assets ₹1,500 lakh (correct answer)
2. Fixed Assets ₹800 lakh; Total Assets ₹1,300 lakh
3. Fixed Assets ₹1,000 lakh; Total Assets ₹1,200 lakh
4. Fixed Assets ₹900 lakh; Total Assets ₹1,400 lakh

Answer: A — Fixed Assets ₹1,000 lakh; Total Assets ₹1,500 lakh

Explanation. Proprietary Fund = Equity Share Capital ₹500 + Reserves ₹250 + Preference Share Capital ₹50 = ₹800 lakh. Fixed Assets = 1.25 × ₹800 = ₹1,000 lakh. Total Sources of Funds = ₹500 + ₹250 + ₹50 + ₹250 + ₹250 + ₹200 = ₹1,500 lakh. Therefore, Total Assets = ₹1,500 lakh. Option b incorrectly excludes preference capital from the proprietary fund or omits part of the financing sources.

Where it goes wrong. Excluding preference share capital from the proprietary fund or forgetting that total assets must equal total liabilities and shareholders' funds.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 6 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Reconstruct the annual Sales and Cost of Goods Sold of Zenith Industrial Systems Ltd. using the Fixed Assets Turnover Ratio and Gross Profit Margin.

1. Sales ₹2,100 lakh; COGS ₹630 lakh
2. Sales ₹2,000 lakh; COGS ₹1,400 lakh
3. Sales ₹2,200 lakh; COGS ₹1,540 lakh
4. Sales ₹2,100 lakh; COGS ₹1,470 lakh (correct answer)

Answer: D — Sales ₹2,100 lakh; COGS ₹1,470 lakh

Explanation. Fixed Assets Turnover = Sales ÷ Fixed Assets. Hence, Sales = 2.10 × ₹1,000 = ₹2,100 lakh. Gross Profit = 30% × ₹2,100 = ₹630 lakh. COGS = ₹2,100 − ₹630 = ₹1,470 lakh. Option a treats gross profit as COGS, while option c uses an incorrect fixed-asset turnover calculation. The sales figure must be determined before applying the gross-profit percentage.

Where it goes wrong. Applying the gross-profit percentage directly as a cost percentage instead of calculating COGS as the balance of sales after gross profit.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 7 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Determine the Profit Before Tax and Profit After Tax of Zenith Industrial Systems Ltd. using its EBIT, debt coupon rates and tax rate.

1. PBT ₹420 lakh; PAT ₹315 lakh
2. PBT ₹365 lakh; PAT ₹365 lakh
3. PBT ₹365 lakh; PAT ₹273.75 lakh (correct answer)
4. PBT ₹310 lakh; PAT ₹232.50 lakh

Answer: C — PBT ₹365 lakh; PAT ₹273.75 lakh

Explanation. Debenture Interest = ₹250 × 10% = ₹25 lakh. Term Loan Interest = ₹250 × 12% = ₹30 lakh. Total Interest = ₹55 lakh. PBT = EBIT ₹420 − ₹55 = ₹365 lakh. Tax = 25% × ₹365 = ₹91.25 lakh. PAT = ₹365 − ₹91.25 = ₹273.75 lakh. Option a ignores finance cost, while option b omits taxation. Preference dividend is not deducted while calculating PAT.

Where it goes wrong. Ignoring interest on one of the borrowing sources or deducting preference dividend while calculating PAT instead of earnings available to equity shareholders.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 8 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Calculate the Operating Cycle and Cash Conversion Cycle of Zenith Industrial Systems Ltd. using the supplied average-balance and credit-turnover information.

1. 81 days and 45 days
2. 81 days and 41 days (correct answer)
3. 76 days and 40 days
4. 85 days and 41 days

Answer: B — 81 days and 41 days

Explanation. Average Inventory = (144 + 150) ÷ 2 = ₹147 lakh. Inventory Turnover = 1,470 ÷ 147 = 10 times; holding period = 36 days. Average Receivables = (200 + 220) ÷ 2 = ₹210 lakh. Credit Sales = 80% × ₹2,100 = ₹1,680 lakh; turnover = 8 times; collection period = 45 days. Payables Turnover = 1,476 ÷ 164 = 9 times; payment period = 40 days. Operating Cycle = 81 days; Cash Conversion Cycle = 41 days.

Where it goes wrong. Adding supplier payment days instead of deducting them, or using total sales rather than credit sales for receivables turnover.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 9 · 2 marks · Financial Analysis and Planning - Ratio Analysis · medium

Scenario. A company has a Current Ratio of 3:1, Quick Ratio of 1.5:1 and Net Working Capital of ₹400 lakh. Assume that there are no prepaid expenses or short-term bank borrowings excluded from current liabilities. Determine its Current Assets and Inventory.

A company has a Current Ratio of 3:1, Quick Ratio of 1.5:1 and Net Working Capital of ₹400 lakh. Assume that there are no prepaid expenses or short-term bank borrowings excluded from current liabilities. Determine its Current Assets and Inventory.

1. Current Assets ₹500 lakh; Inventory ₹250 lakh
2. Current Assets ₹600 lakh; Inventory ₹200 lakh
3. Current Assets ₹600 lakh; Inventory ₹300 lakh (correct answer)
4. Current Assets ₹800 lakh; Inventory ₹400 lakh

Answer: C — Current Assets ₹600 lakh; Inventory ₹300 lakh

Explanation. Let Current Liabilities be x. Current Assets = 3x. Net Working Capital = 3x − x = ₹400 lakh. Therefore, 2x = ₹400 and Current Liabilities = ₹200 lakh. Current Assets = 3 × ₹200 = ₹600 lakh. Quick Assets = 1.5 × ₹200 = ₹300 lakh. Inventory = ₹600 − ₹300 = ₹300 lakh. Option b incorrectly derives inventory using an incorrect quick-asset amount.

Where it goes wrong. Solving the current ratio and net working capital equations incorrectly or forgetting to deduct quick assets from current assets to derive inventory.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 10 · 2 marks · Financial Analysis and Planning - Ratio Analysis · medium

Scenario. An enterprise reports Fixed Assets of ₹800 lakh, Fixed Assets Turnover Ratio of 2.5 times and Gross Profit Margin of 20%. Reconstruct its annual Sales and Cost of Goods Sold.

An enterprise reports Fixed Assets of ₹800 lakh, Fixed Assets Turnover Ratio of 2.5 times and Gross Profit Margin of 20%. Reconstruct its annual Sales and Cost of Goods Sold.

1. Sales ₹2,000 lakh; COGS ₹1,600 lakh (correct answer)
2. Sales ₹2,000 lakh; COGS ₹400 lakh
3. Sales ₹1,800 lakh; COGS ₹1,440 lakh
4. Sales ₹2,500 lakh; COGS ₹2,000 lakh

Answer: A — Sales ₹2,000 lakh; COGS ₹1,600 lakh

Explanation. Sales = Fixed Assets × Fixed Assets Turnover Ratio = ₹800 × 2.5 = ₹2,000 lakh. Gross Profit = 20% × ₹2,000 = ₹400 lakh. COGS = Sales − Gross Profit = ₹2,000 − ₹400 = ₹1,600 lakh. Option b incorrectly treats gross profit as COGS. Option c uses an incorrect turnover calculation. The gross profit percentage is calculated on sales, not on cost.

Where it goes wrong. Confusing Gross Profit Margin with the percentage of cost or using the gross-profit amount as the cost of goods sold.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 11 · 2 marks · Financial Analysis and Planning - Ratio Analysis · medium

Scenario. A company reports Current Assets of ₹800 lakh and Current Liabilities of ₹400 lakh. Immediately before the reporting date, it pays ₹150 lakh of trade creditors out of its cash balance. Calculate the revised Current Ratio and Net Working Capital.

A company reports Current Assets of ₹800 lakh and Current Liabilities of ₹400 lakh. Immediately before the reporting date, it pays ₹150 lakh of trade creditors out of its cash balance. Calculate the revised Current Ratio and Net Working Capital.

1. 2.00:1 and ₹250 lakh
2. 2.50:1 and ₹400 lakh
3. 2.60:1 and ₹250 lakh
4. 2.60:1 and ₹400 lakh (correct answer)

Answer: D — 2.60:1 and ₹400 lakh

Explanation. After payment, Current Assets = ₹800 − ₹150 = ₹650 lakh and Current Liabilities = ₹400 − ₹150 = ₹250 lakh. Revised Current Ratio = 650 ÷ 250 = 2.60:1. Initial NWC = 800 − 400 = ₹400 lakh. Revised NWC = 650 − 250 = ₹400 lakh. Thus, the ratio improves even though the absolute working-capital position remains unchanged. Option c incorrectly reduces NWC by the amount of payment.

Where it goes wrong. Assuming that an improvement in Current Ratio automatically means that Net Working Capital has increased.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 12 · 2 marks · Financial Analysis and Planning - Ratio Analysis · medium

Scenario. A company has Total Assets of ₹1,600 lakh and a Proprietary Ratio of 0.50. Its equity share capital is ₹500 lakh and preference share capital is ₹100 lakh. Determine the balance of Reserves and Surplus, assuming the proprietary fund comprises equity share capital, preference share capital and reserves and surplus only.

A company has Total Assets of ₹1,600 lakh and a Proprietary Ratio of 0.50. Its equity share capital is ₹500 lakh and preference share capital is ₹100 lakh. Determine the balance of Reserves and Surplus, assuming the proprietary fund comprises equity share capital, preference share capital and reserves and surplus only.

1. ₹100 lakh
2. ₹200 lakh (correct answer)
3. ₹300 lakh
4. ₹400 lakh

Answer: B — ₹200 lakh

Explanation. Proprietary Fund = Proprietary Ratio × Total Assets = 0.50 × ₹1,600 = ₹800 lakh. Proprietary Fund consists of equity share capital, preference share capital and reserves. Therefore, Reserves = ₹800 − ₹500 − ₹100 = ₹200 lakh. Option a excludes part of the shareholders' funds, while option c uses an incorrect proprietary ratio. All three components must be included in the proprietary fund.

Where it goes wrong. Excluding preference share capital from proprietary funds or treating total assets as equivalent to equity shareholders' funds.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 13 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Scenario. The following information is available for Rudra Engineering Ltd.: Equity Share Capital ₹500 lakh; Reserves and Surplus ₹300 lakh; Long-term Debt to Net Worth Ratio 0.5:1; Current Liabilities ₹500 lakh; Current Ratio 1:1? No, use Acid-Test Ratio 1:1; Total Asset Turnover Ratio 2.5 times; Gross Profit Margin 20%; Inventory Turnover Ratio 8 times based on COGS; Average Collection Period 36 days; annual sales are entirely on credit. Opening Inventory ₹430 lakh, Closing Inventory ₹420 lakh; Opening Receivables ₹410 lakh, Closing Receivables ₹440 lakh. No prepaid expenses exist. Determine the closing Cash Balance and Fixed Assets, respectively. Use a 360-day year.

The following information is available for Rudra Engineering Ltd.: Equity Share Capital ₹500 lakh; Reserves and Surplus ₹300 lakh; Long-term Debt to Net Worth Ratio 0.5:1; Current Liabilities ₹500 lakh; Current Ratio 1:1? No, use Acid-Test Ratio 1:1; Total Asset Turnover Ratio 2.5 times; Gross Profit Margin 20%; Inventory Turnover Ratio 8 times based on COGS; Average Collection Period 36 days; annual sales are entirely on credit. Opening Inventory ₹430 lakh, Closing Inventory ₹420 lakh; Opening Receivables ₹410 lakh, Closing Receivables ₹440 lakh. No prepaid expenses exist. Determine the closing Cash Balance and Fixed Assets, respectively. Use a 360-day year.

1. ₹60 lakh and ₹780 lakh (correct answer)
2. ₹100 lakh and ₹700 lakh
3. ₹40 lakh and ₹800 lakh
4. ₹60 lakh and ₹920 lakh

Answer: A — ₹60 lakh and ₹780 lakh

Explanation. Net Worth = 500 + 300 = ₹800 lakh. Long-term Debt = 0.5 × 800 = ₹400 lakh. Total Assets = 800 + 400 + 500 = ₹1,700 lakh. Sales = 2.5 × 1,700 = ₹4,250 lakh; COGS = 80% × 4,250 = ₹3,400 lakh. Average Receivables = 425, consistent with 36 days. Acid-test assets = ₹500 lakh. Closing Receivables are ₹440 lakh, so Cash = 500 − 440 = ₹60 lakh. Closing Current Assets = 420 + 440 + 60 = ₹920 lakh. Fixed Assets = 1,700 − 920 = ₹780 lakh.

Where it goes wrong. Using average balances instead of closing balances in the reconstructed closing Balance Sheet or omitting cash when calculating quick assets.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 14 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Scenario. A company reports annual sales of ₹2,500 lakh, Gross Profit Margin of 30%, Operating Profit Margin of 12%, finance cost of ₹50 lakh and an income-tax rate of 25%. Reconstruct its Operating Expenses and Profit After Tax.

A company reports annual sales of ₹2,500 lakh, Gross Profit Margin of 30%, Operating Profit Margin of 12%, finance cost of ₹50 lakh and an income-tax rate of 25%. Reconstruct its Operating Expenses and Profit After Tax.

1. ₹450 lakh and ₹225 lakh
2. ₹450 lakh and ₹187.50 lakh (correct answer)
3. ₹500 lakh and ₹187.50 lakh
4. ₹450 lakh and ₹200 lakh

Answer: B — ₹450 lakh and ₹187.50 lakh

Explanation. Gross Profit = 30% × ₹2,500 = ₹750 lakh. EBIT = 12% × ₹2,500 = ₹300 lakh. Operating Expenses = Gross Profit − EBIT = ₹450 lakh. PBT = ₹300 − ₹50 = ₹250 lakh. Tax = 25% × ₹250 = ₹62.50 lakh. PAT = ₹250 − ₹62.50 = ₹187.50 lakh. Option a omits the finance cost when calculating taxable profit or incorrectly applies taxation to EBIT.

Where it goes wrong. Using gross profit as operating profit or applying tax to EBIT instead of deducting finance cost to calculate PBT.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 15 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Scenario. The following information is available for Meera Manufacturing Ltd.: Equity Share Capital ₹300 lakh; Reserves and Surplus ₹200 lakh; Preference Share Capital ₹100 lakh; Long-term Debt ₹400 lakh; Current Liabilities ₹200 lakh; Fixed Assets to Proprietary Fund Ratio 1.25:1; Current Ratio 2.25:1; Quick Ratio 1.5:1. There are no prepaid expenses or fictitious assets. Calculate the Fixed Assets and closing Inventory, respectively.

The following information is available for Meera Manufacturing Ltd.: Equity Share Capital ₹300 lakh; Reserves and Surplus ₹200 lakh; Preference Share Capital ₹100 lakh; Long-term Debt ₹400 lakh; Current Liabilities ₹200 lakh; Fixed Assets to Proprietary Fund Ratio 1.25:1; Current Ratio 2.25:1; Quick Ratio 1.5:1. There are no prepaid expenses or fictitious assets. Calculate the Fixed Assets and closing Inventory, respectively.

1. ₹600 lakh and ₹150 lakh
2. ₹750 lakh and ₹200 lakh
3. ₹750 lakh and ₹150 lakh (correct answer)
4. ₹900 lakh and ₹150 lakh

Answer: C — ₹750 lakh and ₹150 lakh

Explanation. Proprietary Fund = ₹300 + ₹200 + ₹100 = ₹600 lakh. Fixed Assets = 1.25 × ₹600 = ₹750 lakh. Current Assets = Current Ratio × Current Liabilities = 2.25 × ₹200 = ₹450 lakh. Quick Assets = 1.5 × ₹200 = ₹300 lakh. Inventory = Current Assets − Quick Assets = ₹450 − ₹300 = ₹150 lakh. Option a incorrectly uses an insufficient proprietary-fund base, while option b understates quick assets.

Where it goes wrong. Excluding preference share capital from proprietary funds or confusing current assets with quick assets when deriving inventory.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 16 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Scenario. A trading company reports annual credit sales of ₹3,600 lakh and a Debtors' Velocity of 2 months. Bills Receivable of ₹100 lakh are included in total receivables. Calculate the amount of Sundry Debtors, assuming that the stated total receivable balance and Bills Receivable are measured on the same basis.

A trading company reports annual credit sales of ₹3,600 lakh and a Debtors' Velocity of 2 months. Bills Receivable of ₹100 lakh are included in total receivables. Calculate the amount of Sundry Debtors, assuming that the stated total receivable balance and Bills Receivable are measured on the same basis.

1. ₹400 lakh
2. ₹450 lakh
3. ₹600 lakh
4. ₹500 lakh (correct answer)

Answer: D — ₹500 lakh

Explanation. Debtors' Velocity = 2 months. Receivables Turnover = 12 ÷ 2 = 6 times. Total Receivables = Credit Sales ÷ Receivables Turnover = ₹3,600 ÷ 6 = ₹600 lakh. Sundry Debtors = Total Receivables − Bills Receivable = ₹600 − ₹100 = ₹500 lakh. Option c reports total receivables including bills, while option b uses an incorrect collection period. Bills Receivable must not be counted twice.

Where it goes wrong. Reporting total receivables as Sundry Debtors without deducting Bills Receivable included in that total.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 17 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Scenario. A company reports the following operating figures: | Particulars | Previous Year | Current Year | |---|---:|---:| | Sales | ₹1,000 lakh | ₹1,200 lakh | | COGS | ₹700 lakh | ₹840 lakh | | Operating Expenses | ₹100 lakh | ₹180 lakh | Calculate the increase in Operating Expenses Ratio and identify the implication for operating profitability.

A company reports the following operating figures: | Particulars | Previous Year | Current Year | |---|---:|---:| | Sales | ₹1,000 lakh | ₹1,200 lakh | | COGS | ₹700 lakh | ₹840 lakh | | Operating Expenses | ₹100 lakh | ₹180 lakh | Calculate the increase in Operating Expenses Ratio and identify the implication for operating profitability.

1. Increase of 5 percentage points; operating efficiency has deteriorated despite an unchanged Gross Profit Margin. (correct answer)
2. Increase of 10 percentage points; gross profitability has deteriorated.
3. Decrease of 5 percentage points; operating profitability has improved.
4. No change; operating expenses have increased in the same proportion as sales.

Answer: A — Increase of 5 percentage points; operating efficiency has deteriorated despite an unchanged Gross Profit Margin.

Explanation. Previous-year Operating Expenses Ratio = 100 ÷ 1,000 × 100 = 10%. Current-year Ratio = 180 ÷ 1,200 × 100 = 15%. Increase = 5 percentage points. Gross Profit Margin remains 30% in both years: 300 ÷ 1,000 and 360 ÷ 1,200. However, Operating Profit Margin falls from 20% to 15%. This indicates higher operating expenses relative to sales, reducing operating profitability despite unchanged gross margin.

Where it goes wrong. Assuming that an unchanged Gross Profit Margin necessarily means unchanged operating efficiency, without examining the operating expense burden.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 18 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Scenario. A company has Current Assets of ₹1,500 lakh and Current Liabilities of ₹500 lakh. Its Quick Assets are only ₹250 lakh, and there are no prepaid expenses. Calculate Inventory and determine the correct interpretation of its liquidity position.

A company has Current Assets of ₹1,500 lakh and Current Liabilities of ₹500 lakh. Its Quick Assets are only ₹250 lakh, and there are no prepaid expenses. Calculate Inventory and determine the correct interpretation of its liquidity position.

1. Inventory ₹750 lakh; the company has a satisfactory quick liquidity position.
2. Inventory ₹1,000 lakh; the company has negligible inventory dependence.
3. Inventory ₹1,250 lakh; the high Current Ratio is substantially supported by inventory rather than readily available quick assets. (correct answer)
4. Inventory ₹1,500 lakh; the company has no quick assets available.

Answer: C — Inventory ₹1,250 lakh; the high Current Ratio is substantially supported by inventory rather than readily available quick assets.

Explanation. Inventory = Current Assets − Quick Assets − Prepaid Expenses = ₹1,500 − ₹250 − ₹0 = ₹1,250 lakh. Current Ratio = 1,500 ÷ 500 = 3:1. Quick Ratio = 250 ÷ 500 = 0.50:1. Although the Current Ratio appears strong, the quick liquidity position is comparatively weak because a substantial portion of current assets is invested in inventory. This warrants examination of inventory quality and conversion efficiency.

Where it goes wrong. Interpreting a high Current Ratio as proof of sound liquidity without examining the composition and immediate convertibility of current assets.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 19 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Scenario. A seasonal manufacturing company reports annual COGS of ₹7,200 lakh. Its average monthly inventory during the year was ₹600 lakh, whereas closing inventory at year-end was ₹1,800 lakh due to seasonal stocking. Calculate (i) Inventory Turnover using average inventory and (ii) Inventory Turnover using closing inventory. What is the difference?

A seasonal manufacturing company reports annual COGS of ₹7,200 lakh. Its average monthly inventory during the year was ₹600 lakh, whereas closing inventory at year-end was ₹1,800 lakh due to seasonal stocking. Calculate (i) Inventory Turnover using average inventory and (ii) Inventory Turnover using closing inventory. What is the difference?

1. 12 times and 6 times; difference 6 times
2. 12 times and 4 times; difference 8 times (correct answer)
3. 10 times and 4 times; difference 6 times
4. 8 times and 3 times; difference 5 times

Answer: B — 12 times and 4 times; difference 8 times

Explanation. Using average monthly inventory: Inventory Turnover = ₹7,200 ÷ ₹600 = 12 times. Using closing inventory: ₹7,200 ÷ ₹1,800 = 4 times. Difference = 12 − 4 = 8 times. The unusually high closing inventory results from seasonal stocking and may not represent the normal inventory level throughout the year. The chapter specifically identifies seasonal factors as a limitation of ratio analysis and notes that average inventory may provide a better picture.

Where it goes wrong. Treating a seasonal year-end inventory balance as representative of inventory held throughout the year.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis

Question 20 · 2 marks · Financial Analysis and Planning - Ratio Analysis · hard

Scenario. A company has Current Assets of ₹1,200 lakh and Current Liabilities of ₹800 lakh, including a short-term borrowing of ₹300 lakh. Before publication of its annual financial statements, management reclassifies the ₹300 lakh borrowing as long-term debt without obtaining an actual extension of the borrowing's maturity. Calculate the reported Current Ratio and the correctly classified Current Ratio.

A company has Current Assets of ₹1,200 lakh and Current Liabilities of ₹800 lakh, including a short-term borrowing of ₹300 lakh. Before publication of its annual financial statements, management reclassifies the ₹300 lakh borrowing as long-term debt without obtaining an actual extension of the borrowing's maturity. Calculate the reported Current Ratio and the correctly classified Current Ratio.

1. 1.50:1 and 2.40:1
2. 2.00:1 and 1.50:1
3. 2.40:1 and 2.00:1
4. 2.40:1 and 1.50:1 (correct answer)

Answer: D — 2.40:1 and 1.50:1

Explanation. After the unsupported reclassification, reported Current Liabilities = ₹800 − ₹300 = ₹500 lakh. Reported Current Ratio = ₹1,200 ÷ ₹500 = 2.40:1. However, without an actual maturity extension, the borrowing remains a short-term liability. Correct Current Liabilities = ₹800 lakh, giving Correct Current Ratio = ₹1,200 ÷ ₹800 = 1.50:1. The reclassification improves the reported ratio without improving the underlying liquidity position.

Where it goes wrong. Accepting an accounting reclassification as an actual improvement in short-term solvency when the contractual repayment obligation has not changed.

Authority. ICAI SM: Financial Management and Strategic Management, Financial Analysis and Planning - Ratio Analysis