0% found this document useful (0 votes)
31 views14 pages

Portfolio Constructing-Group 6

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
31 views14 pages

Portfolio Constructing-Group 6

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 14

Effi ient Fronti er

3.00%

2.50%

2.00%

1.50%

1.00%

0.50%

0.00%
4.00% 6.00% 8.00% 1 0 . 0 0% 1 2 . 0 0% 1 4 . 0 0% 1 6 . 0 0% 1 8 . 0 0% 2 0 . 0 0% 2 2 . 0 0%

-0.50%
DATE PLX PVO VCB TCB VHM
1/1/2019 39,500.00 6,300 61,003 24,650.00 40,000
2/1/2019 37,500.00 6,300 93,300 23,600.00 40,800
3/1/2019 40,000.00 6,500 93,600 23,900.00 41,500
4/1/2019 41,100.00 7,200 92,000 24,200.00 42,800
5/1/2019 44,500.00 7,892 91,700 23,350.00 41,500
6/1/2019 48,600.00 6,905 89,200 23,250.00 36,700
7/1/2019 45,900.00 7,103 85,200 23,350.00 37,650
8/1/2019 40,900.00 6,708 87,200 23,500.00 38,850
9/1/2019 41,000.00 5,524 91,200 23,300.00 40,800
10/1/2019 34,356.00 5,524 94,900 23,775.00 42,850
11/1/2019 35,896.00 5,228 97,300 21,100.00 43,400
12/1/2019 34,501.00 5,130 88,500 17,275.00 41,500
1/1/2020 33,298.00 5,130 80,300 15,900.00 43,200
2/1/2020 33,201.00 5,327 84,700 14,750.00 41,300
3/1/2020 33,779.00 5,524 86,800 13,850.00 39,000
4/1/2020 30,699.00 5,820 87,500 16,825.00 45,500
5/1/2020 36,088.00 6,014 89,100 17,250.00 54,700
6/1/2020 36,456.00 6,111 91,600 17,150.00 63,000
7/1/2020 39,246.00 5,820 84,674 16,175.00 55,000
8/1/2020 35,321.00 6,014 79,594 14,975.00 53,500
9/1/2020 35,463.00 4,559 76,630 14,750.00 49,500
10/1/2020 35,416.00 4,753 77,392 14,175.00 51,500
11/1/2020 35,416.00 4,947 79,170 13,250.00 41,500
12/1/2020 35,274.00 5,335 77,815 14,700.00 50,900
1/1/2021 34,801.00 4,753 67,739 12,925.00 48,000
2/1/2021 29,978.00 4,947 68,586 12,950.00 54,500
3/1/2021 27,898.00 6,208 62,235 12,300.00 45,000
4/1/2021 25,854.00 7,469 61,981 16,250.00 50,700
5/1/2021 29,845.00 9,312 71,126 19,475.00 61,000
6/1/2021 38,282.00 7,954 63,252 18,950.00 59,900
7/1/2021 37,284.00 8,536 63,336 17,775.00 62,100
8/1/2021 36,558.00 12,126 66,808 18,575.00 69,600
9/1/2021 39,915.00 10,476 68,501 22,000.00 63,156
10/1/2021 43,543.00 15,715 69,517 24,775.00 73,650
11/1/2021 50,075.00 11,156 71,550 25,200.00 75,301
12/1/2021 56,515.00 8,633 75,360 26,400.00 78,022
1/1/2022 50,891.00 9,603 66,723 25,000.00 79,674
2/1/2022 48,895.00 10,282 64,833 25,900.00 82,200
3/1/2022 49,077.00 9,894 64,243 25,800.00 83,074
4/1/2022 49,077.00 8,245 63,718 24,800.00 76,079
5/1/2022 46,809.00 6,329 65,161 24,250.00 78,667
6/1/2022 45,085.00 6,041 64,243 25,550.00 80,071
7/1/2022 46,537.00 7,383 76,305 26,350.00 87,243
8/1/2022 49,712.00 6,712 64,636 26,850.00 75,857
9/1/2022 48,516.00 6,904 65,554 20,500.00 73,417
10/1/2022 44,695.00 8,438 62,145 20,200.00 71,939
11/1/2022 48,960.00 4,315 64,374 19,625.00 75,118
12/1/2022 51,715.00 3,836 60,965 16,000.00 69,129
1/1/2023 43,540.00 4,699 64,177 15,750.00 66,172
2/1/2023 48,516.00 3,164 60,472 12,050.00 61,070
3/1/2023 45,140.00 2,973 53,970 10,675.00 56,190
4/1/2023 43,540.00 2,973 54,685 11,300.00 55,821
5/1/2023 44,695.00 2,685 53,970 10,650.00 58,039
6/1/2023 45,768.00 2,493 49,678 9,075.00 57,447
7/1/2023 36,789.00 2,685 52,214 9,775.00 55,821
8/1/2023 38,794.00 2,877 55,400 10,350.00 56,634
9/1/2023 40,232.00 2,781 44,216 8,600.00 47,023
10/1/2023 35,133.00 2,493 40,315 7,500.00 40,664
11/1/2023 31,820.00 3,068 53,579 11,125.00 59,444
12/1/2023 42,706.00 3,068 57,676 10,800.00 64,693

Mean 0.28%
Variance 0.00893908516
Std.dev 0.09454673534

Stock Mean Return Variance Weight Expected Return


X̄ s^2 Wi E(r)
PLX
0.28% 0.00893908516 0.455 0.127%

PVO
2.82% 0.03842633703 0.111 0.3122%

VCB
0.51% 0.0082246541 0.287 0.1453%

TCB
1.89% 0.01283835703 0.094 0.1775%

VHM
-0.22% 0.01027723954 0.053 -0.0115%

DXG
1.90% 0.02926774761 0.00000 0.0000%

Sum 1 0.7500%

Portfolio Return
E(Rₚ) 0.00750000005
Portfolio Variance
σp^2 0.00329081662
Portfolio Std.dev
σp 0.05736563976

Yearly Monthly Portfolio


Return Return Std.dev
Minimum -2.64% -0.22% 10.14%

2% 0.17% 6.40%

6% 0.50% 5.84%

7% 0.58% 5.78%

8% 0.67% 5.75%

9% 0.75% 5.74% Minimum - Variance Frontier


10% 0.83% 5.75%

11% 0.92% 5.79%

12% 1.00% 5.88%

13% 1.08% 6.02%

14% 1.17% 6.20%

15% 1.25% 6.42%

16% 1.33% 6.68%

17% 1.42% 6.97%

18% 1.50% 7.30%

19% 1.58% 7.66%

20% 1.67% 8.06%

21% 1.75% 8.51%

22% 1.83% 8.99%

23% 1.92% 9.50%

24% 2.00% 10.03%

25% 2.08% 10.59%

26% 2.17% 11.16%

27% 2.25% 11.75%

28% 2.33% 12.51%

29% 2.42% 13.46%

30% 2.50% 14.55%

31% 2.58% 15.75%

32% 2.67% 17.05%


33% 2.75% 18.43%
Maximum 33.84% 2.82% 19.60%
DXG DATE PLX PVO VCB
14,966.10 1/1/2019 5.33% 0.00% -34.62%
16,788.90 2/1/2019 -6.25% -3.08% -0.32%
15,925.50 3/1/2019 -2.68% -9.72% 1.74%
16,700.00 4/1/2019 -7.64% -8.77% 0.33%
15,790.00 5/1/2019 -8.44% 14.29% 2.80%
13,850.00 6/1/2019 5.88% -2.79% 4.69%
16,000.00 7/1/2019 12.22% 5.89% -2.29%
16,800.00 8/1/2019 -0.24% 21.43% -4.39%
16,150.00 9/1/2019 19.34% 0.00% -3.90%
19,850.00 10/1/2019 -4.29% 5.66% -2.47%
18,250.00 11/1/2019 4.04% 1.91% 9.94%
18,500.00 12/1/2019 3.61% 0.00% 10.21%
19,350.00 1/1/2020 0.29% -3.70% -5.19%
18,937.90 2/1/2020 -1.71% -3.57% -2.42%
15,765.80 3/1/2020 10.03% -5.09% -0.80%
17,896.30 4/1/2020 -14.93% -3.23% -1.80%
21,068.40 5/1/2020 -1.01% -1.59% -2.73%
17,991.00 6/1/2020 -7.11% 5.00% 8.18%
14,061.40 7/1/2020 11.11% -3.23% 6.38%
14,108.80 8/1/2020 -0.40% 31.91% 3.87%
12,783.10 9/1/2020 0.13% -4.08% -0.98%
11,883.50 10/1/2020 0.00% -3.92% -2.25%
9,469.00 11/1/2020 0.40% -7.27% 1.74%
14,108.80 12/1/2020 1.36% 12.24% 14.87%
12,072.90 1/1/2021 16.09% -3.92% -1.23%
12,120.30 2/1/2021 7.46% -20.31% 10.20%
13,256.50 3/1/2021 7.91% -16.88% 0.41%
19,222.00 4/1/2021 -13.37% -19.79% -12.86%
25,092.70 5/1/2021 -22.04% 17.07% 12.45%
23,483.00 6/1/2021 2.68% -6.82% -0.13%
18,464.50 7/1/2021 1.99% -29.61% -5.20%
26,181.70 8/1/2021 -8.41% 15.75% -2.47%
34,656.40 9/1/2021 -8.33% -33.34% -1.46%
44,125.40 10/1/2021 -13.04% 40.87% -2.84%
40,053.70 11/1/2021 -11.40% 29.23% -5.06%
32,052.40 12/1/2021 11.05% -10.10% 12.94%
33,141.40 1/1/2022 4.08% -6.60% 2.92%
30,963.50 2/1/2022 -0.37% 3.92% 0.92%
22,867.50 3/1/2022 0.00% 20.00% 0.82%
18,085.70 4/1/2022 4.85% 30.27% -2.21%
18,279.20 5/1/2022 3.82% 4.77% 1.43%
17,744.00 6/1/2022 -3.12% -18.18% -15.81%
19,761.30 7/1/2022 -6.39% 10.00% 18.05%
23,054.90 8/1/2022 2.47% -2.78% -1.40%
19,308.40 9/1/2022 8.55% -18.18% 5.49%
19,761.30 10/1/2022 -8.71% 95.55% -3.46%
19,349.60 11/1/2022 -5.33% 12.49% 5.59%
16,138.40 12/1/2022 18.78% -18.37% -5.01%
13,133.00 1/1/2023 -10.26% 48.51% 6.13%
11,445.10 2/1/2023 7.48% 6.42% 12.05%
9,469.00 3/1/2023 3.67% 0.00% -1.31%
8,316.20 4/1/2023 -2.58% 10.73% 1.33%
7,970.40 5/1/2023 -2.34% 7.70% 8.64%
7,229.30 6/1/2023 24.41% -7.15% -4.86%
9,221.90 7/1/2023 -5.17% -6.67% -5.75%
9,304.30 8/1/2023 -3.57% 3.45% 25.29%
8,143.30 9/1/2023 14.51% 11.55% 9.68%
6,381.30 10/1/2023 10.41% -18.74% -24.76%
9,757.10 11/1/2023 -25.49% 0.00% -7.10%
9,510.10 12/1/2023 -2.64% 0.00% -1.66%

2.82% 0.51% 1.89% -0.22% 1.90%


0.03842633703 0.008225 0.012838 0.01027723954 0.02926774761
0.1960263682 0.09069 0.113306 0.10137672091 0.1710781915

COVARIANCE MATRIX

PLX PVO VCB TCB

PLX 0.00893908516 -0.00568333105 -0.00026336093 -0.00075080102

PVO -0.00568333105 0.03842633703 0.00258558435 0.00673740384

VCB -0.00026336093 0.00258558435 0.0082246541 0.00478818682

TCB -0.00075080102 0.00673740384 0.00478818682 0.01283835703

VHM -3.9636708E-05 0.00481412712 0.00497750804 0.00669271721

DXG -0.00204660044 0.01180260216 0.00481785821 0.01222666841


Monthly Return
Effiient Fronti
3.00%

2.50%

2.00%

1.50%

1.00%

0.50%

0.00%
4.00% 6.00% 8.00% 10.00% 12.00%

-0.50%
-0.50%
TCB VHM DXG
4.45% -1.96% -10.86%
-1.26% -1.69% 5.42%
-1.24% -3.04% -4.64%
3.64% 3.13% 5.76%
0.43% 13.08% 14.01%
-0.43% -2.52% -13.44%
-0.64% -3.09% -4.76%
0.86% -4.78% 4.02%
-2.00% -4.78% -18.64%
12.68% -1.27% 8.77%
22.14% 4.58% -1.35%
8.65% -3.94% -4.39%
7.80% 4.60% 2.18%
6.50% 5.90% 20.12%
-17.68% -14.29% -11.90%
-2.46% -16.82% -15.06%
0.58% -13.17% 17.11%
6.03% 14.55% 27.95%
8.01% 2.80% -0.34%
1.53% 8.08% 10.37%
4.06% -3.88% 7.57%
6.98% 24.10% 25.50%
-9.86% -18.47% -32.89%
13.73% 6.04% 16.86%
-0.19% -11.93% -0.39%
5.28% 21.11% -8.57%
-24.31% -11.24% -31.03%
-16.56% -16.89% -23.40%
2.77% 1.84% 6.85%
6.61% -3.54% 27.18%
-4.31% -10.78% -29.48%
-15.57% 10.20% -24.45%
-11.20% -14.25% -21.46%
-1.69% -2.19% 10.17%
-4.55% -3.49% 24.96%
5.60% -2.07% -3.29%
-3.47% -3.07% 7.03%
0.39% -1.05% 35.40%
4.03% 9.19% 26.44%
2.27% -3.29% -1.06%
-5.09% -1.75% 3.02%
-3.04% -8.22% -10.21%
-1.86% 15.01% -14.29%
30.98% 3.32% 19.40%
1.49% 2.05% -2.29%
2.93% -4.23% 2.13%
22.66% 8.66% 19.90%
1.59% 4.47% 22.88%
30.71% 8.35% 14.75%
12.88% 8.68% 20.87%
-5.53% 0.66% 13.86%
6.10% -3.82% 4.34%
17.36% 1.03% 10.25%
-7.16% 2.91% -21.61%
-5.56% -1.44% -0.89%
20.35% 20.44% 14.26%
14.67% 15.64% 27.61%
-32.58% -31.59% -34.60%
3.01% -8.11% 2.60%
-8.28% 3.18% -20.34%

X CORRELATION MATRIX

VHM DXG PLX PVO VCB

-3.9636708E-05 -0.00204660044 PLX 1

0.00481412712 0.01180260216 PVO -0.3066492612 1

0.00669271721 0.00481785821 VCB -0.03071467962 0.14544051215 1

0.00497750804 0.01222666841 TCB -0.07008476019 0.30333558484 0.46596955405

0.01027723954 0.00931800921 VHM -0.00413535506 0.24225057748 0.54139583424

0.00931800921 0.02926774761 DXG -0.12652952436 0.35193999522 0.31052784027


Effiient Frontier

Minimum-Variance Frontier

12.00% 14.00% 16.00% 18.00% 20.00% 22.00%

Standard Deviation
ELATION MATRIX

TCB VHM DXG

0.58265236114 1

0.63075217823 0.53726709765 1

You might also like