FA – L1 – Q103 – Interpretation of Financial Statements

KK is the owner of a business supplying goods to other traders. He has just received the financial accounts for his business for the year ended 31st December 20X8 from his accountant. These are reproduced below.

Statement of profit or loss for the year ended 31st December 20X8

GH¢ GH¢
Sales
Cost of sales
Gross profit
Expenses
Net profit

Statement of financial position as at 31st December 20X8

GH¢ GH¢
Non-current assets (net)
Current assets
Inventory 52,000
Receivables 15,000
Cash 100
Total assets
Current liabilities
Payables 6,000
Bank 2,500
Capital
Balance b/d 200,000
Net profit 30,000
Drawings (21,400)
Total capital and liabilities

Note: Inventory on 1st January 20X8 was valued at GH¢ 48,000.

Required:
Calculate for KK Enterprises each of the following ratios for the year ended 31st December 20X8 (where appropriate, calculations should be approximated to two decimal places):
(i) Net profit margin.
(ii) Return on capital employed (using the closing year-end value for capital employed).
(iii) Current ratio.
(iv) Liquid (acid test) ratio.
(v) Rate of inventory turnover.

(i) Net profit margin
Net profit margin = (Net profit / Sales) × 100
= (30,000 / 140,000) × 100
= 21.43%

(ii) Return on capital employed
Return on capital employed = (Net profit / Capital employed) × 100
Capital employed = Total assets – Current liabilities = 207,100 – 8,500 = 198,600
= (30,000 / 198,600) × 100
= 15.11%

(iii) Current ratio
Current ratio = Current assets / Current liabilities
= 67,100 / 8,500
= 7.89:1

(iv) Liquid (acid test) ratio
Liquid ratio = (Current assets – Inventory) / Current liabilities
= (67,100 – 52,000) / 8,500
= 15,100 / 8,500
= 1.78:1

(v) Rate of inventory turnover
Rate of inventory turnover = Cost of sales / Average inventory
Average inventory = (Opening inventory + Closing inventory) / 2
= (48,000 + 52,000) / 2 = 50,000
= 100,000 / 50,000
= 2 times