Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

question,Thanks a lot You are presented with the following financial report extracts for Hamden Lid: (Click the icon to view the income statement.) (Click the

image text in transcribedimage text in transcribed

question,Thanks a lot

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
You are presented with the following financial report extracts for Hamden Lid: (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. i Income statement - X Requirements Requirement (a) For the income statement section, prepare a 'vertical analysis' for the three years (2015-2017) 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 Income statement 31 December Sales 380,000 310,000 250,000 173,000 113,000 2017 2015 140,000 2016 Cost of sales Interest 16,000 10,000 5,000 Amount Per cent Amount Per cent Amount Per cent Sales % % Taxation 20% 63,000 58.000 52.000 Cost of sales % % % Other expenses Gross profit % % Other expenses % % % Print Done 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 (2015-2017) the base vear being 2015 Enter any number in the edit fields and then continue to the next question.You are presented with the following financial report extracts for Hamden Lid: i Statement of financial performance - X (Click the icon to view the income statement.) Ff (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 Complete the table below. (Round to the nearest whole number, as needed. Calculate each line separately.) $ $ $ Hamden Ltd Statement of financial performance Trend percentage analysis Current assets 31 December Inventory 20,000 15,000 19,000 20,000 2017 2016 2015 Accounts receivable 63,000 39,000 33,000 27,000 Per cent Per cent Per cent Total current assets 250,000 110,000 115,000 Current assets Non-current assets Inventory % 100 % Property, plant and equipment 140,000 118,000 112,000 Accounts receivable 100 % Total non-current assets 210,000 200,000 130,000 Total current assets /% 100 % Total assets 460,000 310,000 245,000 170,000 Non-current assets Current liabilities Property, plant and equipment % 100 % Accounts payable 28,000 19,000 13,000 11,000 Total non-current assets % 100 % Total current liabilities 71,000 53,000 44,000 Total assets % 100 % Total non-current liabilities 247,000 128,000 59,000 Current liabilities Total liabilities 318,000 181,000 103,000 Accounts payable % 100 % Total shareholders' funds 142,000 129,000 142,000 Total current liabilities 100 % Total non-current liabilities % 100 % Print Done Enter any number in the edit fields and then continue to the next question.You are presented with the following financial report extracts for Hamden Lid: i Statement of financial performance - (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.) Statement of financial performance 2017 2016 2015 Current assets Return on equity % % Inventory 20,000 15,000 19,000 20,000 Return on capital employed % % Accounts receivable 63,000 39,000 33,000 27,000 Operating profit margin % % % Total current assets 250,000 110,000 115,000 Gross profit margin % Non-current assets Property, plant and equipment 140,000 118,000 112,000 Find the following liquidity ratios for the years 2015, 2016 and 2017. (Round to two decimal places, as needed.) Total non-current assets 210,000 200,000 130,000 2017 2016 2015 Total assets 460,000 310,000 245,000 170,000 Current ratio times times times Current liabilities Acid test ratio times times times Accounts payable 28,000 19,000 13,000 11,000 Find the following efficiency ratios for the years 2015, 2016 and 2017. (Round to two decimal places, as needed.) Total current liabilities 71,000 53,000 44,000 2017 2016 2015 Total non-current liabilities 247,000 128,000 59,000 days 318,000 181,000 103,000 Average inventories turnover period days days Total liabilities Debtors average settlement period days days days Total shareholders' funds 142,000 129,000 142,000 Sales revenue to capital employed times times Print Done Enter any number in the edit fields and then continue to the next question.You are presented with the following financial report extracts for Hamden Lid: i Statement of financial performance X (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 2016 2076 2017 2015 2014 2075 $ $ Average inventories turnover period days days days Debtors average settlement period days days days Statement of financial performance Sales revenue to capital employed times times Current assets Inventory 20,000 15,000 19,000 20,000 Find the following gearing ratios for the years 2015, 2016 and 2017. (Round to two decimal places, as needed.) Accounts receivable 63,000 39,000 33,000 27,000 2017 2016 2015 Total current assets 250,000 110,000 115,000 Gearing ratio % % % Non-current assets Interest cover ratio times times times Property, plant and equipment 140,000 118,000 112,000 Requirement (d) Prepare a report indicating potential strengths and weaknesses in the management of this business, basing it on the analysis of parts (a) (c). Total non-current assets 210,000 200,000 130,000 Which of the following are potential strengths of the business's management? (Select all that apply.) Total assets 460,000 310,000 245,000 170,000 Current liabilities A. High operating profit Accounts payable 28,000 19,000 13,000 11,000 OB. High return on equity and high return on capital employed Total current liabilities 71,000 53,000 44,000 C. Decreasing average inventories turnover period Total non-current liabilities 247,000 128,000 59,000 D. High gross profit Total liabilities 318,000 181,000 103,000 E. Increased gearing ratio Total shareholders' funds 142,000 129,000 142,000 Which of the following are potential weaknesses of the business's management? (Select all that apply.) Print Done Enter any number in the edit fields and then continue to the next question.You are presented with the following financial report extracts for Hamden Lid: i Statement of financial performance - X (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 Which of the following are potential strengths of the business's management? (Select all that apply.) $ $ Statement of financial performance A. High operating profit Current assets OB. High return on equity and high return on capital employed Inventory 20,000 15,000 19,000 20,000 C. Decreasing average inventories turnover period Accounts receivable 63,000 39,000 33,000 27,000 D. High gross profit Total current assets 250,000 110,000 115,000 E. Increased gearing ratio Non-current assets Which of the following are potential weaknesses of the business's management? (Select all that apply.) Property, plant and equipment 140,000 118,000 112,000 Total non-current assets 210,000 200,000 130,000 A. Decreasing average inventories turnover period Total assets 460,000 310,000 245,000 170,000 B. Low sales revenue to capital employed Current liabilities C. Declining interest cover Accounts payable 28,000 19,000 13,000 11,000 [D. Increasing gearing ratio Total current liabilities 71,000 53,000 44,000 E. High return on equity and high return on capital employed Total non-current liabilities 247,000 128,000 59,000 Requirement (e) Identify additional information you would require to improve your analysis of this company over the period specified. Total liabilities 318,000 181,000 103,000 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 142,000 A. Completed financial statements from 2014 TL Print Done Enter any number in the edit fields and then continue to the next question.You are presented with the following financial report extracts for Hamden Lid: i Statement of financial performance - X (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 C. Decreasing average inventories turnover period D. High gross profit E. Increased gearing ratio Statement of financial performance Current assets Which of the following are potential weaknesses of the business's management? (Select all that apply.) Inventory 20,000 15,000 19,000 20,000 A. Decreasing average inventories turnover period Accounts receivable 63,000 39,000 33,000 27,000 B. Low sales revenue to capital employed Total current assets 250,000 110,000 115,000 C. Declining interest cover Non-current assets Property, plant and equipment 140,000 112,000 D. Increasing gearing ratio 118,000 200,000 130,000 E. High return on equity and high return on capital employed Total non-current assets 210,000 Total assets 460,000 310,000 245,000 170,000 Requirement (e) Identify additional information you would require to improve your analysis of this company over the period specified. Current liabilities Which of the following additional information would you require to improve your analysis of this company over the period specified? (Select all that apply.) Accounts payable 28,000 19,000 13,000 11,000 A. Completed financial statements from 2014 Total current liabilities 71,000 53,000 44,000 B. The statement of cash flows for 2015, 2016 and 2017 Total non-current liabilities 247,000 128,000 59,000 318,000 103.000 C. The company's social responsibility report Total liabilities 181,000 D. Sales projections for 2018 Total shareholders' funds 142,000 129,000 142,000 E. Industry benchmark figures for comparison Print Done Enter any number in the edit fields and then continue to the next

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Michelle L. Hanlon, Robert P. Magee, Glenn M. Pfeiffer, Thomas R. Dyckman

6th Edition

1618533118, 978-1618533111

More Books

Students also viewed these Accounting questions

Question

=+ What motivates nonreligious people to be humble?

Answered: 1 week ago

Question

Describe Montaignes position on child rearing.

Answered: 1 week ago