Step 1: Download the 2019 Annual Report from the companys 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 companys consolidated balance sheets and consolidated statements of operations (i.e., income statement) into an Excel workbook.

Step 2: Calculate the following ratios for the past 2 fiscal years. You must clearly show the calculations and should not download pre-calculated ratios from another source. I included an example for the current ratio in the Excel spreadsheet referenced above that you can follow for the other ratios. Once your ratios are complete, please copy the ratios from your spreadsheet to your Word document. Use a basic copy/paste so that you can get feedback on your answers. Do not copy as a picture. (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

Total debt ratio

Return on assets

Return on equity

Interest coverage ratio

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 look, not just at 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 comments and your analysis. You will be assessed on correct use of financial statement analysis tools from the course material, providing thoughtful analysis that draws on 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 quality differ in those two roles? (20 marks)