The monthly adjusted closing prices of microsoft

Reference no: EM131117944

Consider the monthly adjusted closing prices of Microsoft (MSFT), Exxon Mobil Corp. (XOM), P?zer (PFE) and Wal-Mart Stores Inc. (WMT) from January 3, 2011 to December 31, 2015.

1. Using Excel or any other spreadsheet software, ?nd the expected monthly rate of return and the standard deviation of each of these stocks. Moreover, ?nd the covariance of each pair these stocks.

2. Suppose that at the end of the trading day on January 4, 2016, you want to build a portfolio with these four stocks. Find the weights of the minimum variance portfolio with a total rate of return is equal to average of the expected rates of return obtained in question 1. Moreover, if on that date you have $1,000,000, deduce the number of shares of each of these stocks you will have in your portfolio.

3. Using the adjusted closing prices on June 28, 2016 to ?nd the market value of your portfolio.

4. Using the S&P 500 INDEX,(GSPC) as the Market and the same historical data (from January 3, 2011 to December 31, 2015). Compute the Beta of each of these stocks.

5. If monthly the risk-free rate is rf = 0.09, compute the Jensen and Sharpe indexes of each of these stocks. Derive the Jensen and Sharpe indexes of your portfolio. What can you conclude?

Reference no: EM131117944

Questions Cloud

What costs should magilke capitalize for the new equipment : Magilke Industries acquired equipment this year to be used in its operations. The equipment was delivered by the suppliers, installed by Magilke, and placed into operation.

Assets purchased by issuance of capital stock : Discuss the basic accounting problem that arises in handling each of the following situations.

What part of the called method receives the value : What part of the called method receives the value?

The expected rate of return on your investment : You plan to invest $3 million in the construction of an oil well which has a potential revenue of $10 million. The oil well will be located in the Golf of Mexico. As we all know, this region is constantly hit by hurricanes.

The monthly adjusted closing prices of microsoft : Consider the monthly adjusted closing prices of Microsoft (MSFT), Exxon Mobil Corp. (XOM), P?zer (PFE) and Wal-Mart Stores Inc. (WMT) from January 3, 2011 to December 31, 2015.

Calculate the range of potential values for pacificcorp : Using Excel, calculate the range of potential values for PacificCorp (using the multiples for comparable regulated utilities) - the core information is provided in Exhibit 10. Prepare a spreadsheet to recreate the values for PacificCorp - show all..

How should the amount of interest capitalized : How should the amount of interest capitalized be disclosed in the notes to the financial statements?

Estimates for conducting a break-even analysis : Chambers Company has just gathered estimates for conducting a break-even analysis for a new product. Variable costs are $7 a unit. The additional plant will cost $48,000.

What interest rates should be used in determining : What interest rates should be used in determining the amount of interest to be capitalized? How should the amount of interest to be capitalized be determined?

User Account

All Pages