This link will give u access to the report find the data within it and make the Horizontal Analysis and Vertical Analysis

https://www.bmo.com/ir/archive/en/bmo_ar2022.pdf

Section 1 (10 marks) Complete the Horizontal Analysis for each company.

Horizontal Analysis:

1. Using a spreadsheet, to display a horizontal analysis of the balance sheet. Calculate the increase or decrease in each account from the previous year, in both $ and %.
2. Using a spreadsheet, to display a horizontal analysis of the income statement. Calculate the increase or decrease in each account from the previous year, in both $ and %.

Section 1 (10 marks)

Complete the Vertical Analysis for each company.

Vertical Analysis:

1. Using a spreadsheet, to display a vertical analysis of this year's balance sheet and the previous year's balance sheet. Calculate component % for each B/S account, compute as a % of total assets.
2. Using a spreadsheet, to display a vertical analysis of this year's income statement and the previous year's income statement. Calculate component % for each I/S account, compute as a % of net sales.