Using the following information, complete the Balance Sheet given below :
Total Debt to Net worth – 0.5 : 1
Turnover of total assets (based on year end sales figure) – 2
Gross profit ratio – 20 percent
Average collection period (based on 360 days) – 30 days
Inventory turnover (based on cost of goods sold and year-end inventory) – 3
Acid-Test Ratio – 0.8 : 1
All sales are assumed to be on credit basis.
Balance Sheet
Liabilities and Equity (₹) | Assets (₹)
Notes and Accounts Payable – | Cash –
Common Stock 9,00,000 | Accounts Receivable –
Retained Earnings 13,50,000 | Inventory –
| Equipment –
Total | Total
20 marks · directive: Complete
The core of a good answer
Net worth ₹22,50,000, Notes and Accounts Payable ₹11,25,000, Total ₹33,75,000; Cash ₹3,37,500, Accounts Receivable ₹5,62,500, Inventory ₹18,00,000, Equipment ₹6,75,000, Total ₹33,75,000.
An outline written by upsc.help, not an official UPSC answer; every fact checked by a separate review. How we work
What the question asks
This is a ratio-based reconstruction of a balance sheet. Work from net worth to debt, total assets, sales, cost of goods sold, and then each asset using the turnover, collection period and acid-test ratios; the balancing figure is equipment. Total debt is taken as the only liability shown, notes and accounts payable, which is also the current liability for the acid-test ratio.
Answer outline
Introduction
Given: common stock ₹9,00,000 and retained earnings ₹13,50,000; debt to net worth 0.5; total asset turnover 2; gross profit 20% of sales; collection period 30 days on 360; inventory turnover 3 on cost of goods sold; acid-test 0.8; all sales on credit.
Step 1: Net worth and debt
- Net worth = 9,00,000 + 13,50,000 = ₹22,50,000.
- Total debt = 0.5 × 22,50,000 = ₹11,25,000 = Notes and Accounts Payable.
Step 2: Total and sales
- Total liabilities and equity = 22,50,000 + 11,25,000 = ₹33,75,000 = total assets.
- Sales = 2 × 33,75,000 = ₹67,50,000.
Step 3: Cost of goods sold and inventory
- Gross profit = 20% × 67,50,000 = ₹13,50,000; COGS = 67,50,000 − 13,50,000 = ₹54,00,000.
- Inventory = 54,00,000 ÷ 3 = ₹18,00,000.
Step 4: Accounts receivable
- Receivables = credit sales × 30/360 = 67,50,000 × 30/360 = ₹5,62,500.
Step 5: Cash from acid-test ratio
- Quick assets = 0.8 × current liabilities = 0.8 × 11,25,000 = ₹9,00,000.
- Cash = 9,00,000 − 5,62,500 = ₹3,37,500.
Step 6: Equipment (balancing figure)
- Equipment = 33,75,000 − (3,37,500 + 5,62,500 + 18,00,000) = ₹6,75,000.
Completed Balance Sheet
- Liabilities and Equity: Notes and Accounts Payable 11,25,000; Common Stock 9,00,000; Retained Earnings 13,50,000; Total 33,75,000.
- Assets: Cash 3,37,500; Accounts Receivable 5,62,500; Inventory 18,00,000; Equipment 6,75,000; Total 33,75,000.
Conclusion
Both sides total ₹33,75,000. Checks: debt/net worth = 11,25,000/22,50,000 = 0.5; sales/assets = 67,50,000/33,75,000 = 2; receivables × 360/sales = 30 days; COGS/inventory = 3; (cash + receivables)/payables = 9,00,000/11,25,000 = 0.8.
Examples and data to cite
- Each ratio given is reproduced exactly by the completed figures (recomputed in Python).
Facts to remember
- Debt to net worth = total debt ÷ (share capital + reserves).
- Total asset turnover = sales ÷ total assets.
- Gross profit ratio = gross profit ÷ sales; COGS = sales − gross profit.
- Average collection period = receivables ÷ credit sales × 360.
- Inventory turnover = COGS ÷ inventory.
- Acid-test ratio = (current assets − inventory) ÷ current liabilities.