MA – L2 – Q57 – Performance analysis

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.

(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.