Here is the link to the annual report use this to make the report : https://www.bmo.com/ir/archive/en/bmo_ar2022.pdf Section

Here is the link to the annual report use this to make the report:

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

Transcribed Image Text:

Section 1 (10 marks) Complete the Horizontal Analysis for each company. Horizontal Analysis: 1. Using a spreadsheet, create 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, create 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, create 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, create 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. Section 1 (10 marks) Complete the Horizontal Analysis for each company. Horizontal Analysis: 1. Using a spreadsheet, create 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, create 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, create 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, create 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.