Please complete a horizontal and vertical analysis for 2021 and 2020 Balance sheet. Show calculations as well.

(I added examples of horizontal and vertical analysis as well if that's any use when it comes to formatting)

Consolidated Statements of Financial Position (in millions of Canadian dollars) Notes March 28, 2021 $ March 29, 2020 $ 0006 20 6 477.9 40.9 342.3 4.8 31.0 896.9 46.9 116.5 155.0 233.7 53.1 5.1 1,507.2 31.7 32.3 412.3 12.0 43.5 531.8 40.8 115.1 161.7 211.8 53.1 6.0 1,120.3 10 11 12 13 20 Assets Current assets Cash Trade receivables Inventories Income taxes receivable Other current assets Total current assets Deferred income taxes Property, plant and equipment Intangible assets Right-of-use assets Goodwill Other long-term assets Total assets Liabilities Current liabilities Accounts payable and accrued liabilities Provisions Income taxes payable Short-term borrowings Current portion of lease liabilities Total current liabilities Provisions Deferred income taxes Revolving facility Term loan Lease liabilities Other long-term liabilities Total liabilities Shareholders' equity Total liabilities and shareholders' equity 14, 20 15 177.8 20.0 19.1 144.4 15.6 13.0 6 16 12 45.2 262.1 25.6 21.6 35.9 208.9 21.4 15.1 15 6 16 16 12 158.1 192.0 20 367.8 209.6 20.4 907.1 600.1 1,507.2 4.6 600.1 520.2 1,120.3 17 XYZ Corporation Inc. Condensed Balance Sheet December 31 Formula 2016 Amount 2015 Amount % % Assets Current assets Capital assets (net) Total assets $1,020,000 55.6% $ 945,000 59.2% in cell G10 is =F10/$F$12 815,000 44.4% 650,000 40.8% 1,835,000 100.0% 1,595,000 100.0% 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Liabilities Current liabilities Long-term liabilities Total liabilities 344,500 487,500 832,000 18.8% 26.6% 45.3% 303,000 497,000 800,000 19.0% 31.2% 50.2% in cell E15 is =D15/$D$11 Shareholders' Equity Common shares 275,400 15.0% 270,000 16.9% Retained earnings 727,600 39.7% 525,000 32.9% Total shareholders' equity 1,003,000 54.7% 795,000 49.8% Total liabilities and shareholders' equity $1,835,000 100.0% $1,595,000 100.0% Formula in cell F9 is =D9-E9 in cell G11 is =F11/E11 2 XYZ Corporation Inc. 3 Condensed Balance Sheet 4 December 31 5 Increase (Decrease) 6 during 2016 7 2016 2015 Amount % 8 Assets 9 Current assets $1,020,000 $ 945,000 $ 75,000 7.9% 10 Capital assets (net) 815,000 650,000 165,000 25.4% 11 Total assets $1,835,000 $1,595,000 $ 240,000 15.0% 12 13 Liabilities 14 Current liabilities $ 344,500 $ 303,000 $ 41,500 13.7% 15 Long-term liabilities 487,500 497,000 (9,500) -1.9% 16 Total liabilities 832,000 800,000 32,000 4.0% 17 18 Shareholders' Equity 19 Common shares 275,400 270,000 5,400 2.0% 20 Retained earnings 727 600 525,000 202,600 38.6% 21 Total shareholders' equity 1,003,000 795,000 208,000 26.2% 22 Total liabilities and shareholders' equity $1,835,000 $1,595,000 $ 240,000 15.0%