The condensed financial statements of Alton Car Company are attached. REQUIRED: (1) Prepare a vertical analysis...

 

Transcribed Image Text:

The condensed financial statements of Alton Car Company are attached. REQUIRED: (1) 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) (2) (3) Current ratio. (b) (d) (e) (f) (g) (h) Profit margin ratio. Return on total assets. Return on common stockholders' equity. Earnings per share. Book value per share. Debt to equity ratio. ALTON CAR COMPANY COMPARATIVE INCOME STATEMENTS FOR YEARS ENDING DECEMBER 31, 20X3, 20x2, AND 20X1 20X3 20X2 20X1 Sales 74,000 S 68,000 S 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 S 5,808 S 5,492 ALTON CAR COMPANY COMPARATIVE BALANCE SHEETS AT DECEMBER 31, 20X3, 20X2, AND 20X1 20X3 20X2 20X1 ASSETS Current Assets $ 12,780 S 11,940 S 14,140 Long Term Investments 100 930 Plant and Equipment (Net) 19,150 20,000 16,250 TOTAL ASSETS 31,930 S 32,040 S 31,320 LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities $ 5,050 S 4,990 S 4,870 Common Stock, $10 par 13,500 13,500 13,390 Additional Paid In Capital 1,850 1,850 1,460 Retained Earnings 11,530 11,700 11,600 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ 31,930 S 32,040 S 31,320 The condensed financial statements of Alton Car Company are attached. REQUIRED: (1) 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) (2) (3) Current ratio. (b) (d) (e) (f) (g) (h) Profit margin ratio. Return on total assets. Return on common stockholders' equity. Earnings per share. Book value per share. Debt to equity ratio. ALTON CAR COMPANY COMPARATIVE INCOME STATEMENTS FOR YEARS ENDING DECEMBER 31, 20X3, 20x2, AND 20X1 20X3 20X2 20X1 Sales 74,000 S 68,000 S 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 S 5,808 S 5,492 ALTON CAR COMPANY COMPARATIVE BALANCE SHEETS AT DECEMBER 31, 20X3, 20X2, AND 20X1 20X3 20X2 20X1 ASSETS Current Assets $ 12,780 S 11,940 S 14,140 Long Term Investments 100 930 Plant and Equipment (Net) 19,150 20,000 16,250 TOTAL ASSETS 31,930 S 32,040 S 31,320 LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities $ 5,050 S 4,990 S 4,870 Common Stock, $10 par 13,500 13,500 13,390 Additional Paid In Capital 1,850 1,850 1,460 Retained Earnings 11,530 11,700 11,600 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ 31,930 S 32,040 S 31,320

Answer rating: 100% (QA)

Answer According to the given conditions 20x3 Vertiral Andye of Iueome state ... View the full answer