Thursday, December 22, 2016

November 2016 - Low Cost Portfolio Scorecard

Many medias spread fears during the US president election, by injecting a market sell-off expectation should Donald Trump became the elected president of US. What happened eventually was the reverse. Markets rallied strongly, especially US. DJI is just a few points away from 20,000 psychology resistance. Even the lackluster STI breached 2900 as a result.

Will the rally continue in 2700? Only God knows! My part is to stick with the plan and probably be slightly defensive in my portfolio management.

As a result of the rally in equities, low cost portfolio XIRR YTD was 7.4% as of 30 November. XIRR since inception went back above 4% at 4.54%, beating CPF SA return, which I used as a benchmark for my low cost portfolio.
  • CapitaRetail China Trust 5800 shares @ $1.3875
  • CapitaMall Trust 4200 shares @ 1.9075
  • SIA Engineering 1200 shares @ 3.45
  • VanEck Vectors Gold Miners UCITS ETF (GDX.L) 140 shares @ USD 21.56
  • Heineken Malaysia Bhd (2836.KL) 800 shares @ MYR 15.7275
  • Carlsberg Brewery Malaysia Bhd (3255.KL) 900 shared @ MYR 13.78

I injected $4,000 fresh fund and received total dividends of $214.00 and GBP 18.09 in November. Dividends received were:
  • GBP 18.09 from British Land Co PLC  
  • $36.00 from SIA
  • $60.00 from Starhub
  • $53.00 from First REIT
  • $65.00 from Starhill Global REIT

Total portfolio value as of 30 November was about $3,000 shy of the half million mark, with 46.53% in equity and 53.47% in bonds & cash.

Link to Yaruzi's low cost portfolio as of November 2016


  1. You are back from your holiday!

    Merry Christmas to you and your family! :)

    1. Thanks UN, we wish you & family a Merry Christmas and a Happy New Year too! God bless

  2. Yaruzi,

    A very clear representation of your portfolio performance than some other bloggers out there.

    1) Clearly shows capital injection.

    2) Profits and losses in $ amount out in the open.

    I can understand % for Return YTD and XIRR since inception.

    But I've no clue why you have XIRR YTD?

    Unless you just want to feel good about the higher percentages ;)

    If you average out the XIRR YTD with the number of years, it will look even better than XIRR since inception. Now that's statistical manipulation for ownself cheat ownself! LOL!

    Its a good example where the dollar amount returned does not change, how we calculate and what formula we use can make a big difference in percentages.

    Wishing you happy holidays and Merry Christmas!

    1. Hi SMOL, Merry Christmas and Happy New Year to you too!

      I used XIRR YTD to give me the weighted return for the year from 1st January. I give you example:
      Return YTD
      Portfolio starting value 1st Jan 200,000
      Inject fresh fund 30th Nov 200,000
      Portfolio value+fresh fund+profit 31st Dec 410,000

      Return YTD as of 31st Dec=10,000/40,0000=2.5%

      XIRR YTD
      Portfolio starting value 1st Jan 200,000
      Inject fresh fund 30th Nov 200,000
      Portfolio value+fresh fund+profit 31st Dec 410,000

      XIRR YTD as of 31st Dec 4.62%

      The XIRR YTD will reset every 1st Jan, and I hope it will give me a feel on how volatile the annualized weighted return of the portfolio year by year.

      Thanks for coming by.

    2. Yaruzi,

      I see.

      Have you noticed that if you input cash injection on 28th Feb instead of 30th Nov, the XIRR YTD changes?

      Don't mind me.

      I used to be an unofficial Business Navigator and I had great fun "manipulating" the KPIs and statistical reports just to see which top management is alert and know how to read beyond the figures ;)

    3. Yes SMOL fully aware.

      The intention is not to manipulate KPI :-), but to avoid significant injection especially late in the year to skew the actual return. I think the XIRR YTD gives me a better feel on the weighted return.