Below is the supporting data:

In this assignment, you will be performing some financial statement analyses on a publicly traded company: Telus. You are required to follow the steps submitted in a pdf document. So you should have 1 pdf file plus 1 Excel file for your submission. There are 100 marks available for this assignment. See the steps below for mark distribution. Make sure to clearly explain your work so that your Learning Faculty Member can give feedback. You may get partial marks, even if your final answer is incorrect. Instructions Step 1: Download the 2019 Annual Report from the company's website. Since some companies issue financials in both Canadian and US dollars following different accounting rules (e.g., IFRS vs. US-GAAP), make sure to download the statements using Canadian dollars. Transfer the company's consolidated balance sheets and consolidated statements of operations (i.e., income statement) into an Excel workbook. Note that the annual is a bit tough to read, especially if you haven't taken an accounting course in a while. You can find the numbers that you need in the consolidated financial statements starting on page 124. Step 2: Calculate the following ratios for the past 2 fiscal years. You must clearly show the calculations in your spreadsheet and should not download precalculated ratios from another source. (25 marks) - Current ratio - Quick ratio - Inventory turnover - Days of inventory on hand - Accounts receivable turnover - Average collection period - Asset turnover - Gross profit margin - Net profit margin Step 3: Perform a 3-stage DuPont analysis. Note that this needs appropriate analysis, not just a calculation. (15 marks) Step 4: Comment on any areas of strength or weakness of the company, based on your results of Steps 2 and 3 above. Make sure to loke absolute levels, but also trends over time in solvency, liquidity, profitability, and asset management ratios (20 marks). Step 5: Compare your results with the management discussion and analysis in the annual report. Examine any differences between their comment the theories discussed in the course as well as links to what is happening with Telus in the current market. (20 marks) Step 6: Explain whether there would be any difference to your analysis if you were an investor or if you were the CFO. How would the data in those two roles? (20 marks) CONSOLIDATED STATEMENTS OF INCOME AND OTHER COMPREHENSIVE INCOME CONSOLIDATED STATEMENTS OF FINANCIAL POSITION CONSOLIDATED STATEMENTS OF CHANGES IN OWNERS' EQUITY CONSOLIDATED FINANCIAL STATEMENTS CONSOLIDATED STATEMENTS OF CASH FLOWS In this assignment, you will be performing some financial statement analyses on a publicly traded company: Telus. You are required to follow the steps submitted in a pdf document. So you should have 1 pdf file plus 1 Excel file for your submission. There are 100 marks available for this assignment. See the steps below for mark distribution. Make sure to clearly explain your work so that your Learning Faculty Member can give feedback. You may get partial marks, even if your final answer is incorrect. Instructions Step 1: Download the 2019 Annual Report from the company's website. Since some companies issue financials in both Canadian and US dollars following different accounting rules (e.g., IFRS vs. US-GAAP), make sure to download the statements using Canadian dollars. Transfer the company's consolidated balance sheets and consolidated statements of operations (i.e., income statement) into an Excel workbook. Note that the annual is a bit tough to read, especially if you haven't taken an accounting course in a while. You can find the numbers that you need in the consolidated financial statements starting on page 124. Step 2: Calculate the following ratios for the past 2 fiscal years. You must clearly show the calculations in your spreadsheet and should not download precalculated ratios from another source. (25 marks) - Current ratio - Quick ratio - Inventory turnover - Days of inventory on hand - Accounts receivable turnover - Average collection period - Asset turnover - Gross profit margin - Net profit margin Step 3: Perform a 3-stage DuPont analysis. Note that this needs appropriate analysis, not just a calculation. (15 marks) Step 4: Comment on any areas of strength or weakness of the company, based on your results of Steps 2 and 3 above. Make sure to loke absolute levels, but also trends over time in solvency, liquidity, profitability, and asset management ratios (20 marks). Step 5: Compare your results with the management discussion and analysis in the annual report. Examine any differences between their comment the theories discussed in the course as well as links to what is happening with Telus in the current market. (20 marks) Step 6: Explain whether there would be any difference to your analysis if you were an investor or if you were the CFO. How would the data in those two roles? (20 marks) CONSOLIDATED STATEMENTS OF INCOME AND OTHER COMPREHENSIVE INCOME CONSOLIDATED STATEMENTS OF FINANCIAL POSITION CONSOLIDATED STATEMENTS OF CHANGES IN OWNERS' EQUITY CONSOLIDATED FINANCIAL STATEMENTS CONSOLIDATED STATEMENTS OF CASH FLOWS