Answer the following questions

\f1i."erl:ini:all Analysis a} Using a spreadsheet, prepare a vertical analysis ofthe most current 1vear's balance sheet and the previous year's balance sheet. Calculate component 96 for each BIS account, compute as a t? of total assets. b] Using a spreadsheet, prepare a vertical analvsis of the most current vear's income statement and the previous year's income statement. Calculate component 913 for each IKE account, compute as a '36 of net sales. Sheet 2: Horizontal Analysis - use accounts that are applicable to your company: ie. Revenue, etc. - Use CONSOLIDATED statements not condensed statement: 3} Using a spreadsheet, prepare a horizontal analysis of the balance sheet. Calculate the increase or decrease in each account from the previous year, in both 5 and 5%. b] Using a spreadsheet, prepare a horizontal analysis of the income statement. Calculate the increase or decrease in each account from the previous year, in both 5 and 5:3