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 ) of 2 and the Return from the market (R m ) 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 Twitter TWTR N Facebook 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

The Answer is in the image, click to view ...

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 (R_f) of 2% and the Return from the market (R_m) 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
Twitter	TWTR-N
Facebook	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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Can you show the formula for how to do this question in Excel? Find the following Betas for the companies listed below: (use www.globeinvestor.com) Assuming a risk-free rate (Rf) of 2% and the Return...

Find the following Betas for the companies listed below: (use www.globeinvestor.com) Assuming a risk-free rate (R f ) of 2% and the Return from the market (R m ) of 6.5% calculated the expected...

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...

Using spreadsheets to solve complex problems is a key competence in fact a requirement for many middle management positions in the workplace. Corporate finance provides many opportunities to use MS...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

help ACC 215 Financial Report 150 Point Assignment! Step 1: Select your companies. You may pick any two companies - examples are included at the end of this assignment. However, they must be from the...

Master budget My company is Kobe Steel ( the company to use) please read the instructuoon OBJECTIVE: The objective of this individual Financial Management Project is to motivate the students'...

Content what you say (13/15) Professionalism how you say it (1/15) Visual appeal how it looks. (1/15) You should have received an email from me with your assigned company name. You cannot select your...

KINGS OWN INSTITUTE* Success in Higher Education ICT106 DATA COMMUNICATIONS AND NETWORKS T223 Page 1 of 18 AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD ABN: 72 132 629 979 CRICOS 03171A...

Using spreadsheets to solve complex problems is a key competence - in fact a requirement for many middle management positions in the workplace. Corporate finance provides many opportunities to use MS...

2. Determine the vertical displacement at joint B and horizontal displacement at jointD using Castigliano's Second Theorem. The truss is pinned and roller at A and C, respectively. Use, E = 200 GPa...

During 2011, Seagul Outboards sold 200 outboard engines for $250 each. The engines are under a one-year warranty for parts and labor, and from past experience, the company estimates that, on average,...

( 2 5 pts ) You are starting to make a simple game. ( All values should be whole numbers ) ( A ) Write a function named updatescore that has four parameters, a , b , c , and score. If the first three...

Hypothesis Testing of a Single Mean LCTCS Tuition: Louisiana Community And Technical College System consist of 2 community colleges across the state. I think RPCC's tuition and fees is lower than the...

7. What level of proof should be used in this matter? Why? This matter of arbitration stems from an indictment of Thomas Allen for one count of arson first degree and ten counts of burglary in...

6. Should the Union be allowed to provide character witnesses on behalf of Mr. Allen? If so, why? If not, why not? This matter of arbitration stems from an indictment of Thomas Allen for one count of...

2. Distinguish between arrests, indictments, and convictions. This matter of arbitration stems from an indictment of Thomas Allen for one count of arson first degree and ten counts of burglary in...