MONTE CARLO SIMULATION

TRY TO DETERMINE THE OPTMINATION ASSET ALLOWING CONSIDERING BETA BETWEEN 1.3 AND 1.5 OR (MIN = 1.3 AND MAX = 1.5) FROM THE FOLLOWING INFORMATION (SIBANYE-STILLWATER LTD, SYGWD.JO AND MTN.JO) YOU CAN USE EXCEL TO GENERATE THE RESULTS BUT ALSO GRAPHS IF POSSIBLE AND FOR WEIGHTS YOU CAN MAYBE USE EXCEL SOLVER TO GENERATE THEM)

Date	Currency: LOCAL - Market Price	Sibanye-Stillwater Ltd. Monthly returns		Date	SYGWD.JO Monthly returns	MTN.JO Monthly returns
1	37.4969258	-0.053672316		1	0.118587048	-0.178183212
2	35.48437893	-0.160447761		2	-0.09962406	0.166693906
3	29.79098978	0.113777778		3	-0.006263048	-0.018472102
4	33.18054239	0.280925778		4	0.055882353	-0.14314208
5	42.50181208	-0.111682243		5	-0.063668922	-0.003068306
6	37.75511437	-0.132737156		6	-0.020824479	-0.009279681
7	32.74360787	-0.256975334		7	0.04296875	-0.027240656
8	24.32930832	-0.206258503		8	0.002080732	0.114575679
9	19.31118159	-0.12958519		9	-0.006229236	-0.005547879
10	16.80873845	0.19259551		10	-0.003343084	-0.045269874
11	20.04602601	-0.131109643		11	0.036477987	0.018448995
12	17.41779869	0.090839985		12	0.014158576	0.07492829
13	19.00003126	-0.057491289		13	0.007578779	-0.071146196
14	17.90769496	-0.116580887		14	-0.00277118	-0.028936178
15	15.82	-0.048672566		15	0.026200873	0.038475033
16	15.05	0.116943522		16	-0.015860735	0.090640595
17	16.81	0.235574063		17	0.016116352	-0.017765094
18	20.77	-0.267212325		18	0.12417795	-0.012944326
19	15.22	0.203022339		19	-0.026152787	0.052944575
20	18.31	0.025122884		20	-0.077385159	0.056703118
21	18.77	-0.15716569		21	0.014553811	-0.038067394
22	15.82	-0.123261694		22	-0.041525104	-0.022069999
23	13.87	-0.181687094		23	-0.018511225	-0.073774427
24	11.35	0.037004405		24	0.054574639	0.093257281
25	11.77	-0.067119796		25	0.013318113	-0.08575522