RATIO Questions
RATIO Questions
RATIO Questions
Bengal Co is a public company. Its most recent financial statements are shown below:
20X1 20X0
$’000 $’000
20X1 20X0
$'000 $’000 $'000 $'000
Non-current assets
Property, plant and equipment 9,500 5,400
Intangibles 6,200 nil
15,700 5,400
Current assets
Inventories 3,600 1,800
Trade receivables 2,400 1,400
Cash and cash equivalents nil 4,000
Non-current assets held for sale 2,000 8,000 nil 7,200
Total assets 23,700 12,600
Equity and liabilities
Equity
Equity shares of $1 each 5,000 5,000
Retained earnings 4,500 2,250
9,500 7,250
Non-current liabilities
5% loan notes 2,000 2,000
8% loan notes 7,000 nil
Current liabilities
Bank overdraft 200 nil
Trade payables 2,800 2,150
Current tax payable 2,200 5,200 1,200 3,350
Total equity and liabilities 23,700 12,600
Additional information:
(i) Bengal Co acquired the assets of another business during the year. It has identified that some of
the assets are surplus to requirements and have been classified as 'held for sale' at 31 March
20X1. It expects that it will take some time for the remaining assets to be fully integrated into its
current business. There were no disposals of assets.
(ii) Depreciation of property, plant and equipment for the year ended 31 March 20X1 was
$640,000.A disappointed shareholder has observed that although revenue during the year has
increased by 48% (8,250 / 17,250 × 100), profit for the year has only increased by 20% (500 /
2,500 × 100).
Required
(a) Comment on the performance (including addressing the shareholder's observation) and
financial position of Bengal Co for the year ended 31 March 20X1. Up to five marks are
available for the calculation of appropriate ratios.
(b) Explain the limitations of ratio analysis.
B) Woodbank Co
Shown below are the financial statements of Woodbank Co for its most recent two years:
STATEMENTS OF PROFIT OR LOSS FOR THE YEAR ENDED 31 MARCH:
20X4 20X3
$’000 $’000
20X4 20X3
$’000 $'000
ASSETS
Non-current assets
Property, plant and equipment 118,000 85,000
Goodwill 30,000 –
148,000 85,000
Current assets
Inventories 15,500 12,000
Trade receivables 11,000 8,000
Cash and cash equivalents 500 5,000
______________________
27,000 25,000
Total assets 175,000 110,000
EQUITY AND LIABILITIES
Equity
Equity shares of $1 each 80,000 80,000
Retained earnings 15,000 10,000
95,000 90,000
Non-current liabilities
10% loan notes 55,000 5,000
Current liabilities
Trade payables 21,000 13,000
Current tax payable 4,000 2,000
25,000 15,000
$'000
Revenue 30,000
Cost of sales (21,000)
______
Gross profiT 9,000
Distribution costs (2,000)
Administrative expenses (2,000)
(iii) The following six ratios have been correctly calculated for Woodbank Co for the years ended
31 March:
20X3
Return on capital employed (ROCE) 10.5%
(profit before interest and tax/year-end
total assets less current liabilities)
Net asset (equal to capital employed) turnover 1.16 times
Gross profit margin 22%
Profit before interest and tax margin 9.1%
Current ratio 1.7:1
Gearing (debt/(debt + equity)) 5.3%
Required
(a) Calculate the ratios in (iii) above for Woodbank Co for the year ended 31 March 20X4.
(b) Calculate for the year ended 31 March 20X4 equivalent ratios to the first FOUR only for
Woodbank Co excluding the effects of the purchase of Shaw Co.
(c) Assess the comparative financial performance and position of Woodbank Co for the year
ended 31 March 20X4. Your answer should refer to the effects of the purchase of Shaw Co.
C) Greenwood
Greenwood Co is a public listed company. On 31 March 20X7 Greenwood Co sold its 80%-owned
subsidiary –Deadwood Co – for $6 million. The directors have been advised that the disposal
qualifies as a discontinued operation and it has been accounted for accordingly. The disposal
proceeds were not collected until after the year end. Greenwood Co did not own any other
subsidiaries.
Extracts from Greenwood Co's financial statements are set out below.
20X7 20X6
$'000 $'000
Revenue 27,500 21,200
Cost of sales (19,500) (15,000)
______________________
Gross profit 8,000 6,200
Operating expenses (2,900) (2,450)
______________________
5,100 3,750
Non-controlling interest
1,250
14,000
Non-current liabilities
5% loan notes 8,000 5,000
Current liabilities
Bank overdraft 1,150 nil
Trade payables 2,400 2,800
Current tax payable 950 4,500 1,000 3,800
Total equity and liabilities 27,000 22,800
Notes
1 The carrying amount of the assets of Deadwood Co at 31 March 20X6 was $6.25 million which
included $3 million of property, plant and equipment.
2 All of the cash and cash equivalents within the group at 31 March 20X6 were attributable to
Deadwood Co.
3 Deadwood Co is a wholesale business whereas Greenwood Co is a retail business. Deadwood
Co sold a large amount of goods to its parent at a price that was set by Greenwood Co.
4 Greenwood Co measures non-controlling interest at share of net assets.
Required
Analyse the financial performance and position of Greenwood Co for the two years ended
31 March 20X7. (Ignore working capital and gearing.)
Note. Your analysis should be supported by appropriate ratios (up to 6 marks available) and
refer to the effects of the disposal.