Return standard deviations for each of five stocks

Assignment Help Financial Management

Reference no: EM131923735

Getting started:

For the project, form a 2-3 person team. As a team, pick 5 large ( > $1 billion market cap) publicly traded companies that you might want to invest in. Make sure all 5 companies have been publicly traded with daily price data available in Yahoo Finance for at least the last 5 years. Create a portfolio that invests 24% of $1 million in company A, 22% in company B, 20% in company C, 18% in company D, and 16% in company E.

Please enter the return standard deviations for each of the 5 stocks and for the portfolio during the last calendar year. Please use daily returns, and make sure to show your work. Please keep in mind that the standard deviation you will get using daily data is the daily standard deviation. In finance, the practice is to annualize the standard deviation by multiplying the daily standard deviation by sqrt(252) - there are approximately 252 trading days in a year. This is especially important if you want to be able to compute the Sharpe ratio correctly. The numerator in the Sharpe ratio is the ***annual*** excess return. Therefore, the denominator, which is the standard deviation, should also be annualized. The Companies are: Facebook, Amazon, Apple, Microsoft, Macy's. Last calendar year is 2016.

Reference no: EM131923735

Questions Cloud

Dividend-discount model predict colgate stock should sell : What prices does the dividend-discount model predict colgate stock should sell?

What is the payoff to the call holder : The call holder exercises the call at expiration when the price of GE stock is $43. What is the payoff to the call holder?

Straight-line-double-declining-balance depreciation : Computing and recording straight-line versus double-declining-balance depreciation At the beginning of 2014,

Protection against rising inflation : Assume Juan bought 24 ounces of gold for $3,960 as protection against rising inflation. What was Juan’s profit in 1980 and in 1982?

Return standard deviations for each of five stocks : Please enter the return standard deviations for each of the 5 stocks and for the portfolio during the last calendar year.

Expected return and standard deviation of portfolio : What is the expected return and the standard deviation of a portfolio consisting of 100% Stock X?

What do you think ex-dividend price will be : Lee Ann, Inc., has declared a $6.00 per-share dividend. What do you think the ex-dividend price will be?

What is the amount of the new mortgage : What is the amount of the new mortgage? What is the loan-to-value ratio on the new mortgage? What is the before tax cash flow under the new mortgage?

Calculate the IRR of the cash flow based on actual dollars : Calculate the IRR of the cash flow based on actual dollars.

User Account

All Pages