missing percentages

common sized balance sheet for 2017 and 2018 its the last three pictures

After graduating from college in May 2018, Ryan Crews started his career in finance at the W&T Corporation, a small to medium-sized warehouse distributor in Nashville, Tennessee. The company was founded by David Winston and Colin Tabor in 2005, after they have worked together in management at Walmart. Although Crews had an offer from Sam's Club, he became excited about the opportunity with W&T. For W&T, 2017 tumed out to be a good financial year. But in 2018, the company experienced a 5.2 percent sales reduction, where sales declined from $5.9 million to $5.6 million. The downturn then led to other financial problems, including a 50 percent reduction in the company's stock price. The share price went from $34 per share at the end of 2017 to $17 per share at the end of 2018! David Winston and Colin Tabor want to understand what may have happened. Financial information for W&T for both years is shown in the popup window, where all the numbers, except for per-share data, are shown in thousands W and T Corporation Income Statement ($ thousands) for the Years Ended 12/31/2017 and 12/31/2018 2017 2018 Sales $ $ 5,900 (3,600) 5,600 (3,300) $ 2,300 $ 2,300 Cost of goods sold Gross profits Operating expenses: Selling, general, and administrative expenses Depreciation expenses Total operating expenses Operating profits (820) (320) (1.140) (770) (490) $ $ (1,260) $ $ 1,160 (200) 1,040 (270) Interest expense Earnings before taxes (taxble income) $ 960 $ 770 (162) (202) Income taxes $ 758 $ 608 Net income income taxes $ 758 $ 608 Net income Additional information: 140 140 Number of common shares outstanding Dividends paid to stockholders Market price per share $152 $152 $34 $17 W and T Corporation Balance Sheet ($ thousands) for 12/31/2017 and 12/31/2018 2017 2018 ASSETS Cash $ 400 505 915 Accounts receivable 600 Inventories 500 135 880 170 Other current assets Total current assets 1,635 $ 2,470 Total current assets 1,635 Gross fixed assets $ 4,650 (1,600) 2,470 5,050 (2,200) Accumulated depreciation Net fixed assets $ 3,050 $ 2,850 $ 4,685 $ 5,320 Total assets LIABILITIES (DEBT) AND EQUITY Accounts payable Short-term notes payable Total current liabilities 400 150 540 250 $ 550 790 1,200 1,150 $ 1,700 $ Long-term debt Total liabilities Common equity: Common stock 1,990 1,100 1,885 1,100 2,230 Retained earnings Total common equity $ 2,985 $ 3,330 Total liabilities and equity 4,685 $ 5,320 a. Using what you have learned in this chapter and Chapter 3, prepare a financial analysis of W&T, comparing the firm's financial performance between the two years. (1) Compute the financial ratios as shown in the popup window. for 2017 and 2018. (2) Complete a common-sized Income statement for 2017 and 2018, (3) Complete a common-sized balance sheet for 2017 and 2018 (4) Compute the price learnings and pricebook ratios for 2017 and 2018 b. What conclusions can you make from your analysis? c. What recommendations would you make to management? a. (1) Compute the financial ratios for W&T Corporation 2017 2018 3.13 X Current ratio 2.97 X (Round to two decimal places) 2017 1.81 X 2018 1.80 X Acid-test ratio (Round to two decimal places) 2017 37.11 days 2018 59.53 days Days in receivables (Round to two decimal places) 2017 50.69 days 2018 97,33 days Days in inventories (Round to two decimal places) Days in inventories 50.69 days 97.33 days (Round to two decimal places.) 2017 2018 19.5% Operating return on assets 25 % (Round to one decimal place.) 2017 2018 18.5 % Operating profit margin 19.7 % (Round to one decimal place.) 2017 2018 1.05 X Total asset turnover 1.26 X (Round to two decimal places.) 2018 2017 1.93 X Fixed asset turnover 1.96 X (Round to two decimal places.) 2018 2017 1.93 X Fixed asset turnover 1.96 X (Round to two decimal places.) 2017 2018 37.4 % Debt ratio 36.3 % (Round to one decimal place.) 2017 5.80 X 2018 3.85 X Times interest earned (Round to two decimal places.) 2017 2018 18.3 % I (Round to one decimal place.) Return on equity 25.4 % (2) Complete a common-sized income statement for 2017 and 2018. (Round to one decimal place.) Common-Sized Income Statement ($ thousands) for the Years Ended 12/31/2014 and 12/31/2015 2017 2017 2018 2018 Sales 5,900 $ % 100.0 % -61.0 % 39.0 % (3,600) 2,300 5,600 (3,300) 2,300 % $ % Cost of goods sold Gross profits Operating expenses: Selling, general, and administrative expenses Depreciation expenses -13.9% % (820) (320) -5.4 % (770) (490) % A % -13.9% -5.4 % -19.3 % % % Selling, general, and administrative expenses Depreciation expenses Total operating expenses Operating profits Interest expense Earnings before taxes (taxable income) Income taxes (820) (320) $ (1,140) $ 1,160 (200) $ 960 % 19.7 % -3.4 % 16.3 % (770) (490) $ (1,260) $ 1,040 (270) 770 (162) $ 608 (202) -3.4 % % Net income 758 12.9 % % Common-Sized Income Statement ($ thousands) for the Years Ended 12/31/2017 and 12/31/2018 2017 2017 2018 2018 Sales $ 5,900 5,600 100.0 % -61.0 % (3.600) (3,300) 2,300 100.0 % -58.9 % 41.1 % $ 2,300 39.0 % S Cost of goods sold Gross profits Operating expenses: Selling, general, and administrative expenses Depreciation expenses Total operating expenses Operating profits -13.9% -5.4 % (820) (320) (1,140) 1,160 (770) (490) (1,260) 1,040 -13.8 % -8.8 % -22.5 % -19.3 % $ 19.7 % $ 18.6 % -19.3 % (1,260) -22.5 % |(1,140) 1,160 19.7 % $ 1,040 18.6 % Total operating expenses Operating profits Interest expense Earnings before taxes (taxable income) Income taxes (200) -3.4 % (270) 4.8% $ 960 16.3% $ 770 13.8 % (202) -3.4 % -2.9 % (162) 808 Net income $ 758 12.8% 10.9 % (3) Complete a common-sized balance sheet for 2017 and 2018. (Round to one decimal place.) Common-Sized Balance Sheet (s thousands) for 12/31/2017 and 12/31/2018 2017 2017 2018 2018 (3) Complete a common-sized balance sheet for 2017 and 2018. (Round to one decimal place.) Common-Sized Balance Sheet (s thousands) for 12/31/2017 and 12/31/2018 2017 2017 2018 2018 ASSETS Cash 400 % $ 505 600 % Accounts receivable Inventories 915 I 880 500 % Other current assets 135 % 170 % Total current assets $ 1,635 % 2,470 % Total current assets $ 1,635 % $ % Gross fixed assets % $ % 2,470 5,050 (2,200) 2,850 Accumulated depreciation % 4,650 (1.600) 3,050 4,685 % Net fixed assets $ % $ % $ Total assets % $ 5,320 % $ 400 % 540 % LIABILITIES (DEBT) AND EQUITY Accounts payable Short-term notes payable Total current liabilities 150 250 % $ 550 % 790 Inna-term rieht 1 150 % 1.200 % UU 040 Account Short-term notes payable 150 % 250 % Total current liabilities 550 % 790 % 1,150 % % 1,200 1,990 $ 1,700 % % Long-term debt Total liabilities Common equity: Common stock Retained earnings Total common equity Total liabilities and equity lalala le % S 1.100 1,100 1.885 % 2,230 % $ 2,985 % S 3,330 4,685 % 5,320