3 4 5 6 7 8 9 10 11 12 13 14 Canadian Tire 15 Home Depot 16 Walmart Inc. 17 18 19 20 21 Canadian Tire 22 Home Depot 23 Walmart Inc. 24 25 26 27 28 29 30 31 32 33 34 35 36 Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Gross Profit Margin 12-2022 34.24% 33.63% 25.10% Net Profit Margin 12-2022 5.86% 10.87% 2.39% Current Ratio 12-2022 1.61 1.01 0.93 Quick Ratio 12-2021 35.82% 33.95% 24.83% 12-2022 1.16 0.24 0.28 12-2021 6.92% 9.74% 2.42% 12-2021 1.72 1.23 0.97 12-2021 1.35 0.51 0.49 12-2020 34.14% 34.09% 24.69% 12-2020 5.06% 10.20% 2.84% 12-2020 2.03 1.08 0.79 12-2020 1.58 0.29 0.22 Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Debt Ratio 12-2022 68.2% 102.4% 62.5% Equity Ratio 12-2022 25.4% -2.4% 37.5% 12-2021 70.1% 95.3% 65.3% 2.7 -43.38 1.66 12-2021 23.5% 4.7% 34.7% Debt to Equity Ratio 12-2022 12-2021 3.0 20.39 1.88 Return on Equity (ROE %) 12-2022 19.4% 20.50 15.24% 12-2021 23.4% 140.61 15.98% 12-2020 71.4% 106.1% 65.5% 12-2020 22.1% -6.1% 34.5% 12-2020 3.2 -17.44 1.90 12-2020 17.3% -4.50 18.46% Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Return on Assets (ROA%) 12-2022 4.8% 23.1% 5.5% Asset Turnover 12-2022 0.81 2.1 2.3 18 15.59 4.9 12-2021 5.3% 21.1% 5.5% Earnings per Share (EPS) 12-2022 12-2021 0.77 2.2 2.3 4.1 5.2 8.5 12-2021 19 11.98 4.77 Inventory Turnover 12-2022 12-2021 4.4 5.6 9.4 12-2020 3.8% 23.6% 6.5% 12-2020 0.75 2.3 2.3 12-2020 12 10.29 5.22 12-2020 4.3 5.1 8.9 Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Inventory Turnover in days 12-2022 89 70 43 Cash Flow to current debt 12-2022 0.08 0.56 0.32 12-2021 84 65 39 0.04 0.21 0.18 Cash Flow to total debt 12-2022 12-2021 0.30 0.80 0.28 0.03 0.10 0.05 12-2021 0.12 0.27 0.15 Cash Flow return on sales 12-2022 12-2021 0.11 0.13 0.04 12-2020 84 71 41 12-2020 0.45 1.07 0.46 12-2020 0.17 0.38 0.24 12-2020 0.16 0.17 0.07 Canadian Tire Home Depot Walmart Inc. Canadian Tire Home Depot Walmart Inc. Cash Flow per share 12-2022 -0.46 127.7 43.42 12-2021 1.74 157.4 39.27 Receivables turnover 12-2022 2.56 47.10 77.4 12-2021 2.60 51.83 87.4 12-2020 3.36 184.0 90.88 12-2020 2.33 54.54 83.4 Create an Infographic (visual representation of data) of the most important indicators of the financial position and performance of Canadian Tire. Showcase how the company performed relative to its peers. Infographic Guidelines: Use any software to create your Infographic Clearly indicate the name of the company you have chosen and the industry it operates in; Use a variety of text and graphics to represent your data Creating your own graphs from data is required. Do not copy and paste from the internet. Submit your Google Sheets link to show your graph data. Divide your Infographic into categories: -Sample categories include but not limited to: ratios, trend analysis, comparison to other organizations in the same industry; -Note 1: focus the analysis of your organization on the: ability to make a profit, collect receivables, use of capital assets, shareholders' equity and how revenue is generated; -Note 2: ensure that you use a mix of ratios including EPS, and provide some analysis of Shareholders' Equity. Include calculations in a separate sheet.