Respuesta :
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.
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:
https://brainly.com/question/14698328