Problem 13-17A (Algo) Horizontal analysis LO 13-1 Prepare a horizontal analysis of both the balance sheet and income statement Complete this question by entering your answers in the tabs below. Analysis Bal Sheet Analysis Inc Stmt Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) STUART COMPANY Horizontal Analysis of Balance Sheets Year 4 Year 3 % Change STUART COMPANY Horizontal Analysis of Balance Sheets Year 4 Year 3 % Change Assets Current assets Cash Marketable securities Accounts receivable (net) Inventories Prepaid items Total current assets Investments Plant (net) Land 16,500 $ 21,800 54,300 136,000 25,700 254,300 27,200 270,700 29,400 327,300 12,700 6,100 47,500 144,900 10,900 222,100 21,300 256,100 24,700 302,100 Total long-term assets $ 581,600 $ 524,200 $ 16,300 $ 112,800 19,400 148,500 4,600 99,700 13,300 117,600 Total assets Liabilities and Stockholders' Equity Liabilities Current liabilities Notes payable Accounts payable Salaries payable Total current liabilities Noncurrent liabilities Bonds payable Other Total noncurrent liabilities Total liabilities Stockholders' equity Preferred stock (par value $10,4% cumulative, nonnarticipatina: 7 100 shares authorized and issued) 99,700 30,300 130,000 278,500 99,700 26,800 126,500 244,100 71,000 71,000 A IMG-9143 (1).jpg 34.jpg 30.jpg 30,300 130,000 278,500 26,800 126,500 244,100 Other Total noncurrent liabilities Total liabilities Stockholders' equity Preferred stock (par value $10,4% cumulative, nonparticipating: 7,100 shares authorized and issued) Common stock (no par: 50,000 shares authorized; 10,000 shares issued) Retained earnings Total stockholders' equity Total liabilities & stockholders' equity 71,000 71,000 71,000 161,100 303, 100 581,600 $ 71,000 138,100 280,100 524,200 $ % Analysis Bal Sheet Analysis Inc Stmt> Prepare a horizontal analysis of the income statement. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).). STUART COMPANY Horizontal Analysis of Income Statements Year 4 Year 3 % Change $ 231,200 $ 211,700 9,200 6,900 240,400 218,600 Revenues Sales (net) Other revenues Total revenues Expenses Cost of goods sold Selling, general, and administrative expenses Interest expense Income tax expense Total expenses Net income (loss) 119,900 53,500 7.100 21,700 202,200 38,200 $ 102,600 48,100 6,300 20,700 177.700 40,900 $ %