Answer the following case study and submit your response and workings in a word file. You can also submit an excel file to show your workings.

Case Study:

You are to assess a 2-asset portfolio that consists of Westpac shares and Fortescue shares. You have been given the historical prices of these companies over the past 2 years (this spreadsheet Download this spreadsheet) in order to analyse historical performance. Assume that the risk-free rate is 3.5% per year and the forward-looking market return is expected to be 8.5% per year.

Forecast adjustments:

• You note that the data you have used does not include dividend information, which you also want to include in your analysis. For Westpac, the annual dividend rate is 7.42%, and for Fortescue the annual dividend rate is 0.83%
• You also note that Westpac has suffered from a large one-off event in the recent past (compliance breaches) and, thus, in your return expectations you will adjust the historical return upwards by 1.5% p.a. Fortescue, on the other hand, has had relative good luck recently and, thus, in your return expectations you will adjust the historical return downwards by 1.5% p.a.

1. Based on the daily closing prices, calculate the daily and annualised returns and standard deviations, as well as the correlations of these two stocks. (8 marks)
2. Using the annualised paramaters (as well as the forecast adjustments) and correlation of these two stocks from Section A, construct an efficient frontier with 21 portfolios (starting at 0% to WBC, and going up by 5% weighting for each portfolio - opposite for FMG [i.e. starting at 0% and going up]). For all portfolios, you need to tabulate weights in each stock, portfolio's return, standard deviation, and Sharpe ratio. Be as exact as you can. (12 marks)
3. Discuss the role of the minimum variance portfolio and the tangency portfolio and identify the portfolios from Part B that best represent each of these.Hint: You might use a chart to help visualise the concepts you discuss.(10 marks)

Excel File

Date	WBC	FMG
31/3/2021	24.41	19.99
1/4/2021	24.54	20.25
6/4/2021	24.7	20.53
7/4/2021	24.84	20.48
8/4/2021	25.16	21
9/4/2021	25.21	20.89
12/4/2021	25.3	20.55
13/4/2021	25.31	20.36
14/4/2021	25.33	20.24
15/4/2021	25.5	20.95
16/4/2021	25.32	20.82
19/4/2021	25.36	21.2
20/4/2021	25.24	21.6
21/4/2021	24.98	21.6
22/4/2021	25.11	21.32
23/4/2021	25.12	21.66
26/4/2021	25.08	22.7
27/4/2021	24.99	22.96
28/4/2021	25.3	22.62
29/4/2021	25.19	22.58
30/4/2021	24.98	22.59
3/5/2021	26.23	22.48
4/5/2021	25.99	22.66
5/5/2021	25.96	22.72
6/5/2021	26.02	22.75
7/5/2021	26.09	22.97
10/5/2021	26.42	24.79
11/5/2021	26.08	24.09
12/5/2021	25.77	24.43
13/5/2021	25.19	23.44
14/5/2021	25.41	22.79
17/5/2021	25.33	23.1
18/5/2021	25.46	23.57
19/5/2021	25.18	22.83
20/5/2021	25.52	22.81
21/5/2021	25.65	22.3
24/5/2021	25.98	21.37
25/5/2021	26.2	21.72
26/5/2021	26.27	21.22
27/5/2021	26.09	22.27
28/5/2021	26.46	22.12
31/5/2021	26.42	22.43
1/6/2021	26.2	22.82
2/6/2021	26.22	23.28
3/6/2021	26.5	23.44
4/6/2021	26.87	22.97
7/6/2021	26.63	22.65
8/6/2021	26.73	22.42
9/6/2021	26.55	22.65
10/6/2021	26.59	22.83
11/6/2021	26.29	23.22
15/6/2021	26.55	23.33
16/6/2021	26.55	22.95
17/6/2021	26.94	22.61
18/6/2021	26.88	22.42
21/6/2021	26.15	21.81
22/6/2021	26.61	22.38
23/6/2021	26.08	22.48
24/6/2021	25.83	22.74
25/6/2021	25.89	22.92
28/6/2021	25.82	23.05
29/6/2021	25.86	23.14
30/6/2021	25.81	23.34
1/7/2021	25.65	23.59
2/7/2021	25.64	23.58
5/7/2021	25.53	23.69
6/7/2021	25.45	23.36
7/7/2021	25.6	23.55
8/7/2021	25.53	23.71
9/7/2021	25.37	23.87
12/7/2021	25.52	24.66
13/7/2021	25.33	25.18
14/7/2021	25.27	25.2
15/7/2021	24.99	25.72
16/7/2021	24.91	25.78
19/7/2021	24.69	25.42
20/7/2021	24.52	25.17
21/7/2021	24.76	25.29
22/7/2021	24.93	25.19
23/7/2021	24.71	25.25
26/7/2021	24.62	25.42
27/7/2021	24.79	25.82
28/7/2021	24.56	25.81
29/7/2021	24.52	26.3
30/7/2021	24.52	24.91
2/8/2021	25.03	24.39
3/8/2021	24.8	24
4/8/2021	24.84	24.09
5/8/2021	24.89	23.27
6/8/2021	25.12	23.05
9/8/2021	25.36	22.76
10/8/2021	25.58	22.51
11/8/2021	25.77	22.52
12/8/2021	25.76	22.52
13/8/2021	26.16	22.3
16/8/2021	25.79	21.87
17/8/2021	25.45	21.58
18/8/2021	25.81	21.45
19/8/2021	25.82	20.13
20/8/2021	25.76	20.36
23/8/2021	25.78	19.49
24/8/2021	25.91	19.76
25/8/2021	26.15	20.28
26/8/2021	26.01	20
27/8/2021	25.99	20
30/8/2021	25.8	21.32
31/8/2021	25.82	21
1/9/2021	26.11	20.33
2/9/2021	26.03	20.71
3/9/2021	26.02	20.85
6/9/2021	25.99	18.57
7/9/2021	26.03	17.99
8/9/2021	26.09	17.92
9/9/2021	25.6	17.81
10/9/2021	25.65	18.27
13/9/2021	25.64	18.41
14/9/2021	25.72	18.08
15/9/2021	25.79	17.82
16/9/2021	26	17.25
17/9/2021	25.88	15.27
20/9/2021	25.3	14.7
21/9/2021	25.19	14.75
22/9/2021	24.91	15.37
23/9/2021	25.07	15.53
24/9/2021	25.25	15.34
27/9/2021	25.46	15.75
28/9/2021	25.31	14.87
29/9/2021	25.17	14.8
30/9/2021	26	14.96
1/10/2021	25.41	14.57
4/10/2021	25.95	14.4
5/10/2021	25.81	14.22
6/10/2021	25.65	14.18
7/10/2021	26.01	13.91
8/10/2021	25.96	14.25
11/10/2021	26.06	15
12/10/2021	25.63	14.79
13/10/2021	25.3	14
14/10/2021	25.27	14.32
15/10/2021	25.39	14.6
18/10/2021	25.58	14.74
19/10/2021	25.48	14.56
20/10/2021	25.68	14.5
21/10/2021	25.83	14.41
22/10/2021	25.74	14.31
25/10/2021	25.71	14.51
26/10/2021	25.79	14.37
27/10/2021	25.95	14
28/10/2021	26.23	14.02
29/10/2021	25.67	13.93
1/11/2021	23.78	14.33
2/11/2021	23.13	13.95
3/11/2021	23.15	14.38
4/11/2021	23.2	14.18
5/11/2021	22.55	14.27
8/11/2021	22.84	14.33
9/11/2021	22.52	14.59
10/11/2021	22.71	14.28
11/11/2021	22.68	15.45
12/11/2021	22.69	15.75
15/11/2021	22.83	15.94
16/11/2021	22.75	15.89
17/11/2021	22.37	15.59
18/11/2021	22.15	15.34
19/11/2021	22.14	15.47
22/11/2021	21.68	15.8
23/11/2021	21.81	17.35
24/11/2021	21.8	17.57
25/11/2021	21.63	17.88
26/11/2021	21.08	17.19
29/11/2021	20.92	17.6
30/11/2021	20.52	17.01
1/12/2021	20.62	17.27
2/12/2021	20.46	17.25
3/12/2021	20.7	17.1
6/12/2021	20.72	17.15
7/12/2021	20.95	17.41
8/12/2021	21.07	17.98
9/12/2021	21.02	18.25
10/12/2021	20.85	18.1
13/12/2021	20.82	18.46
14/12/2021	20.93	18.7
15/12/2021	20.99	18.64
16/12/2021	20.96	18.8
17/12/2021	21.03	18.98
20/12/2021	21.01	19.46
21/12/2021	21.05	19.79
22/12/2021	21.07	19.44
23/12/2021	21.18	19.16
24/12/2021	21.2	19.24
29/12/2021	21.46	19.28
30/12/2021	21.5	19.14
31/12/2021	21.35	19.21
4/1/2022	21.66	19.85
5/1/2022	21.84	19.96
6/1/2022	21.48	19.75
7/1/2022	21.75	20.37
10/1/2022	21.83	20.64
11/1/2022	21.67	21.12
12/1/2022	21.67	20.88
13/1/2022	21.73	21.4
14/1/2022	21.45	21.37
17/1/2022	21.47	20.77
18/1/2022	21.41	20.75
19/1/2022	21.24	20.44
20/1/2022	21.11	21.39
21/1/2022	20.98	20.94
24/1/2022	20.8	20.52
25/1/2022	20.21	19.5
27/1/2022	20.16	19.48
28/1/2022	20.63	19.45
31/1/2022	20.3	19.87
1/2/2022	20.4	19.73
2/2/2022	20.6	20.46
3/2/2022	21.07	21.13
4/2/2022	21.52	21.34
7/2/2022	21.56	21.53
8/2/2022	21.85	22.23
9/2/2022	22.38	21.43
10/2/2022	22.62	22.28
11/2/2022	22.78	22.83
14/2/2022	23.88	22.75
15/2/2022	23.07	21.59
16/2/2022	23.29	21.15
17/2/2022	23.49	20.5
18/2/2022	23.53	19.85
21/2/2022	23.85	19.61
22/2/2022	23.56	19.32
23/2/2022	23.69	19.36
24/2/2022	23.13	18.55
25/2/2022	22.83	18.6
28/2/2022	22.81	18.15
1/3/2022	22.96	17.76
2/3/2022	22.58	18.59
3/3/2022	22.47	19.37
4/3/2022	22.21	19.2
7/3/2022	21.77	19.54
8/3/2022	21.67	18.66
9/3/2022	21.96	18.83
10/3/2022	22.65	18.2
11/3/2022	22.67	18.23
14/3/2022	23.23	18.04
15/3/2022	23.49	17.15
16/3/2022	23.69	17.4
17/3/2022	23.68	18.17
18/3/2022	23.66	18.57
21/3/2022	23.55	18.71
22/3/2022	23.62	18.94
23/3/2022	23.8	19
24/3/2022	23.89	18.94
25/3/2022	23.75	19.27
28/3/2022	24.03	19.42
29/3/2022	24.29	19.49
30/3/2022	24.51	19.8
31/3/2022	24.24	20.66
1/4/2022	23.95	21.06
4/4/2022	23.91	21.7
5/4/2022	24.05	21.72
6/4/2022	24.24	21.66
7/4/2022	24.11	21.75
8/4/2022	24.1	21.83
11/4/2022	24.24	21.19
12/4/2022	24.14	21.17
13/4/2022	24.29	21.34
14/4/2022	24.11	21.61
19/4/2022	24.4	21.73
20/4/2022	24.36	21.68
21/4/2022	24.51	21.48
22/4/2022	24.21	21.22
26/4/2022	23.9	19.76
27/4/2022	23.45	20.1
28/4/2022	23.59	21.73
29/4/2022	23.87	21.63
2/5/2022	23.88	21.65
3/5/2022	23.9	20.61
4/5/2022	24.07	20.12
5/5/2022	24.01	20.83
6/5/2022	23.83	20.83
9/5/2022	24.6	19.63
10/5/2022	24.65	19.11
11/5/2022	24.25	19.55
12/5/2022	23.79	19.01
13/5/2022	24	19.39
16/5/2022	24.38	18.96
17/5/2022	24.46	19.39
18/5/2022	24.44	19.78
19/5/2022	23.45	19.4
20/5/2022	23.57	20.15
23/5/2022	23.41	20.71
24/5/2022	23.54	20.77
25/5/2022	23.87	20.68
26/5/2022	23.9	19.92
27/5/2022	24.09	19.59
30/5/2022	24.22	19.85
31/5/2022	23.87	20.11
1/6/2022	24.1	20.76
2/6/2022	23.93	20.61
3/6/2022	24	21.46
6/6/2022	23.92	21.4
7/6/2022	23.41	21.16
8/6/2022	21.98	21.63
9/6/2022	21.17	21.56
10/6/2022	20.85	21.45
14/6/2022	20.07	19.63
15/6/2022	19.7	19.88
16/6/2022	19.33	19.63
17/6/2022	19.19	18.6
20/6/2022	19.19	17
21/6/2022	19.71	17.59
22/6/2022	19.53	17.62
23/6/2022	19.62	17.25
24/6/2022	19.48	17.28
27/6/2022	19.92	17.88
28/6/2022	19.75	18.56
29/6/2022	19.94	18.4
30/6/2022	19.5	17.53
1/7/2022	19.42	17
4/7/2022	19.67	17.07
5/7/2022	19.67	17.32
6/7/2022	19.85	16.48
7/7/2022	20	17.2
8/7/2022	19.95	17.3
11/7/2022	19.94	16.85
12/7/2022	20.1	16.89
13/7/2022	20.16	16.99
14/7/2022	19.94	17.41
15/7/2022	19.9	16.33
18/7/2022	20.15	16.89
19/7/2022	20.3	17.01
20/7/2022	20.53	17.9
21/7/2022	20.84	17.7
22/7/2022	21.07	17.83
25/7/2022	21.05	18.25
26/7/2022	21.13	18.7
27/7/2022	21.41	18.18
28/7/2022	21.43	18.7
29/7/2022	21.51	18.34
1/8/2022	21.66	18.21
2/8/2022	22	17.9
3/8/2022	21.75	18.02
4/8/2022	21.85	17.66
5/8/2022	21.96	18.14
8/8/2022	22.07	18.96
9/8/2022	21.9	18.95
10/8/2022	22.2	18.83
11/8/2022	22.48	19.08
12/8/2022	22.66	18.94
15/8/2022	22.43	19.13
16/8/2022	22.34	19.43
17/8/2022	22.52	19.23
18/8/2022	22.34	19.08
19/8/2022	22.18	19.16
22/8/2022	21.8	19.1
23/8/2022	21.36	19.04
24/8/2022	21.38	19.12
25/8/2022	21.59	19.14
26/8/2022	21.68	19.87
29/8/2022	21.27	18.89
30/8/2022	21.28	18.95
31/8/2022	21.61	18.42
1/9/2022	21.23	17.64
2/9/2022	21.4	17.2
5/9/2022	21.35	16.41
6/9/2022	21.27	16.44
7/9/2022	20.83	16
8/9/2022	21.17	16.78
9/9/2022	21.25	17.81
12/9/2022	21.47	18.4
13/9/2022	21.59	18.23
14/9/2022	21.19	17.77
15/9/2022	21.54	17.93
16/9/2022	21.53	17.62
19/9/2022	21.55	17.45
20/9/2022	21.89	17.3
21/9/2022	21.73	16.54
23/9/2022	21.42	16.76
26/9/2022	21.18	15.94
27/9/2022	21.06	16.82
28/9/2022	20.93	16.46
29/9/2022	21.12	16.78
30/9/2022	20.64	16.82
3/10/2022	20.6	16.93
4/10/2022	21.43	17.21
5/10/2022	22.15	17.62
6/10/2022	21.94	17.6
7/10/2022	21.88	17.31
10/10/2022	21.58	17.63
11/10/2022	21.6	17.24
12/10/2022	22.41	16.76
13/10/2022	23.07	16.99
14/10/2022	23.5	17.11
17/10/2022	23.43	16.91
18/10/2022	23.98	17.07
19/10/2022	23.65	17.21
20/10/2022	23.92	16.52
21/10/2022	23.73	16.36
24/10/2022	23.87	16.77
25/10/2022	23.9	16.26
26/10/2022	24.01	16.13
27/10/2022	23.77	16.07
28/10/2022	23.99	14.76
31/10/2022	24.11	14.7
1/11/2022	24.32	15.5
2/11/2022	24.5	15.73
3/11/2022	23.91	15.28
4/11/2022	24.14	15.87
7/11/2022	23.19	16.64
8/11/2022	23.66	16.63
9/11/2022	23.72	17.12
10/11/2022	23.61	16.78
11/11/2022	24.08	17.76
14/11/2022	23.85	19.55
15/11/2022	23.96	19.4
16/11/2022	23.84	19.85
17/11/2022	23.2	19.5
18/11/2022	23.62	19.96
21/11/2022	23.97	19.21
22/11/2022	23.94	19.2
23/11/2022	24.08	19.07
24/11/2022	23.87	19.17
25/11/2022	23.99	18.94
28/11/2022	23.76	19.04
29/11/2022	23.83	19.46
30/11/2022	23.77	19.38
1/12/2022	23.92	19.96
2/12/2022	23.76	19.68
5/12/2022	23.72	21.03
6/12/2022	23.75	20.7
7/12/2022	23.57	21.17
8/12/2022	23.29	20.8
9/12/2022	23.44	21.39
12/12/2022	23.36	21.12
13/12/2022	23.66	20.23
14/12/2022	23.57	20.46
15/12/2022	23.5	20.41
16/12/2022	23.3	20.13
19/12/2022	23.25	20.23
20/12/2022	23.28	19.93
21/12/2022	23.55	20.53
22/12/2022	23.55	20.7
23/12/2022	23.5	20.57
28/12/2022	23.49	20.83
29/12/2022	23.27	20.66
30/12/2022	23.35	20.51
3/1/2023	22.73	20.4
4/1/2023	23.44	20.97
5/1/2023	23.47	21.03
6/1/2023	23.4	21.8
9/1/2023	23.37	21.63
10/1/2023	23.41	21.77
11/1/2023	23.3	22.3
12/1/2023	23.5	22.92
13/1/2023	23.76	22.8
16/1/2023	23.93	22.33
17/1/2023	23.93	22.03
18/1/2023	23.82	22.2
19/1/2023	23.95	22.58
20/1/2023	24	22.6
23/1/2023	23.89	22.38
24/1/2023	23.65	22.51
25/1/2023	23.67	22.48
27/1/2023	23.93	22.49
30/1/2023	23.75	22.19
31/1/2023	23.72	22.24
1/2/2023	23.6	22.33
2/2/2023	23.5	22.24
3/2/2023	23.92	21.95
6/2/2023	23.85	21.96
7/2/2023	23.73	22.05
8/2/2023	23.9	22.48
9/2/2023	23.9	22.52
10/2/2023	23.84	22
13/2/2023	23.7	22.14
14/2/2023	23.86	22.18
15/2/2023	22.83	22
16/2/2023	22.76	22.32
17/2/2023	22.78	22.26
20/2/2023	23.01	22.58
21/2/2023	22.84	23.3
22/2/2023	22.87	22.89
23/2/2023	22.66	22.83
24/2/2023	22.67	22.44
27/2/2023	22.73	20.81
28/2/2023	22.53	21.4
1/3/2023	22.07	22.12
2/3/2023	21.64	23.06
3/3/2023	21.73	22.76
6/3/2023	22.09	22.2
7/3/2023	22.37	22.52
8/3/2023	22.11	22.2
9/3/2023	22.38	22.11
10/3/2023	21.79	21.51
13/3/2023	21.49	21.76
14/3/2023	21.41	21.45
15/3/2023	21.65	21.73
16/3/2023	21.19	21.04
17/3/2023	21.24	21.42
20/3/2023	21.12	20.8
21/3/2023	21.42	20.77
22/3/2023	21.43	21.03
23/3/2023	21.33	20.33
24/3/2023	21.2	20.32
27/3/2023	21.23	20.32
28/3/2023	21.53	20.56
29/3/2023	21.69	21.16
30/3/2023	21.69	21.61
31/3/2023	21.66	22.49