ACCUMM1 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) You are given the following details in connection with the results for Bleddyn plc, and you are also given a selection of industry average data. Note that "Inventory 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 000 2018 000 2019 000 2020 000 Industry Average Sales Gross Profit 770 400 790 405 750 300 700 275 Not available Not available Dividend per share Shares in issue (000) 3.4p 350 3.0p 350 3.Op 350 2.9p 350 Not applicable Not applicable The following ratios have been calculated ROCE 38.5% 38.7% Asset Turnover 1.25 1.25 Quick ratio 1.89 1.88 Inventory Turnover 3.6 3.4 Receivables Days 12.1 12.7 Payables Days 22.8 22.9 Gearing 30% 30% PE ratio 6.1 5.1 Interest Cover 1.7 1.8 32.5% 1.05 1.78 3.5 12.5 30.9% 0.78 1.17 3.7 19.8 37.5 25% 3.1 1.2 34.1% 1.47 1.29 3.97 13.2 24.7 35% 9.1 1.6 25.2 30% 8.1 1.4 REQUIRED 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) ACCUMM1 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) You are given the following details in connection with the results for Bleddyn plc, and you are also given a selection of industry average data. Note that "Inventory 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 000 2018 000 2019 000 2020 000 Industry Average Sales Gross Profit 770 400 790 405 750 300 700 275 Not available Not available Dividend per share Shares in issue (000) 3.4p 350 3.0p 350 3.Op 350 2.9p 350 Not applicable Not applicable The following ratios have been calculated ROCE 38.5% 38.7% Asset Turnover 1.25 1.25 Quick ratio 1.89 1.88 Inventory Turnover 3.6 3.4 Receivables Days 12.1 12.7 Payables Days 22.8 22.9 Gearing 30% 30% PE ratio 6.1 5.1 Interest Cover 1.7 1.8 32.5% 1.05 1.78 3.5 12.5 30.9% 0.78 1.17 3.7 19.8 37.5 25% 3.1 1.2 34.1% 1.47 1.29 3.97 13.2 24.7 35% 9.1 1.6 25.2 30% 8.1 1.4 REQUIRED 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)