Annual standard deviation over the past five years

Assignment Help Case Study
Reference no: EM131028790

ALEX SHARPE'S PORTFOLIO

On Friday, January 26, 2007, Alex Sharpe at in her home office and pondered her investment strategy. During her MBA program, Sharpe had learned that in an efficient market, investors should buy and hold the Standard & Poor (S&P) 500 was the most commonly used benchmark for the overall U.S. stock market, Sharpe had invested her children's educational savings in the Vanguard 500 Index Fund, a no-load mutual fund constructed to track the performance of the S&P 500.Risk and Return

The last five years' worth for monthly returns for the Vanguard 500 Index Fund, Hasbro and R.J. Reynolds are provided (see Exhibit 3) In addition to compare the returns on the individual components of her portfolio, Sharpe also wanted to fully compare the risk profiles of the two companies to that of the Vanguard Fund. She wanted to ensure that the expected return f her new portfolio would provide adequate compensation for talking on any new risky assets. To find the investments of her portfolio, Alex has faced the following issues:

- Which stock appears to be riskiest based on the annual standard deviation over the past five years?

- The investment return rate of each stock is correlated with S&P 500 Index?

- How might the expected return of each stock related to its riskiness?

- In what stock(s) (if any) should Alex invest?

Case Analysis Guidelines

1. Use the linear aggression.
- Between S&P 500 and Hasbro; -Between S&P 500 and Reynolds;

2. Use the Excel for analysis.

3. Calculate the following values:
- Sum of Square Total (SST);
- Sum of Square Error (SSE);
- Sum of Square Regression (SSR);
- Coefficient of Determination;
- Correlation Coefficient;
- Mean Square Error (MSE);

4. Use F statistics for evaluate the linearity of the relationship.

Attachment:- CaseProject.rar

Verified Expert

Reference no: EM131028790

Questions Cloud

Comprehensive tax return project-tax : John is a computer consultant who specializes in installing software systems. John deals mainly with city and county governments and school districts. Currently, John has contracts with Placer and El Dorado Counties which pay him an annual retaine..
How gas is projected from aerosol cans : I need 1 page about How gas is pressurized and how gas is projected from aerosol cans. I need just a page from scholarly sources only. You said in chat you can do it in 2 hours.
What are the blocks in this experiment : What are the experimental units, and what are the blocks in this experiment? Test the hypothesis that there are no differences among the treatment means, using α=.05.
How many grams of copper will be formed : A 1.090 g piece of aluminum is placed into a solution containing 5.10 g of copper (II) nitrate. How many grams of copper will be formed? This is a single replacement reaction.
Annual standard deviation over the past five years : Which stock appears to be riskiest based on the annual standard deviation over the past five years - The investment return rate of each stock is correlated with S&P 500 Index?
Decision analysispecify the environment type of your example : Give one real-life example in which you can use Decision Analysis tools to the class Discussion Board topic "Decision Analysis" Specify the environment type of your example, and your preferred tool to deal with to solve the problem. Justify your choi..
Find the p-value associated with the test : Assuming that the requirements for a one-way layout are met, analyze the data. State whether there is statistical support at the α = .05 level of significance for the conclusion that at least one of the concretes differs in average strength from t..
Reconstruct a rational function based on the information : You are also supposed to select an oblique asymptote such that it is an increasing line (positive slope) with a y-intercept other than (0, 0).
Importance of the brain as part of central nervous system : Pretend you are a tour guide giving a tour of the human brain. In a 1-2 page paper, describe the tour you would give, highlighting the major parts of the brain, the control centers and their functions, and the importance of the brain as part of th..

Reviews

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

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