Please do the followings using excel:

a) liquidity and capital structure.

b) Calculate operating leverage for the firm for the previous 4 years.

Note: if you don't find information on the given pictures, you can assume numbers and do the maths.

Year Ending Jan 2022 (Update) Year Ending Jan 2021 (Restated) Year Ending lan 2020 (Update) Year Ending jan 2019 (Update) 3560.300 3509.417 3343.513 4075 156 3560.306 3509.417 3343.513 4075. 156 3560.306 3509.417 3343.513 4075.156 3219.056 3161.189 3029.24 3703.58 3219.056 3161.189 3029.244 3703.58 34125 348.228 314.269 371 576 309.599 308.998 288.926 296.098 309.599 208.925 24.270 25.158 21.99 8.515 3.415 3.419 5.268 5.007 27.691 28.577 27.258 13.522 108.98 1547 -29.169 1.143 - 1.072 1.647 -29.369 1.143 -1.072 1 title 2 Net Sales 3 Revenue 4 Total Revenue 5 Cost of Revenue 6 Cost of Revenue, Total 7 Gross Profit & Selling/General/Administrative Expense 9 Selling/General/Admin Expenses, Total 10 Depreciation 11 Amortization of Intangibles 12 Depreciation/Amortization 13 Restructuring Charge 14 Litigation 15 Impairment Assets Held for Use 16 Loss(Gain) on Sale of Assets - Operating 17 Other Unusual Expense (Income) 18 Unusual Expense (income) 19 other, Net 20 Other Operating Expenses. Total 21 Total Operating Expense 22 Operating income 23 Interest Expense. Non-Operating 24 Interest Expense, Net Non-Operating 25 Interest Income. Non-Operating 25 Interest Income - Non-Operating 26 Investment income. Non-Operating 27 Interest/invest income. Non-Operating 28 Interest Inc. Exp. Net Non-Op. Total 29 Net Income Before Taxes 30 Provision for Income Taxes 31 Net Income After Taxes 32 Minority interest 33 Net Income Before Extra.Items 34 Discontinued Operations 35 Total Extraordinary Items 36 Net Income 37 Income Available to Com Excl Extraord 38 Income Available to Com Incl Extraord 39 Basic Weighted Average Shares 40 Basic EPS Excluding Extraordinary Items 41 Basic EPS including Extraordinary Items 3557.993 2.313 -10.841 -10.641 3469.395 40.022 -11.825 - 11.825 3346.571 -3.058 - 13.443 -11.40 2012. 125 63.028 -11 846 -11 845 0.221 0.221 -10.62 -8.307 -1.971 -6.336 -0.903 -7.239 0.362 0.362 -11.463 28.559 -16.46 45,019 0.741 0.741 -12.702 -15.78 0.776 0.776 -11.07 51.958 14.917 37.041 -11.457 -0.863 -1233 -0.5 43.529 36.52 -7.239 -7.239 -7.239 988.392 -0.00732 -0.00732 43.529 43.529 43.529 986.437 0.04413 0.04413 -12 33 -12-13 -12 33 974.769 -0.01265 -0.01265 36.52 36.52 36.52 965.331 0.01783 0.03783 4509 6.336 -0.903 -7.239 140/ -0.863 -12 33 ST. -0.521 36.52 43.529 -7.239 -7.239 -7.239 988.392 -0.00732 -0.00732 43.529 43.529 43.529 986.437 0.04413 0.0443 -12.33 -12.33 -12 33 974.769 -0.01265 -0.01265 36.52 36.52 36.52 965.331 0.01783 0.03783 -7.239 988.392 -0.00732 -0.00732 0.02 43.529 1017.749 0.04277 0.04277 0.01 0 3.687 3.687 14.716 -12.33 974.769 -0.01265 -0.01265 0.01 10.594 -4.261 -4.261 39.662 36.52 1010.875 0.03613 0.03613 0.035 37.093 0.36) 0.863 13.115 1.363 1.36) 11.736 31 Net Income After lakes 32 Minority interest 33 Net Income Before Extra.Items 34 Discontinued Operations 35 Total Extraordinary Items 36 Net Income 37 Income Available to Com Excl Extraord 38 Income Available to Com Incil Extraord 39 Basic Weighted Average Shares 40 Basic EPS Excluding Extraordinary Items 41 Basic EPS Including Extraordinary Items 42 Dilution Adjustment 43 Diluted Net Income 44 Diluted Weighted Average Shares 45 Diluted EPS Excluding Extraord Items 46 Diluted EPS including Extraord items 47 DPS - Common Stock Primary Issue 48 Gross Dividends - Common Stock 49 Litigation Charge, Supplemental 49 Litigation Charge. Supplemental 50 Restructuring Charge, Supplemental 51 Other Unusual Expense income), Suppl. 52 Non-Recurring items, Supplemen Total 53 Total Special items 54 Normalized Income Before Taxes 55 Effect of Special Items on Income Taxes 56 Inc Tax Ex impact of Sp items 57 Normalized Income After Taxes 58 Normalized inc. Avail to Com. 59 Basic Normalized EPS 60 Diluted Normalized EPS 61 Amort of Intangibles, Supplemental 62 Depreciation, Supplemental 63 Interest Expense, Supplemental 64 Rental Expense, Supplemental 65 Stock-Based Compensation, Supplemental 66 Equity in Affiliates, Supplemental 67 Minority Interest, Supplemental 68 Audit Fees 69 Audit Related Fees 70 Tax Fees 71 Gross Margin 72 Operating Margin 73 Pretax Marin 13.099 14.766 6.439 5.1611 3.1901 2.3459 0.00237 0.00237 3.415 240.276 10.341 2.277 -0.012 18.403 -10.900 17.593 -3.8381 -20.2981 37.8911 36.4011 0.0369 0.03577 3.419 25.158 11.625 3.231 35.401 36.544 20.784 -11.899 -16.192 36.926 36. 113 0.03705 0.03705 5.268 21.99 13.44) 2.412 1.691 13.978 12.905 64.864 -4.194 10.723 54.141 53.62 0.05555 0.05304 5.007 8.515 11.84 13.147 2.278 0.86 -0.903 0.437 0.0015 -1.49 0.3872 0.028 -0.36) 0.3872 0.02528 -0.521 0.38 0.136 9.58485 0.06497 -0.23332 9.92267 1.14042 0.81378 9.39937 -0.09146 -0.47136 9.1180 1.54664 1.27499 15 -0.23332 -0.47136 73 Pretax Margin 74 Effective Tax Rate 7s Net Profit Margin 76 Normalized EBIT 77 Normalized EBITDA 78 Current Tax - Domestic 79 Current Tax Other 80 Current Tax - Total 81 Deferred Tax. Domestic 82 Deferred Tax - Total 83 Deferred Tax - Total 54 Other Tax 85 Income Tax - Total 36 Defined Contribution Expense - Domestic 87 Total Pension Expense -0.20333 17.059 44.75 7.563 0.151 7.714 0.81378 -57.63507 1 24035 29.056 57.633 2.778 -1.381 1.397 -0.36877 33.46 60.744 -3.273 -0.339 -3.612 1.27499 28.70973 0.89616 75.934 89.456 15.217 -0.95 14.267 -9.685 -9.685 -17.857 - 17.857 -0.651 -0.681 0.65 0.65 -1.971 -16.46 -4.293 14.917 Year Ending Jan 2022 (Update) Year Ending Jan 2021 (Restated) Year Ending lan 2020 (Update) Year Ending jan 2019 (Update) 3560.300 3509.417 3343.513 4075 156 3560.306 3509.417 3343.513 4075. 156 3560.306 3509.417 3343.513 4075.156 3219.056 3161.189 3029.24 3703.58 3219.056 3161.189 3029.244 3703.58 34125 348.228 314.269 371 576 309.599 308.998 288.926 296.098 309.599 208.925 24.270 25.158 21.99 8.515 3.415 3.419 5.268 5.007 27.691 28.577 27.258 13.522 108.98 1547 -29.169 1.143 - 1.072 1.647 -29.369 1.143 -1.072 1 title 2 Net Sales 3 Revenue 4 Total Revenue 5 Cost of Revenue 6 Cost of Revenue, Total 7 Gross Profit & Selling/General/Administrative Expense 9 Selling/General/Admin Expenses, Total 10 Depreciation 11 Amortization of Intangibles 12 Depreciation/Amortization 13 Restructuring Charge 14 Litigation 15 Impairment Assets Held for Use 16 Loss(Gain) on Sale of Assets - Operating 17 Other Unusual Expense (Income) 18 Unusual Expense (income) 19 other, Net 20 Other Operating Expenses. Total 21 Total Operating Expense 22 Operating income 23 Interest Expense. Non-Operating 24 Interest Expense, Net Non-Operating 25 Interest Income. Non-Operating 25 Interest Income - Non-Operating 26 Investment income. Non-Operating 27 Interest/invest income. Non-Operating 28 Interest Inc. Exp. Net Non-Op. Total 29 Net Income Before Taxes 30 Provision for Income Taxes 31 Net Income After Taxes 32 Minority interest 33 Net Income Before Extra.Items 34 Discontinued Operations 35 Total Extraordinary Items 36 Net Income 37 Income Available to Com Excl Extraord 38 Income Available to Com Incl Extraord 39 Basic Weighted Average Shares 40 Basic EPS Excluding Extraordinary Items 41 Basic EPS including Extraordinary Items 3557.993 2.313 -10.841 -10.641 3469.395 40.022 -11.825 - 11.825 3346.571 -3.058 - 13.443 -11.40 2012. 125 63.028 -11 846 -11 845 0.221 0.221 -10.62 -8.307 -1.971 -6.336 -0.903 -7.239 0.362 0.362 -11.463 28.559 -16.46 45,019 0.741 0.741 -12.702 -15.78 0.776 0.776 -11.07 51.958 14.917 37.041 -11.457 -0.863 -1233 -0.5 43.529 36.52 -7.239 -7.239 -7.239 988.392 -0.00732 -0.00732 43.529 43.529 43.529 986.437 0.04413 0.04413 -12 33 -12-13 -12 33 974.769 -0.01265 -0.01265 36.52 36.52 36.52 965.331 0.01783 0.03783 4509 6.336 -0.903 -7.239 140/ -0.863 -12 33 ST. -0.521 36.52 43.529 -7.239 -7.239 -7.239 988.392 -0.00732 -0.00732 43.529 43.529 43.529 986.437 0.04413 0.0443 -12.33 -12.33 -12 33 974.769 -0.01265 -0.01265 36.52 36.52 36.52 965.331 0.01783 0.03783 -7.239 988.392 -0.00732 -0.00732 0.02 43.529 1017.749 0.04277 0.04277 0.01 0 3.687 3.687 14.716 -12.33 974.769 -0.01265 -0.01265 0.01 10.594 -4.261 -4.261 39.662 36.52 1010.875 0.03613 0.03613 0.035 37.093 0.36) 0.863 13.115 1.363 1.36) 11.736 31 Net Income After lakes 32 Minority interest 33 Net Income Before Extra.Items 34 Discontinued Operations 35 Total Extraordinary Items 36 Net Income 37 Income Available to Com Excl Extraord 38 Income Available to Com Incil Extraord 39 Basic Weighted Average Shares 40 Basic EPS Excluding Extraordinary Items 41 Basic EPS Including Extraordinary Items 42 Dilution Adjustment 43 Diluted Net Income 44 Diluted Weighted Average Shares 45 Diluted EPS Excluding Extraord Items 46 Diluted EPS including Extraord items 47 DPS - Common Stock Primary Issue 48 Gross Dividends - Common Stock 49 Litigation Charge, Supplemental 49 Litigation Charge. Supplemental 50 Restructuring Charge, Supplemental 51 Other Unusual Expense income), Suppl. 52 Non-Recurring items, Supplemen Total 53 Total Special items 54 Normalized Income Before Taxes 55 Effect of Special Items on Income Taxes 56 Inc Tax Ex impact of Sp items 57 Normalized Income After Taxes 58 Normalized inc. Avail to Com. 59 Basic Normalized EPS 60 Diluted Normalized EPS 61 Amort of Intangibles, Supplemental 62 Depreciation, Supplemental 63 Interest Expense, Supplemental 64 Rental Expense, Supplemental 65 Stock-Based Compensation, Supplemental 66 Equity in Affiliates, Supplemental 67 Minority Interest, Supplemental 68 Audit Fees 69 Audit Related Fees 70 Tax Fees 71 Gross Margin 72 Operating Margin 73 Pretax Marin 13.099 14.766 6.439 5.1611 3.1901 2.3459 0.00237 0.00237 3.415 240.276 10.341 2.277 -0.012 18.403 -10.900 17.593 -3.8381 -20.2981 37.8911 36.4011 0.0369 0.03577 3.419 25.158 11.625 3.231 35.401 36.544 20.784 -11.899 -16.192 36.926 36. 113 0.03705 0.03705 5.268 21.99 13.44) 2.412 1.691 13.978 12.905 64.864 -4.194 10.723 54.141 53.62 0.05555 0.05304 5.007 8.515 11.84 13.147 2.278 0.86 -0.903 0.437 0.0015 -1.49 0.3872 0.028 -0.36) 0.3872 0.02528 -0.521 0.38 0.136 9.58485 0.06497 -0.23332 9.92267 1.14042 0.81378 9.39937 -0.09146 -0.47136 9.1180 1.54664 1.27499 15 -0.23332 -0.47136 73 Pretax Margin 74 Effective Tax Rate 7s Net Profit Margin 76 Normalized EBIT 77 Normalized EBITDA 78 Current Tax - Domestic 79 Current Tax Other 80 Current Tax - Total 81 Deferred Tax. Domestic 82 Deferred Tax - Total 83 Deferred Tax - Total 54 Other Tax 85 Income Tax - Total 36 Defined Contribution Expense - Domestic 87 Total Pension Expense -0.20333 17.059 44.75 7.563 0.151 7.714 0.81378 -57.63507 1 24035 29.056 57.633 2.778 -1.381 1.397 -0.36877 33.46 60.744 -3.273 -0.339 -3.612 1.27499 28.70973 0.89616 75.934 89.456 15.217 -0.95 14.267 -9.685 -9.685 -17.857 - 17.857 -0.651 -0.681 0.65 0.65 -1.971 -16.46 -4.293 14.917