20X1 ALTON CAR COMPANY COMPARATIVE BALANCE SHEETS AT DECEMBER 31, 20X3, 20X2, AND 20X1 20X3 20X2 ASSETS Current Assets $ 12,780 $ 11,940 $ Long Term Investments 100 Plant and Equipment (Net) 19,150 20,000 TOTAL ASSETS $ 31,930 $ 32,040 $ 14,140 930 16,250 31,320 $ $ $ LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Common Stock, $10 par Additional Paid In Capital Retained Earnings TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY 5,050 13,500 1,850 11,530 4,990 13,500 1,850 11,700 4,870 13,390 1,460 11,600 $ 31,930 $ 32,040 $ 31,320 ALTON CAR COMPANY COMPARATIVE INCOME STATEMENTS FOR YEARS ENDING DECEMBER 31, 20X3, 20X2, AND 20X1 20X3 20X2 2 0X1 Sales $ 74,000 | $ 68,000 $ 59,000 Cost of Goods Sold 45,658 40,052 33,866 Gross Margin From Sales 28,342 27,948 25,134 Operating Expenses: Selling Expenses 12,306 11,506 10,095 Administrative Expenses 8,658 8,262 7,304 Total Operating Expenses 20,964 19,768 17,399 Income Before Taxes 7,378 8,180 7,735 Income Tax Expense 2,140 2,372 2,243 Net Income $ 5,238 $ 5,808 $ 5,492 MANAGERIAL ACCOUNTING HANDOUT PROBLEM 15 Score Name Section Problem (10 points). The condensed financial statements of Alton Car Company are attached. REQUIRED: (1) (2) Prepare a vertical analysis on the income statement for all three years. Round your answers to three decimal places (one decimal place for percentages). Prepare a horizontal analysis on the balance sheet from 20X2 to 20X3 and from 20X1 to 20X2. Round your percentage change answers to four decimal places (two decimal places for percentages). Compute the following ratios for 20X2 and 20X3. Round all percentages to four decimal places and all other ratios to two decimal places. (a) Current ratio. Profit margin ratio. (d) Return on total assets. Return on common stockholders' equity. Earnings per share. Book value per share. Debt to equity ratio. (6) (f)