In this assignment, you will estimate the weighted average cost of capital of a publicly traded company: Telus. Although you must use the most recent stock market data, you should use the 2019 Annual Report for the financial statement information. You are required to follow the instructions outlined below and produce a report in the form of an executive summary, which should be no more than one page long. The report should stand on its own. You must include all your data and formulas as a reference tool to support your Word document. You will probably use Excel for your calculations, so copy your spreadsheet at the bottom of the Word document. Please use a basic copy/paste rather than a picture. In this way your work can receive feedback.

There are 100 marks available for this assignment. See the marking guide below for mark distribution. Make sure to carefully watch the screencast from this module before completing this assignment. Do not forget to properly reference all of your sources and clearly justify any assumptions.

Instructions

To estimate the cost of capital, you will need to estimate the cost of equity of the company using the capital asset pricing model. You need to estimate beta yourself, showing the calculations in the accompanying spreadsheet, the cost of debt, and the appropriate weights to use for each of them. Because data on preferred shares can be difficult to find, you can ignore them for the purposes of this assignment. Does your estimate seem reasonable? Why or why not?

Marking Guide

Professional presentation of your report including referencing (10 marks)

Correct use of CAPM to estimate cost of equity (30 marks)

Appropriate methods used to estimate cost of capital (30 marks)

Discussion of reasonability of your estimate (30 marks)