EXERCISE 12-4B PART 1 & 2.

#1 - prepare a vertical analysis for year 2 and year 1

#2 - prepare a horizontal analysis for year 2 using year 1 as the base year

Required: 1. Prepare a vertical analysis of the balance sheet data for Year 2 and Year 1. Express each amount as a percentage of total assets. (Amounts to be deducted should be indicated by a minus sign. Round your answers to 1 decimal place.) COMPANY A Balance Sheet December 31 Year 2 Amount Year 1 Amount Assets Cash Accounts receivable Inventory Buildings Less: Accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Contingent liability Common stock Retained earnings Total liabilities and stockholders' equity $ 1,692,000 1,164,000 2,424,000 8,280,000 (1,560,000) $ 12,000,000 $ 500,000 800,000 1,200,000 8,280,000 (780,000) $ 10,000,000 $ 1,000,000 $ 1,128,000 1,176,000 5,520,000 4,176,000 $ 12,000,000 5,520,000 3,480,000 $ 10,000,000 2. Prepare a horizontal analysis for Year 2 using Year 1 as the base year. (Note: If the percentage increase or decrease cannot be calculated, then leave the cell blank. Decreases should be indicated by a minus sign. Round your percentage answers to 1 decimal place.) COMPANYA Balance Sheet December 31 Year Year 2 Increase (Decrease) Amount % Year 1 Assets Cash Accounts receivable Inventory Buildings Less: Accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Contingent liability Common stock Retained earnings Total liabilities and stockholders' equity $ 1,692,000 $ 500,000 1,164,000 800,000 2,424,000 1,200,000 8,280,000 8,280,000 (1,560,000) (780,000) $ 12,000,000 $10,000,000 $ 1,128,000 $ 1,000,000 1,176,000 5,520,000 5,520,000 4,176,000 3,480,000 $ 12,000,000 $ 10,000,000