Prepare a horizontal analysis of both the balance sheet and Income statement for Year 4 and...

Transcribed Image Text:

Prepare a horizontal analysis of both the balance sheet and Income statement for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Balance Sheet Income Statement Prepare a horizontal analysis of the balance sheet for Year 4 and Year 3. Note: 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). Assets Current assets STUART COMPANY Horizontal Analysis of Balance Sheets Year 4 Year 3 % Change Cash Marketable securities S 16,600 $ 20,200 13,800 % 7,200 Inventories Accounts receivable (net) Prepaid items 55,500 48,900 135,700 143,700 28,700 10,700 Total current assets 254,700 222,300 Investments 28,100 21,700 Plant (net) 271,900 255,600 Land 30,000 24,700 Total long-term assets 330,000 302,000 Total assets S 584,700 $ 524,300 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 S 15,600 $ 5,200 111,900 98,800 20,700 13,100 148,200 117,100 99,600 99,600 31,900 28,700 131,500 128,300 279,700 243,400 Preferred stock (par value $10, 4% cumulative, nonparticipating: 8,000 shares authorized and issued) 80,000 80,000 Common stock (no par; 50,000 shares authorized; 10,000 80,000 80,000 shares issued) Retained earnings 145,000 120,900 Total stockholders' equity 305,000 280,900 Total liabilities & stockholders' equity S 584,700 $ 524,300 < Balance Sheet Income Statement > Prepare a horizontal analysis of both the balance sheet and Income statement for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Balance Sheet Income Statement Prepare a horizontal analysis of the income statement for Year 4 and Year 3. Note: 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 STUART COMPANY Horizontal Analysis of Income Statements Year 4 Year 3 % Change $ 231,800 $211,700 % 9,100 5,800 240,900 217,500 Total revenues Expenses Cost of goods sold 119,700 102,000 Selling, general, and administrative expenses 54,500 48,600 Interest expense 7,900 7,100 Income tax expense 22,800 21,800 Total expenses Net income (loss) 204,900 179,500 $ 36,000 $ 38,000 < Balance Sheet Income Statement > Prepare a horizontal analysis of both the balance sheet and Income statement for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Balance Sheet Income Statement Prepare a horizontal analysis of the balance sheet for Year 4 and Year 3. Note: 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). Assets Current assets STUART COMPANY Horizontal Analysis of Balance Sheets Year 4 Year 3 % Change Cash Marketable securities S 16,600 $ 20,200 13,800 % 7,200 Inventories Accounts receivable (net) Prepaid items 55,500 48,900 135,700 143,700 28,700 10,700 Total current assets 254,700 222,300 Investments 28,100 21,700 Plant (net) 271,900 255,600 Land 30,000 24,700 Total long-term assets 330,000 302,000 Total assets S 584,700 $ 524,300 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 S 15,600 $ 5,200 111,900 98,800 20,700 13,100 148,200 117,100 99,600 99,600 31,900 28,700 131,500 128,300 279,700 243,400 Preferred stock (par value $10, 4% cumulative, nonparticipating: 8,000 shares authorized and issued) 80,000 80,000 Common stock (no par; 50,000 shares authorized; 10,000 80,000 80,000 shares issued) Retained earnings 145,000 120,900 Total stockholders' equity 305,000 280,900 Total liabilities & stockholders' equity S 584,700 $ 524,300 < Balance Sheet Income Statement > Prepare a horizontal analysis of both the balance sheet and Income statement for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Balance Sheet Income Statement Prepare a horizontal analysis of the income statement for Year 4 and Year 3. Note: 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 STUART COMPANY Horizontal Analysis of Income Statements Year 4 Year 3 % Change $ 231,800 $211,700 % 9,100 5,800 240,900 217,500 Total revenues Expenses Cost of goods sold 119,700 102,000 Selling, general, and administrative expenses 54,500 48,600 Interest expense 7,900 7,100 Income tax expense 22,800 21,800 Total expenses Net income (loss) 204,900 179,500 $ 36,000 $ 38,000 < Balance Sheet Income Statement >