P18-2 Vertical analysis [20–30 min] The McConnell Department Stores Pty Ltd's chief executive officer (CEO) has asked you to compare the company's profit performance and financial position with the average for the industry. The CEO has given you the company's income statement and balance sheet, as well as the industry average data for retailers. MCCONNELL DEPARTMENT STORES PTY LTD Income statement compared with industry average for the year ended 31 December 2016 McConnell Industry average Net sales $778 000 100.0% Cost of sales 522 816 65.8 $255 184 Gross profit Selling and general expenses 34.2 161 046 19.7 Other expenses 4 668 0.4 Profit $ 89 470 14.1% MCCONNELL DEPARTMENT STORES PTY LTD Balance sheet compared with industry average as at 31 December 2016 McConnell Industry average Current assets $325 440 70.9% Property, plant and equipment, net Intangible assets, net 120 960 23.6 8 640 0.8 Other assets 24 960 4.7 Total assets $480 000 100.0% Current liabilities $222 720 48.1 Non-current liabilities 107 520 16.6 Shareholders' equity Total liabilities and shareholders' equity 149 760 35.3 $480 000 100.0% Requirement Prepare a vertical analysis for McConnell for both its income statement and its balance sheet.

P18-2 Vertical analysis [20–30 min] The McConnell Department Stores Pty Ltd's chief executive officer (CEO) has asked you to compare the company's profit performance and financial position with the average for the industry. The CEO has given you the company's income statement and balance sheet, as well as the industry average data for retailers. MCCONNELL DEPARTMENT STORES PTY LTD Income statement compared with industry average for the year ended 31 December 2016 McConnell Industry average Net sales $778 000 100.0% Cost of sales 522 816 65.8 $255 184 Gross profit Selling and general expenses 34.2 161 046 19.7 Other expenses 4 668 0.4 Profit $ 89 470 14.1% MCCONNELL DEPARTMENT STORES PTY LTD Balance sheet compared with industry average as at 31 December 2016 McConnell Industry average Current assets $325 440 70.9% Property, plant and equipment, net Intangible assets, net 120 960 23.6 8 640 0.8 Other assets 24 960 4.7 Total assets $480 000 100.0% Current liabilities $222 720 48.1 Non-current liabilities 107 520 16.6 Shareholders' equity Total liabilities and shareholders' equity 149 760 35.3 $480 000 100.0% Requirement Prepare a vertical analysis for McConnell for both its income statement and its balance sheet.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Compute the receivable turnover ratio Also compute the inventory turnover ratio
I need help with questions 1-6
#becausesneaker.... HW CH 17 Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales Cost of merchandise sold Selling expenses Administrative expenses Income tax expense Custom Order Sales Cost of merchandise sold Selling expenses a. Prepare an income statement in comparative form, statin each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Administrative expenses Income tax expense $483,000 280,140 82,110 86,940 14,490 Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 Current year Amount $483,000 280,140 82,110 86,940 14,490 percentage points, and administrative expenses net income as a percent of sales Current year Percent % % % % % % $420,000 218,400 79,800 71,400 21,000 % % % Previous year Amount $420,000 218,400 79,800 71,400 21,000 Previous year Percent b.…
Financial Statements Diane Bernick opened Bernick's Consulting. Transactions for the month of January and trial balance at January 31 are shown. Jan. 1 Bernick invested cash in the business, $12,000. 2 Paid office rent, $750. 3 Purchased office equipment on account, $1,300. 5 Received cash for services rendered, $950. 8 Paid phone bill, $85. 10 Paid for a magazine subscription (miscellaneous expense), $20. 11 Purchased office supplies on account, $250. 15 Made a payment on account (see Jan. 3 transaction), $200. 18 Paid part-time employee, $600. 21 Received cash for services rendered, $800. 25 Paid utilities bill, $105. 27 Bernick withdrew cash for personal use, $400. 29 Paid part-time employee, $600.
Vertical Analysis Income statement information for Einsworth Corporation follows: Sales $285,000 Cost of goods sold 94,050 Gross profit 190,950 Prepare a vertical analysis of the income statement for Einsworth Corporation. If required, round percentage answers to the nearest whole number. Einsworth Corporation Vertical Analysis of the Income Statement Amount Percentage Sales $285,000 % Cost of goods sold 94,050 Gross profit $190,950
Below is the common-sized statement for the current calendar year fo Hugo Boss and Industry average, Industry Hugo Boss Average Sales 100% 100% Cost of Goods Sold 46.7% 45.2% Gross Profit 53.3% 54.8% Selling Expenses 12.9% 16.7% Administrative Expenses 13.1% 14.5% Total Operating Expenses 25.0% 31.2% Income from Operations 27.3% 23.6% Other Revenue 1.8% 1.2% 29.% 24.8% Other Expense(Interest) 1.0 0.9 Income Before Income Tax 28.1% 23.9% Income Tax Expense 9.8 8.4 Net Income 18.3% 15.5% Using the common-sized statement above, compare Hugo Boss with the industry average and identify strengths and weaknesses that Hugo Boss has to the industry. Does Hugo Boss need any course correction. What does it need?
Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.6 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 30% Total liabilities-to-assets ratio: 35% Quick ratio: 1.20 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.25 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information Sales Cost of goods sold $ 640,000 448,000 Balance Sheet Assets Cash Accounts payable Liabilities and Equity $ 90,000 Accounts receivable 64,000 Long-term debt 50,000 Inventories Common stock Fixed assets Retained earnings 100,000 Total assets $ 400,000 Total liabilities and equity $
Profitability Ratios East Point Retal, Inc. seils apparel through company-owned retail stores. Recent financial information for East Point follows (in thousands): Fiscal Year 3 Fiscal Year 2 $145,000 $(74,600) 3,000 11,200 Fiscal Year 3 Fiscal Year 2 Fiscal Year 1 Net income (los) Interest expense Total assets (at and of fiscal year) Total stockholders equity (at end of fiscal year) Assume the apparel industry average return on total assets is 5.0% and the average return on stockholders' equity is 8.0% for the year ended February 2, Year 3. $1,307,759 1,010,000 Fiscal Year 3 Fiscal Year 2 $1,243,965 990,000 $1,106,719 724,942 a. Determine the return on total assets for East Point for fiscal Years 2 and 3. Round percentages to one decimal place. If required, use a minus sign to indicate a negative return on total assets. % b. Determine the retum on stockholders' equity for East Point for fiscal Years 2 and 3. Round percentages to one decimal place. If required, use a minus sign to…