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