fbpx

The Ultimate Comprehensive Analysis of The 11-Year Returns of the STI ETF: Part 1 – Dollar Cost Averaging

Reading Time: 18 minutes

This is part 1 of a 4 part series. I started off trying to write a single article but the amount of analysis grew too large to fit into a single post, so I’ve decided to split it up into the following 4 parts:

“If ya want something done right, you’ve just gotta do it yourself!”

Or in this case, it’s more like:

“If I want something overly-done, I am the only one stupid enough to take the time to do it.”

So… I’ve just finished crunching the numbers on my portfolio’s returns if I had invested S$1,000 a month, every month into the STI ETF while reinvesting dividends over the last 11 years! Took me forever but the results were worth it.

Man… I need a hobby…

Oh well, what’s done is done… So I might as well share the results! I think it will surprise you; it sure surprised me.

For those afraid of long posts, here’s the summary of the results, and if you’d like to read the gory details, you can scroll down to read more.

TL;DR: Summary of findings

  1. Over the last 11 years, if you DCA into the STI ETF and reinvest the dividends, you will have received an inflation adjusted return of 5.63%, which is 7.15% non-inflation adjusted return.
  2. More than 57% of the time in the last 11 years, the STI ETF returned more than 6% in inflation adjusted returns each year.
  3. Not reinvesting your dividends and reinvesting dividends provided the same rate of returns in the last 11 year period.
  4. STI ETF remains one of the best investment vehicle for long-term Singapore investors who wishes to setup a lazy Bogleheads 3-Fund Portfolio and put our financial independence plan on auto-pilot.

Why in the world did you spend your time doing this?!

As Singaporean investors, when we talk about a Singapore-Dollar-denominated broad-based diversified stock index, the only good option we really have is the Straits Times Index. Even though it only has 30 companies, it’s the best we’ve got.

Then if you want to invest in a Singapore-Dollar-denominated broad-based low-cost diversified exchange traded fund (ETF), then you only really have the STI ETF.

That is why the STI ETF, both the SPDR Straits Times Index ETF (ES3) and the Nikko AM Singapore STI ETF (G3B), are featured so prominently in my post on Building a Bogleheads 3-Fund Portfolio in Singapore and many other personal finance blogs.

However, how good is it really? How much returns can investors expect for investing in the STI ETF on a long-term basis?

Since I’ve recommended that Singaporeans have it as one of the core ETF in their portfolio, I wanted to get the numbers to back it up. Especially since in the last 11 years, the STI ETF chart looks like this:

SPDR Straits Times Index ETF performance from 10-Jan-2008 to 10-Dec-2018
SPDR Straits Times Index ETF performance from 10-Jan-2008 to 10-Dec-2018

Hmmm… *squints at the start price in 2008 and closing price in 2018*

Doesn’t look too impressive right? We started pretty much where we ended up at the end of the 11 year period. Most of the time it was just moving sideways. So how good can the STI ETF be for growing our hard-earned money really?

If the chart looks like this, wouldn’t I do better by putting my money elsewhere? Should we trust the advice that’s been thrown around about Dollar Cost Averaging (DCA) and long term investing into the STI?

Great questions, and you’re in luck! This analysis is meant to provide the answer to those questions and be as thorough as possible.

But hang on. Since the STI ETF has been around a while, surely there must have been other analysis done?

Other currently available analysis of the STI ETF returns

In the quest to find answers, I’ve been digging around the interwebs but have not been able to find any analysis that really answer all of my questions. The best analysis I could find were these 2 articles:

Although both articles are good, detailed and well-written, there were more analysis that I wished were covered.

What I wanted to see covered

  • Neither article looked at reinvesting dividends and how it will impact returns. Conventional wisdom tells us that reinvesting dividends increases our total returns as it allows our dividend to compound over time. Would that have been true with the STI ETF?
  • What are the most probable returns that we would have gotten from the STI over time? Are we more likely to receive 1%, 2% or 5% return? We should try to track the returns over time to find what level of returns are more or less likely.
  • How does Dollar Cost Averaging compares to Lump Sum investing when it comes to the STI ETF during the same time period? The standard recommendation within the FIRE community is that lump sum better than DCA most of the time because if the market always go up in the long run, you should buy now when stocks are cheap. However, unlike the S&P 500 or VTSAX, the STI – being made up of just 30 stocks – is much more volatile and the “self-cleansing” nature of a stock index and the strong upwards pressure may not be as pronounced. (Covered in Part 2 & Part 3, coming soon.)
  • How does inflation affects the returns? I don’t think either articles covered this, I assume that all figures stated were not adjusted for inflation. Since we’re talking about long-term investments, the rate of inflation will affect our returns so it would be good to see that taken into account.

Since I really wanted to scratch this itch and feed my curiosity, I decided to get down and dirty to do the analysis myself!

So if you’re ready, let’s dive in!

WARNING: Hardcore maths ahead! For science!

So what’s the setup and how are you calculating the returns?

We will be taking a look at the SPDR Straits Times Index ETF (ES3) in this analysis, so when I say “STI ETF” going forward, that’s the one I’m referring to. Why? Because it’s the bigger of the 2 ETFs as well as it’s the one I’m investing in using my POEMs Regular Savings Plan so it only makes sense that I want to know how it performed.

Here’s the investment setup:

Monthly InvestmentS$1,000.00
Transaction Cost per Month (Brokerage Fee)S$6.42 (or 0.642% of S$1,000)
Purchase Dates10th of each month or next trading day
Remainder AmountsAny remaining amounts from one month gets added to the next month’s funds.
Dividend ReinvestmentAny dividends paid will be added to the next month’s funds to invest.
Start Date10-Jan-2008
End Date (Last Buying Date)10-Dec-2018
Total Number of Purchases132
Total Amount Invested (Absolute)S$132,000.00
Total Amount Invested (Inflation Adjusted)S$140,856.22
Assessment Date (Selling Date)10-Jan-2019

Source of Inflation Data: Data.gov.sg

Why adjust for inflation?

Why the difference between the Total Amount Invested (Absolute) and Total Amount Invested (Inflation Adjusted) you ask? It’s because S$1,000 in 2008 and 2018 are not worth the same. With inflation, the value of the dollar erodes over time and so S$1,000 in 2008 is actually worth more than S$1,000 in 2018.

When we adjust for inflation, we’re looking to see how much all the money that was paid or received leading up to today is worth in today’s dollar. That is why in total, after adjusting for inflation, we actually spent closer to S$141,000 after 11 years of investing S$1,000 rather than S$132,000.

Once we adjust for inflation, we can compare every investment scenario on equal terms – in the value of today’s dollars.

Measuring the returns

In order to calculate the returns of this simulation, I will be using the Internal Rate of Returns (IRR) which will give us the “annual returns”, the rate at which an asset will appreciate per year. This returns rate can then be used to compare with the expected returns of other assets such as Fixed Deposit rate or the Singapore Savings Bond (SSB).

In order to calculate the IRR of this investment, I will be using the XIRR function in excel to calculate our returns for each month. This will let us map the returns of the STI ETF over time, after 2 months, 3, months, 50 months, or 132 months.

At the end, we will see the returns of the portfolio if I sell all of the STI ETF shares in my entire portfolio on the 10th of January 2019 after 11 years of buying every month.

Without further adieu, here are the findings.

11-Year Internal Rate of Returns of the STI ETF with Reinvested Dividend

Before we get right into the numbers, here’s what this investment looks like summed up in a chart of total portfolio value the total investment over time – already adjusted for inflation:

Total investment vs total portfolio value over time (adjusted for inflation)
Total investment vs total portfolio value over time (adjusted for inflation)
ES3 Data Sources: Yahoo Finance (Price) and SPDR Website (Dividend)

Huh… wait… that looks pretty promising compared to our price chart earlier that looked like it barely moved. Also notice that aside from the one or two years, the portfolio value has always stayed above the amount of money that has been added to the portfolio – even during times when the market dropped sharply like at the end of 2011 and 2015.

So what was the actual return? Here are the hard numbers:

Inflation AdjustedNot Inflation Adjusted
Total Shares Purchased61,389 Units61,389 Units
Total Capital OutlayS$140,856.22 with remainder of S$0.70S$131,999.30 with remainder of S$0.70
Total Portfolio on 10-Jan-2019S$198,347.86S$198,347.86
Portfolio GainS$57,491.64 (40.82%)S$66,348.56 (50.26%)
Rate of Return5.63%7.15%

This means that in the past 11 years, between 10th January 2008 and 10th January 2019, the STI ETF returned on average 5.63% each year after accounting for inflation.

Since the average inflation in the past 11 years was around 1.5%, even the CPF Special Account would have provided less than 3.5% in real returns, even if you account for an extra 1% of bonus interest! So far, the STI ETF looks like a good deal.

Note: The reason I also provided the non-inflation adjusted returns is so you can use this number to compare with other assets being advertised today. When you see the CPF rates (like 5% or 4%) these are not yet adjusted for inflation so you should compare it with the “Not Inflation Adjusted” column.

How IRR changes over time

Since you only get a return on your portfolio when you receive dividend or sell your shares – and we reinvest all of our dividends – the only time we make a return is during a sale. This means that our rate of return is determined by the price when we sell and that is constantly changing over time.

How does that look like for our investment portfolio? Is 5.63% return just a fluke due to an unusually high price at the time of sale?

Let’s map out the rate of returns of our investment over time by calculating the rate of return for each month by assuming that we’d sell our entire portfolio on the 10th of each month:

Chart of the real rate of return over time
Chart of the real rate of return over time

The rate of return is affected by the length of your investment, it is highly sensitive to price movement in the beginning of the investment period and becomes more stable over time. That is why you see huge volatility earlier on that stabilizes as time goes by.

But what’s the return you will normally get?

The volatility in the beginning obscures the more subtle changes later on but it does seem that most of the time, the returns hover between 6 and 9%. Let’s make that clearer by taking a look at the distribution of the returns over the last 11 years in a histogram.

Histogram of the returns of the STI ETF in the last 10 years
Histogram of the returns of the STI ETF in the last 11 years

This chart makes it super clear that although there are pockets of negative returns, the majority of the time, it is on the positive side for the last 11 years. To make this chart easier to digest, I combined all the negative returns into one group, and anything above 13% return into another group so we can zoom into the 6-9% mark.

Condensed histogram of the returns of the STI ETF in the last 10 years with returns less than 0% and more than 13% grouped together.
Condensed histogram of the returns of the STI ETF in the last 11 years with returns less than 0% and more than 13% grouped together.

Great! Now we can actually see that the majority of the time, the returns for STI ETF in the last 11 years is often positive. Out of 132 periods, only 13 of those had returns of less than 0% and 27 of those had returns between 6% and 7%.

Broken down into a table, this is what that looks like:

Real ReturnFrequencyPercentCumulative %Reverse Cumulative %
Less than 0%139.92%9.92%100.00%
0 – 1%21.53%11.45%90.08%
1 – 2%00.00%11.45%88.55%
2 – 3%75.34%16.79%88.55%
3 – 4%86.11%22.90%83.21%
4 – 5%96.87%29.77%77.10%
5 – 6%1712.98%42.75%70.23%
6 – 7%2720.61%63.36%57.25%
7 – 8%1813.74%77.10%36.64%
8 – 9%43.05%80.15%22.90%
9 – 10%10.76%80.92%19.85%
10 – 11%10.76%81.68%19.08%
11 – 12%10.76%82.44%18.32%
12 – 13%21.53%83.97%17.56%
More than 13%2116.03%100.00%16.03%
Total131100%

The total occurrence is 131 not 132 because the first period does not provide a return.

Very fascinating!

If you read the table, you can ask it a lot of questions and get very clear answers. For example:

  1. “How often did the STI ETF return more than 6% real return a year?” – You can look down the “IRR” column to find “6 – 7%” and across to the “Reverse Cumulative %” column to see that the STI ETF returned more than 6% at 57.25% of the time if you started 11 years ago.
  2. “How often did the STI ETF return less than 4% real return a year?” – Since our CPF Special Account (even with bonus interest) only returns 5% (less than 3.5% real return) a year, this is a question we might want to know the answer to. We can look down the “IRR” column to find “3 – 4%” and across to the “Cumulative %” column to find that in the past 11 years, the STI ETF returned less than 4% only 22.90% of the time. Very handy!

Using this table, you can also see that the STI ETF returns between 5% to 9% more than 50% of the time and it returned more than 5% per year at 70.23% of the time in the last 11 years!

With that kind of odds, it’s no wonder why I have no qualms about having the STI ETF as one of the core parts of my portfolio.

What if I don’t reinvest the dividend? How badly am I impacting my returns if I spend the dividend instead?

Here comes the interesting part. Let’s repeat the same simulation, but this time, we will not reinvest any of the dividend. Instead we’ll use the dividend to offset the capital injection if any, and whatever that’s left, we’ll take out to spend. A person’s gotta eat right? Dividend is a great way to live off your investment without having to sell shares after all. So how will that affect the final portfolio returns? Here’s the setup:

Monthly InvestmentS$1,000.00
Transaction Cost per Month (Brokerage Fee)S$6.42 (or 0.642% of S$1,000)
Purchase Dates10th of each month or next trading day
Remainder AmountsAny remaining amounts from one month gets added to the next month’s funds.
DividendDividends paid will be used to offset the next month’s investment. Any remaining will be taken out.
Start Date10-Jan-2008
End Date (Last Buying Date)10-Dec-2018
Total Number of Purchases132
Total Amount Invested (Absolute)S$132,000.00
Total Amount Invested (Inflation Adjusted)S$113,861.60
Assessment Date (Selling Date)10-Jan-2019

(From now I will refer to reinvesting dividend as “RD” and not reinvesting dividend as “No RD” so it’s shorter to read and write.)

The first thing you’ll already notice is that the Total Amount Invested (Inflation Adjusted) is actually lower than the absolute amount invested! How is that possible?

This is because we have to account for withdrawing the dividend, this actually reduces the net amount we’ve invested. This helps reduce the total cost of the portfolio.

Now, of course, since we don’t reinvest the dividends, we won’t be able to buy as many shares. Here’s what the Total Portfolio Value and Total Investment looks like against the same chart for when we reinvest the dividend:

Chart of total investment vs total portfolio value for both RD and No RD. All figures has been adjusted for inflation.
Chart of total investment vs total portfolio value for both RD and No RD. All figures has been adjusted for inflation.

As you can see, although the Portfolio Value for No RD ended up much less than if we did reinvest, their total cost (Total Investment) is also lower as they received income from the dividends over time. It’s hard to tell here which performed better.

In order to compare properly, we will have to take a look at the chart for the percentage gain over time:

Chart of the total gain/loss for DCA with and without reinvesting dividends. All figures has been adjusted for inflation.

Chart of the total gain/loss for DCA with and without reinvesting dividends. All figures has been adjusted for inflation.

What’s this? It looks like they both performed almost exactly as well until near the end where the gain from No RD is higher than reinvesting? Although it’s quite a small difference (less than 2%), that’s an unexpected result… we’d normally expect reinvesting to outperform. What’s going on here?

Why is the percentage gain from reinvesting dividends lower than if we don’t reinvest?

The conventional wisdom is that reinvesting your dividends should provide a greater return as you allow your dividends to compound over time rather than take it out of the investment pool.

So what could be causing this odd behavior? Right now I’m not 100% sure but my suspicion is that whenever dividend is paid, the gain from purchasing more shares by reinvesting is similar but not quite as good as the cost reduction by pulling out the dividend.

It’s possible that given that all else being equal, the inflation rate is playing a role in helping to boost the effect of getting money out earlier. If any of you have any ideas you’d like to test out to get a clearer answer to this conundrum, I’m all ears!

What about the real rate of returns between the two?

Good question, looking at just the percentage gain isn’t always useful, it’s always better to compare the rate of return.

When the real rate of return for both scenario is put into a chart, it’s exactly the same over time!

Real rate of returns for DCA with and without reinvesting dividends over time
Real rate of returns for DCA with and without reinvesting dividends over time

This is because the XIRR formula has already taken into account the cash flow from withdrawing the dividend vs reinvesting it back into your portfolio.

Overall because reinvesting the dividend just means that you’re deferring receiving the dividend until later (when you sell your shares) your overall rate of return remains the same whether you reinvest the dividend or withdraw it to use earlier.

Here’s a table of the final results of both reinvesting dividends and not reinvesting:


Reinvest Dividend

No Reinvest Dividend
Total Invested$131,999.30$131,999.44
Total Invested (Inflation Adjusted)$140,856.22$113,861.60
Cumulative Units61,38950,244
Average Purchase Price$2.66$2.63
Total Dividend (Inflation Adjusted)$32,871.61$28,998.20
Total Portfolio Value (Today’s Dollar)$198,347.86$162,338.36
Inflation Adjusted Gain (S$)$57,491.64$48,476.76
Inflation Adjusted Gain (%)40.82%42.58%
11-Year IRR7.15%7.15%
11-Year IRR (inflation Adjusted)5.63%5.62%

A few points to note:

  • Cumulative units of shares is lower for not reinvesting dividends. This is expected as the dividend is withdrawn instead of used to purchase more shares.
  • The Average Purchase Price for RD is slightly higher than not reinvesting. This is because the dividend is being used to purchase more shares over time as the share price increased so naturally the average cost of the shares will increase as well.
  • Total Dividend is higher for RD than No RD. This is due to having more shares to pay out dividends over time as the dividend is used to purchase more shares.
  • Although Inflation Adjusted Gain percentage for No RD is higher than that of RD, the inflation adjusted and non-inflation adjusted 11-Year IRR are almost exactly the same across both options.

So what’s the verdict? Reinvest or don’t reinvest the dividends?

Since the overall real returns from both options are the same, how should be look at these options and decide between them? Here’s my take:

  1. Reinvesting dividend trades getting cash flow from dividend now into the total portfolio value and higher accumulated units of shares over time compared to No RD.
  2. As FIRE practitioners, we are attempting to build our portfolio to hit our “FIRE Number” – a number which will let us live on our investments forever. This means that the investment method that gets our portfolio to that point quicker is the best strategy.
  3. During our accumulation phase, we will be working to earn income and do not require the income from dividends to supplement our income and cover any costs.
  4. If you wish to live off of dividends once you retire, it’s best to reinvest the dividend so you accumulate more shares of the STI ETF quicker. By the time you retire, you will have much more units and thus a higher dividend payout to live on.

Based on the above 4 points, clearly reinvesting dividends is the best option and is the option I am currently using. Your situation may be different though so if you do need the income from the dividend right now, taking the dividend to cover expenses may be better for you.

How does STI ETF compares to other investment vehicle?

Now that we have the detailed data from all the calculation that I just did, we can make direct comparison between the returns of the STI ETF and other asset classes. Here are the current rate of return of popular investment products today (not adjusted for inflation, so compare it with the 7.15% return of the STI ETF):

Investment VehicleNon-Inflation Adjusted Return
CPF Special Account4% – 5%
CPF Ordinary Account2.5% – 3.5%
Singapore Savings Bond (10 Year)2.20% (If held to maturity)
Fixed Deposit Rate (Source: MoneySmart)1.5% – 1.95%

Average inflation rate in the last 11 years: 1.54%

It’s almost not really a comparison here. Of course, it’s probably not fair to compare the returns of a stock index to safer investments as shown above, but the takeaway is clear:

  • For SGD denominated investment, it’s hard to beat the STI ETF in terms of returns.
  • A lot of the safe investment vehicles either barely keeps up with inflation or are very restricted (CPF.)

The only other investment vehicle that could potentially beat the STI ETF are REITs (as touched upon by Kyith of Investment Moat in his STI ETF article.) However, I haven’t done the detailed research on that and that could be a good place to analyse after this. (Stay tuned!)

However, if you are waiting on the side-lines, I think the STI ETF remains one of the best options for parking any investment capital that you do not need in the short term.

OK great, so how do I invest in the STI ETF?

As far as I can tell, every brokerage firm in Singapore allows you to invest in any stock listed on the SGX and both STI ETF are listed there. As long as you have a brokerage account, you should be able to purchase either of the 2 available STI ETF:

However, one of the most important consideration when selecting your investment platform is cost. The current investment platform I’m using “POEMs” by Phillips Capital provides a Regular Savings Plan which allows me to automatically buy a fixed value of shares each month starting at a cost of $6.42 per month.

If I only invest S$100 a month, the S$6.42 transaction cost will be 6.42% of my investment! Which is exorbitantly high! However, if I instead invest S$1,000 per month, that same S$6.42 fee is now only 0.642% of the transaction, much better. This is my current monthly setup and is the setup I used for calculations in this post.

What would returns look like if costs were higher than 0.642%?

Here’s a table for those curious:

Cost (%)Inflation Adjusted Returns (%)Non-Inflation Adjusted Returns (%)Inflation Adjusted Gain (%)
6.42%4.61%6.12%32.62%
3.21%5.19%6.70%37.18%
1.284%5.52%7.04%39.90%
0.642%5.63%7.15%40.82%
0.321%5.68%7.21%41.27%

Clearly keeping costs low will be important for your portfolio return. So keep it as low as possible. So if your broker has transaction costs structured with a minimum fee, it’s always better to push up your investment amount to minimize the transaction cost as a percentage of the total investment.

There are a lot of regular savings product available today to help you invest in the STI ETF with DCA and also reinvests the dividend automatically for you at very low cost. Phillip Capital’s Regular Savings Plan is one and POSB Invest Saver is another. You can read Kyith’s comprehensive guide to POSB Invest Saver for more information on that one.

Update: Seedly also has a very comprehensive analysis of which regular savings plan is the cheapest. It lists all of the available plans and gave a very good breakdown. You should check it out.

I may do one of my own posts on the best platforms to use in the future so stay tuned.

What does this mean for us folks on the FIRE path?

Phew, that was a long analysis. I hope you’re still following along. So based on these results, what kinds of conclusions can we draw and how should we – as people pursuing financial independence in Singapore – interpret this information to apply to our investment portfolios?

Here are the key takeaways:

  1. DCA investing into the STI ETF is a great way to build up the local currency portion of your lazy 3-Fund portfolio and it has provided great returns over the last 11 years even through the last financial crisis.
  2. In terms of real returns of the entire investment, it does not matter whether you reinvest the dividend or take it out to be used. Taking out the money just means you get to enjoy the fruits of your investments sooner but at the expense of the future size of your retirement nest-egg.
  3. If you do not reinvest your dividends, you will reach your “FIRE Number” later than if you were to reinvest the dividends.
  4. Reinvesting your dividend into the STI ETF is the way to go for your if you do not need the cash flow from the dividend to cover expenses. It allows you to quickly build up the portfolio value during the accumulation phase and build up more units of shares such that the portfolio can provide higher dividend income during your retirement.
  5. Minimise costs while you invest into the STI ETF, if your brokerage offers a fixed cost structure, try to increase your monthly investment so the percentage of the investment that the transaction cost takes up is lower.

I hope this analysis was interesting and helpful for you as it was for me. Now I can continue to invest into the STI ETF with more confidence and understand that I’m on the right path.

My next post will go into the details of whether Lump Sum investing into STI ETF is better or worse than DCA. If you’ve ever wondered whether you should put all your annual bonus into the STI right away or spread it out over time, then that’s what we’ll be looking at in the next post. Since it takes some time to run these types of simulation and compile the results, it might take a bit of time. Stay tuned!

As always, I welcome all comments and feedback (and even corrections if you spot any mistakes!) I’d love to hear from you about what I’m doing well and what I’m not so I can improve my posts to make it easier to read and understand.

You can also follow me on twitter if you want to have a conversation by tweeting @firepathlion! Thank you for reading!

If you enjoyed this post, it would make my day if you could help share this article with your friends who might also find it interesting. Thank you!

Until next time.

FPL

20 thoughts on “The Ultimate Comprehensive Analysis of The 11-Year Returns of the STI ETF: Part 1 – Dollar Cost Averaging”

  1. Hey RPL, great analysis!

    It seems like the answer to the conundrum is in the final table comparing RD and NRD. The average purchase price for NRD is lower, thus the percentage gain will be higher. This is due to the volatility of the stock price and depends on the price which you reinvest the dividends. It just so happens that you reinvested the dividends at a higher price causing average cost to go up, and also the final STI closing price being lower than the ten year ‘average’ (it’s not really the average but it works here). Try running the numbers again but increase the final closing price – RD should outperform NRD once you increase it high enough.

    Reply
    • Thanks WGM! Yes that’s a good point, the higher average price as well as the volatility could be it. I’ll try running the numbers with a higher final selling price to see how it moves when I get home. 🙂 Although because the average price is higher for RD vs No RD, I suspect both returns will increase by an equal amount and ending with No RD with higher returns again. Let’s find out!

      Reply
  2. Since the metric we are using here is total gain/loss, only 2 variables matter: cost and profit. Cost is calculated by average buying price * quantity, profit is by average selling price * quantity. In both cases, average selling price is the same, but quantity and average buying price is different. In this specific situation, at low prices, the effect from the lower average selling price dominates the equation, so NRD outperforms. As you increase the average selling price, the effect of the larger quantity in RD becomes more prominent, so eventually, RD outperforms.

    Reply
    • I just re-ran the simulation with the selling price at 10-Jan-2019 at S$4 instead of the S$3.21 which is a significant increase, but instead of narrowing the gap or RD overtaking No RD, the gap between the gains of RD and No RD increased with No RD showing even greater % return (RD gain of 74.89% and no RD gain of 77.23%).

      I think this is the correct result as the quantity of shares shouldn’t factor into the percentage gain.

      As an example:
      * Case A: 10 shares at $5 per share
      * Case B: 5 shares at $4 per share
      * Current Price: $6 per share

      Case A will have 20% gain and Case B will have 50% gain. If the price increases to $10, Case A will have 100% gain but Case B will now have 250% gain. The number of shares doesn’t factor into the percent gain calculation.

      So something else is causing this weird behaviour… :\

      Reply
      • I’m guessing it’s how you calculate in the cost basis in both cases. In the table, total invested for RD and NRD is the same, because in period zero you put in the same amount in both portfolios (I got confused about this too in my earlier analysis).

        If cost basis is the same, then % return depends on the total profit (loss) of your portfolio. In your example, with $6: Case A has a return of ($6 – $5) x 10 = $10 and Case B has a return of ($6 – $4) x 5 = $10 (coincidence). But with $10: Case A has a return of ($10 – $5) x 10 = $50 but Case B has a return of ($10 – $4) x 5 = $30. Since both cases are a matter of RD vs NRD, the cost should be the same since you put the same amount of money into the portfolio. So given the same cost, Case A has a better return compared to Case B as the price increases.

        Reply
        • Hmmmmmmmmmm, I think that is the case if you do not take into account the return you receive from taking out the dividend. If you subtract the income from the dividend from the cost and then account for inflation, this is where it may be possible for Case B to come out ahead (as what’s being shown in this case, as long as I haven’t made any calculation mistakes.)

          Reply
  3. Currently FSMone has ETF rsp plan for ES3 as well, and although it mentioned the fee are 0.08% or $1, is there any hidden charges that is not make known to us? Would really appreciated if anyone can shine some light on this.

    Also i am not sure should i set up CDP or just invest directly with FSMone rsp plan so my shares are kept with a custodian account. Which would be better option?

    Thanks 🙂

    Reply
  4. How does compounding interest play a role here? Because in DBS website, they mentioned about compounding interest and investing in ETF, fetch you a larger sum than stated here.

    So are ETF compounded?

    Reply
    • Hey G! Thanks for reading and commenting with your question.

      So the terminology is probably slightly inaccurate. When most places talk about compounding with regards to stocks and investments, it’s closer to “compound growth” rather than “compound interest” since stocks and shares don’t pay interest. They do often pay dividends and they also appreciate in value, which will provide the same compounding effect as compound interest does.

      For example, stocks and ETF will grow / appreciate in value over time and that appreciation is measured in percentage growth, as in “Singtel stock appreciated by 10% this year!” If you hold 1 share of Singtel and let’s say that it was worth S$100 in year 1. If it appreciated by 10% that year, the same share of Singtel will now be worth S$110. You didn’t have to do anything. Then next year, Singtel appreciated by another 10%. Now that Singtel share is worth S$121 because it increased by 10% from S$110. Over time, your share of Singtel continues to grow on top of it’s own value without having to pay any interest and thus provide you with compound growth.

      Similarly, if a stock pays dividends, you can use the dividend to reinvest into the same stock in order to get the compounding effect. This is much more similar to how compound interest works. The share pays dividend, you use the dividend to buy more shares, and those new shares also pay dividend and on and on.

      ETFs are just a collection of shares and those shares can appreciate and/or pay dividend. So as long as you continue to hold the ETF and reinvest any dividend you receive into the same ETF, you will also enjoy the effect of compound growth.

      I hope that makes sense!

      Reply
  5. Hi FPL,

    As usual, this is an insightful post.

    At the same time, could I get your personal views on the arguments raised against investing into STI index mentioned in https://financialhorse.com/STI-ETF/.

    For a lay reader, the returns of the index differs quite drastically between your post and that in the said link. If there are any assumptions made, different time period etc which affects your conclusion, could you perhaps let us know?

    Reply
    • Hi RR,

      I also received blog post from elsewhere which indicates STI-ETF perform poorly around 3%. I guess it depends on the time when the writer did the analysis.

      If it is like in the mid of Covid-19 crisis, the performance will be even worse.

      I think FPL have part2 & 3 of the following up post talking about the crisis.

      Do bear in mind in the finacianl horse post, it mentioned 10 year return is 7.42%, which is not far from HPL calculation.

      The STI-ETF gives dividend twice annually.

      So, from HPL working,
      He invested $140.8k
      His final asset value is $198k ( after11 years)
      Total gain = $58k.

      Out of which, $37.8k (57%) is the dividend, $20.2k (43%) is capital appreciation.

      IMHO, if you want to invest for dividend with a moderate capital growth, STI-ETF is probably one of the many instruments you can consider.

      HPL,

      Thanks for the detail write-up. I was looking for someone who could do the calculation then just quote some number from the factsheet/prospectus.

      Would you be able to share your working on how to get the $198k? I was trying to emulate that through excel spreadsheet, but the return is quite far below of the 40% you calculated. Which of the closing price you’ve used in the calculation? The closing price or adjusted closing price from Yahoo?

      Thanks.
      LPT

      Reply
  6. Hi FPL,

    Thanks for the detailed analysis
    I like that you are going into the details of things, and also giving the break down of input & assumption. It makes it easier to follow and replicate the calculation.
    About replicating the calculation, similarly to what you are doing, I tried to plot a surface graph of IRR with the 2 following dimension varying:
    – starting date of investment
    – ending date of investment
    In your case, you are “only” making the ending date of investment varying.
    I ended up finding much lower IRRs than what you discuss & present (mostly in the range of 0% to 3% at best)

    So to confirm that my calculation was correct, I wanted to compare my own calculation results to yours, and make sure that, for the same starting & ending date, we have the same IRR.

    But it turns out that I didn’t find the same result.
    Using exactly the same dataset as you (yahoo finance), same dates, same investment strategy (buying every 10th of the month or so & reinvest dividends), I find an IRR of 4.6%
    Besides, I don’t even consider the transaction fee & inflation, which would further degrade the IRR.

    Drilling deeper into explaining this discrepancy, you explain that, on the 10th of Jan 2019 (when you sell all you shares), you own a total of 61389 shares.
    In my calculation, on the 10/12/2019, I only own 55205 share
    Significant difference which explain the bulk of the IRR difference.

    In a previous response to comment, you gave a link to your spreadsheet, for which I have requested access to check what is different in your calculation.
    Hopefully, I can get access and understand better where the mistake is coming from.
    In the meantime, if you do have an idea to explain this, don’t hesitate to share

    Thanks for your interesting work

    Tony

    Reply
    • Hi Tony! This is definitely concerning! I’d love to know if I made any mistakes in my spreadsheet that could be causing this discrepancy. Can you request access again in case I had missed that email from Google Sheets!

      Reply
      • Hi FPL,

        Thanks for allowing the access!
        I had a quick look at your file and found 3 differences with my own file:

        – Stock price: I consider the Opening price, whilst you considered the Adjusting closing price. I wasn’t familiar with this definition. After looking it up, I agree with you that we should consider Adjusted closing price

        – Adjusted closing price: I cannot explain why, but the Adj closing price you have in your file are different from the Adj closing price extracted from Yahoo finance. The downloaded Yahoo data is ranging from 0.1 to 0.2 SGD greater than data in your file.

        – Dividends: I downloaded the Yahoo finance dividend data. According to Yahoo finance, dividends on ES3.SI only started in August 2013. On the contrary, it seems that your file considers dividends as early as February 2008

        Could you give your view on the second and third points?

        Thank you

        Tony

        Reply
        • Hi Tony! Hmmmm I’m not sure why the Adjusted Closing Price would be different for you as we both got that data from the same source – Yahoo Finance. That is very strange… Does it make a huge impact on the outcome of the analysis?

          As for dividends information, I did not use the Yahoo Finance Dividend Data, instead I used the information from https://www.dividends.sg/view/es3 as they seem to have data going further back – it goes all the way back to 2002 but unfortunately the Yahoo Finance data doesn’t go back that far so I haven’t been able to do a longer term study on the returns.

          Hope this helps!

          Reply
  7. Hi FPL,

    I just started a blog on investments as I have the same mindset to reach FIRE. I really liked your calculations and post on DCA. Your post is extremely detailed and comprehensive. I have linked it on my (newbie) blog, I hope you don’t mind. Please let me know if you do. Thanks! Have a great week!

    Best regards,
    Duskerdawn

    Reply
    • Hey Duskerdawn! Great to see another financial blogger getting started! I do not mind at all, I really appreciate it and just approved the link back in the comments 🙂 good luck on your blogging journey!

      Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.