Investment Type Name of Investment Particulars Board Lot
10
AC (Ayala Corporation)
ALI (Ayala Land, 100
Incorporated)
BDO (Banco de Oro 10
EQUITIES Stocks
Unibank, Incorporated)
TEL (Philippine Long
Distance Telephone 5
Company)
SM (SM Investments 10
Corporation)
Equities 19,731,567.00
STOCKS
Valuations AC ALI BDO
EPS 2015e 29.60 1.12 6.46
P/E2015e 25.00 30.38 15.94
MPS 740.00 34.00 103.00
P/E Industry Ave 22.05 17.5 11.61
Target Price 652.68 19.60 75.00
BVS 334.86 8.68 50.25
P/BV 2015e 2.38 3.96 2.11
MPS 796.97 34.37 106.03
P/BV Industry Ave 1.57 1.47 2.18
Target Price 525.73 12.76 109.55
ROE 10.76 14.12 13.7
ROE Industry Ave 8.32 12.39 21.24
Dividend Yield 0.71 1.22 1.17
Div Yield Industry Ave 1.82 1.06 2.6
[Link]
m/finance/stocks/chart
AC ?symbol=[Link]
[Link]
m/finance/stocks/overv
ALI iew?symbol=[Link]
[Link]
m/finance/stocks/overv
BDO iew?symbol=[Link]
[Link]
m/finance/stocks/overv
TEL iew?symbol=[Link]
SM
MPS Number of Shares Investment Target Price
740 3000 2,220,000.00 1899.72
34 1,500 51,000.00 51.08
103 1,000 103,000.00 177.50
2,270 4000 9,080,000.00 2910.32
880 9250 8,140,000.00 2494.91
19,594,000.00
CKS CASH OUTLAY
TEL SM
151.53 37.13 Transaction Cost
14.98 23.7 Broker's Commission
2270.00 880.00 SEC Fee
18.64 33.68 PSE Transaction Fee
2824.52 1250.54 SCCP Fee
573.4 336.55 Cash Outlay
3.96 2.61
2270.66 878.40
4.18 2.47
2396.81 831.28
25.83 11.92
23.26 11.54
5.55 1.21
2.69 1.91
Total Equity Expected Return Percentage Return Cash Outlay
5,699,161.01 3,479,161.01 156.72%
2,226,660.00
76,622.72 25,622.72 50.24%
51,153.00
177,501.75 74,501.75 72.33%
103,309.00
11,641,284.23 2,561,284.23 28.21%
9,107,240.00
23,077,879.76 14,937,879.76 183.51%
8,164,420.00
19,652,782.00
AC ALI BDO TEL
2,220,000.00 51,000.00 103,000.00 9,080,000.00
6,216.00 142.80 288.40 25,424.00
111.00 2.55 5.15 454.00
111.00 2.55 5.15 454.00
222.00 5.10 10.30 908.00
2,226,660.00 51,153.00 103,309.00 9,107,240.00
2
SM
8,140,000.00
22,792.00
407.00
407.00
814.00
8,164,420.00
DATE PSE AC ALI BDO PLDT
24-Sep-15 295.00 740.00 34.00 103.00 2,270.00
23-Sep-15 298.00 759.50 34.00 102.00 2,264.00
22-Sep-15 295.60 777.00 34.15 103.60 2,304.00
21-Sep-15 300.00 779.00 34.25 103.00 2,306.00
18-Sep-15 300.00 782.00 35.05 103.00 2,340.00
17-Sep-15 298.00 770.00 34.50 101.60 2,392.00
16-Sep-15 296.80 761.00 35.20 99.85 2,374.00
15-Sep-15 297.00 749.00 35.90 98.50 2,344.00
14-Sep-15 297.00 749.50 35.95 97.20 2,402.00
11-Sep-15 298.20 728.00 34.30 96.10 2,346.00
10-Sep-15 300.00 730.00 33.65 96.95 2,306.00
9-Sep-15 299.20 742.00 34.20 94.65 2,392.00
8-Sep-15 297.00 727.50 34.35 93.50 2,384.00
7-Sep-15 298.00 725.00 34.65 93.50 2,392.00
4-Sep-15 298.20 748.50 35.80 94.40 2,444.00
3-Sep-15 300.00 760.00 36.00 97.00 2,440.00
2-Sep-15 300.00 760.00 36.40 98.00 2,412.00
1-Sep-15 300.00 755.00 36.65 97.65 2,446.00
28-Aug-15 300.00 738.00 35.95 98.50 2,518.00
27-Aug-15 300.00 725.00 34.80 97.00 2,552.00
26-Aug-15 299.80 709.00 34.40 93.00 2,464.00
25-Aug-15 295.00 717.00 33.50 94.10 2,430.00
24-Aug-15 299.40 704.50 33.75 95.00 2,536.00
20-Aug-15 300.00 755.00 37.10 98.95 2,750.00
19-Aug-15 305.00 771.00 37.80 100.00 2,770.00
18-Aug-15 301.00 770.00 38.00 101.00 2,740.00
17-Aug-15 303.00 760.00 37.65 99.90 2,704.00
14-Aug-15 304.00 759.00 37.50 103.00 2,712.00
13-Aug-15 305.00 755.00 38.00 103.00 2,708.00
12-Aug-15 306.60 750.00 38.30 102.00 2,700.00
BETA
AC ALI BDO PLDT SM
0.67 3.08 1.13 4.50 0.99
STOCK RISK PREMIUM
AC ALI BDO PLDT SM
-2.25% -10.30% -3.78% -15.04% -3.30%
STANDARD DEVIATION (DAILY)
AC ALI BDO PLDT SM
2.79% 4.01% 3.60% 5.72% 2.54%
VARIANCE (DAILY)
AC ALI BDO PLDT SM
0.08% 0.16% 0.13% 0.33% 0.06%
SM %PSE %AC %ALI %BDO %PLDT %SM
880.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
878.50 -1.01% -2.57% 0.00% 0.98% 0.27% 0.17%
890.00 -0.20% -4.76% -0.44% -0.58% -1.48% -1.12%
890.00 -1.67% -5.01% -0.73% 0.00% -1.56% -1.12%
880.00 -1.67% -5.37% -3.00% 0.00% -2.99% 0.00%
900.00 -1.01% -3.90% -1.45% 1.38% -5.10% -2.22%
891.00 -0.61% -2.76% -3.41% 3.15% -4.38% -1.23%
885.50 -0.67% -1.20% -5.29% 4.57% -3.16% -0.62%
894.50 -0.67% -1.27% -5.42% 5.97% -5.50% -1.62%
842.00 -1.07% 1.65% -0.87% 7.18% -3.24% 4.51%
845.00 -1.67% 1.37% 1.04% 6.24% -1.56% 4.14%
845.00 -1.40% -0.27% -0.58% 8.82% -5.10% 4.14%
850.00 -0.67% 1.72% -1.02% 10.16% -4.78% 3.53%
862.00 -1.01% 2.07% -1.88% 10.16% -5.10% 2.09%
873.00 -1.07% -1.14% -5.03% 9.11% -7.12% 0.80%
885.00 -1.67% -2.63% -5.56% 6.19% -6.97% -0.56%
881.00 -1.67% -2.63% -6.59% 5.10% -5.89% -0.11%
887.00 -1.67% -1.99% -7.23% 5.48% -7.20% -0.79%
878.00 -1.67% 0.27% -5.42% 4.57% -9.85% 0.23%
870.00 -1.67% 2.07% -2.30% 6.19% -11.05% 1.15%
859.00 -1.60% 4.37% -1.16% 10.75% -7.87% 2.44%
890.00 0.00% 3.21% 1.49% 9.46% -6.58% -1.12%
840.00 -1.47% 5.04% 0.74% 8.42% -10.49% 4.76%
897.00 -1.67% -1.99% -8.36% 4.09% -17.45% -1.90%
898.00 -3.28% -4.02% -10.05% 3.00% -18.05% -2.00%
900.00 -1.99% -3.90% -10.53% 1.98% -17.15% -2.22%
900.00 -2.64% -2.63% -9.69% 3.10% -16.05% -2.22%
929.00 -2.96% -2.50% -9.33% 0.00% -16.30% -5.27%
914.50 -3.28% -1.99% -10.53% 0.00% -16.17% -3.77%
901.00 -3.78% -1.33% -11.23% 0.98% -15.93% -2.33%
R-SQUARED
AC ALI BDO PLDT SM
0.0566 0.5577 0.0931 0.5858 0.1471
EXPECTED RETURN
AC ALI BDO PLDT SM
-0.3596% -8.4111% -1.8912% -13.1540% -1.4088%
STANDARD DEVIATION (ANNUALIZED)
AC ALI BDO PLDT SM
44.11% 63.44% 56.97% 90.40% 40.22%
VARIANCE (ANNUALIZED)
AC ALI BDO PLDT SM
19.45% 40.24% 32.45% 81.73% 16.18%
market risk premium -3.341132%
risk free rate 1.8868%
AC ALI BDO TEL
YEAR 1
P/E Industry Average 22.05 17.50 11.61 18.64
P/E 2016e 25.00 30.38 15.94 14.98
EPS 2016e 29.60 1.12 6.46 151.53
Target Price 652.68 19.60 75.00 2824.52
YEAR 2
P/E Industry Average 22.05 17.50 11.61 18.64
P/E 2017e 29.87 35.64 18.40 15.05
EPS 2017e 35.37 1.31 7.46 152.29
Target Price 779.89 22.99 86.58 2838.64
YEAR 3
P/E Industry Average 22.05 17.50 11.61 18.64
P/E 2018e 35.69 41.81 21.24 15.13
EPS 2018e 42.26 1.54 8.61 153.05
Target Price 931.89 26.97 99.95 2852.84
YEAR 4
P/E Industry Average 22.05 17.50 11.61 18.64
P/E 2019e 42.65 49.04 24.52 15.21
EPS 2019e 50.50 1.81 9.94 153.81
Target Price 1113.51 31.64 115.38 2867.10
YEAR 5
P/E Industry Average 22.05 17.50 11.61 18.64
P/E 2020e 50.96 57.53 28.31 15.28
EPS 2020e 60.34 2.12 11.47 154.58
Target Price 1330.54 37.12 133.20 2881.43
YEAR 6
P/E Industry Average 22.05 17.50 11.61 18.64
P/E 2021e 60.90 67.49 32.68 15.36
EPS 2021e 72.10 2.49 13.24 155.36
Target Price 1589.86 43.54 153.76 2895.84
YEAR 7
P/E Industry Average 22.05 17.50 11.61 18.64
P/E 2022e 72.77 79.18 37.72 15.44
EPS 2022e 86.16 2.92 15.29 156.13
Target Price 1899.72 51.08 177.50 2910.32
BETA 1.15 1.27 1.3 0.84
STANDARD DEVIATION
SM
33.68
23.70
37.13
1250.54
33.68
26.59
41.66
1403.10
33.68
29.84
46.74
1574.28
33.68
33.48
52.44
1766.35
33.68
37.56
58.84
1981.84
33.68
42.14
66.02
2223.62
33.68
47.28
74.08
2494.91
1.28
Investment Type Name of Investment Particulars Board Lot
BDO (Banco de Oro
Unibank, 10
Incorporated)
EQUITIES Stocks
TEL (Philippine Long
Distance Telephone 5
Company)
SM (SM Investments 10
Corporation)
CASH OUTLAY
BDO TEL SM
Transaction Cost 154,500.00 465,350.00 264,000.00
Broker's Commission 432.60 1,302.98 739.20
SEC Fee 7.73 23.27 13.20
PSE Transaction Fee 7.73 23.27 13.20
SCCP Fee 15.45 46.54 26.40
Cash Outlay 154,963.50 466,746.05 264,792.00
MPS Number of Shares Investment Target Price
103 1,500 154,500.00 177.50
2,270 205 465,350.00 2910.32
880 300 264,000.00 2494.91
883,850.00
19731567
Total Equity Expected Return Percentage Return Cash Outlay
266,252.63 111,752.63 72.33%
154,963.50
596,615.82 131,265.82 28.21%
466,746.05
748,471.78 484,471.78 183.51%
264,792.00
886,501.55