Question

Horizontal Analysis Increase (Decrease) in the Current year (versus Previous year) Amount Percentage Current Year Previous Year $ % Income Statement Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Interest Expense Income before Income Tax Expense Income Tax Expense (30%) Net Income Balance Sheet Cash Accounts Receivable. Net 122,000 54,400 67,600 35,000 3,800 28,800 8,640 20,160 107,400 49,200 58,200 32,200 3,800 22,200 6,660 15,540 $ 15,000 5,200 9,400 2,800 0 46,600 1,980 $ 4,620 13.6 10.6 16.2 8.1 % 0.0 29.7 29.7 29.7 % $ % 38,200 10,400 37,600 104,000 190,200 36,200 98.6 673 (34.0) (8.8) 11.9 $ $ $ $ 22.7 Inventory Property and Equipment, Net Total Assets Accounts Payable Income Tax Payable To Payable Note Payable (long-term) Total Liabilities Common Stock (par $10) Retained Earnings Total Liabilities and Stockholders' Equity 75,860 17.400 24,800 94.800 $ 212,860 44.400 1.400 38,000 83,800 88,000 41,060 $ 212,860 37,660 7,000 (12,800) (9.200) 22,660 8,200 700 0 8.900 0 13,760 22,660 OOOOOOOOOOOO 700 38,000 74,900 88,000 27.300 190,200 100.0 0.0 11.9 0.0 50.4 11.9 $ $ %

Answer 1

1]

The columns are filled correctly except these two items :

Sales revenue : amount increase = 122,000 - 107,400 = $14,600

Operating expenses : % increase = 2,800 / 32,200 = 8.7%

2-a]

Cash account increased by the largest dollar amount

2-b]

Income tax payable account increased by the largest percentage