Industry average figures are available for 2019 as follows: Ratio Industry Average Earnings per Share (pence) Dividend Cover (times) Average Collection Period (days) Inventory Turnover (times) Current times) Quick (times) Profit margin (%) Return on total assets (%) Debt (%) Times interest earned 38.2 8.8 75 7.2 0.9 0.8 8.0 22.2 35.2 28.1 Required: 1. Based on the extracts from the 2020 published accounts, update the tabulation of ratios for Tweed Limited for both 2019 and 2020. Show all workings. (10 marks) 2. Identify any factors in performance of Tweed Limited over the past four-year period which might prove to be of concern, especially in relation to 2019 industry averages. (10 marks - maximum word count 800 words) 3. Compare the performance of Tweed Limited with Tartan's key ratios and comment on whether it is likely that the acquisition of Tweed Limited will strengthen or weaken these ratios. (5 marks - maximum word count 300 words) Total 25 marks 2020 '000 2019 '000 Profit and Loss Account Revenue Cost of Sales Gross Profit Other Expenses Profit before Interest Interest Profit before Taxation Taxation Profit after Taxation Dividend paid and proposed Retained Profits for the year 2,550 1.520 1,030 _724 306 42 264 42 222 60 162 2,330 1.040 1,290 722 568 66 502 94 408 132 276 2020 $'000 2020 '000 2019 '000 Balance Sheet Non-current Assets 3,024 2,028 Current Assets Inventories Debtors Cash at Bank 550 400 50 1,000 1,240 320 250 374 944 1.030 - (86) Current Liabilities Net Current Liabilities (240) Total Assets less Current Liabilities 2,784 1,942 Long-term Liabilities 820 1.964 280 1.662 Capital & Reserves Ordinary Share Capital Share Premium Retained Profits 702 200 1.062 1.964 662 100 200 1.662 Share Capital comprises 1 Ordinary Shares. During 2020, 40,000 Ordinary Shares were issued at a price of 3.50 per share. Case Study 2 Tartan Group Construction Limited (Tartan") is considering the possibility of bidding for a large family-owned house-building company, Tweed Limited. Tartan's business interests cover a wide range of construction activities, concentrating mainly on large motorway and bridge projects with a large presence in the low-cost end of the housing market. As part of Tartan's recent strategic policy review, its Board of Directors has decided that it believes that it could generate more shareholder value if future growth was propelled by acquisitions rather than the present reliance on the organic growth of the existing business. In particular, Tweed Limited appears an ideal complementary acquisition for Tartan, as it concentrates on the provision of high-quality executive housing. The financial director of Tartan, has been assembling a record of the recent performance of Tweed Limited through the compilation of a series of ratios extracted from its published accounts for 2018 and 2017, as follows: Ratio Review Earnings per Share (pence) Dividend Cover (times) Average Collection Period (days) Inventory Turnover (times) Current times) Quick (times) Profit margin (%) Return on total assets (%) Debt (%) Times interest earned 2018 65.2 15.5 88 6.8 1.2 0.8 20.1 10.1 31.1 33.6 2017 48.2 6.7 65 5.4 1.1 0.5 16.2 15.2 23.4 25.7 Tartan's own key ratios for 2020 are: Return on Total assets Profit Margin 28% 10% 15% Debt The year-end 2020 accounts of Tweed Limited have just become available, providing the opportunity to update the ratio review to include both 2019 and 2020 accounts. The following information has been extracted from the published financial accounts of Tweed Limited at its 2020 year-end