- 20 Marks
Question
Kack Ltd is a listed company that assembles domestic electrical goods which it then sells to both wholesale and retail customers. Kack Ltd’s management was disappointed in the company’s results for the year ended 31 March 2014. In an attempt to improve performance, the following measures were taken early in the year ended 31 March 2015:
- A national advertising campaign was undertaken.
- Rebates to all wholesale customers purchasing goods above set quantity levels were introduced.
- The assembly of certain lines ceased and was replaced by bought-in completed products. This allowed Kack Ltd to dispose of surplus plant.
Kack Ltd’s summarised financial statements for the year ended 31 March 2015 are set out below:
STATEMENT OF PROFIT OR LOSS AND OTHER COMPREHENSIVE INCOME
FOR THE YEAR ENDED 31 MARCH 2015
| Description | GHSm |
|---|---|
| Revenue (25% cash sales) | 4,000 |
| Cost of sales | (3,450) |
| Gross profit | 550 |
| Operating expenses | (370) |
| Operating profit | 180 |
| Profit on disposal of plant (note (i)) | 40 |
| Financial charges | (20) |
| Profit before tax | 200 |
| Income tax expense | (50) |
| Profit for the year | 150 |
STATEMENT OF FINANCIAL POSITION
AS AT 31 MARCH 2015
| Description | GHSm | GHSm |
|---|---|---|
| Non-current assets | ||
| Property, plant, and equipment (note (ii)) | 550 | |
| Current assets | ||
| Inventory | 250 | |
| Trade receivables | 360 | |
| Bank | nil | |
| Total current assets | 610 | |
| Total assets | 1,160 | |
| Equity and liabilities | ||
| Equity | ||
| Stated capital (400m shares) | 100 | |
| Income surplus | 380 | |
| Total equity | 480 | |
| Non-current liabilities | ||
| 8% loan notes | 200 | |
| Current liabilities | ||
| Bank overdraft | 10 | |
| Trade payables | 430 | |
| Current tax payables | 40 | |
| Total current liabilities | 480 | |
| Total equity and liabilities | 1,160 |
Below are ratios calculated for the year ended 31 March 2014:
- Return on year-end capital employed (profit before interest and tax over total assets less current liabilities): 28.1%
- Net assets (equal to capital employed) turnover: 4 times
- Gross profit margin: 17%
- Net profit (before tax) margin: 6.3%
- Current ratio: 1.6:1
- Closing inventory holding period: 46 days
- Trade receivables’ collection period: 45 days
- Trade payables’ payment period: 55 days
- Dividend yield: 3.75%
- Dividend cover: 2 times
Notes:
- Kack Ltd received GHS 120 million from the sale of plant that had a carrying amount of GHS 80 million at the date of its sale.
- The market price of Kack Ltd’s share throughout the year averaged GHS 3.75 each.
- There were no issues or redemption of shares or loans during the year.
- Dividends paid during the year ended 31 March 2015 amounted to GHS 90 million, maintaining the same dividend paid in the year ended 31 March 2014.
Required:
a) Calculate ratios for the year ended 31 March 2015 (showing your workings) for Kack Ltd, equivalent to those provided above.
(10 marks)
b) Analyse the financial performance and position of Kack Ltd for the year ended 31 March 2015 compared to the previous year.
(10 marks)
(Total: 20 marks)
Answer
a) Ratios Calculation
| Ratio Description | Formula | Calculation | Result |
|---|---|---|---|
| Return on Capital Employed (ROCE) | Profit before Interest and Tax / Total Assets – Total Current Liabilities | 220 / 680 × 100 | 32.3% |
| Net assets turnover | Turnover / Net Assets | 4,000 / 680 | 5.9 times |
| Gross profit margin | Gross Profit / Turnover | 550 / 4,000 × 100 | 13.8% |
| Net profit margin | Profit before Tax / Turnover | 200 / 4,000 × 100 | 5% |
| Current ratio | Current Assets / Current Liabilities | 610 / 480 | 1.27:1 |
| Closing inventory holding period | Average Inventory / Cost of Sales × 365 | 250 / 3,450 × 365 | 26 days |
| Trade receivables collection period | Trade Receivable / Credit Sales × 365 | 360 / 3,000 × 365 | 44 days |
| Trade payables payment period | Trade Payables / Credit Purchase × 365 | 430 / 3,450 × 365 | 45 days |
| Dividend yield | Dividend per Share / Market Price × 100 | 22.5 / 375 × 100 | 6% |
| Dividend cover | Net Profit after Tax / Dividend Paid | 150 / 90 | 1.67 times |
b) Analysis of Financial Performance and Position
The first thing to notice about Kack’s results is that the ROCE has increased by 4.2 percentage points, from 28.1% to 32.3%. On the face of it, this is impressive. However, we have to take into account the fact that the capital employed has been reduced by the plant disposal and the net profit has been increased by the profit on disposal. So, the ROCE has been inflated by this transaction, and we should look at what the ROCE would have been without the disposal. Taking out the disposal gives us the following ratios:
| Ratio Description | Calculation | Result |
|---|---|---|
| ROCE without disposal | 180 / (680 + 80) × 100 | 23.7% |
| Net asset turnover without disposal | 4,000 / 760 | 5.3 times |
| Net profit margin without disposal | 160 / 4,000 × 100 | 4% |
Comparing these ratios to those for the period ended 31 March 2014, we can see that ROCE has fallen. This fall has been occasioned by the fall in the net profit margin. The asset turnover has improved on the previous year after adding back the disposal.
The gross profit percentage is 3.2% down on the previous year. This is probably due to the rebates offered to wholesale customers, which will have increased sales at the expense of profitability. The replacement of some production lines by bought-in products will probably also have reduced profit margins. Sales may have been increased by the advertising campaign, but this has been an additional expense charged against the net profit.
Kack’s liquidity has also declined over the current year. The current ratio has gone down from 1.6 to 1.3. However, there has been a sharp decline in the inventory holding period, probably due to holding less raw material for production. It could be that the finished goods can be delivered directly to the wholesalers from the supplier, reducing the current ratio. The receivables collection period has remained fairly constant, but the payables payment period has decreased by 10 days. This fall in the payables period may indicate that the finished goods supplier demands prompt payment. The liquidity situation would have been much worse without the GHS 120 million from the plant sale.
The dividend yield has increased from 3.75% to 6%, which looks attractive to potential investors. However, the dividend amount is the same as last year, meaning that the dividend per share is unchanged. Therefore, the increase in dividend yield can only have come from a fall in the share price, which reflects the market’s dissatisfaction with Kack’s performance. Furthermore, the dividend cover has declined, indicating that the same dividend has been paid on less profit.
Conclusion: Kack’s overall performance and position have declined compared to the previous year, and the plant disposal has helped mask the underlying issues.
- Topic: Financial Statement Analysis
- Series: NOV 2015
- Uploader: Dotse