help please asap!

Exercise 12-4B Part 1 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 1 Amount Amount Assets Cash $ 1,820,000 Accounts receivable 1,386,000 Inventory 3,094,000 9,800,000 Buildings Less: Accumulated depreciation (2,100,000) Total assets $ 14,000,000 Liabilities and Stockholders' Equity Accounts payable $ 1,372,000 Contingent liability 1,316,000 Common stock 6,650,000 Retained earnings 4,662,000 Total liabilities and stockholders' equity $ 14,000,000 Year 2 $ 625,000 1,000,000 2,125,000 9,800,000 (1,050,000) $ 12,500,000 $ 1,225,000 6,650,000 4,625,000 $ 12,500,000 Exercise 12-4B Part 2 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.) COMPANY A Balance Sheet December 31 Increase (Decrease) Amount Year 2 Year 1 % Assets Cash $ 1,820,000 $ 625,000 Accounts receivable 1,386,000 1,000,000 Inventory 3,094,000 2,125,000 Buildings 9,800,000 9,800,000 Less: Accumulated depreciation (2,100,000) (1.050,000) Total assets $ 14,000,000 $ 12,500,000 Liabilities and Stockholders' Equity Accounts payable $ 1,372,000 $1,225,000 Contingent liability 1,316,000 Common stock 6,650,000 6,650,000 Retained earnings 4,662,000 4,625,000 Total liabilities and stockholders' equity $ 14,000,000 $ 12,500,000 Year