Incomplete question
You are presented with the following financial report extracts for Hamden Ltd: B Click the icon to view the income statement.) (Click the icon to view the statement of financial performance.) You should note that there are also other current assets, non-current assets, and current liabilities that are not specifically listed in the extracts shown above. Requirements Income statement Requirement (a) For the income statement section, prepare a 'vertical analysis' for the three years (20152017). Complete the table below. (Round the 'per cent' values to the nearest whole number. Calculate each line separately.) 2017 2016 2015 2014 $ $ $ $ Hamden Ltd Vertical analysis 31 December Income statement Sales 380,000 250,000 2017 2016 2015 Cost of sales 310,000 140,000 10,000 173,000 16,000 113.000 Amount Per cent Amount Per cent Amount Per cent Interest 5.000 Sales % % % Taxation 20% 58.000 Cost of sales 63,000 52,000 % Other expenses % % % % % % % % Print Done Gross profit Other expenses Operating profit Interest % % % % % % Profit before tax % % % Taxation 20% % % % Profit for the year % % % Requirement (b) For the statement of financial position extract prepare a 'trend percentage' analysis for the three vears (20152017) the base vear beina 2015 Enter any number in the edit fields and then continue to the next question Statement of financial performance You are presented with the following financial report extracts for Hamden Ltd: (Click the icon to view the income statement.) 5 (Click the icon to view the statement of financial performance.) You should note that there are also other current assets, non-current assets, and current liabilities that are not specifically listed in the extracts shown above. Requirements Complete the table below. (Round to the nearest whole number, as needed. Calculate each line separately.) 2017 2016 2015 2014 $ $ Hamden Ltd Statement of financial performance Trend percentage analysis Current assets 31 December 20,000 20,000 2017 19,000 33,000 2016 Inventory Accounts receivable Total current assets 2015 15,000 39,000 110,000 63,000 27,000 Per cent Per cent Per cent 250,000 115,000 Current assets % % 100 % Non-current assets Property, plant and equipment Total non-current assets 140,000 Inventory Accounts receivable 118,000 112,000 130,000 % % 100 % 100 % 210,000 460,000 200,000 310,000 % % Total assets 245,000 170,000 % % 100 % Current liabilities Accounts payable Total current liabilities 28,000 19,000 Total current assets Non-current assets Property, plant and equipment Total non-current assets Total assets Current liabilities 11,000 13,000 44,000 % % 71,000 100 % 100 % % % Total non-current liabilities 247,000 53,000 128,000 181,000 129,000 59,000 103,000 Total liabilities 318,000 % % 100 % Total shareholders' funds 142.000 142,000 Accounts payable Total current liabilities Total non-current liabilities % % 100 % % % 100 % Print Done Enter any number in the edit fields and then continue to the next question. Statement of financial performance You are presented with the following financial report extracts for Hamden Ltd: (Click the icon to view the income statement.) 5 (Click the icon to view the statement of financial performance.) You should note that there are also other current assets, non-current assets, and current liabilities that are not specifically listed in the extracts shown above. Requirements Complete the table below. (Round to the nearest whole number, as needed. Calculate each line separately.) 2017 2016 2015 2014 $ $ Hamden Ltd Statement of financial performance Trend percentage analysis Current assets 31 December 20,000 20,000 2017 19,000 33,000 2016 Inventory Accounts receivable Total current assets 2015 15,000 39,000 110,000 63,000 27,000 Per cent Per cent Per cent 250,000 115,000 Current assets % % 100 % Non-current assets Property, plant and equipment Total non-current assets 140,000 Inventory Accounts receivable 118,000 112,000 130,000 % % 100 % 100 % 210,000 460,000 200,000 310,000 % % Total assets 245,000 170,000 % % 100 % Current liabilities Accounts payable Total current liabilities 28,000 19,000 Total current assets Non-current assets Property, plant and equipment Total non-current assets Total assets Current liabilities 11,000 13,000 44,000 % % 71,000 100 % 100 % % % Total non-current liabilities 247,000 53,000 128,000 181,000 129,000 59,000 103,000 Total liabilities 318,000 % % 100 % Total shareholders' funds 142.000 142,000 Accounts payable Total current liabilities Total non-current liabilities % % 100 % % % 100 % Print Done Enter any number in the edit fields and then continue to the next question. Statement of financial performance You are presented with the following financial report extracts for Hamden Ltd: (Click the icon to view the income statement.) (Click the icon to view the statement of financial performance.) You should note that there are also other current assets, non-current assets, and current liabilities that are not specifically listed in the extracts shown above. Requirements 2017 2016 2015 2014 $ $ $ $ Requirement (c) Prepare as many ratios as possible from the available information to cover profitability, liquidity, efficiency and gearing. Find the following profitability ratios for the years 2015, 2016 and 2017. (Round to two decimal places, as needed.) 2017 2016 2015 Return on equity % % 20,000 15,000 39,000 % % 20,000 63,000 250,000 Return on capital employed Operating profit margin Gross profit margin 27,000 19,000 33,000 115,000 % Statement of financial performance Current assets Inventory Accounts receivable Total current assets Non-current assets Property, plant and equipment Total non-current assets Total assets % % 110,000 % % % 140,000 118,000 Find the following liquidity ratios for the years 2015, 2016 and 2017. (Round to two decimal places, as needed.) 210,000 112,000 130,000 245,000 2017 2016 200,000 310,000 2015 460,000 170,000 Current ratio times times times Current liabilities Acid test ratio times times times 11,000 Accounts payable Total current liabilities Find the following efficiency ratios for the years 2015, 2016 and 2017. (Round to two decimal places, as needed.) 28,000 71,000 247,000 19,000 53,000 128,000 181,000 13,000 44,000 59,000 103,000 2017 2016 2015 Total non-current liabilities days Total liabilities 318,000 Average inventories turnover period Debtors average settlement period Sales revenue to capital employed days days days days days Total shareholders' funds 142,000 129,000 142,000 times times Print Done Enter any number in the edit fields and then continue to the next question. Statement of financial performance You are presented with the following financial report extracts for Hamden Ltd: (Click the icon to view the income statement.) 5 (Click the icon to view the statement of financial performance.) You should note that there are also other current assets, non-current assets, and current liabilities that are not specifically listed in the extracts shown above. Requirements 2017 2016 2015 2014 Which of the following are potential strengths of the business's management? (Select all that apply.) $ $ $ Statement of financial performance Current assets 20,000 19,000 20,000 A. High operating profit B. High return on equity and high return on capital employed C. Decreasing average inventories turnover period D. High gross profit E. Increased gearing ratio Inventory Accounts receivable Total current assets 15,000 39,000 63,000 33,000 27,000 250,000 110,000 115,000 Non-current assets Which of the following are potential weaknesses of the business's management? (Select all that apply.) Property, plant and equipment Total non-current assets 140,000 210,000 460,000 118,000 200,000 310,000 112,000 130,000 245,000 Total assets 170,000 Current liabilities A. Decreasing average inventories turnover period B. Low sales revenue to capital employed C. Declining interest cover OD. Increasing gearing ratio E. High return on equity and high return on capital employed 11,000 Accounts payable Total current liabilities Total non-current liabilities 28,000 71,000 247,000 318,000 19,000 53,000 128,000 181,000 13,000 44,000 59,000 103,000 142,000 Total liabilities Requirement (e) Identify additional information you would require to improve your analysis of this company over the period specified. Which of the following additional information would you require to improve your analysis of this company over the period specified? (Select all that apply.) Total shareholders' funds 142.000 129,000 A. Completed financial statements from 2014 E-nar NA-17 Print Done Enter any number in the edit fields and then continue to the next question. Statement of financial performance x - You are presented with the following financial report extracts for Hamden Ltd: (Click the icon to view the income statement.) (Click the icon to view the statement of financial performance.) You should note that there are also other current assets, non-current assets, and current liabilities that are not specifically listed in the extracts shown above. Requirements OC. Decreasing average inventories turnover period D. High gross profit E. Increased gearing ratio 2017 2016 2015 2014 $ $ $ $ Which of the following are potential weaknesses of the business's management? (Select all that apply.) 20,000 20,000 63,000 250,000 15,000 39,000 Statement of financial performance Current assets Inventory Accounts receivable Total current assets Non-current assets Property, plant and equipment Total non-current assets Total assets 19,000 33,000 115,000 27,000 A. Decreasing average inventories turnover period B. Low sales revenue to capital employed C. Declining interest cover OD. Increasing gearing ratio E. High return on equity and high return on capital employed 110,000 140,000 118,000 210,000 200,000 310,000 112,000 130,000 245,000 460,000 170,000 Requirement (e) Identify additional information you would require to improve your analysis of this company over the period specified. Which of the following additional information would you require to improve your analysis of this company over the period specified? (Select all that apply.) Current liabilities 11,000 Accounts payable Total current liabilities DOO A. Completed financial statements from 2014 B. The statement of cash flows for 2015, 2016 and 2017 28,000 71,000 247,000 19,000 53,000 128,000 181,000 Total non-current liabilities 13,000 44,000 59,000 103,000 142,000 Total liabilities 318,000 C. The company's social responsibility report D. Sales projections for 2018 E. Industry benchmark figures for comparison Total shareholders' funds 142,000 129,000 Print Done Enter any number in the edit fields and then continue to the next
