Mary and David are planning for their wedding ceremony one and a half year from now. They were advised by the wedding planner that the wedding cost should be around USD 28,000.This couple has gone through their budget and found that they can invest USD 300 per weekfrom the freelance income starting from this week. This couple has opened accounts at The Tracker Fund of Hong Kong and China Government Bond. The first fund follows an investment strategy designed to match the return of the Blue Chip in Hong Kong. The second fund invests in long-term Bond in China. The fees for both funds are very low.

The couple has decided to follow a strategy in which they contribute a fixed fraction of the USD 300 to each investment. A financial consultant from an investment bank suggested them to invest 80% of the USD 300 each week in The Tracker Fund of Hong Kong and the remaining 20% in the China Government Bond.The consultant explained that The Tracker Fund of Hong Kong has averaged larger returns than the China Government Bond. Even though stock returns are risky investments in the short run, the risk would be fairly minimal in the historical record. However, another financial consultant recommended just the opposite: invest 20% in The Tracker Fund of Hong Kong and the remaining 80% in the China Government Bond,he said, China Government Bond is backed by the China government. If you follow this allocation, he said, your average return will be lower, but at least you can reach your USD 28,000 target in one and a half year from now.

Not knowing which consultant to believe, the couple has come to you for help.

Questions:

The spreadsheet Marriage.xlsx contains 261 weekly returns of The Tracker Fund of

Hong Kong and the China Government Bond from the first week of January 2012 to the first week of January 2017. In each of the next one and a half year from now, it is . Set up a spreadsheet to simulate the two suggested investment strategies over the above investment period. Plot the value of each strategy over time for one simulation trial. What was the total value of each strategy one and a half year from now?

Did either of the strategies reach the target? (non-random number)

Simulate 200 trials of the two suggested investment strategies over the investment period. Create a histogram of the final investment values. Based on your simulation results, which of the two suggested investment strategies would you recommend? Why? (Random number)

Suppose the couple needs to have USD 35,000 for the expense for their marriage. Based on the same simulation results, which of the two strategies would you recommend now? Why?

Week	Return (Blue Chip)	Return (Bond)
1	-0.00637362	0.006863729
2	0.035806558	0.006046148
3	-0.010874714	0.006647246
4	-0.008032959	0.007129663
5	0.046948305	0.00668351
6	-0.007513179	0.007147246
7	0.001550548	0.006142851
8	0.027091182	0.005819774
9	-0.022585692	0.006542851
10	-0.001004395	0.005723071
11	0.059304336	0.005421973
12	-0.053779067	0.005764829
13	-0.016607676	0.00571428
14	-0.013056031	0.00505494
15	0.001507691	0.00494505
16	-0.016454929	0.005104391
17	0.05217797	0.004290106
18	-0.016601082	0.005356039
19	-0.014571414	0.004561534
20	1.75824E-05	0.004740655
21	-0.045645009	0.005171423
22	0.040652707	0.004880215
23	0.005272522	0.004131864
24	-0.065540594	0.005295599
25	-0.017742839	0.00502527
26	0.030338431	0.005176918
27	0.095613091	0.004968127
28	0.014980205	0.00656373
29	-0.016748335	0.005787906
30	0.061484554	0.00610439
31	0.037361501	0.004503292
32	-0.005297797	0.005328566
33	-0.097865836	0.005143951
34	0.028560411	0.00370659
35	0.018888992	0.004414281
36	0.046307646	0.004608787
37	-0.031197771	0.004114282
38	0.063197739	0.004778017
39	-0.006103291	0.005116478
40	-0.044362593	0.004624171
41	-0.081701017	0.004799995
42	0.064366969	0.004487908
43	0.003315381	0.004354941
44	-0.097715287	0.004442853
45	-0.060120819	0.003949447
46	-0.052971376	0.003861535
47	0.082659258	0.00413626
48	0.055895549	0.00412637
49	0.038148314	0.004081315
50	-0.010701088	0.004380215
51	0.058872469	0.004582413
52	0.064144991	0.004851644
53	0.046030723	0.004761534
54	0.015472512	0.00541428
55	0.042025233	0.005495599
56	0.041409849	0.005348346
57	-0.040382377	0.005378017
58	0.002316481	0.005052742
59	-0.043868088	0.005810983
60	0.045298856	0.005886807
61	-0.006103291	0.005591203
62	-0.044362593	0.005899994
63	0.002915382	0.00614395
64	0.096339464	0.006098895
65	0.021313166	0.006801092
66	0.032880187	0.007479113
67	0.007939553	0.007691201
68	0.006252741	0.008597794
69	0.024086789	0.008479112
70	-0.022573604	0.008063728
71	0.003999996	0.008936255
72	0.042977979	0.008745046
73	-0.003957139	0.008967024
74	0.011729659	0.008905486
75	0.055447197	0.008415376
76	0.014410975	0.008429662
77	-0.017499983	0.014070316
78	-0.036557106	0.013671415
79	-0.000196703	0.013246141
80	-0.0433571	0.011731856
81	-0.097865836	0.009602188
82	0.028560411	0.008745046
83	0.018888992	0.010151638
84	0.046307646	0.010771418
85	-0.031197771	0.012408779
86	0.063197739	0.011632955
87	0.003967029	0.01051977
88	-0.018483498	0.011546142
89	0.045043911	0.008376915
90	0.012032955	0.00562417
91	0.067098834	0.006484609
92	0.002780217	0.006969224
93	-0.072054873	0.007404388
94	0.056494449	0.00754285
95	0.021109869	0.008359332
96	0.067065867	0.008363728
97	0.003373623	0.007730762
98	-0.108417474	0.007987904
99	0.047175777	0.008339552
100	0.061769169	0.007842849
101	0.032494473	0.007999992
102	0.07428564	0.008943947
103	0.014406579	0.008612079
104	0.030835134	0.008279113
105	0.020494485	0.008994497
106	0.120362517	0.009127463
107	-0.034626339	0.009438452
108	-0.04813182	0.010941747
109	0.02285712	0.008059333
110	-0.097865836	0.007061531
111	0.028560411	0.007114279
112	0.018888992	0.006352741
113	0.046307646	0.006769224
114	-0.031197771	0.007870322
115	0.063197739	0.007290103
116	0.003967029	0.006094499
117	-0.018483498	0.006863729
118	0.045043911	0.006046148
119	0.012032955	0.006647246
120	0.067098834	0.007129663
121	0.002780217	0.00668351
122	-0.072054873	0.007147246
123	0.056494449	0.006142851
124	0.021109869	0.005819774
125	0.067065867	0.00505494
126	0.003373623	0.00494505
127	-0.108417474	0.005098352
128	0.047175777	0.00428503
129	0.061769169	0.005349702
130	0.032494473	0.004556138
131	0.07428564	0.004735046
132	0.014406579	0.005165306
133	0.030835134	0.004874442
134	0.020494485	0.004126976
135	0.120362517	0.005289334
136	-0.034626339	0.005019325
137	-0.04813182	0.005170794
138	0.02285712	0.00496225
139	0.0417582	0.006555965
140	-0.02340657	0.003788915
141	0.00681318	0.004296006
142	-0.0087912	0.003229139
143	0.00076923	0.005000666
144	-0.06087906	0.004837123
145	-0.05516478	0.005066522
146	0.05802192	0.005546173
147	0.04846149	0.005326653
148	-0.02912085	0.005567027
149	-0.01791207	0.006517549
150	-0.05626368	0.006768899
151	-0.0065934	0.006052166
152	0.04549446	0.006729386
153	-0.03164832	0.007360506
154	-0.01912086	0.007406605
155	-0.02362635	0.008641405
156	0.13923063	0.007785277
157	0.0120879	0.007633808
158	0.12373614	0.008113459
159	0.04813182	0.007183792
160	0.01901097	0.007425264
161	0.03824172	0.007536122
162	0.0285714	0.006661334
163	0.04010985	0.006223392
164	0.08329662	0.00623327
165	-0.00571428	0.007069642
166	0.04197798	0.007543805
167	-0.03439557	0.00743185
168	0.0186813	0.006861098
169	0.12362625	0.00743185
170	0.00021978	0.007213427
171	0.00285714	0.006568038
172	-0.01109889	0.007483437
173	0.02780217	0.006202538
174	0.08439552	0.006573526
175	0.01505493	0.005682275
176	0.00197802	0.005232259
177	-0.00351648	0.004819562
178	0.06758235	0.005289334
179	0.01747251	0.005019325
180	-0.00285714	0.005170794
181	-0.00670329	0.00496225
182	-0.03527469	0.006555965
183	0.04912083	0.003788915
184	0.07868124	0.004296006
185	0.05131863	0.003229139
186	0.00483516	0.005000666
187	0.08352736	0.004837123
188	0.06080704	0.005066522
189	-0.01361024	0.005546173
190	0.06025824	0.005326653
191	0.01822016	0.005567027
192	-0.06245344	0.006517549
193	0.02809856	0.006768899
194	-0.02897664	0.006696458
195	0.14740768	0.006214611
196	0.04533088	0.006959882
197	0.02985472	0.006052166
198	-0.00965888	0.006729386
199	0.01130528	0.007360506
200	0.05477024	0.007406605
201	0.05466048	0.008641405
202	0.0422576	0.007785277
203	-0.0241472	0.007633808
204	-0.23620352	0.008113459
205	-0.08989344	0.007183792
206	0.08100288	0.007425264
207	0.04686752	0.007536122
208	0.0515872	0.006661334
209	-0.03314752	0.006223392
210	0.01185408	0.00623327
211	0.00856128	0.007069642
212	0.05092864	0.007543805
213	-0.0043904	0.00743185
214	-0.03633056	0.006861098
215	0.04653824	0.00743185
216	0.02996448	0.007213427
217	-0.01558592	0.006568038
218	0.01986656	0.007483437
219	0.07935648	0.006202538
220	-0.02733024	0.006573526
221	0.02590336	0.005682275
222	0.05663616	0.005232259
223	0.04412352	0.004819562
224	-0.00592704	0.005855696
225	0.09856448	0.00518177
226	0.02118368	0.00457809
227	-0.00428064	0.005360678
228	-0.02557408	0.005059936
229	0.02283008	0.005002861
230	0.02590336	0.006345226
231	-0.07364896	0.006761216
232	0.01415904	0.007861011
233	0.02886688	0.007281478
234	-0.02711072	0.00608729
235	0.107016	0.00685561
236	-0.0076832	0.006038995
237	-0.00351232	0.006639382
238	-0.09911328	0.007121229
239	-0.05400192	0.006675603
240	-0.00406112	0.00713879
241	0.07068544	0.006135584
242	0.03007424	0.00581289
243	0.04851392	0.00653511
244	0.05092864	0.005716301
245	-0.0043904	0.005415558
246	-0.03633056	0.00575801
247	0.04653824	0.00570752
248	0.02996448	0.00504896
249	-0.01558592	0.0049392
250	0.01986656	0.005098352
251	0.07935648	0.00428503
252	-0.02733024	0.005349702
253	0.02590336	0.004556138
254	0.05663616	0.004735046
255	0.04412352	0.005165306
256	-0.00592704	0.004874442
257	0.09856448	0.004126976
258	0.02118368	0.005289334
259	-0.00428064	0.005019325
260	-0.02557408	0.005170794
261	0.02283008	0.00496225