(Request) Spreadsheet/Model comparing after tax returns of ETF, Life assurance, Directly held shares, non tax relieved pension contribution?

ClubMan said:
For me, this thread calls to mind a famous John Bogle (founder of The Vanguard Group) quote...

“The greatest enemy of a good plan is the dream of a perfect plan. Stick to the good plan.”
Click to expand...
Agreed, the other issue is that people are spending so much time procrastinating over this decision they’re likely losing more money sitting on the fence than any possible tax savings their eventual decision yields.

The thing is, it’s my view that the advice AAM should be giving the average person walking in off the street asking how to invest their savings is to put it into a single World Equities ETF, without question. Advising people to dabble in share picking is trying to reach tax perfection by what is now clearly a negligible amount when everything is factored in. An ETF is cheap, easy, low stress and simple - a good plan.
 
Last edited:
Zenith63 said:
Agreed, the other issue is that people are spending so much time procrastinating over this decision they’re likely losing more money sitting on the fence than any possible tax savings their eventual decision yields.
Click to expand...
At the risk of boring people with the same post again, that's exactly what I did for too long...

What to do with a million euros?

Personal details Your age: 49 Your spouse's age: 54 Number and age of children: 2 aged 9 and 14 Income and expenditure Annual gross income from employment or profession: €30,000 (state job) Annual gross income of spouse/partner: €60000 (state job) Pension: have maxed AVC’s (should I also...
www.askaboutmoney.com
I took a slightly different approach but it's worked out pretty well for me. There may have been an even better one, who knows...

As another famous businessman, Tony Soprano, said, "more is lost by indecision than wrong decision".
 
Last edited:
My experience was that I had the benefit of reading your and Brendan's posts recommending buying a basket of shares ~20 years ago. I did that for a decade or so and really enjoyed learning and the ups and downs, hours and hours spent watching the Deepwater Horizon disaster wondering how best to play it with my BP shares, hunting down SCRIP/DRIP shares to maximise compounding etc. It ultimately lead me to start a business using the money I'd invested.

Fast forward 10-15 years I had money to invest in the markets again, but this time decided to go with a single diversified ETF. The experience is utterly different - I spend no time researching companies, no emotional tugs while in that world of researching towards the latest meme stock, no time rifling through stuff like SCRIP receipts and dividend withholding tax slips to get them over to my accountant every year, no time trying to harvest annual CGT allowances, no time lying awake at night wondering if buying Vodafone was a good call or not buying Microsoft will punish me. When I buy I stick the date/price in a Google doc that my accountant can review in nearly a decades time and I look at the price on the index every week or so with interest, that's it.

While I loved the process of learning to buy individual shares I don't think it is for the vast majority of people, and having seen both sides of this I am very firmly of the view that we should be recommending a single ETF to most people off the street that ask for advice on AAM and not a basket of shares. The individual shares approach is in my view letting the tax tail vigorously wag the safe investment dog for the average punter.
 
Good post - but I'm still happy with my BRK.B et. al. simplified approach to direct equity investment and the preferential and simplified (no dividends) tax treatment. Admittedly it's probably riskier than a more diversified ETF but less so than a manual portfolio/basket of shares approach.
 
I probably should have said that if I was doing it all over again I would go the same route, what I learned was invaluable and as I said I loved it, even the downs. But from talking to friends and family over the years I know the average person is not like this and would much more likely have come out the far end with nothing or a deep distrust of stock market investing.

So my view is that if somebody comes to AAM asking about entrepreneurship, learning how stock markets work and expressing a tolerance for risk then we should direct them to buy a basket of shares. If they come here with their life’s savings in a bank account, no knowledge or interest in stock markets and an aversion to risk we should be recommending an All World ETF and downplay the drama about Deemed Disposal, referring them to the spreadsheets in this thread showing the returns to your pocket and lifestyle are basically the same.
 
ClubMan said:
For me, this thread calls to mind a famous John Bogle (founder of The Vanguard Group) quote...

“The greatest enemy of a good plan is the dream of a perfect plan. Stick to the good plan.”
Click to expand...
Agreed. Both ETFs and shares are good options. Just pick one and go with that. They are both much better than leaving cash on deposit while you mull over the minutiae.
 
More than anything, the lack of loss offset is what really grinds my gears.

Picture this.

It's 2007, you just got a windfall of 1 million. "Hurray I can retire now!". You dump it into an ETF and retire, selling off small bits of ETF as your source of income. Then 2008 rolls around and you're down 50% on your ETF. You still have to sell, you're retired after all, every sale is now 50% loss. It's 2012 now, it took 5 years for the ETF to be back to break even of 2007. Since you can't use ETF losses, that's a lot of money you will never ever see again.

Under CGT, you would use those losses against gains after 2012 and be no worse off in the end, but not under ETF tax.

I can understand 41% rate. I can understand deemed disposal.

I don't understand why loss offset are not allowed for funds only, when allowed for Income Tax & Capital Gains Tax.

Could anyone tell me the rationale behind that?
 
Yes that is a strange one.

But just to be clear, losses within the ETF, which might include 500+ companies, will be offset automatically without being taxed. And through average costing you can effectively offset losses for the same ETF in a given year. What you’re talking about is carrying forward losses in subsequent years, which is indeed a difference from individual shares but is unlikely to be a concern to the vast majority of investors, particularly the ordinary person in the middle of their career investing for 10-20 years.
 
Last edited:

I'm not quite yet convinced of that.

If you could indefinitely hold shares, then it would be very unlikely to pose a problem. Invest today, never sell and 40 years from now your oldest shares will have gained perhaps 1400%. When next 2008 rolls around, even a 50% drop would mean your oldest shares are still around 700% gain and so can be "safely" sold in retirement without worrying about losses.

However deemed disposal changes that equation. It only gives you 8 years before tax is due. If you're investing non trivial sums, it's highly unlikely that you will be able to cover the tax out of pocket and be essentially forced to sell your oldest most profitable shares to cover the tax. What remains then is the "younger" shares that are less profitable and thus more likely to go from small profit to a loss when next 2008 style 50% drop happens.

This 8 year cycle repeats, perpetually keeping you closer to break even than CGT ever would.
 
You can use the average cost instead of FIFO which will help here.
 
@3CC

Major Kudos to you on the updates in your sheet!

When I'm considering this space, one other important option is to contribute more to your pension.

Unfortaunately there are a myriad of varietes there, depending on how much tax rate you pay at what rate, and how much you have already contributed.

For my case, I'm a higher rate tax payer, that is already making the max contibution that one can get tax relief on. I could contribute more, and have it accumulate with no tax drag, but ultimately it would be subject to income tax when I draw it down. (and there are some other risks like the fund threshold). Would you be interested in trying to model this too?
 

In that case, you would receive a rebate of the deemed exit tax when actually selling at a loss
 
Hi SPC100.

Thanks an interesting question.

If my figures are correct, investing in your pension in excess of the age related limits, and therefore without tax relief on the way in, does not look great.

My figures are based on paying the higher rate of income tax in retirement on the entire value of the pension other than the 25% tax free lump sum. If you expect to pay the lower rate of tax, the outcome is better at ~€201k rather than ~€158k.

I have assumed that you leave the full amount invested for 16 years. If you retire the pension sooner than that, you will presumably take the 25% lump sum and therefore will have less invested (in a subsequent ARF) which will lower your return.

The pension option becomes more attractive when the benefit of the tax free growth outweighs the fact that you need to pay income tax on both the capital and the growth (excluding the tax free lump sum). For this reason, the pension option might outperform the others over a longer time period.

So my own take from this is that the pension option could be better if you expect to pay lower rate income tax in retirement. Otherwise, probably not unless the investment horizon is very long.

Sometimes I get the sums wrong so I'd appreciate if you let me know of any errors.

 
Very interesting! Thanks so much for extending your modeling. I wasn't expectin such a clear cut outcome.

Granted, this is sort of the ''worst case pension model scenario': No tax relief, high income tax on drawdown.

I agree with you, that as you extend the time period, the pension scenario should improve.

In real life, I think there may well be much longer time periods. e.g. I would not be drawing down everything in one future year (until i die!), I would be drawing a small amount (or having the imputed distribution) each year. Notionally, I would potentially 'never' actuallly draw down much of the additional investment (or it's growth, beyond imputed distributions), e.g. if you cast it as the last thing you ever withdraw from the pension.

Regardless, would be interesting to see how many more 8 year periods it takes for pension to get ahead.
 
SPC100 said:
In real life, I think there may well be much longer time periods. e.g. I would not be drawing down everything in one future year (until i die!),
Click to expand...

Yes - that's very true. It's probably not worth modelling yearly drawdown but maybe a reasonable approximation would be to assume that your average investment period is half way through your expected retirement. So for example, if you are 55 now and intend to be retired from age 60 to hopefully age 85, then your average investment period will be from age 55 to age 72.5 which 17.5 years.

I have looked at the scenario again but now over a longer period below. This is using a different file but I have set the figures below to be the same as those above for consistency. So the file looks different but the scenario should be identical. (I have used the cells in green to cross check against the figures above.)

The result is that with no tax relief on pension contributions, 25% tax free lump, and higher tax rate on all income at drawdown (assuming you have already used your lower rate tax band with other income) - the tipping point in favour of the pension contributions vs the Accumulating ETF is ~ 24 years.

In truth, you would need to divest the 25% lump sum much earlier than the rest of the funds and so the pension would perform a bit worse than my figures indicate.

If your income tax rate was 20%, the tipping point is about 8 years.

So pension contributions in excess of the age related limit seem beneficial if you expect to be a lower rate taxpayer during retirement. If you expect to be a higher rate taxpayer in retirement, surpassing the age related limits probably only makes sense for those who are younger than say 45-50 years of age.

Hopes this helps.

 
Fantastic thread. Seems to confirm by evidence what one would expect intuitively.

With the greatest respect to people that do invest in baskets of shares – including those who seem to have done well out of it – it seems very unlikely this would outperform a global equities index fund, even with deemed disposal and a 41% exit tax rate.

If it was easy to get gains above what you can get in an index fund by randomly selecting shares we wouldn't need index funds. I'd love to see some hard numbers from people who've followed the basket of shares strategy, and a comparison of how they might have fared had they invested the same amount in ETFs in the same period.

This would be all the more the case if deemed disposal gets nuked and exit tax goes down to 33% as planned.
 
Ent319 said:
I'd love to see some hard numbers from people who've followed the basket of shares strategy, and a comparison of how they might have fared had they invested the same amount in ETFs in the same period.
Click to expand...
I imagine you'll get a selection effect here - the people who have beaten the ETF will be more than happy to share that, the others not so much.
 

It's an ongoing point of discussion here on AAM - which is better, shares or ETFs. There's plenty of well informed people who make good arguments for both. The truth is both are good, neither is better, and which you prefer probably comes down to just your personal preference or individual circumstances.
 
I'd say that the difference in returns between the two is massively dwarfed by the opportunity costs of the missed returns due to people procrastinating and investing in neither, or asset classes less appropriate to a medium/long term investment timeframe (e.g. deposits etc.).
 
I am that man on the street procrastinator. I am overwhelmed with the tax implications of EFTs. What do I need to record for (potentially) 8 years time. Should I buy monthly or does that complicate a future tax return.

Do I need to buy more than one EFT for a balanced investment?

The above has convinced me that EFTs are for me. Particularly the post about the value of my time and being awake at 4am. I want to buy and forget.

To extend it further. Which EFT would you buy? Do those that offer diffident add more tax complications?
 
You must log in or register to reply here.
Menu
Log in
Register