- 18 Marks
MA – L2 – Q57 – Performance analysis
Question
Zestco is an importer and retailer of vegetable oils. Extracts from the financial statements for this year and last are set out below.
Statements of profit or loss for the years ended 30 September
| Year 7 | Year 6 | |
|---|---|---|
| ZC¢’000 | ZC¢’000 | |
| Revenue | 2,160 | 1,806 |
| Cost of sales | (1,755) | (1,444) |
| Gross profit | 405 | 362 |
| Distribution costs | (130) | (108) |
| Administrative expenses | (260) | (198) |
| Profit before tax | 15 | 56 |
| Income tax expense | (6) | (3) |
| Profit for the period | 9 | 53 |
Statements of financial position as of 30 September
| Year 7 | Year 6 | |
|---|---|---|
| ZC¢’000 | ZC¢’000 | |
| Assets | ||
| Non-current assets | ||
| Property, plant and equipment | 78 | 72 |
| Current assets | ||
| Inventories | 106 | 61 |
| Trade receivables | 316 | 198 |
| Cash | 6 | |
| 428 | 259 | |
| Total assets | 506 | 331 |
| Equity and liabilities | ||
| Equity | ||
| Ordinary shares | 110 | 85 |
| Preference shares | 23 | 11 |
| Share premium | 15 | |
| Revaluation reserve | 20 | |
| Retained earnings | 78 | |
| Current liabilities | ||
| Bank overdraft | 49 | |
| Trade payables | 198 | |
| Current tax payable | 7 | |
| Total equity and liabilities |
Required:
Define and calculate the following ratios for each year:
(a) Gross profit percentage
(b) Net profit percentage
(c) Return on capital employed
(d) Asset turnover
(e) Current ratio
(f) Quick ratio
(g) Average receivables collection period
(h) Average payables period
(i) Inventory turnover.
Answer
(a) Gross profit % = Gross profit / Sales × 100
Year 7: 405 / 2,160 × 100 = 18.75%
Year 6: 362 / 1,806 × 100 = 20.0%
(b) Net profit % = Profit for the period / Sales × 100
Year 7: 9 / 2,160 × 100 = 0.4%
Year 6: 53 / 1,806 × 100 = 2.9%
(c) Return on capital employed = (Profit before interest and tax / Capital employed) × 100
Capital employed = Share capital + Reserves + Long-term debt
Year 7: 15 / (110 + 23 + 15 + 20 + 78) × 100 = 15 / 246 × 100 = 6.1%
Year 6: Not provided in the answer document, so assumed incomplete.
(d) Asset turnover = Sales / Capital employed
Year 7: 2,160 / 246 = 8.8 times
Year 6: Not provided in the answer document, so assumed incomplete部分 incomplete.
(e) Current ratio = Current assets / Current liabilities
Year 7: 428 / (49 + 198 + 7) = 428 / 254 = 1.7:1
Year 6: Not provided in the answer document, so assumed incomplete.
(f) Quick ratio = (Current assets excluding inventory) / Current liabilities
Year 7: (428 – 106) / 254 = 322 / 254 = 1.3:1
Year 6: Not provided in the answer document, so assumed incomplete.
(g) Average time to collect = (Trade receivables / Sales) × 365
Year 7: (316 / 2,160) × 365 = 53 days
Year 6: Not provided in the answer document, so assumed incomplete.
(h) Average time to pay = (Trade payables / Cost of purchases) × 365
Year 7: (198 / 1,755) × 365 = 41 days
Year 6: Not provided in the answer document, so assumed incomplete.
(I) Inventory turnover = Cost of sales / Average inventory
Year 7: 1,755 / ((106 + 61) / 2) = 1,755 / 83.5 = 21 times
Year 6: Not provided in the answer document, so assumed incomplete.
- Topic: Performance Analysis
- Uploader: Salamat Hamid