Required: 1. Prepare a vertical analysis of the balance sheet data for 2022 and 2021. 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.) FEDERER SPORTS APPAREL Balance Sheet December 31 2022 2021 Amount % Amount Assets Cash $ $ Accounts receivable 2,431,000 1,581,000 3,128,000 754,000 1,305,000 1,595,000 11,832,000 11,832,000 (1,972,000) $ 17,000,000 (986,000) $ 14,500,000 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,856,000 $ 1,496,000 1,360,000 7,888,000 6,256,000 $ 17,000,000 7,888,000 4,756,000 $ 14,500,000 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 Increase (Decrease) Amount % 2022 2021 Assets $ 2,431,000 $ 754,000 1,581,000 1,305,000 3,128,000 1,595,000 11,832,000 11,832,000 (1,972,000) (986,000) $ 17,000,000 $ 14,500,000 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,856,000 1,496,000 1,360,000 7,888,000 7,888,000 6,256,000 $ 17,000,000 4,756,000 $ 14,500,000