Question
The balance sheets for Federer Sports Apparel for 2022 and 2021 are presented below. 1. Prepare a vertical analysis of the balance sheet data for
The balance sheets for Federer Sports Apparel for 2022 and 2021 are presented below.
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.)
Table for #1:
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.)
Table for #2:
(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 Amount % 2021 Amount % Assets $ 2,300,000 1,500,000 2,800,000 11,000,000 (2,000,000) $ 15,600,000 $ 800,000 1,200,000 1,700,000 11,000,000 (1,000,000) $ 13,700,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,700,000 $ 1,450,000 1,500,000 8,000,000 4,650,000 $ 15,600,000 8,000,000 4,000,000 $ 13,700,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 Cash Accounts receivable $ 2,300,000 $ 800,000 1,500,000 1,200,000 2,800,000 1,700,000 11,000,000 11,000,000 (2,000,000) (1,000,000) $ 15,600,000 $ 13,700,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,450,000 $ 1,700,000 1,500,000 8,000,000 8,000,000 4,650,000 4,000,000 $ 15,600,000 $ 13,700,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started