Find the beta for amazon

Assignment Help HR Management
Reference no: EM133109571

The excel file 'Question 2_Stock Prices CW 2021' contains the monthly stock prices for Amazon (the technology company) as well as the value of the S&P 500 index over the period 30/05/1997 to 30/09/2019. Excel functions STDEV, VAR, COVAR, and CORREL are especially useful for answering the questions below.

a) Calculate the monthly returns for the S&P 500 index and for Amazon. Find the beta for Amazon. Interpret the value that you have found for Amazon's beta.

b) Forecast the expected return for Amazon using the CAPM model and assuming that the return on the market is 3.8% and the risk-free rate is 1.5%.

c) Suppose that you can borrow or lend at 1.5%, which is the risk-free rate. Would you invest in:

1. Some combination of your stock (Amazon) and the market (S&P 500)

2. Some combination of the market (S&P 500 index) and borrowing or lending at the risk-free rate? Please explain.

Reference no: EM133109571

Questions Cloud

Compare the decline in value : Avi Erlander currently holds corporate bonds yielding six percent and government bonds yielding four percent. He is fascinated by the world of finance and is al
Ipo process using the dutch auction method : The firm asks an investment bank to get investor bids to sell a total of 950,000 shares. The bids received are provided in the table below.
Investing in stocks vs bonds : Discuss the uncertainty of future cash flows between investing in stocks vs. bonds. Which financial asset is more risky?
The volkswagen scandal : Explain how the culture of Volkswagen created this ethical scandal. While Volkswagen claimed to support ethics and sustainability,
Find the beta for amazon : The excel file 'Question 2_Stock Prices CW 2021' contains the monthly stock prices for Amazon (the technology company) as well as the value of the S&P 500 i
Compare and contrast life insurance products : Compare and Contrast life insurance products vis-a-vis General insurance products.
Distinctive competencies and competitive advantage : Define value creation for customers and components that can be used to determine value creation per unit. How value creation is related to competitive advantage
Announcement of the deal : Firm A enters into a merger agreement with firm B whereby A will buy B and will pay for B with its own stock. Upon announcement of the deal, Firm A's stock pric
Display the seller account ref : The business relationship manager has asked you to write a sales summary report. Display the seller account ref, seller name, product code, product description,

Reviews

Write a Review

HR Management Questions & Answers

  Determine employees with high potential within organization

Debate the usefulness of self-assessment surveys to determine employees with high potential within the organization. Create a list of five (5) critical areas.

  What can an organization do to diversify the workforce

What can an organization do to diversify the workforce when there has been a practice which has resulted in 'nepotism' as described in Sabrina's post?

  How fast should she run as she leaves the roof

As a movie stunt coordinator, you need to be sure a stunt will be safe before it is performed. If a stuntwoman is to run horizontally off the roof of a three-st

  Explain the goal of information security

Recently, a terminated employee used his mobile device to log in to the company network and steal sensitive data. As the manager of the information technology.

  What is the organization analysis

What is the "organization analysis" component of the needs analysis process. What are two actions you can take to perform this component of the analysis?

  How does coaching impact employee job performance

You were promoted to the position of "Manager" for a small unit within a larger customer service company whose market is the property and casualty insurance bus

  Question on fair labor standards act

The Fair Labor Standards Act (FLSA) is the principal federal statute that regulates wages and hours in the U.S. Under the FLSA, most employees must be paid at l

  What criteria should an organization focus

Assess why organizations might choose a performance management process over a performance appraisal system. What criteria should an organization focus on when.

  What is the strategic role of the hrm function

What is the strategic role of the HRM function at Coca Cola? How does HRM help Coca Cola to become a more successful international business?

  Formulating the expatriate pay

Maria is the HR manager for a US company that has just opened an office in Hong Kong. She is determining the compensation for a new US manager that will be runn

  What are three predictor tests

Explain which one would be appropriate to use to evaluate each of the following positions: guest service representative, front/back office supervisor

  How can organization use flexibility to utilize human talent

How can organizations use flexibility to utilize human talent in the pursuit of achieving strategic goals? The response must be typed.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd