1 | Total Portfolio (SGD) | 591,206.28 | as of 31 July 2017 | Portfolio Allocation | Exchange Rate | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Total Cost (SGD) | 565,296.85 | Equity | 44.50% | AUD | 1.0804 | HKD | 0.1727 | USD | 1.3518 | |||||||||||
3 | Profit/Loss before FX (SGD) | 31,959.97 | Bonds | 55.50% | CNY | 0.2006 | IDR | 0.00010167 | |||||||||||||
4 | FX Profit/Loss (SGD) | (6,050.54) | EUR | 1.5981 | JPY | 0.012247 | |||||||||||||||
5 | Profit/Loss after FX (SGD) | 25,909.43 | 4.58% | GBP | 1.7829 | MYR | 0.3144 | ||||||||||||||
6 | |||||||||||||||||||||
7 | Securities Name | Quantity | Average Unit Price | Latest Unit Price | Total Cost (FCY) | Total Market Value (FCY) | Profit/Loss (FCY) | Total Cost (SGD) | Total Market Value (SGD) | Profit/Loss (SGD) | Total Dividend (SGD) | Profit/Loss after Dividend (SGD) | % Profit/Loss (SGD) | % Profit/Loss after Dividend (SGD) | CAGR | TTM Dividend | TTM Yield on Cost | TTM Yield on Current Price | Purchase Date | Sector | |
8 | Equity - ETF/Fund | ||||||||||||||||||||
9 | iShares MSCI World (USD) | 230.0000 | 41.4716 | 50.1350 | 9,538.47 | 11,531.05 | 1,992.58 | 12,713.51 | 15,587.67 | 2,874.16 | 0.00 | 2,874.16 | 22.61% | 22.61% | 2.37% | 0.00 | 0.00% | 0.00% | 21-Aug-2015 | ETF | |
10 | STI ETF | 4,200.0000 | 3.4136 | 3.3200 | 14,337.04 | 13,944.00 | (393.04) | 14,337.04 | 13,944.00 | (393.04) | 819.00 | 425.96 | -2.74% | 2.97% | 0.32% | 399.00 | 2.78% | 2.86% | 30-Mar-2015 | ETF | |
11 | VanEck Vectors Gold Miners UCITS ETF (USD) | 140.0000 | 21.7941 | 23.8200 | 3,051.17 | 3,334.80 | 283.63 | 4,333.58 | 4,507.98 | 174.40 | 0.00 | 174.40 | 4.02% | 4.02% | 0.53% | 0.00 | 0.00% | 0.00% | 14-Nov-2016 | Materials | |
12 | Vanguard FTSE AS (HKD) | 4,000.0000 | 21.3989 | 22.2000 | 85,595.72 | 88,800.00 | 3,204.28 | 14,927.55 | 15,335.76 | 408.21 | 853.99 | 1,262.20 | 2.73% | 8.46% | 0.91% | 424.71 | 2.85% | 2.77% | 7-May-2015 | ETF | |
13 | Equity - Stocks | ||||||||||||||||||||
14 | Ascott REIT | 5,500.0000 | 1.0656 | 1.1900 | 5,860.54 | 6,545.00 | 684.46 | 5,860.54 | 6,545.00 | 684.46 | 158.12 | 842.58 | 11.68% | 14.38% | 1.85% | 158.12 | 2.70% | 2.42% | 28-Dec-2016 | REITS | |
15 | Bayer Motoren WK (EUR) | 26.0000 | 76.3950 | 77.7100 | 1,986.27 | 2,020.46 | 34.19 | 2,994.90 | 3,228.90 | 234.00 | 102.45 | 336.45 | 7.81% | 11.23% | 1.39% | 102.45 | 3.42% | 3.17% | 3-Aug-2016 | Consumer Discretionary | |
16 | BHP Billiton PLC (GBP) | 180.0000 | 9.6586 | 13.7800 | 1,738.55 | 2,480.40 | 741.85 | 3,115.48 | 4,422.31 | 1,306.83 | 133.90 | 1,440.73 | 41.95% | 46.24% | 5.03% | 133.90 | 4.30% | 3.03% | 3-Aug-2016 | Materials | |
17 | BP PLC (GBP) | 530.0000 | 4.3184 | 4.4580 | 2,288.75 | 2,362.74 | 73.99 | 4,152.03 | 4,212.53 | 60.50 | 219.50 | 280.00 | 1.46% | 6.74% | 0.86% | 219.50 | 5.29% | 5.21% | 12-Sep-2016 | Energy | |
18 | British Land Co PLC (GBP) | 320.0000 | 5.5193 | 6.1050 | 1,766.18 | 1,953.60 | 187.42 | 3,088.34 | 3,483.07 | 394.74 | 97.02 | 491.76 | 12.78% | 15.92% | 1.91% | 97.02 | 3.14% | 2.79% | 7-Jul-2016 | REITS | |
19 | BT Group PLC (GBP) | 580.0000 | 3.9287 | 3.1350 | 2,278.65 | 1,818.30 | (460.35) | 4,133.69 | 3,241.85 | (891.84) | 48.24 | (843.60) | -21.58% | -20.41% | -2.95% | 48.24 | 1.17% | 1.49% | 12-Sep-2016 | Telecommunication | |
20 | Capitaland Commercial Trust | 2,400.0000 | 1.2867 | 1.7200 | 3,088.08 | 4,128.00 | 1,039.92 | 3,088.08 | 4,128.00 | 1,039.92 | 321.36 | 1,361.28 | 33.68% | 44.08% | 4.29% | 217.92 | 7.06% | 5.28% | 24-Aug-2015 | REITS | |
21 | Capitaland Mall Trust | 4,200.0000 | 1.9147 | 2.0100 | 8,041.74 | 8,442.00 | 400.26 | 8,041.74 | 8,442.00 | 400.26 | 235.62 | 635.88 | 4.98% | 7.91% | 1.03% | 235.62 | 2.93% | 2.79% | 14-Nov-2016 | REITS | |
22 | Capitaland Retail China Trust | 5,800.0000 | 1.3927 | 1.6600 | 8,077.66 | 9,628.00 | 1,550.34 | 8,077.66 | 9,628.00 | 1,550.34 | 274.34 | 1,824.68 | 19.19% | 22.59% | 2.77% | 274.34 | 3.40% | 2.85% | 14-Nov-2016 | REITS | |
23 | Carlsberg Brewery Malaysia Bhd (MYR) | 900.0000 | 13.8739 | 15.0000 | 12,486.51 | 13,500.00 | 1,013.49 | 4,084.34 | 4,244.40 | 160.06 | 190.71 | 350.78 | 3.92% | 8.59% | 1.11% | 190.71 | 4.67% | 4.49% | 17-Nov-2016 | Consumer Staples | |
24 | China Mobile (HKD) | 500.0000 | 83.9684 | 83.7500 | 41,984.20 | 41,875.00 | (109.20) | 7,364.03 | 7,231.81 | (132.22) | 212.26 | 80.04 | -1.80% | 1.09% | 0.14% | 212.26 | 2.88% | 2.94% | 25-Jun-2016 | Telecommunication | |
25 | Chow Tai Fook (HKD) | 5,800.0000 | 4.9040 | 8.1100 | 28,443.20 | 47,038.00 | 18,594.80 | 4,960.49 | 8,123.46 | 3,162.97 | 516.72 | 3,679.69 | 63.76% | 74.18% | 7.11% | 516.72 | 10.42% | 6.36% | 31-Mar-2016 | Consumer Discretionary | |
26 | CNOOC (HKD) | 4,000.0000 | 8.2962 | 8.7400 | 33,184.76 | 34,960.00 | 1,775.24 | 6,036.31 | 6,037.59 | 1.28 | 370.88 | 372.16 | 0.02% | 6.17% | 0.72% | 216.86 | 3.59% | 3.59% | 10-Dec-2015 | Energy | |
27 | Daimler AG (EUR) | 31.0000 | 62.6939 | 59.2900 | 1,943.51 | 1,837.99 | (105.52) | 2,913.91 | 2,937.29 | 23.39 | 109.31 | 132.70 | 0.80% | 4.55% | 0.58% | 109.31 | 3.75% | 3.72% | 26-Aug-2016 | Consumer Discretionary | |
28 | DBS | 319.0000 | 13.3597 | 21.6200 | 4,261.73 | 6,896.78 | 2,635.05 | 4,261.73 | 6,896.78 | 2,635.05 | 0.00 | 2,635.05 | 61.83% | 61.83% | 6.03% | 0.00 | 0.00% | 0.00% | 10-Feb-2016 | Financials | |
29 | Deutsche Bank (EUR) | 240.0000 | 12.3100 | 15.0900 | 2,954.41 | 3,621.60 | 667.19 | 4,436.06 | 5,787.68 | 1,351.62 | 50.90 | 1,402.51 | 30.47% | 31.62% | 3.61% | 50.90 | 1.15% | 0.88% | 28-Jul-2016 | Financials | |
30 | First REIT | 2,500.0000 | 1.2162 | 1.3500 | 3,040.54 | 3,375.00 | 334.46 | 3,040.54 | 3,375.00 | 334.46 | 370.00 | 704.46 | 11.00% | 23.17% | 2.44% | 212.50 | 6.99% | 6.30% | 2-Sep-2015 | REITS | |
31 | Global Logistic Properties | 2,200.0000 | 1.8479 | 3.3100 | 4,065.38 | 7,282.00 | 3,216.62 | 4,065.38 | 7,282.00 | 3,216.62 | 0.00 | 3,216.62 | 79.12% | 79.12% | 7.94% | 0.00 | 0.00% | 0.00% | 13-Sep-2016 | Real Estate | |
32 | Greggs PLC (GBP) | 220.0000 | 10.1970 | 11.0000 | 2,243.34 | 2,420.00 | 176.66 | 3,981.70 | 4,314.62 | 332.91 | 82.37 | 415.28 | 8.36% | 10.43% | 1.32% | 82.37 | 2.07% | 1.91% | 30-Sep-2016 | Consumer Staples | |
33 | Heineken Malaysia Bhd (MYR) | 800.0000 | 15.8344 | 17.9800 | 12,667.52 | 14,384.00 | 1,716.48 | 4,143.55 | 4,522.33 | 378.78 | 151.60 | 530.38 | 9.14% | 12.80% | 1.63% | 151.60 | 3.66% | 3.35% | 17-Nov-2016 | Consumer Staples | |
34 | HSBC Holdings Plc (HKD) | 800.0000 | 53.7289 | 78.4500 | 42,983.12 | 62,760.00 | 19,776.88 | 7,543.54 | 10,838.65 | 3,295.11 | 557.08 | 3,852.19 | 43.68% | 51.07% | 5.55% | 504.51 | 6.69% | 4.65% | 9-Sep-2016 | Financials | |
35 | Hugo Boss (EUR) | 55.0000 | 48.3627 | 63.7300 | 2,659.95 | 3,505.15 | 845.20 | 4,087.81 | 5,601.58 | 1,513.77 | 161.27 | 1,675.04 | 37.03% | 40.98% | 4.63% | 161.27 | 3.95% | 2.88% | 30-Sep-2016 | Consumer Discretionary | |
36 | Indocement Tunggal Prakarsa (IDR) | 1,900.0000 | 15,757.4300 | 17,500.0000 | 29,939,117.00 | 33,250,000.00 | 3,310,883.00 | 3,049.48 | 3,380.53 | 331.05 | 145.50 | 476.55 | 10.86% | 15.63% | 1.87% | 145.50 | 4.77% | 4.30% | 25-Jun-2016 | Materials | |
37 | Keppel Corp | 900.0000 | 7.1227 | 6.4100 | 6,410.43 | 5,769.00 | (641.43) | 6,410.43 | 5,769.00 | (641.43) | 378.00 | (263.43) | -10.01% | -4.11% | -0.49% | 180.00 | 2.81% | 3.12% | 9-Nov-2015 | Industrials | |
38 | M1 | 1,600.0000 | 2.5478 | 1.8050 | 4,076.48 | 2,888.00 | (1,188.48) | 4,076.48 | 2,888.00 | (1,188.48) | 94.40 | (1,094.08) | -29.15% | -26.84% | -4.01% | 94.40 | 2.32% | 3.27% | 9-Sep-2016 | Telecommunication | |
39 | Malayan Banking Berhad (MYR) | 1,600.0000 | 7.6721 | 9.5400 | 12,275.36 | 15,264.00 | 2,988.64 | 4,071.74 | 4,799.00 | 727.26 | 163.06 | 890.33 | 17.86% | 21.87% | 2.64% | 163.06 | 4.00% | 3.40% | 30-Sep-2016 | Financials | |
40 | PCCW (HKD) | 5,000.0000 | 5.0372 | 4.4000 | 25,186.00 | 22,000.00 | (3,186.00) | 4,422.66 | 3,799.40 | (623.26) | 177.38 | (445.88) | -14.09% | -10.08% | -1.38% | 177.38 | 4.01% | 4.67% | 9-Sep-2016 | Telecommunication | |
41 | Perusahaan Gas Negara (IDR) | 11,000.0000 | 2,710.3322 | 2,250.0000 | 29,813,654.20 | 24,750,000.00 | (5,063,654.20) | 3,100.62 | 2,516.33 | (584.29) | 67.44 | (516.85) | -18.84% | -16.67% | -2.36% | 67.44 | 2.18% | 2.68% | 9-Sep-2016 | Energy | |
42 | Prada Spa (HKD) | 1,000.0000 | 25.3500 | 27.7000 | 25,350.00 | 27,700.00 | 2,350.00 | 4,527.51 | 4,783.79 | 256.28 | 133.19 | 389.47 | 5.66% | 8.60% | 1.05% | 133.19 | 2.94% | 2.78% | 30-May-2016 | Consumer Discretionary | |
43 | Royal Dutch Shell PLC-B (GBP) | 90.0000 | 20.1513 | 21.5200 | 1,813.62 | 1,936.80 | 123.18 | 3,228.06 | 3,453.12 | 225.06 | 176.04 | 401.10 | 6.97% | 12.43% | 1.54% | 176.04 | 5.45% | 5.10% | 23-Aug-2016 | Energy | |
44 | Sembcorp Industries | 1,500.0000 | 2.7090 | 3.2300 | 4,063.50 | 4,845.00 | 781.50 | 4,063.50 | 4,845.00 | 781.50 | 60.00 | 841.50 | 19.23% | 20.71% | 2.49% | 60.00 | 1.48% | 1.24% | 9-Sep-2016 | Industrials | |
45 | SIA | 400.0000 | 10.6414 | 10.3900 | 4,256.56 | 4,156.00 | (100.56) | 4,256.56 | 4,156.00 | (100.56) | 36.00 | (64.56) | -2.36% | -1.52% | -0.20% | 36.00 | 0.85% | 0.87% | 31-Aug-2016 | Industrials | |
46 | SIA Engineering | 1,200.0000 | 3.4738 | 3.6400 | 4,168.56 | 4,368.00 | 199.44 | 4,168.56 | 4,368.00 | 199.44 | 0.00 | 199.44 | 4.78% | 4.78% | 0.63% | 0.00 | 0.00% | 0.00% | 14-Nov-2016 | Industrials | |
47 | Singtel | 2,500.0000 | 3.6057 | 3.9700 | 9,014.25 | 9,925.00 | 910.75 | 9,014.25 | 9,925.00 | 910.75 | 245.00 | 1,155.75 | 10.10% | 12.82% | 1.46% | 245.00 | 2.72% | 2.47% | 8-Jan-2016 | Telecommunication | |
48 | Sinopec Engineering Group Co (HKD) | 3,000.0000 | 6.6431 | 7.0100 | 19,929.30 | 21,030.00 | 1,100.70 | 3,441.79 | 3,631.88 | 190.09 | 77.20 | 267.29 | 5.52% | 7.77% | 0.98% | 77.20 | 2.24% | 2.13% | 23-Aug-2016 | Energy | |
49 | Starhill Global REIT | 5,000.0000 | 0.8157 | 0.7800 | 4,078.50 | 3,900.00 | (178.50) | 4,078.50 | 3,900.00 | (178.50) | 187.00 | 8.50 | -4.38% | 0.21% | 0.03% | 187.00 | 4.59% | 4.79% | 13-Oct-2016 | REITS | |
50 | Starhub | 1,200.0000 | 3.3837 | 2.7300 | 4,060.44 | 3,276.00 | (784.44) | 4,060.44 | 3,276.00 | (784.44) | 168.00 | (616.44) | -19.32% | -15.18% | -2.17% | 168.00 | 4.14% | 5.13% | 31-Oct-2016 | Telecommunication | |
51 | Telstra Corporation Limited (AUD) | 760.0000 | 5.0256 | 4.1000 | 3,819.46 | 3,116.00 | (703.46) | 4,057.41 | 3,366.53 | (690.88) | 124.07 | (566.81) | -17.03% | -13.97% | -1.99% | 124.07 | 3.06% | 3.69% | 31-Oct-2016 | Telecommunication | |
52 | Toyota Motor Corp (JPY) | 100.0000 | 5,787.9000 | 6,234.0000 | 578,790.00 | 623,400.00 | 44,610.00 | 7,844.34 | 7,634.78 | (209.56) | 80.91 | (128.65) | -2.67% | -1.64% | -0.22% | 80.91 | 1.03% | 1.06% | 30-Sep-2016 | Consumer Discretionary | |
53 | UOB | 200.0000 | 18.0814 | 23.9900 | 3,616.28 | 4,798.00 | 1,181.72 | 3,616.28 | 4,798.00 | 1,181.72 | 140.00 | 1,321.72 | 32.68% | 36.55% | 4.11% | 140.00 | 3.87% | 2.92% | 4-Aug-2016 | Financials | |
54 | Venture | 600.0000 | 8.1981 | 13.1700 | 4,918.86 | 7,902.00 | 2,983.14 | 4,918.86 | 7,902.00 | 2,983.14 | 600.00 | 3,583.14 | 60.65% | 72.84% | 6.81% | 300.00 | 6.10% | 3.80% | 8-Jan-2016 | Information Technology | |
55 | Bonds - ETF/Fund | ||||||||||||||||||||
56 | ABF PAIF (USD) | 40.0000 | 120.7623 | 115.1000 | 4,830.49 | 4,604.00 | (226.49) | 6,524.81 | 6,223.69 | (301.13) | 331.40 | 30.28 | -4.62% | 0.46% | 0.05% | 149.96 | 2.30% | 2.41% | 20-Apr-2015 | ||
57 | CSOP China Ultra Short Term Bond ETF (HKD) | 200.0000 | 177.0982 | 172.1500 | 35,419.64 | 34,430.00 | (989.64) | 6,226.77 | 5,946.06 | (280.71) | 58.73 | (221.98) | -4.51% | -3.56% | -0.47% | 58.73 | 0.94% | 0.99% | 28-Jul-2016 | ||
58 | Fullerton Short Term Interest Rate Fund C | 26,840.1300 | 1.3040 | 1.3170 | 34,999.53 | 35,347.38 | 347.85 | 34,999.53 | 35,347.38 | 347.85 | 0.00 | 347.85 | 0.99% | 0.99% | 0.01% | 0.00 | 0.00% | 0.00% | |||
59 | United SGD Fund Cl A (Acc) | 116,689.6000 | 1.7996 | 1.8450 | 210,000.00 | 215,292.31 | 5,292.32 | 210,000.00 | 215,292.31 | 5,292.32 | 0.00 | 5,292.32 | 2.52% | 2.52% | 0.02% | 0.00 | 0.00% | 0.00% | |||
60 | Cash | ||||||||||||||||||||
61 | Cash MMF (SGD) | 36,669.63 | 36,669.63 | ||||||||||||||||||
62 | Cash MMF (USD) | 2,947.42 | 3,984.32 | ||||||||||||||||||
63 | Cash in Bank | 500.00 | 500.00 | ||||||||||||||||||
64 | AUD | 116.54 | 125.91 | ||||||||||||||||||
65 | CNY | 289.45 | 58.06 | ||||||||||||||||||
66 | EUR | 2,951.52 | 4,716.82 | ||||||||||||||||||
67 | GBP | 5,000.46 | 8,915.32 | ||||||||||||||||||
68 | HKD | 11,014.42 | 1,902.19 | ||||||||||||||||||
69 | JPY | 332,056.00 | 4,066.69 | ||||||||||||||||||
70 | MYR | 13,884.44 | 4,365.27 | ||||||||||||||||||