The income statements for Federer Sports Apparel for 2022 and 2021 are presented below. FEDERER SPORTS APPAR
Income Statement
For the Years Ended December 31
Year Increase Decrease
2019 2018 Amount %
Net sales 18,800,000 15,500,000
Cost of goods 13,200,000 7,000,000
Gross prof 5,600,000 8,500,000
Operating expenses 1,600,000 1,200,000
Depreciation expense 1,000,000 1,000,000
Inventory write-down 200,000 0
Loss (litigation) 1,500,000 300,000
Required:
Prepare a horizontal analysis for 2022 using 2021 as the base year.

The horizontal analysis of the Income Statement is the analytical form of preparing the income statement to determine the accurate amount and percentage of changes in each item of the income statement.

The horizontal income statement is attached below.

The horizontal analysis determines the change in the amounts of each account. The percentage change is the division of a change in amount by the base amount of the base year.

In this case, the base year was 2021.

Therefore, the change in amounts will be determined based upon the figures of the base year.

To know more about horizontal analysis, refer to the link:

link

Answer and Explanation:

The Preparation of horizontal analysis for 2022 using 2021 as the base year is prepared with the help of a spreadsheet.

Horizontal analysis is a method for the analysis of financial statements that indicates fluctuations in the amount of the related products over a period of time. It is a valuable instrument for determining trend situations.

So, with the help of the spreadsheet, we will be able to find the net income by using the formulas.

answer; buyer guide;