Salt Ltd is a Government Business Entity that would like to acquire (100% of) a viable private company. It has obtained the following draft financial statements for two companies, Light Ltd and Favour Ltd Ltd. They operate in the same industry and their managements have indicated that they would be receptive to a takeover.
Statement of profit or loss account for the year ended 31 December 2017
Light Ltd | Favour Ltd Ltd | |
GH¢’000 | GH¢’000 | |
Revenue | 12,000 | 20,500 |
Cost of sales | (10,500) | (18,000) |
Gross profit | 1,500 | 2,500 |
Operating expenses | (240) | (500) |
Finance costs | (210) | (600) |
Profit before tax | 1,050 | 1,400 |
Income tax expense | (150) | (400) |
Profit for the year | 900 | 1,000 |
Note: Dividends paid during the year | 250 | 700 |
Statements of financial position as at 31 December 2017 | ||
Assets | Light Ltd | Favour Ltd Ltd |
Non-current assets | GH¢’000 | GH¢’000 |
Freehold factory (note(i) | 4,400 | - |
Owned plant (note (ii)) | 5,000 | 2,200 |
Leased plant (note (ii)) | - | 5,300 |
9,400 | 7,500 | |
Current assets | ||
Inventory | 2,000 | 3,600 |
Trade receivables | 2,400 | 3,700 |
Bank | 600 | - |
5,000 | 7,300 | |
Total assets | 14,400 | 14,800 |
Equity and liabilities | ||
Equity shares of GH¢1 each | 2,000 | 2,000 |
Property revaluation reserve | 900 | - |
Retained earnings | 2,600 | 800 |
5,500 | 2,800 | |
Non-current liabilities | ||
Finance lease obligations (note (iii)) | - | 3,200 |
7% loan notes | 3,000 | - |
10% loan notes | - | 3,000 |
Deferred tax | 600 | 100 |
Government grants | 1,200 | - |
4,800 | 6,300 | |
Current liabilities | ||
Bank overdraft | - | 1,200 |
Trade payables | 3,100 | 3,800 |
Government grants | 400 | - |
Finance lease obligations (note (iii)) | - | 500 |
Taxation | 600 | 200 |
4,100 | 5,700 | |
Total equity and liabilities | 14,400 | 14,800 |
Notes:
i) Both companies operate from same premises.
ii) Additional details of the two companies’ plant are:
Light Ltd Favour Ltd Ltd
GH¢’000 GH¢’000
Owned plant – Historical cost 8,000 10,000
Leased plant – original fair value - 7,500
There were no disposals of plant during the year by either company.
iii) The interest rate implicit within Favour Ltd Ltd’s finance leases is 7.5% per annum. For the purpose of calculating ROCE and gearing, all finance lease obligations are treated as long-term interest bearing borrowings.
Required:
Assess the relative financial performance and financial position of Light Ltd and Favour Ltd Ltd for the year ended 31 December 2017 to inform the directors of Salt Ltd in their acquisition decision. Your analysis should focus on profitability, liquidity and gearing.
Assessment of the relative performance and financial position of Light Ltd and Favour Ltd Favour Ltd for the year ended 31 December 2017.
Appendix
Ratio | Formula | Light Ltd | Favour Ltd Ltd |
Gross profit margin | Gross Profit/Revenue | 1,500/12,000*100 =12.5% | 2,500/20,500*100 =12.2% |
Operating profit margin | Profit before interest and tax/Revenue | 1,260/12,000*100 =10.5% | 2,000/20,500*100 =9.8% |
ROCE | Profit before interest and tax/(Shareholders’ fund + Long-term interest bearing borrowings) | 1,260/(5,500+3,000)*100 =14.8% | 2,000/(2,800+6,700)*100 =21% |
Return on equity | Profit after Tax/Shareholders’ funds | 900/5,500*100 =16.4% | 1,000/2,800*100 =35.7% |
Pre-tax Return on equity | Profit before Tax/Shareholders’ funds | 1,050/5,500*100 =19.1% | 1,400/2,800*100 =50% |
Net assets turnover | Revenue /(Total Assets – Total liabilities) | 12,000/5,500 =2.2 times | 20,500/2,800 =7.3 times |
Current ratio | Current assets/Current liabilities | 5,000/4,100 =1.2:1 | 7,300/5,700 =1.3:1 |
Acid test ratio | (Currents assets-Inventory)/Current liabilities | (5,000-2,000)/4,100 =0.73:1 | (7,300-3,600)/5,700 =0.65:1 |
Interest cover | Profit before interest and tax/Interest | 1,260/210 =6 times | 2,000/600 =3.3 times |
Closing inventory holding period | Closing inventory x 365 days Cost of sales | 2,000 x 365 10,500 =70 days | 3,600 x 365 18,000 =73 days |
Trade receivables collection period | Trade receivables x 365 days Revenue | 2,400 x 365 12,000 =73 days | 3,700 x 365 20,500 =66 days |
Trade payables payment period | Trade payables x 365 days Cost of sales | 3,100 x 365 10,500 =108 days | 3,800 x 365 18,000 =77 days |
Gearing ratio | Interest bearing debt/(Interest bearing debt + Shareholders’ fund) *100 | 3,000/(3,000+5,500)*100 =35.3% | 6,700/(6,700+2,800)*100 =70.5% |
Dividend cover | Profit after tax/Dividends | 900/250 =3.6 times | 1,000/700 =1.4 times |
Introduction
This report is based on the draft financial statements supplied and the ratios shown in (a) above. Although covering many aspects of performance and financial position, the report has been approached from the point of view of a prospective acquisition of the entire equity of one of the two companies.
Profitability
The ROCE of 20·9% of Favour Ltd is far superior to the 14·8% return achieved by Light Ltd. ROCE is traditionally seen as a measure of management’s overall efficiency in the use of the finance/assets at its disposal. More detailed analysis reveals that Favour Ltd’s superior performance is due to its efficiency in the use of its net assets; it achieved a net asset turnover of 2·3 times compared to only 1·2 times for Light Ltd. Put another way, Favour Ltd makes sales of GH¢2·30 per GH¢1 invested in net assets compared to sales of only GH¢1·20 per GH¢1 invested for Light Ltd.
The other element contributing to the ROCE is profit margins. In this area Favour Ltd’s overall performance is slightly inferior to that of Light Ltd, gross profit margins are almost identical, but Light Ltd’s operating profit margin is 10·5% compared to Favour Ltd’s 9·8%. In this situation, where one company’s ROCE is superior to another’s it is useful to look behind the figures and consider possible reasons for the superiority other than the obvious one of greater efficiency on Favour Ltd’s part. A major component of the ROCE is normally the carrying amount of the non-current assets. Consideration of these in this case reveals some interesting issues. Favour Ltd does not own its premises whereas Light Ltd does. Such a situation would not necessarily give a ROCE advantage to either company as the increase in capital employed of a company owning its factory would be compensated by a higher return due to not having a rental expense (and vice versa). If Favour Ltd’s rental cost, as a percentage of the value of the related factory, was less than its overall ROCE, then it would be contributing to its higher ROCE.
There is insufficient information to determine this. Another relevant point may be that Favour Ltd’s owned plant is nearing the end of its useful life (carrying amount is only 22% of its cost) and the company seems to be replacing owned plant with leased plant. Again this does not necessarily give Favour Ltd an advantage, but the finance cost of the leased assets at only 7·5% is much lower than the overall ROCE (of either company) and therefore this does help to improve Favour Ltd’s ROCE. The other important issue within the composition of the ROCE is the valuation basis of the companies’ non-current assets. From the question, it appears that Light Ltd’s factory is at current value (there is a property revaluation reserve) and note (ii) of the question indicates the use of historical cost for plant. The use of current value for the factory (as opposed to historical cost) will be adversely impacting on Light Ltd’s ROCE. Favour Ltd does not suffer this deterioration as it does not own its factory.
The ROCE measures the overall efficiency of management; however, as Salt is considering buying the equity of one of the two companies, it would be useful to consider the return on equity (ROE) – as this is what Salt is buying. The ratios calculated are based on pre-tax profits; this takes into account finance costs, but does not cause taxation issues to distort the comparison. Clearly Favour Ltd’s ROE at 50% is far superior to Light Ltd’s 19·1%. Again the issue of the revaluation of Light Ltd’s factory is making this ratio appear comparatively worse (than it would be if there had not been a revaluation). In these circumstances it would be more meaningful if the ROE was calculated based on the asking price of each company (which has not been disclosed) as this would effectively be the carrying amount of the relevant equity for Salt Ltd.
Gearing
From the gearing ratio it can be seen that 71% of Favour Ltd’sassets are financed by borrowings (39% is attributable to Favour Ltd’s policy of leasing its plant). This is very high in absolute terms and double Light Ltd’s level of gearing. The effect of gearing means that all of the profit after finance costs is attributable to the equity even though (in Favour Ltd’s case) the equity represents only 29% of the financing of the net assets. Whilst this may seem advantageous to the equity shareholders of Favour Ltd, it does not come without risk. The interest cover of Favour Ltd is only 3·3 times whereas that of Light Ltd is 6 times. Favour Ltd’s low interest cover is a direct consequence of its high gearing and it makes profits vulnerable to relatively small changes in operating activity. For example, small reductions in sales, profit margins or small increases in operating expenses could result in losses and mean that interest charges would not be covered. Another observation is that Light Ltd has been able to take advantage of the receipt of government grants; Favour Ltd has not. This may be due to Light Ltd purchasing its plant (which may then be eligible for grants) whereas Favour Ltd leases its plant. It may be that the lessor has received any grants available on the purchase of the plant and passed some of this benefit on to Favour Ltd via lower lease finance costs (at 7·5% per annum, this is considerably lower than Favour Ltd has to pay on its 10% loan notes).
Liquidity
Both companies have relatively low liquid ratios of 1·2 and 1·3 for Light Ltd and Favour Ltd respectively, although at least Light Ltd has GH¢600,000 in the bank whereas Favour Ltd has a GH¢1·2 million overdraft. In this respect Favour Ltd’s policy of high dividend payouts (leading to a low dividend cover and low retained earnings) is very questionable. Looking in more depth, both companies have similar inventory days; Favour Ltd collects its receivables one week earlier than Light Ltd (perhaps its credit control procedures are more active due to its large overdraft), and of notable difference is that Light Ltd receives (or takes) a lot longer credit period from its suppliers (108 days compared to 77 days). This may be a reflection of Light Ltd being able to negotiate better credit terms because it has a higher credit rating.
Summary
Although both companies may operate in a similar industry and have similar profits after tax, they would represent very different purchases. Favour Ltd’s sales revenues are over 70% more than those of Light Ltd, it is financed by high levels of debt, it rents rather than owns property and it chooses to lease rather than buy its replacement plant. Also its remaining owned plant is nearing the end of its life. Its replacement will either require a cash injection if it is to be purchased (Favour Ltd’s overdraft of GH¢1·2 million already requires serious attention) or create even higher levels of gearing if it continues its policy of leasing. In short although Favour Ltd’soverall return seems more attractive than that of Light Ltd, it would represent a much more risky investment. Ultimately the investment decision may be determined by Salt’s attitude to risk, possible synergies with its existing business activities, and not least, by the asking price for each investment (which has not been disclosed to us).
(25 MARKS) QUESTION 3 Sime Garby Berhad is a publicly listed company. The following is the Statement of Profit and Loss and the Statements of Financial Position for the company for the year 2017: Statement of Profit or Loss for the year ended 31 December 2017 2017 2016 RM000 BM'000 25.500 17.250 Revenue Cost of sales (14,800) (10.350) Gross profit 10,700 6.900 Distribution costs (2,700) (1.850) Administrative expenses (2,100) (1.450) Finance costs (650) (100) Profit before tax 5,250 3,500 Income...
QUESTION 3 (25 MARKS) Sejengkal Berhad is a publicly listed company. The following are the Statement of Profit or Loss and the Statement of Financial Position for the company: Statement of Profit or Loss for the year ended 31 December 2018 RM'000 25,500 (14,800 10,700 Revenue Cost of sales Gross profit 2017 RM'000 17,250 (10,350) 6,900 Distribution costs Administrative expenses Finance costs Profit before tax Income tax expense Profit for the year (2,700) (2,100) (650) 5,250 (2,250) 3.000 (1,850) (1,450)...
Cumi Ltd. and Ciki Ltd. are both computer component manufacturers in Longford. You are provided with the following summarized information in relation to both companies. Income statements for year ended 31 March 2018 Cumi Lid. Cik Lid. AED'000 AED'000 Revenue 1.500 2000 Cost of sales 1.000 1.600 Gross profit 500 Operating expenses 150 200 Operating profit 350 200 Interest on debentures 100 50 Profit before tak 250 Tax SO Profit after tax 200 Dividends 70 Retained profits 350 30 120...
Question 2 Two companies Samsong Sdn Bhd and Huaway Sdn Bhd trade in the same market. Their financial statements for the year ended 30 September 2019 are summarised below: Statements of Comprehensive Income for the year ended 30 September 2019: Samsong Huaway RM'000 RM'000 Revenue 284 405 (155) (251) 129 154 Cost of sales Gross profit Administrative Distribution Depreciation Interest on loan (24) (35) (37) (53) (12) (9) Nil (5) Profit before tax 61 47 Income tax expense (10) (4)...
Question 2 Aisha was tasked to research the recent financial performance for Old Chang Kee Ltd (Old Chang Kee"). Below is an extract of its financial statements: Consolidated Income Statement For the financial year ended 31 March 2019 $'000 2018 $'000 Revenue Cost of sales Gross profit 89,789 (32.251) 57,538 85,487 (33,249) 52,238 Other income 1,209 1,729 Selling and distribution expenses Administrative expenses Finance costs Other expenses Share of results of joint venture Profit before tax (38,039) (12,892) (329) (1,774)...
Question 4 Daniel, an investor is considering purchasing shares in either Garth Ltd & James Ltd. Both companies are in the same line of business and their accounts are summarized below: Statement of financial Position as at December 1st 2016 Assets Garth Ltd James Ltd. Non Current Assets S'000 S'000 S'000 S'000 2 140 840 At Cost Accumulated Depreciation (226) 1 852 614 (280) Current Assets 276 334 Inventory Receivables 138 196 Bank and Cash 192 606 18 548 1...
On 1 July 2015, Fluffy Ltd acquired all the issued shares of
Glider Ltd. Fluffy Ltd paid $30 000 in cash and 20 000 shares in
Fluffy Ltd valued at $3 per share. At this date, the equity of
Glider Ltd consisted of $66 000 share capital and $6000 retained
earnings.
At 1 July 2015, all the identifiable assets and liabilities of
Glider Ltd were recorded at amounts equal to their fair values
except for:
Additional information
(a) Fluffy Ltd...
The draft statement of profit or loss of Event Light Ltd for the year ended 30 June 2020 showed a profit before tax of $25 240, included the following items of income and expense: Government grant (exempt from tax) Proceeds on sale of plant Carrying amount of plant sold Impairment of goodwill Bad debts expense Depreciation expense – plant Insurance expense Long-service leave expense 6 000 23 000 20 000 11 100 8 100 14 000 12 900 14 500...
Analysis Case 15-4 Lease concepts; Walmart QL015–1 though 1015-4 Real World Financials Walmart Inc. is the world's largest retailer. A large portion of the premises that the company occupies are leased. Its financial statements and disclosure notes revealed the following information: Balance Sheet ($ in millions) 2017 2016 $11,637 $11,096 (5,169) (4,751) Assets Property: Property under finance lease obligations Less: Accumulated amortization Liabilities Current liabilities: Finance lease obligations due within one year Long-term debt: Long-term finance lease obligations 565 551...
ABC Ltd acquired 70% of the shares in XYZ Ltd on 31st December 2015 for a cost of £4,000,000. The balance sheets of the two companies at 31 December 2016, and the profit and loss accounts for the year ended 31 December 2016 are as follows: Additional information: – A goodwill impairment review has been carried out and it has been determined that goodwill has been impaired by £300,000 as at 31st December 2016 – On 31st December 2016, ABC...