This exercise requires you to construct a portfolio using actual data. You may use Google finance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This exercise requires you to construct a portfolio using actual data. You may use Google finance or Yahoo finance to download historical data of any 5 stocks (preferably US stocks). You will download monthly historical stock price data for 5 years (60 observations per stock). Stock price should be adjusted for dividends. 1. On your excel file, label sheet 1 as 'Raw Data' and add stock returns for the 5 stocks you have picked. Also find the average return and sample standard deviation for each stock. 2. On the same sheet, create a 5 by 5 variance covariance matrix. You can find sample variance and sample covariance using the returns data for each stock. 3. On a new sheet 'Portfolio Construction' display a summary of stock returns and the stock variance-covariance matrix. Also write out a 1 x 5 matrix of weights [w1 w2 .. w5] that you will use in Excel to calculate the portfolio return Rp and the portfolio standard deviation op. This exercise requires you to construct a portfolio using actual data. You may use Google finance or Yahoo finance to download historical data of any 5 stocks (preferably US stocks). You will download monthly historical stock price data for 5 years (60 observations per stock). Stock price should be adjusted for dividends. 1. On your excel file, label sheet 1 as 'Raw Data' and add stock returns for the 5 stocks you have picked. Also find the average return and sample standard deviation for each stock. 2. On the same sheet, create a 5 by 5 variance covariance matrix. You can find sample variance and sample covariance using the returns data for each stock. 3. On a new sheet 'Portfolio Construction' display a summary of stock returns and the stock variance-covariance matrix. Also write out a 1 x 5 matrix of weights [w1 w2 .. w5] that you will use in Excel to calculate the portfolio return Rp and the portfolio standard deviation op.
Expert Answer:
Answer rating: 100% (QA)
The five years data of two companies NOKIA and Ultra tech are taken The following calculations are made in excel a The return is calculated as Where N... View the full answer
Posted Date:
Students also viewed these accounting questions
-
In the real world, is it possible to construct a portfolio of stocks that has an expected return equal to the risk-free rate? Provide examples.
-
Three Rivers Investment Company desires to construct a portfolio with a 20 percent expected return. The portfolio is to consist of some combination of Security X and Security Y, which have the...
-
Do you think it is possible to construct a portfolio of stocks that has an expected return that equals the risk-free rate of return?
-
The Assembly Department of Interface, Inc., manufacturer of computers, had 4500 units of beginning inventory in September, and 8000 units wore transferred to it from the Production Department. The...
-
Explain the limited liability partnership.
-
The following items were extracted from the 2008 financial records of Cummins, Inc. (dollars in millions): Allowance for doubtful accounts During the following year, the company wrote off $11 of...
-
After an intense period of negotiation, Global Enterprises Corporation TA 2, 3 agreed to purchase all of the outstanding common shares of The Carlton Corporation. The agreed-upon price was \($294\)...
-
Cala Manufacturing purchases a large lot on which an old building is located as part of its plans to build a new plant. The negotiated purchase price is $ 280,000 for the lot plus $ 110,000 for the...
-
Given the following values, write out the corresponding DNS alias resource record: Canonical record: www2.example.org TTL: 30 minutes Alias: www3.example.org
-
The planet and its moon gravitationally attract each other. Rank the forces of attraction between each pair, from greatest to least. B 2M (2m (2m d 2d
-
The businessman Finds when he produces10items the cost is$200,and when he produces20items the cost is$250.Find his marginalcost.
-
Let f(x)=3x-5 and let g(x)=5x+1. Find (f + g)(3). (f + g)(3) = (Simplify your answer.)
-
1. What measures can the Content Management Team take to mitigate risks associated with content management? 2. How does the Content Management Team ensure content scalability to accommodate growth...
-
Solve: +32 Give your answer as an interval. Enter DNE if the inequality does not have a solution. > Next Question
-
1. (a) List three differences between heat and temperature. (3) (b) Imagine you are working at an espresso coffee shop stand, and your task is to prepare steamed milk for a customer. To do this, you...
-
How can we balance cost to maximize profit in casino industry
-
A piston-cylinder assembly contains 2 lb of water initially at 100 lbf/in and 400F. The water undergoes two processes in series: a constant-pressure process followed by a constant -volume process. At...
-
What are the three kinds of research types? Explain each type.
-
Experimental data for leaching sugar from sugarcane with water show that a reasonable value for effective equilibrium constant \(y / x=m_{E}\) is 1.18 where \(\mathrm{y}\) and \(\mathrm{x}\) are the...
-
A countercurrent leaching system is recovering oil from soybeans with five stages. On a volumetric basis, liquid flow rate/solids flow rate \(=1.36\). Recovery of oil in the solvent is \(97.5 \%\)....
-
Barium sulfide is produced by reacting barium sulfate ore with coal. The result is barium black ash, which is \(\mathrm{BaS}\) plus insoluble solids. Since \(\mathrm{BaS}\) is soluble in water, it...
Study smarter with the SolutionInn App