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.) supersunt a decimal place. of tota FEDERER SPORTS APPAREL Balance Sheet December 31 2022 Amount 2021 % Amount % Assets Cash $ 2,200,000 1,237,500 3,112,500 7,150,000 (1,200,000) $ 12,500,000 800,000 990,000 1,660,000 7,150,000 (600,000) $ 10,000,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,250,000 $ 1,512,500 850,000 5,050,000 5,087,500 $ 12,500,000 5,050,000 3,700,000 $ 10,000,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 2022 2021 Increase (Decrease) Amount % Assets Cash Accounts receivable $ 2,200,000 1,237,500 3,112,500 7,150,000 (1,200,000) $ 12,500,000 $ 800,000 990,000 1,660,000 7,150,000 (600,000) $ 10,000,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,250,000 1,512,500 850,000 5,050,000 5,087,500 12,500,000 5,050,000 3,700,000 $ 10,000,000 $