^GSPC	^BSESN	^KS11
Date	Adj. Closing Price	Adj. Closing Price	Adj. Closing Price
12/31/2011	1312.41	17193.55	2030.25
12/1/2011	1257.6	15454.91992	1955.79
11/1/2011	1246.959961	16123.45996	1825.73999
10/1/2011	1253.300049	17705.00977	1847.51001
9/1/2011	1131.420044	16453.75977	1909.030029
8/1/2011	1218.890015	16676.75	1769.650024
7/1/2011	1292.280029	18197.19922	1880.109985
6/1/2011	1320.640015	18845.86914	2133.209961
5/1/2011	1345.199951	18503.2793	2100.689941
4/1/2011	1363.609985	19135.96094	2142.469971
3/1/2011	1325.829956	19445.2207	2192.360107
2/1/2011	1327.219971	17823.40039	2106.699951
1/1/2011	1286.119995	18327.75977	1939.300049
12/1/2010	1257.640015	20509.08984	2069.72998
11/1/2010	1180.550049	19521.25	2051
10/1/2010	1183.26001	20032.33984	1904.630005
9/1/2010	1141.199951	20069.11914	1882.949951
8/1/2010	1049.329956	17971.11914	1872.810059
7/1/2010	1101.599976	17868.28906	1742.75
6/1/2010	1030.709961	17700.90039	1759.329956
5/1/2010	1089.410034	16944.63086	1698.290039
4/1/2010	1186.689941	17558.71094	1641.25
3/1/2010	1169.430054	17527.76953	1741.560059
2/1/2010	1104.48999	16429.55078	1692.849976
1/1/2010	1073.869995	16357.95996	1594.579956
12/1/2009	1115.099976	17464.81055	1602.430054
11/1/2009	1095.630005	16926.2207	1682.77002
10/1/2009	1036.189941	15896.28027	1555.599976
9/1/2009	1057.079956	17126.83984	1580.689941
8/1/2009	1020.619995	15666.63965	1673.140015
7/1/2009	987.47998	15670.30957	1591.849976
6/1/2009	919.320007	14493.83984	1557.290039
5/1/2009	919.140015	14625.25	1390.069946
4/1/2009	872.809998	11403.25	1395.890015
3/1/2009	797.869995	9708.5	1369.359985
2/1/2009	735.090027	8891.610352	1206.26001
1/1/2009	825.880005	9424.240234	1063.030029
12/1/2008	903.25	9647.30957	1162.109985

1. Compute monthly holding period return using Adj. close prices.

2. Use the Excel functions to compute mean and standard deviation of the monthly return for each index

3. To achieve international diversification, John invest GSPC and BSESN indexes. What are the weights on the two indexes to achieve the optimal international portfolio? what are the mean and standard deviation of returns on his optimal international portfolio. (ALL CALCULATIONS SHOULD BE DONE IN EXCEL)

4.Mary instead invests in GSPC and KS11. What are the weights on the two indexes to achieve the optimal international portfolio? what are the mean and standard deviation of returns on his optimal international portfolio. (ALL CALCULATIONS SHOULD BE DONE IN EXCEL)

Please UPLOAD your Excel sheets so that I can see how you get the answers.