ACCUMMI COURSEWORK 1 ISSUED 11 OCTOBER 2021 FOR SUBMISSION BY 12 NOON ON 22 OCTOBER 2021 ANSWER ALL THE QUESTIONS USE YOUR STUDENT NUMBER ONLY - DO NOT WRITE YOUR NAME ON ANY ANSWER SHEET. SHOW ALL WORKINGS WHERE NECESSARY Question 1 Eve Emerson commenced trading as a retailer of hill walking kit on 1 April 2020. Eve's business has traded profitably, and she has given you the following details of her business activities for the 12 months ended 31 March 2021. Sales Inventory at 31 March 2021 Distribution costs Purchases Trade payables Accruals Receivables Cash at bank Administrative expenses Insurance 143,000 42,000 16,000 97,000 2,200 3,000 2,870 419 1,400 900 Notes 1) Inventory at 1 April 2020 was 23,230. 2) Non-current assets (at cost on 1 April 2020) were 120,000. 3) Non-current assets at cost comprised buildings (80,000), fixtures and fittings (20,000) and a car (20,000). Annual depreciation is to be provided at 10% on a straight line basis on fixtures and fittings, and at 25% on a reducing balance basis on cars. 4) Insurance was paid for a 12 month period commencing 1 October 2020. 5) Eve withdrew 200 from the business each month for her own purposes. Eve lives alone and has no other source of income. Required Prepare the Statement of Profit and Loss and the Statement of Financial Position for the year ended 31 March 2021. You will have to use balancing figures where necessary. Calculate the Gross Profit Margin and the Quick Ratio, and briefly assess the performance of Eve's business in its first year. (18 marks) Question 2 You are given the following details in connection with the results for Bleddyn ple, and you are also given a selection of industry average data. Note that Mnventory Turnover" is given in days. "Shares in issue refers to ordinary 1 shares. "Gearing" is calculated as; Debt/(Debt + Equity) Year ended 30 June 2017 2018 2019 2020 Industry 000 000 E000 E000 Average Sales 770 790 750 700 Not available Gross Profit 400 405 300 275 Not available Dividend per share 3.4p 3.Op 3.0p 2.9p Not applicable Shares in issue (000) 350 350 350 350 Not applicable The following ratios have been calculated ROCE 38.5% 38.7% 32.5% 30.9% 34.1% Asset Turnover 1.25 1.25 1.05 0.78 1.47 Quick ratio 1.89 1.88 1.78 1.17 1.29 Inventory Turnover 3.4 3.5 3.7 3.97 Receivables Days 12.1 12.7 125 19.8 13.2 Payables Days 22.8 22.9 25.2 37.5 24.7 Gearing 30% 30% 30% 25% 35% PE ratio 6.1 5.1 8.1 3.1 9.1 Interest Cover 1.7 1.8 14 1.2 1.6 REQUIRED 3.6 a) Calculate any additional ratios you consider to be appropriate, and analyse Bleddyn ple's performance for the period above. State any necessary assumptions, and show your workings. Suggest possible reasons for any of the trends and changes which you identify, and comment on the possible future outcomes, assuming that Directors' policies stay unchanged into the future. (18 marks) b) Following a major increase in share value, Bleddyn ple's PE ratio at 30 June 2021 was 20.4. The company's performance has not improved, but it is noted that Bleddyn plc holds some very valuable land. What type of investors might have pushed the share price up, and why? (4 marks) =
