Question
. Download the annual report of BCE Inc. for the year ended December 31, 2021 from www.sedar.com 2. Download the annual report of Rogers Communications
. Download the annual report of BCE Inc. for the year ended December 31, 2021 from www.sedar.com 2. Download the annual report of Rogers Communications Inc. for the year ended December 31, 2021 from www.sedar.com 3. Complete the financial statements ratios worksheet contained in Appendix 1 of this assignment. This format must be used. The worksheet has space for you to fill in the financial statement ratio amounts for BCE (Bell) and Rogers. The calculation of these ratios will count for 30 of the 100 marks assigned to this assignment. There is also a 50-word maximum limit for you to fill in a brief interpretation and analysis of the ratio. The interpretation and analysis of the ratios will also count for 30 of the 100 marks assigned to this assignment. Please note that if you exceed the 50-word maximum space limit for your brief interpretation of the ratio, you will receive a maximum mark of satisfactory. You are also required to provide as an appendix a maximum two-page description of how you calculated the final ratios (i.e. supporting calculations). However, it is important to note that markers will only be grading the ratios as correct (full marks) or incorrect (zero marks). 4. Provide an overall recommendation using any information publicly available as of October 31, 2022 on which companys publicly available stock you feel would be the best investment for an investor. This section is limited to 600 words in total and will be worth 20 of the 100 marks assigned to this assignment. Feel free to bring in any other information your research has generated into this section and to use ratios that you were not asked to calculate. Please note that if you exceed the 600-word maximum space limit for your overall recommendation, you will receive a maximum mark of satisfactory. 5. Your final submission should consist of a Microsoft Word readable document containing the following: a. A title page containing the names of your group and the group number assigned to you. b. Appendix 1 of this assignment with all ratios and interpretations completed. Note that when completed Appendix 1 may take several pages. c. A 600-word maximum overall recommendation. d. A two-page maximum set of supporting calculations. e. References. You should submit this final Microsoft Word readable document to the drop box by 10:00 p.m. on November 20, 2022. Failure to follow the formatting guidelines noted above will result in a zero grade. Failure to follow word limits will result in your grade being limited as outlined above. 6. Present your project to the class on the scheduled date. The presentation will be for five minutes followed by two minutes for questions. Your slides should therefore be brief and straight to the point. Consider using tables and graphs to illustrate. All team members must participate. All members will earn the same grade.Appendix 1 Financial Statement Ratios and Evaluations Worksheet Ratio BCE Inc. Ratio Amount Y/E December 31, 2021 Rogers Inc. Ratio Amount Y/E December 31, 2021 Interpretation and Discussion (maximum 50 words per ratio) Working Capital Current Ratio Receivables Turnover Average Collection Period Inventory Turnover Days in Inventory Debt to Total Assets Times Interest Earned Free Cash Flow Profit Margin Assets Turnover Return on Assets Return on Common Shareholders Equity Basic Earnings per Share Price to Earnings Ratio
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started