Analysis Project:Trend Calculations

Watch the Horizontal Analysis Calculation video + Vertical Analysis Calculation video posted in the Financial Analysis Project Module prior to starting this activity! Using the 3 financial statements provided for Bed Bath and Beyond to compute horizontal analysis and vertical analysis as indicated in the attached template. Horizontal analysis looks at change over a period of time.... must calculate $ change and % change for each 2 year period. Vertical analysis expresses all rows on the Income Statement as a \% of revenue within a single yearm so you will calculate for 2022,2021, and 2020. On the balance sheet all items are expressed as a \% of total assets within a single year for vertical analysis. It is important to use absolute addressing on the denominator to create your calculation formula, The vertical analysis video explains how to use absolute addressing. Overall, these two techniques provide us a sense of changes, the magnitude of changes, and the pace of the change (faster, slower, etc.) Bed Bath and Bevond FY23.22 complete xsx=