Exercise 12-4A Prepare vertical and horizontal analyses (LO12-1, 12-2) Part 1 and 2

Exercise 12-4A Part 1 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 ploce.) FEDERER SPORTS APPAREL Balance Sheet December 31 Amount Amount Assets 3.000.000 Accounts receivable 980,000 1.242.000 1.977.500 14.700.000 Inventory Budings 00.000 LOSS: Accumulated depreciation (2.800.000 1.400.000 Total assets 20.000.000 Liabilities and Stockholders' Equity 1.900.00 ACCOUN's Day Contingent liability 1.840.00 Common stock Retsedenas ata o 30 s econ 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 APPARI Increase (Decrease 2022 2021 Amount Assets Cash $ Accounts receivable 3.000.000 1.800.000 300.000 14.700.000 2.800.000) 20.000.000 $ 80.000 1.242.500 1.977.500 14.700.000 (1.400.000) $17.500.000 Budings Less: Accumulated depreciation Total assets Liabilities and Stockholders' Equity $ 5 2.187.50 Accounts payab Contingent liability Common stock 1.020.000 1.340.000 100.000 Retained emings 140.000 To t es and stockho certu