Vertical Analysis a) Using a spreadsheet, prepare a vertical analysis of the most current year's balance sheet and the previous year's balance sheet. Calculate component % for each B/S account, compute as a % of total assets. b) Using a spreadsheet, prepare a vertical analysis of the most current year's income statement and the previous year's income statement. Calculate component % for each I/S account, compute as a % of net sales.