Problem 13-17A Horizontal analysis LO 13-1 Prepare a horizontal analysis of both the balance sheet and income statement. arch Complete this question by entering your answers in the tabs below. Analysis Bal Analysis Inc Sheet 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. (.e., .234 should be entered as 23.4).) Assets Current assets Cash C Et ALLENDALE COMPANY Horizontal Analysis of Balance Sheets Year 4 < Prev $ 40,000 $ 3 of 4 Year 3 36,000 Next > Percentage Change % D Assets Current assets Cash earch 3 Marketable securities Accounts receivable (net) Inventories Prepaid items Total current assets Investments Plant (net) Land E Total long-term assets Total assets Liabilities and Stockholders' Equity Liabilities. Current liabilities 4 10 R 20 Di 5 ALLENDALE COMPANY Horizontal Analysis of Balance Sheets Year 4 T 6 < Prev Y & S $ 7 40,000 $ 36,000 20,000 6,000 54,000 46,000 135,000 143,000 25,000 10.000 274,000 241,000 27,000 20,000 270,000 255,000 29,000 24,000 326,000 299,000 600,000 $ 540,000 3 of 4 lije U Year 3 8 Next > 9 Percentage Change % P MAHIRIWw 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, nonparticipating: 8,000 shares authorized and issued) Common stock (no par, 50,000 shares authorized; 10,000 shares issued) 3 Lo search Retained earnings Total stockholders' equity Total liabilities & stockholders' equity 64 4 % E Pa 5 Author 40 6 < Prev Tel 7 $ $ 17,000 $ 113,800 21,000 151,800 100,000 32,000 132,000 283,800 80,000 80,000 156,200 316.200 600,000 $ 3 of 4 BE 6,000 100,000 15,000 121,000 8 100,000 27,000 127,000 248,000 80,000 Analysis Ine Stat 80,000 132,000 292,000 540,000 Next > 9 0 Problem 13-17A Horizontal analysis LO 13-1 Prepare a horizontal analysis of both the balance sheet and income statement. ch Complete this question by entering your answers in the tabs below. Analysis Bal Analysis Inc Sheet 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).) Revenues Sales (net) Other revenues Q i ALLENDALE COMPANY Horizontal Analysis of Income Statements Year 4 < Prev duduk $ Year 3 Percentage Change 230,000 $ 210,000 8,000 5,000 3 of 4 www Next % 0 Revenues Sales (net) Other revenues Total revenues Expenses Cost of goods sold ALLENDALE COMPANY Horizontal Analysis of Income Statements Year 4 Selling, general, and administrative expenses Interest expense Income tax expense Total expenses Net income (loss) Prev $ 230,000 $ 210,000 8,000 5,000 238,000 215,000 $ < Analysis Bal Sheet 120,000 55,000 8,000 23,000 206,000 32,000 $ Year 3 3 of 4 103,000 50,000 7,200 22,000 182,200 32,800 www www Percentage Change Analysis Inc Stat Next > % %