User Account

All Pages

Compute the beta value for each stock

Assignment Help Operation Management
Reference no: EM132288595

Discussion :

You will need to collect the stock price data for any 2 companies of your choice and the S&P 400 index. Choose companies that are in different industries.

Collect the end-of-month prices for the last 21 months of your chosen stocks and the S&P 400 and set them on the spreadsheet.

Taking this raw data, compute the monthly returns for all (there should be 20 returns). Make sure that I am able to see the cell formulas for each computation.

Next, compute the mean rate of return and the standard deviation of returns for both your stocks and the stock market.

Compute the beta value for each stock and plot the characteristic lines of the 2 companies on 2 graphs.

Compute the correlation coefficient for the 2 stocks. Plot the returns of your stocks against each other on a graph within the spreadsheet.

Next, assume that you construct a portfolio where you put equal money in each of your 2 stocks.

Compute the 20 monthly rates of return for the portfolio and the standard deviation of returns of the portfolio and its beta value.

Finally, within the spreadsheet discuss in DETAIL your findings regarding risk/return of your portfolio as compared to the risk/return characteristics of the 2 individual stocks. These comments must be detailed with a complete analysis.

Reference no: EM132288595

Questions Cloud

Who are the members of a healthcare team : Who are the members of a healthcare team that you believe are most needed to implement a program? Can you explain why?
Average cost minimizing level of output : Marginal cost equals average cost at the average cost minimizing level of output.
How does role vary between design and implementation : What is the role of the nurse in healthcare program implementation? How does this role vary between design and implementation of healthcare programs?
Two bidders for the unique china teacup it sells : Each of the bidders can either have a high-value of $100 or a low-value of $70 with equal probability. If Anna can only set one price, what price should she set
Compute the beta value for each stock : Collect the end-of-month prices for the last 21 months of your chosen stocks and the S&P 400 and set them on the spreadsheet.
Discuss three examples of stock trades performed : Discuss three examples of stock trades performed in our StockTrak simulation game.
Describe the pharmacodynamic processes : Examine Case Study: A Puerto Rican Woman With Comorbid Addiction. You will be asked to make three decisions concerning the medication to prescribe.
Find the equilibrium market price and quantity : In a perfectly competitive market, the market demand curve is given by Qd = 1000-10P d , and the market supply curve is given by Qs = 30P s .
Analysis of relevant legislation : Complex Complaints Briefing Report - Reflect customer needs you have identified and show how these needs will be satisfied through the service provided

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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