Sell @ $4.00.
Did my Jump-Q and got 2ct higher. Left my very expensive ones from long ago. There was a serious buy-up just before 5pm and the momentum spilled over to 5pm matching. Buyer CP = DMG. 😀
SPH @ $3.94
SIAEC @ $4.09
Popular Hldgs @ $0.205
StarHub @ $3.47
Popular Hldgs @ $0.205
Buy @ $0.205.
Take the risk to buy at a higher price to average up. Results were good with Div = 0.8ct. If they can maintain this, Yield = 6.341%. 😀
Main fear is the earnings growth may have been mainly contributed by the Malaysia operations which was driven by the free Book Voucher given to their tertiary students by their govt (Election coming?). We'll also see the 26-units condo launch for 8Raja (Balestier area) in the coming quarters. Risk is they may have to make provisions if they're unable to sell.
STEng @ $3.17
XIRR
XIRR (in Excel spreadsheet) could be used to measure the performance of our Stocks Investment. Explanation on how to use can be found at,
http://office.microsoft.com/en-gb/excel-help/xirr-HP005209341.aspx
To calculate XIRR for our Stocks Investment on an annual basis, I copied all my transactions to a worksheet as follows,
1 Jan 12 : + (Mkt Value of All Stocks on 31 Dec11)
Dates : + (Buy Transactions)
.
.
Dates : – (Sell Transactions)
.
.
Dates : – (Dividends)
.
.
31 Dec 12 : – (Mkt Value of All Stocks on 30 Jun 12)
Dates above means each individual date and the corresponding value of transaction. There's no need to arrange the transactions in Time order as XIRR will sort it our for us.
Note that I used 31 Dec 12 as the end date (even tho' the Mkt Value is for 30 Jun 12) as I wanted to get a comparative figure to benchmark against STI. Using 30-Jun-12 as the End Date would annualise the figures and would give ~2x the STI benchmark.
Results
2011 : XIRR = -7.58% vs -5.81% (my own non-scientific method) vs STI = -17.04%
2012 : XIRR = +21.77% vs +17.27% (own method) vs STI = +8.77%
2011 till end Jun-12 : XIRR = +7.83%
It looks like my own method is only conservative when I have +ve returns. When I have -ve returns (like 2011), it's no more conservative!
Portfolio – Q212
My portfolio (at cost) of S'pore stks for Q212 close,
The STI closed at 2878.45, +8.77% from end 2011. Using cost as a reference, my portfolio stats (vs 2011),
- Size : -10.9% (Cost) / +2.38% (Market Value)
- Net Portfolio Performance vs End-2011 Mkt Value : +14.32% (Unrealised) + 0.12% (Realised) + 2.90% (Div) = +17.35%
- Further Breakdown of Realised Profits : -1.62% (Stocks Bought before 2012) + 1.75% (Stocks Bought in 2012)
- Portfolio Composition
- 2011 : 40.08% (Yield Stocks) + 27.43% (REITs) + 21.65% (Infrastructure) + 5.03% (Shipping Trusts) + 5.82% (Junk)
- 2012 : 57.48% (Yield Stocks) + 27.10% (REITs) + 15.42% (Infrastructure)
- Quite a Radical Shift in Portfolio Composition to One that's Hopefully Less Risky
- Reduced Infrastructure (Highly Geared eg. MIIF) & Removed Shipping Trust (High Gearing + Low Cycle)
- Increased Yield Stocks (Lower Volatility in Earnings)
So, +17.35% vs +8.77% (STI), better than STI. Quite unbelievable, to confirm again when I receive my CDP statements! One factor that'd enhance (artificially) my portfolio performance is the base where I'm using Cost and which'd reduced by -10.9% (due to selling). Using Market Value would not solve this 'problem' as it's even lower (sitting on unrealised losses wrt cost).
Changes in portfolio (vs Q112),
- New Additions : Hour Glass, SIAEC
- Increases : Popular, RafflesMed, MIIF, SPH
- Decreases : HLFin, FrasersComm, AIMSAMPIREIT, Cambridge, STEng, SingPost, StarHub
- No Change : Sabana, KGT, CitySpring, SBSTransit
- No More : SingTel