Block Department Stores\' chief executive officer (CEO) has asked you to compare
ID: 2518478 • Letter: B
Question
Block Department Stores' 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. Block Department Stores, Inc. Income Statement Compared with Industry Average For the Year Ended December 31 amounts in thou Block Industry Average 6 Sales revenues 7 Less: Cost of goods sold 8 Gross profit 9 Less Operating expenses 10 Operating income 11 Less Interest expense 12 Income before income taxes 13 Less Income tax expense 14 Net income 100.0% 65.7% 23% 526,286 64,220 91,494 1,173 90,321 ,083 48 143% 0.3% 140% 15 Block Department Stores, Inc. Balance Sheet Compared with Industry Average As of December 3 (omounts in thousands Block Industy Average Assets 312,340 117,760 5,980 23,920 460,000 709% 23.7% 0% 4.796 7 Current assets 8 Fixed assets, net intangible assets, net 10 Other assets 11 Total assets 12 13 4 Current liabilities Liabilities 213,440 104,880 318,320 483% 16.7% 650% 15 Long-term Babilities 16 Total liabilities 17 18 Stockholders equity 19 Total common stockholders equity 21 Total liabilities and equity 141 60,000 100.0% Requirements Prepare a common-size income statement and balance sheet for Block Depart- ment Stores. The first column of each statement should present Block Department Stores' common-size statement, while the second column should present the industry averages 1.Explanation / Answer
BLOCK DEPARTMENT STORES, INC Common-Size Income Statement Year Ended December 31, 2017 Amounts in Thousands Block Average Industry Average Net Sales $782,000.00 100.00% 100.00% Less: Cost of Good sold $526,286.00 67.30% 65.70% Gross Profit $255,714.00 32.70% 34.30% Less: Operating Expenses $164,220.00 21.00% 19.50% Operating Income $91,494.00 11.70% 14.80% Less :Interest Expenses $1,173.00 0.15% 0.50% Earning before Tax $90,321.00 11.55% 14.30% Less:Tax $5,083.00 0.65% 0.30% Net income $85,238.00 10.90% 14.00% BLOCK DEPARTMENT STORES, INC Common-Size Balance Sheet Year Ended December 31, 2017 Amounts in Thousands Assets Block Average Industry Average Current Assets $312,340.00 67.90% 70.90% Fixed Assets, Net $117,760.00 25.60% 23.70% Intangible Assets, Net $5,980.00 1.30% 0.70% Other Assets $23,920.00 5.20% 4.70% Total Assets $460,000.00 100.00% 100.00% Liabilities Current Liabilities $213,440.00 46.40% 48.30% Long-term Liabilities $104,880.00 22.80% 16.70% Total Liabilities $318,320.00 69.20% 65.00% Stockholders’ Equity $141,680.00 30.80% 35.00% Total Liabilities and Stockholders’ Equity $460,000.00 100.00% 100.00%