! Required information Exercise 12-4A Prepare vertical and horizontal analyses (LO12-1, 12-2) (The following information applies to the questions displayed below.) The balance sheets for Federer Sports Apparel for 2022 and 2021 are presented below. Exercise 12-4A Part 2 2. Prepare a horizontal analysis for 2022 using 2021 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.) FEDERER SPORTS APPAREL Balance Sheet December 31 Year 2022 2021 Increase (Decrease) Amount % Assets Cash $ 3,087,000 $ 1,073,000 1,764,000 1,424,500 3,717,000 2,405,000 14,763,000 14,763,000 (2,331,000) (1,165,500) $ 21,000,000 $ 18,500,000 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.953,000 $ 2,331,000 1,995,000 9,324,000 9,324,000 7,728,000 6,845,000 $ 21,000,000 $ 18,500,000