1	2	3	4	5			1	2	3	4	5
31-10-95	4681.3	675	142.4	#NA	1205		31-10-95	10774.8	4883.37	5188.16	#NA	8934.92
30-11-95	4754.9	625.1	155.6	91.9	1177.7		30-11-95	10944.14	4522.53	5669.91	19942.84	8732.21
29-12-95	5154.1	683.9	165.3	96.9	834.6		29-12-95	11863.13	4947.76	6021.97	21019.48	6188.31
31-01-96	5395.9	730.7	164.9	106	853.7		31-01-96	12438.44	5286.86	5963	23000.63	6329.69
29-02-96	5129.4	754.7	166.6	107.1	740.8		29-02-96	11824.22	5472.73	6024.19	23230.24	5493.08
29-03-96	5267.3	792.1	161.6	102.8	748.4		29-03-96	12142.03	5743.99	5842.11	22293.65	5549.06
30-04-96	5425.5	901.2	163.6	125.5	808.9		30-04-96	12573.2	6535.26	5845.7	27221.66	5880.43
31-05-96	5762.3	856.9	159.9	137.3	982.6		31-05-96	13353.89	6213.93	5716.46	29776.57	7142.7

You are presented with the monthly stock prices of five (5) listed companies labeled Stock Prices. You are also presented with the market capitalization figures of these companies labeled MV. Note that columns for stock prices correspond with columns for capitalization. Data are for the period October 31, 1995 to October 31, 2005.

In the following exercises, use the five (5) companies with complete data over the ten-year period. You will use excel throughout in these exercises. Allotted marks are indicated.

1. Compute the holding period returns from the prices of the five stocks that you have selected and obtain the expected return and the risk of each stock. Plot a graph with the expected return on the vertical axis and risk on the horizontal axis. Assess if there is a risk return relationship in the five stocks selected.

2. (i) Using the market capitalization figures, generate an index based on the five stocks. Set the base of index to be equal to 100 by selecting any of the dates of choice using the market capitalization of that date as your base capitalization. Kindly indicate clearly what this date is as well as the capitalization of that date. Generate the index as well as the returns of the index. Plot the time series of both the index and the returns.

(ii) Run a regression of the returns of each of the five stocks against the returns of the market index and measure the five slopes. What is the importance of the measurement of these slopes as far as investment is concerned? What is the significance of the are the slopes measuring?

3. In this exercise, select any two (A and B) of the five companies to form a two asset portfolio. Combine the companies so that A has the following percentage weights, 100, 90, 80, 70, 60, 50, 40, 30, 20, 10, and 0.

a. Compute the risk and the expected return of each portfolio.

b. Plot a graph of expected return of the portfolio on the vertical axis and the risk on the horizontal axis.

c. On your graph identify (i) the mean-variance frontier, (ii) the efficient frontier (iii) the inefficient frontier (iv) the minimum variance point. Explain the significance of these frontiers or points in investment.

PLEASE THE QUESTION HAS AN EXCEL FILE WHICH CANNOT BE UPLOADED. CAN I GET YOUR EMAIL TO SEND THEM TO YOU DIRECTLY? WE REALLY NEED THE SOLUTIONS.