Question
- Submit your report in MS Excel format. Find the following Betas for the companies listed below: (use www.globeinvestor.com) Assuming a risk-free rate (R f
- Submit your report in MS Excel format.
Find the following Betas for the companies listed below: (use www.globeinvestor.com)
Assuming a risk-free rate (Rf) of 2% and the Return from the market (Rm) of 6.5% calculated the expected return of each company based on the Capital Asset Pricing Model.
Company | Stock Symbol | Beta | Expected Return |
TD Bank | TD-T |
|
|
Royal Bank | RY-T |
|
|
Canadian Tire Corporation | CTC.A-T |
|
|
Suncor Energy | SU-T |
|
|
Sierra Wireless | SW-T |
|
|
| TWTR-N |
|
|
| FB-Q |
|
|
Microsoft | MSFT-Q |
|
|
Apple | AAPL-Q |
|
|
Amazon | AMZN-Q |
|
|
Alphabet Inc. (Google) | GOOGL-Q |
|
|
Starbucks | SBUX-Q |
|
|
Re-order your list from the lowest beta to the highest and compare their expected return.
- Comment on your results. (Hint: Look at the grouping of the companies, and the value of betas from 0 to 0.5, from 0.5 to 1, from 1 to 1.25 and 1.25 and up)
- What does the value of beta tell us about a company? What does the value of beta and CAPM tell us about the risk in investing in a company?
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