Exercise 12-76 Preparation of Common Size Statements for Vertical Analysis Financial statements for Steele Inc. follow. Steele Inc. Consolidated Income Statements (in thousands except per share amounts) 2019 2018 2017 Net sales $7,245,088 $6,944,296 $6,149,218 Cost of goods sold (5,286,253) (4,355,675) $1,958,835 (1,259,896) (4,953,556) $1,990,740 (1,202,042) $1,793,543 (1,080,843) 0 2,617 0 $701,556 $788,698 Gross margin General and administrative expenses Special and nonrecurring items Operating income Interest expense Other income Gain on sale of investments Income before income taxes Provision for income taxes (63,685) (62,398) $712,700 (63,927) 11,529 7,308 10,080 0 9,117 0 $645,179 $660,302 $745,497 (290,000) $455,497 Net Income (254,000) $391,179 (257,000) $403,302 Steele Inc. Consolidated Balance Sheets (in thousands) Dec. 31, 2019 ASSETS Current assets: Dec. 31, 2018 Cash and equivalents Accounts receivable $41,235 Inventories 837,377 $320,558 1,056,911 733,700 109,456 $2,220,625 Other 803,707 Total current assets 101,811 Property and equipment, net $1,784,130 Other assets 1,666,588 1,813,948 247,892 24R 772 Steele Inc. Consolidated Balance Sheets (in thousands) Dec. 31, 2019 ASSETS Dec 31, 2018 Current assets: Cash and equivalents $320,558 $41,235 Accounts receivable 1,056,911 837,377 Inventories 733,700 803,707 Other 109,456 101,811 Total current assets Property and equipment, net Other assets $2,220,625 1,666,588 $1,784,130 1,813,948 248,372 247,892 $4,135,105 $3,846,450 Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable Accrued expenses Other current liabilities Income taxes Total current liabilities $250,363 $309,092 347,892 274,220 15,700 0 93,489 137,466 $707,444 Long-term debt $720,778 650,000 Deferred income taxes 275,101 541,639 274,844 Other long-term liabilities 61,267 41,572 1,693,812 1,578,833 Total liabilities Stockholders' equity: Preferred stock Common stock Additional paid-in capital-common stock Retained earnings $100,000 89,727 128,906 2,397,112 $2.715,745 (274,452) $2,441,293 $4,135,105 $100,000 89,727 127,776 2,136,794 $2,454,297 Less: Treasury stock, at cost Total stockholders' equity (186,680) $2,267,617 Total liabilities and stockholders' equity $3,846,450 Required: 1. Prepare a common size income statement for Steele to be used in vertical analysis. Enter your answers in percentage terms, rounded to two decimal places, and do not include the "%" sign with your answer. For example, "100.00" or "28.72". If an amount is zero, enter "0". For those boxes in which underlying dollar amount is shown as negative, use a minus sign. You do not need to include the actual dollar amounts shown above. Steele Inc. Consolidated Income Statements 2019 2018 2017 Net sales % % % % % % % % % % % % % % % % % % Cost of goods sold Gross margin General and administrative expenses Special and nonrecurring items Operating income Interest expense Other income Gain on sale of investments Income before income taxes Provision for income taxes Net income % % % % % % % % % % % % % % % % Prepare a common size balance sheet for Steele to be used in vertical analysis. Enter your answers in percentage terms, rounded to two decimal places, and do not include the "%" sign with your answer. For example, "100.00" or "28.72". If an amount is zero, enter "O". You do not need to include the actual dollar amounts shown above. Prepare a common size balance sheet for Steele to be used in vertical analysis. Enter your answers in percentage terms, rounded to two decimal places, and do not include the "%" sign with your answer. For example, "100.00" or "28.72". If an amount is zero, enter "O". You do not need to include the actual dollar amounts shown above. Steele Inc. Component Percentage Balance Sheets Dec 31, 2019 Dec 31, 2018 % % Current assets: Cash and equivalents Accounts receivable Inventories % % % % Other % % Total current assets % % Property and equipment, net % % Other assets % % Total assets % % Current liabilities: Accounts payable Accrued expenses % % % % Other current liabilities % % Income taxes % % % % Total current liabilities Long-term debt Deferred income taxes % % % % Other long-term liabilities % % yapm ICT Other assets % % % % % % Total assets Current liabilities: Accounts payable Accrued expenses Other current liabilities Income taxes % % % % % % Total current liabilities % % % % % %