Find the ratio analysis for the following years 2020 and 2021. If possible do it in an excel sheet.
Requirements: -
| Earning per share |
| Price Earning ratio |
| Dividend Payout ratio |
| Dividend Yield ratio |
| Return on assets |
| Return on equity |
| Book Value Per Share |
| Financial Leverage |
| Working Capital |
| Current ratio |
| Acid test ratio |
| Receivables turnover |
| Average Collection Period |
| Inventory turnover |
| Average Sales Period |
| Asset turnover |
| Time Interest Earned |
| Debt to equity |
| Net profit to sales |
Consolidated Statements of income and comprehensive Income On millions of Canadian dollars. concept per share amounts) Yes March 28, March 20, M Notes 2021 2020 $ Revenue 5 503.7 958.1 Cost of sales 9 349.7 3648 Gross profit 5540 5033 Selling general and administrative expenses 367.3 3505 Depreciation and more 10, 11, 12 507 Operating income 116.9 1921 Net interest, finance and other costs 15 30.9 28.4 Income before income taxes BE 1637 Income tax expense 6 15.8 120 Net Income 70.2 151.7 Other comprehensive income Herre that will not be reclassified teaming net of tax Actual gainonposampeyan obligation 07 402) Here at may be read to cart oft Cumartersation austment (126) 94 Netloss on the designed How hedges 21 (12) (24) Reclassification of net toesign) on cash tow hedge to come 21 73 3.79 Nel pinoon derives designated as a no investment hedge 21 02 10.3) Other comprehensive (loss) income 15.6) 28 Comprehensive income 5 Earnings per share Bask 5 0.54 5 1385 Diluted 0.63 $ 15 The accompanying notes to the consolidated Instant Integral part financial statements Consolidated Statements of Changes in Equity in millions of Cardun dollars) Accu other Contributed Ride Share capital surplus carming income Total - Malipie Subordas Neshares hawa 3 5 5 Beat Marat 10 labi. wines 17 Dawo se + 06 OS Eche fare US 13 NON Oro PP 0.1 sro Sovery 12 Rance 200 14 2 1126 21 16 ws 12 - Nacoger teaser ES 11 14 T. Cacheco 11 23 - 24 NO SI Ofer 20 22 Burbe TA Wence Man 2120 1 1 040 Free 16 10 NOW POL TO2 O corpo - Share Manh 11 30 The accompanying notes to the code fonctions are an integral part of these financial statements Consolidated Statement of Financial Position in millions of Canadian dollars) March 28 March 20 Notes 2021 2020 Assets Current asset: Cash 477.9 31.7 Trade receivables 8 40.9 323 9423 4123 Income taxes receivable 6 4.8 120 Other current assets 20 31,0 43.5 Total current assets 896.9 5310 Deferred income tans 8 489 408 Property plant andre 10 1185 115.1 Intangible assets 11 1550 1617 Right- 12 27 2118 Good 13 531 531 Omer forglemmel 20 5.1 00 Total asets 1.5072 1.120.3 Liabilities Current liabilities Accounts payable and accredits 14, 20 1778 1444 Provisions 55 20.0 155 Income be patie 8 991 130 Short-term borrowings 55 Current portion of leases 12 452 359 Total current abilities 2821 2009 Provisions 55 255 214 Deferred income taxes 8 215 151 Revolving facility 16 Termom 18 3578 1561 Lease 12 2095 1920 Omer long-term brides 20 204 46 Total liabilities 907.1 600.1 Shareholders' equity 17 600.1 5202 Total liabilities and shareholders' equity 15672 10205 The accompanying notes to the consolidated financialmente integral part of these financiers BE . = 44 44 Consolidated Statements of Cash Flows in milions of Canadian dollars) Year ended March 21 March 28, March 31, Notes 2021 2020 2016 $ Operating atitis Notice 702 1617 143.6 er not afecting Depreciation and testin 10, 11, 12 84 631 222 home repense 5 9 158 520 380 aper 18 207 204 Forexchanges 0 IT) 27 Acceleration of named costs on ostings 15 1.1 7.0 Lots on disposal of assets 03 17 02 Shared payment 18 113 85 38 2190 237 2256 Canging on non cash 22 1025 120.61 (1007) Income ad 16.8 (521) (41.00 tored (210) (18.51 (105) Nutcash from operating activities 2907 625 73.4 Investing activities Purchase of property, plant and equipment 10 (289 445.3) (30.3) mestreiningas 11 15.11 (17.01 (19.09 Business mention 336 Net cashed in investing activities 2 12.01 623 82.99 Financing activities Tarm loans 18 2475 Transactions on anong advies 16 10. ) 12.31 Subordinate voting the purchased for Canon 17 (38.71 Pindalones 12 (38) 24.) Settlement of termen dative contradas 20 149 40 Excise of stock options 18 40 24 3.1 Net cash from used in financing activities ERTO 158 21 an Effects of foreign currency exchange rate changes (125 18 10:33 Ford 4462 56. 167 Cash, beginning of period 317 BB 053 Cash, end of period 21.7 6 The accompanying not to consolidated financial statements are an integral part of these francis Consolidated Statements of income and comprehensive Income On millions of Canadian dollars. concept per share amounts) Yes March 28, March 20, M Notes 2021 2020 $ Revenue 5 503.7 958.1 Cost of sales 9 349.7 3648 Gross profit 5540 5033 Selling general and administrative expenses 367.3 3505 Depreciation and more 10, 11, 12 507 Operating income 116.9 1921 Net interest, finance and other costs 15 30.9 28.4 Income before income taxes BE 1637 Income tax expense 6 15.8 120 Net Income 70.2 151.7 Other comprehensive income Herre that will not be reclassified teaming net of tax Actual gainonposampeyan obligation 07 402) Here at may be read to cart oft Cumartersation austment (126) 94 Netloss on the designed How hedges 21 (12) (24) Reclassification of net toesign) on cash tow hedge to come 21 73 3.79 Nel pinoon derives designated as a no investment hedge 21 02 10.3) Other comprehensive (loss) income 15.6) 28 Comprehensive income 5 Earnings per share Bask 5 0.54 5 1385 Diluted 0.63 $ 15 The accompanying notes to the consolidated Instant Integral part financial statements Consolidated Statements of Changes in Equity in millions of Cardun dollars) Accu other Contributed Ride Share capital surplus carming income Total - Malipie Subordas Neshares hawa 3 5 5 Beat Marat 10 labi. wines 17 Dawo se + 06 OS Eche fare US 13 NON Oro PP 0.1 sro Sovery 12 Rance 200 14 2 1126 21 16 ws 12 - Nacoger teaser ES 11 14 T. Cacheco 11 23 - 24 NO SI Ofer 20 22 Burbe TA Wence Man 2120 1 1 040 Free 16 10 NOW POL TO2 O corpo - Share Manh 11 30 The accompanying notes to the code fonctions are an integral part of these financial statements Consolidated Statement of Financial Position in millions of Canadian dollars) March 28 March 20 Notes 2021 2020 Assets Current asset: Cash 477.9 31.7 Trade receivables 8 40.9 323 9423 4123 Income taxes receivable 6 4.8 120 Other current assets 20 31,0 43.5 Total current assets 896.9 5310 Deferred income tans 8 489 408 Property plant andre 10 1185 115.1 Intangible assets 11 1550 1617 Right- 12 27 2118 Good 13 531 531 Omer forglemmel 20 5.1 00 Total asets 1.5072 1.120.3 Liabilities Current liabilities Accounts payable and accredits 14, 20 1778 1444 Provisions 55 20.0 155 Income be patie 8 991 130 Short-term borrowings 55 Current portion of leases 12 452 359 Total current abilities 2821 2009 Provisions 55 255 214 Deferred income taxes 8 215 151 Revolving facility 16 Termom 18 3578 1561 Lease 12 2095 1920 Omer long-term brides 20 204 46 Total liabilities 907.1 600.1 Shareholders' equity 17 600.1 5202 Total liabilities and shareholders' equity 15672 10205 The accompanying notes to the consolidated financialmente integral part of these financiers BE . = 44 44 Consolidated Statements of Cash Flows in milions of Canadian dollars) Year ended March 21 March 28, March 31, Notes 2021 2020 2016 $ Operating atitis Notice 702 1617 143.6 er not afecting Depreciation and testin 10, 11, 12 84 631 222 home repense 5 9 158 520 380 aper 18 207 204 Forexchanges 0 IT) 27 Acceleration of named costs on ostings 15 1.1 7.0 Lots on disposal of assets 03 17 02 Shared payment 18 113 85 38 2190 237 2256 Canging on non cash 22 1025 120.61 (1007) Income ad 16.8 (521) (41.00 tored (210) (18.51 (105) Nutcash from operating activities 2907 625 73.4 Investing activities Purchase of property, plant and equipment 10 (289 445.3) (30.3) mestreiningas 11 15.11 (17.01 (19.09 Business mention 336 Net cashed in investing activities 2 12.01 623 82.99 Financing activities Tarm loans 18 2475 Transactions on anong advies 16 10. ) 12.31 Subordinate voting the purchased for Canon 17 (38.71 Pindalones 12 (38) 24.) Settlement of termen dative contradas 20 149 40 Excise of stock options 18 40 24 3.1 Net cash from used in financing activities ERTO 158 21 an Effects of foreign currency exchange rate changes (125 18 10:33 Ford 4462 56. 167 Cash, beginning of period 317 BB 053 Cash, end of period 21.7 6 The accompanying not to consolidated financial statements are an integral part of these francis
