Topic 05 - Class Portfolio Theory
Topic 05 - Class Portfolio Theory
Topic 05 - Class Portfolio Theory
Adani
and Special Hospitals Asian Paints Axis Bank Bajaj Finance Bajaj Finserv
Enterprises .
Economic Enterprise Ltd. Ltd. Ltd. Ltd.
Ltd.
Zone Ltd. Ltd.
6.5 8.6
-9.7 7.3
-14.9 2.2
13.4 -2.0
-0.2 1.9
-12.6 11.0
8.4 -0.1
4.4 -8.2
14.4 15.8
3.1 -4.2
-4.4 -2.1
-4.7 -5.6
-7.0 -4.2
6.9 -5.9
-4.7 7.8
2.8 -8.7
-5.1 3.4
8.8 -3.7
-4.6 -6.7
-26.3 -11.9
8.5 -3.0
10.0 10.8
-0.3 3.2
5.6 24.6
-5.3 -3.5
3.7 14.5
12.2 8.3
4.9 2.8
9.6 9.7
0.7 7.9
13.8 -1.8
9.7 0.9
-7.1 17.4
6.6 9.0
1.0 1.2
11.7 7.3
2.8 8.8
-5.7 -1.1
3.2 2.0
-2.7 -1.5
2.1 11.6
-5.1 -22.3
-9.4 -3.0
0.5 6.3
0.4 -15.1
-8.6 -6.2
-8.1 -13.9
15.5 1.8
2.0 -2.4
-6.5 -4.8
7.1 -2.0
5.3 5.1
-1.7 -3.5
1.8 1.5
2.5 -3.0
4.8 -5.8
-0.9 5.3
4.1 4.7
5.3 -3.7
0.3 4.0
-0.2 0.8
-0.5 -0.6
2.0 -6.2
6.7 7.9
15.4 13.2
-3.2 1.4
-2.7 8.1
-1.5 -7.7
2.3 -3.8
-0.6 -5.4
16.3 16.1
-0.7 5.0
Adani Ports Apollo
Adani
and Special Hospitals Asian Paints
Enterprises
Economic Enterprise Ltd.
Ltd.
Zone Ltd. Ltd.
1.00
0.58 1.00
0.71 0.45 1.00
0.70 0.50 0.91 1.00
0.54 0.58 0.41 0.52 1.00
0.43 0.44 0.39 0.50 0.44 1.00
0.32 0.41 0.37 0.32 0.38 0.24 1.00
0.05 0.29 -0.04 0.05 0.03 0.15 0.14
0.50 0.48 0.38 0.40 0.37 0.29 0.08
0.26 0.12 0.29 0.28 0.07 0.13 0.08
-0.04 0.16 -0.10 -0.08 0.07 -0.03 0.27
0.44 0.58 0.44 0.46 0.43 0.32 0.54
0.55 0.54 0.50 0.61 0.46 0.38 0.26
0.31 0.38 0.23 0.24 0.24 0.08 0.37
0.74 0.51 0.70 0.73 0.58 0.39 0.45
0.39 0.47 0.45 0.42 0.47 0.39 0.46
0.41 0.77 0.35 0.38 0.52 0.34 0.58
0.63 0.51 0.59 0.66 0.46 0.31 0.28
0.05 0.00 0.23 0.14 0.13 0.01 0.55
0.78 0.52 0.73 0.69 0.43 0.38 0.23
0.79 0.60 0.79 0.80 0.55 0.42 0.32
0.29 0.12 0.27 0.28 0.17 0.09 0.19
0.38 0.40 0.40 0.42 0.26 0.34 0.37
0.59 0.46 0.50 0.58 0.37 0.27 0.12
0.52 0.36 0.68 0.63 0.38 0.37 0.31
0.66 0.61 0.66 0.67 0.52 0.38 0.42
0.42 0.29 0.41 0.47 0.21 0.22 0.27
0.58 0.62 0.49 0.51 0.52 0.34 0.50
0.57 0.69 0.50 0.45 0.52 0.37 0.43
0.20 0.15 0.27 0.19 0.14 0.13 0.44
0.53 0.43 0.36 0.36 0.38 0.26 0.15
0.54 0.53 0.37 0.42 0.52 0.41 0.11
0.45 0.30 0.44 0.42 0.37 0.28 0.15
0.43 0.52 0.33 0.38 0.58 0.35 0.40
0.47 0.47 0.61 0.57 0.35 0.36 0.49
0.63 0.54 0.63 0.65 0.46 0.38 0.21
0.70 0.38 0.66 0.61 0.51 0.32 0.14
0.25 0.40 0.15 0.21 0.22 0.26 0.23
0.35 0.34 0.17 0.18 0.28 0.10 0.34
0.43 0.38 0.47 0.49 0.46 0.34 0.43
0.60 0.64 0.43 0.48 0.48 0.29 0.30
0.58 0.43 0.58 0.67 0.42 0.26 0.13
0.43 0.28 0.46 0.48 0.18 0.17 0.24
0.55 0.39 0.71 0.69 0.36 0.19 0.36
0.47 0.42 0.45 0.54 0.46 0.39 0.35
0.19 0.20 0.18 0.23 0.11 -0.04 0.13
Divi's Dr. Reddy's Grasim HCL
Coal India Eicher Motors
Cipla Ltd. Laboratories Laboratories Industries Technologies
Ltd. Ltd.
Ltd. Ltd. Ltd. Ltd.
1.00
0.19 1.00
0.16 0.07 1.00
0.47 -0.06 0.21 1.00
0.25 0.39 0.17 0.09 1.00
0.20 0.35 0.19 0.03 0.54 1.00
0.42 0.15 0.20 0.46 0.30 0.30 1.00
-0.06 0.36 0.21 0.01 0.48 0.54 0.22
0.18 0.14 0.10 0.14 0.43 0.33 0.36
0.29 0.37 0.10 0.17 0.60 0.43 0.28
0.18 0.52 0.40 0.04 0.41 0.56 0.31
-0.04 -0.04 0.06 0.03 0.26 0.01 0.18
0.03 0.44 0.30 -0.05 0.35 0.49 0.18
0.03 0.44 0.23 -0.07 0.47 0.60 0.28
0.28 -0.04 0.17 0.34 -0.02 0.19 0.69
0.16 0.46 0.12 0.12 0.54 0.51 0.21
0.28 0.31 0.54 0.24 0.32 0.62 0.32
-0.08 0.41 0.12 -0.08 0.29 0.35 0.10
0.05 0.49 0.14 -0.01 0.49 0.63 0.28
0.21 0.04 0.26 0.01 0.31 0.47 0.57
0.26 0.37 0.16 0.13 0.71 0.59 0.33
0.18 0.41 0.06 0.07 0.68 0.48 0.31
0.03 0.11 0.17 0.22 0.20 0.08 0.22
0.21 0.69 0.14 -0.02 0.33 0.53 0.16
0.23 0.68 0.05 0.07 0.33 0.52 0.19
0.05 0.53 0.05 0.00 0.23 0.39 0.08
0.34 0.30 0.13 0.43 0.34 0.41 0.54
0.28 0.28 0.14 0.12 0.46 0.37 0.40
-0.02 0.25 0.22 -0.12 0.36 0.47 0.10
-0.04 0.55 0.18 -0.17 0.35 0.54 0.03
0.59 0.23 0.34 0.38 0.27 0.31 0.53
0.38 0.07 0.06 0.29 0.28 0.33 0.68
0.23 0.21 0.35 0.08 0.33 0.46 0.34
0.22 0.40 0.13 0.05 0.51 0.58 0.29
0.21 0.42 0.53 -0.01 0.36 0.58 0.23
0.14 0.08 0.34 0.19 0.29 0.38 0.66
0.06 0.32 0.27 0.07 0.39 0.48 0.39
0.07 0.21 0.21 0.09 0.37 0.74 0.42
0.34 0.02 0.30 0.34 0.15 0.25 0.60
HDFC Life Hero Hindalco
HDFC Bank Hindustan ICICI Bank IndusInd
Insurance MotoCorp Industries
Ltd. Unilever Ltd. Ltd. Bank Ltd.
Company Ltd. Ltd. Ltd.
1.00
0.50 1.00
0.47 0.53 1.00
0.66 0.33 0.49 1.00
0.11 0.31 0.09 -0.10 1.00
0.68 0.35 0.39 0.64 0.03 1.00
0.77 0.43 0.47 0.71 -0.01 0.78 1.00
0.17 0.26 0.08 0.28 0.07 0.17 0.24
0.45 0.32 0.34 0.43 0.10 0.40 0.46
0.49 0.23 0.28 0.67 -0.10 0.55 0.59
0.69 0.47 0.35 0.44 0.23 0.64 0.64
0.68 0.45 0.58 0.66 0.06 0.67 0.67
0.39 0.29 0.15 0.33 0.18 0.32 0.35
0.59 0.55 0.70 0.49 0.07 0.50 0.58
0.51 0.51 0.65 0.38 0.10 0.48 0.59
0.28 0.40 0.16 0.06 0.53 0.27 0.07
0.45 0.25 0.43 0.55 0.00 0.53 0.52
0.43 0.22 0.44 0.55 -0.21 0.51 0.50
0.41 0.25 0.31 0.44 0.02 0.46 0.43
0.46 0.39 0.47 0.43 -0.01 0.34 0.47
0.40 0.70 0.45 0.40 0.33 0.54 0.50
0.60 0.39 0.41 0.38 0.05 0.64 0.66
0.62 0.27 0.30 0.58 -0.03 0.80 0.70
0.07 0.22 0.33 0.42 -0.03 0.30 0.29
0.25 0.36 0.22 0.17 0.26 0.10 0.14
0.45 0.40 0.43 0.43 0.28 0.42 0.46
0.50 0.39 0.53 0.50 -0.10 0.59 0.59
0.53 0.25 0.26 0.78 -0.02 0.63 0.62
0.29 0.22 0.13 0.36 0.18 0.37 0.34
0.53 0.38 0.28 0.42 0.32 0.50 0.53
0.56 0.42 0.37 0.51 0.21 0.46 0.50
0.08 0.20 0.05 0.28 0.05 0.14 0.10
Kotak Mahindra &
Larsen & LTIMindtree
Infosys Ltd. ITC Ltd. JSW Steel Ltd. Mahindra Mahindra
Toubro Ltd. Ltd.
Bank Ltd. Ltd.
1.00
0.09 1.00
0.30 0.32 1.00
0.12 0.46 0.29 1.00
0.17 0.54 0.45 0.54 1.00
0.55 0.20 0.40 0.20 0.40 1.00
0.18 0.48 0.42 0.34 0.62 0.40 1.00
0.07 0.34 0.36 0.38 0.59 0.28 0.69
0.02 0.23 0.05 0.37 0.31 0.18 0.12
-0.01 0.48 0.40 0.38 0.55 0.16 0.50
0.07 0.47 0.44 0.34 0.55 0.12 0.48
0.11 0.38 0.29 0.44 0.46 0.09 0.44
0.36 0.29 0.41 0.30 0.25 0.25 0.46
0.31 0.36 0.31 0.40 0.52 0.40 0.57
0.13 0.24 0.44 0.45 0.52 0.28 0.51
0.07 0.37 0.43 0.54 0.64 0.20 0.50
0.39 0.33 0.45 -0.02 0.27 0.27 0.30
0.55 0.17 0.23 0.06 0.20 0.47 0.28
0.24 0.21 0.42 0.29 0.46 0.45 0.45
0.13 0.39 0.43 0.33 0.53 0.37 0.64
0.25 0.39 0.78 0.42 0.54 0.36 0.42
0.64 0.19 0.41 0.15 0.35 0.70 0.29
0.27 0.30 0.37 0.48 0.60 0.51 0.36
0.37 0.42 0.50 0.43 0.61 0.50 0.50
0.56 0.05 0.37 0.02 0.16 0.58 0.19
Oil & Natural
Power Grid Reliance SBI Life
Maruti Suzuki Nestle India Gas
NTPC Ltd. Corporation Industries Insurance
India Ltd. Ltd. Corporation
Of India Ltd. Ltd. Company Ltd.
Ltd.
1.00
0.25 1.00
0.42 0.15 1.00
0.47 -0.06 0.71 1.00
0.21 0.20 0.68 0.55 1.00
0.46 0.15 0.33 0.47 0.28 1.00
0.52 0.43 0.30 0.27 0.35 0.32 1.00
0.43 0.16 0.37 0.42 0.44 0.26 0.38
0.40 0.12 0.58 0.60 0.59 0.31 0.46
0.22 0.11 0.35 0.34 0.19 0.40 0.39
0.25 0.23 0.15 0.19 0.15 0.43 0.30
0.37 0.28 0.39 0.31 0.32 0.40 0.47
0.57 0.04 0.47 0.60 0.38 0.44 0.42
0.29 0.03 0.45 0.47 0.36 0.25 0.35
0.24 0.12 0.09 0.18 0.12 0.30 0.37
0.49 0.42 0.32 0.28 0.23 0.36 0.44
0.39 0.29 0.37 0.31 0.30 0.36 0.46
-0.01 0.06 -0.04 0.10 0.04 0.26 0.32
Sun
Tata Tata
Shriram State Bank Of Pharmaceutic Tata Motors Tata Steel
Consultancy Consumer
Finance Ltd. India al Industries Ltd. Ltd.
Services Ltd. Products Ltd.
Ltd.
1.00
0.58 1.00
0.16 0.21 1.00
0.13 0.07 0.34 1.00
0.27 0.40 0.35 0.31 1.00
0.53 0.57 0.33 0.35 0.41 1.00
0.46 0.57 0.45 0.17 0.42 0.50 1.00
0.28 0.16 0.30 0.46 0.30 0.34 0.41
0.45 0.41 0.12 0.26 0.41 0.38 0.40
0.39 0.39 0.22 0.32 0.40 0.37 0.52
0.01 0.09 0.29 0.58 0.20 0.28 0.37
Tech
Titan Ultratech
Mahindra Wipro Ltd.
Company Ltd. Cement Ltd.
Ltd.
1.00
0.51 1.00
0.50 0.41 1.00
0.66 0.26 0.33 1.00
Equal
Asian Paints Weight Bharti Risk Return Profile-Low Correlation
Correl = 0.05
Ltd. Portfoli Airtel Ltd.
2.10
o
-5.59 -3.7 -1.74 1.90
-5.94 -9.2 -12.56 Equal Weight Portfolio, Bhar
1.70
1.24 3.2 5.06 [X VALUE], [Y VALUE] VAL
-0.65 -0.6 -0.62 1.50
Risk 7.06 5.12 7.04
Return
Return 0.96 1.45 1.95 1.30
1.10
As the correlation is lower (0.05), the portfolio 0.90 Asian Paints Ltd., [X
risk is significantly lower than the average of VALUE], [Y VALUE]
both the stocks. 0.70
0.50
4.00 4.50 5.00 5.50 6.00 6.50 7.00
Risk
e-Low Correlation
Risk
Equal
ICICI Bank Weight State Bank Risk Return Profile-High Correlation
Correl = 0.8
Ltd. Portfoli Of India
2.00
o
11.87 8.6 5.34 1.90 ICICI Bank Ltd., [X
-11.45 -13.4 -15.37 VALUE], [Y VALUE] Equal Weight Portfolio,
[X VALUE], [Y VALUE]
6.77 4.5 2.22 1.80
2.91 1.9 0.86
Risk 8.75 9.24 10.74 1.70
1.72
Return
Return 1.95 1.49
1.60
State
VAL
1.50
As the correlation is Higher, There is no
significant reduction in the portfolio risk. 1.40
1.30
4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00
Risk
igh Correlation
[X
UE] Equal Weight Portfolio,
[X VALUE], [Y VALUE]
sk
Stock-A Stock-B
Risk 20.00 34.00 Case-1 Case-2 Case-3
Return 12.00 18.00 Correlation
Correlation 1.00 1.00 1.00
Portfolio Portfolio Portfolio Portfolio Portfolio
Weight-A Weight-B
Risk Return Risk Return Risk
100% 0.00% 20.00 12.00 20.00 12.00 20.00
99.00% 1.00% 20.14 12.06 20.14 12.06 20.14
98.00% 2.00% 20.28 12.12 20.28 12.12 20.28
97.00% 3.00% 20.42 12.18 20.42 12.18 20.42
96.00% 4.00% 20.56 12.24 20.56 12.24 20.56
95.00% 5.00% 20.70 12.30 20.70 12.30 20.70
94.00% 6.00% 20.84 12.36 20.84 12.36 20.84
93.00% 7.00% 20.98 12.42 20.98 12.42 20.98
92.00% 8.00% 21.12 12.48 21.12 12.48 21.12
91.00% 9.00% 21.26 12.54 21.26 12.54 21.26
90.00% 10.00% 21.40 12.60 21.40 12.60 21.40
89.00% 11.00% 21.54 12.66 21.54 12.66 21.54
88.00% 12.00% 21.68 12.72 21.68 12.72 21.68
87.00% 13.00% 21.82 12.78 21.82 12.78 21.82
86.00% 14.00% 21.96 12.84 21.96 12.84 21.96
85.00% 15.00% 22.10 12.90 22.10 12.90 22.10
84.00% 16.00% 22.24 12.96 22.24 12.96 22.24
83.00% 17.00% 22.38 13.02 22.38 13.02 22.38
82.00% 18.00% 22.52 13.08 22.52 13.08 22.52
81.00% 19.00% 22.66 13.14 22.66 13.14 22.66
80.00% 20.00% 22.80 13.20 22.80 13.20 22.80
79.00% 21.00% 22.94 13.26 22.94 13.26 22.94
78.00% 22.00% 23.08 13.32 23.08 13.32 23.08
77.00% 23.00% 23.22 13.38 23.22 13.38 23.22
76.00% 24.00% 23.36 13.44 23.36 13.44 23.36
75.00% 25.00% 23.50 13.50 23.50 13.50 23.50
74.00% 26.00% 23.64 13.56 23.64 13.56 23.64
73.00% 27.00% 23.78 13.62 23.78 13.62 23.78
72.00% 28.00% 23.92 13.68 23.92 13.68 23.92
71.00% 29.00% 24.06 13.74 24.06 13.74 24.06
70.00% 30.00% 24.20 13.80 24.20 13.80 24.20
69.00% 31.00% 24.34 13.86 24.34 13.86 24.34
68.00% 32.00% 24.48 13.92 24.48 13.92 24.48
67.00% 33.00% 24.62 13.98 24.62 13.98 24.62
66.00% 34.00% 24.76 14.04 24.76 14.04 24.76
65.00% 35.00% 24.90 14.10 24.90 14.10 24.90
64.00% 36.00% 25.04 14.16 25.04 14.16 25.04
63.00% 37.00% 25.18 14.22 25.18 14.22 25.18
62.00% 38.00% 25.32 14.28 25.32 14.28 25.32
61.00% 39.00% 25.46 14.34 25.46 14.34 25.46
60.00% 40.00% 25.60 14.40 25.60 14.40 25.60
59.00% 41.00% 25.74 14.46 25.74 14.46 25.74
58.00% 42.00% 25.88 14.52 25.88 14.52 25.88
57.00% 43.00% 26.02 14.58 26.02 14.58 26.02
56.00% 44.00% 26.16 14.64 26.16 14.64 26.16
55.00% 45.00% 26.30 14.70 26.30 14.70 26.30
54.00% 46.00% 26.44 14.76 26.44 14.76 26.44
53.00% 47.00% 26.58 14.82 26.58 14.82 26.58
52.00% 48.00% 26.72 14.88 26.72 14.88 26.72
51.00% 49.00% 26.86 14.94 26.86 14.94 26.86
50.00% 50.00% 27.00 15.00 27.00 15.00 27.00
49.00% 51.00% 27.14 15.06 27.14 15.06 27.14
48.00% 52.00% 27.28 15.12 27.28 15.12 27.28
47.00% 53.00% 27.42 15.18 27.42 15.18 27.42
46.00% 54.00% 27.56 15.24 27.56 15.24 27.56
45.00% 55.00% 27.70 15.30 27.70 15.30 27.70
44.00% 56.00% 27.84 15.36 27.84 15.36 27.84
43.00% 57.00% 27.98 15.42 27.98 15.42 27.98
42.00% 58.00% 28.12 15.48 28.12 15.48 28.12
41.00% 59.00% 28.26 15.54 28.26 15.54 28.26
40.00% 60.00% 28.40 15.60 28.40 15.60 28.40
39.00% 61.00% 28.54 15.66 28.54 15.66 28.54
38.00% 62.00% 28.68 15.72 28.68 15.72 28.68
37.00% 63.00% 28.82 15.78 28.82 15.78 28.82
36.00% 64.00% 28.96 15.84 28.96 15.84 28.96
35.00% 65.00% 29.10 15.90 29.10 15.90 29.10
34.00% 66.00% 29.24 15.96 29.24 15.96 29.24
33.00% 67.00% 29.38 16.02 29.38 16.02 29.38
32.00% 68.00% 29.52 16.08 29.52 16.08 29.52
31.00% 69.00% 29.66 16.14 29.66 16.14 29.66
30.00% 70.00% 29.80 16.20 29.80 16.20 29.80
29.00% 71.00% 29.94 16.26 29.94 16.26 29.94
28.00% 72.00% 30.08 16.32 30.08 16.32 30.08
27.00% 73.00% 30.22 16.38 30.22 16.38 30.22
26.00% 74.00% 30.36 16.44 30.36 16.44 30.36
25.00% 75.00% 30.50 16.50 30.50 16.50 30.50
24.00% 76.00% 30.64 16.56 30.64 16.56 30.64
23.00% 77.00% 30.78 16.62 30.78 16.62 30.78
22.00% 78.00% 30.92 16.68 30.92 16.68 30.92
21.00% 79.00% 31.06 16.74 31.06 16.74 31.06
20.00% 80.00% 31.20 16.80 31.20 16.80 31.20
19.00% 81.00% 31.34 16.86 31.34 16.86 31.34
18.00% 82.00% 31.48 16.92 31.48 16.92 31.48
17.00% 83.00% 31.62 16.98 31.62 16.98 31.62
16.00% 84.00% 31.76 17.04 31.76 17.04 31.76
15.00% 85.00% 31.90 17.10 31.90 17.10 31.90
14.00% 86.00% 32.04 17.16 32.04 17.16 32.04
13.00% 87.00% 32.18 17.22 32.18 17.22 32.18
12.00% 88.00% 32.32 17.28 32.32 17.28 32.32
11.00% 89.00% 32.46 17.34 32.46 17.34 32.46
10.00% 90.00% 32.60 17.40 32.60 17.40 32.60
9.00% 91.00% 32.74 17.46 32.74 17.46 32.74
8.00% 92.00% 32.88 17.52 32.88 17.52 32.88
7.00% 93.00% 33.02 17.58 33.02 17.58 33.02
6.00% 94.00% 33.16 17.64 33.16 17.64 33.16
5.00% 95.00% 33.30 17.70 33.30 17.70 33.30
4.00% 96.00% 33.44 17.76 33.44 17.76 33.44
3.00% 97.00% 33.58 17.82 33.58 17.82 33.58
2.00% 98.00% 33.72 17.88 33.72 17.88 33.72
1.00% 99.00% 33.86 17.94 33.86 17.94 33.86
0.00% 100.00% 34.00 18.00 34.00 18.00 34.00
Case-3
Chart Title
1.00 20.00
Portfolio
Return 18.00
12.00
12.06 16.00
12.12 Column E
Return
Total Weight
1.00
26.95
5.19
Adani Ports Bharat
and Special Asian Paints Bajaj Finance Petroleum
Economic Ltd. Ltd. Corporation
Zone Ltd. Ltd.
-4.24 -5.59 5.72 -7.36 1. Covariance Matrix
42.51
6.52