Soldato
- Joined
- 4 Aug 2007
- Posts
- 22,429
- Location
- Wilds of suffolk
For a bit of "fun" I knocked up a quick spreadsheet showing the effect of the tax on investment. I have assumed a salary deduction of £80.
I have assumed that the £80 is grossed up by tax making it £100 (current situation)
I have assumed a 4% return on investment (after commission) which is pretty reasonable even in current economic circumstances.
I have simplified the annual rates by using rate/12 rather than adjusting for compounding. Its not so far out for a calculation of this size to materially affect the result (it slightly benefits the calculation using the higher rate)
Person A saves £80 per month net into a pension scheme that achieves 4% growth per annum, after 10 years its worth £14,774 (the £80 is made up to £100 via tax relief)
Person B invests £80 per month into his investment portfolio. He is better than the market and achieves 6% growth. After 10 years his portfolio is worth £13,176
If you look at month 1 contributions after 10 years A has gone from £80 to £149, B has gone from £80 to £146. Within about a year B would overtake A as B would continue to earn at 6% and A only at 4%. I takes this long for B with 2% extra growth to negate the tax effect.
The total pot is lower for B overall due to it taking that long to negate the tax benefit, if you look at the last month. A £80 has gone to £100.33 due to tax, B has gone from £80 to £80.4.
In order over 10 years to make up for the tax break of pension contributions B would actually have to achieve just over 8% growth.
Looking longer term over 20 years A would achieve a total pot of £34,395 and B would achieve £34,306. This is using the original 4% and 6% returns and the same contribution rate.
If the pension fund achieved the same 6% growth it would be worth £42,883 after 20 years for person A, vs £34,306 for person B thats a farily marked difference.
I have assumed that the £80 is grossed up by tax making it £100 (current situation)
I have assumed a 4% return on investment (after commission) which is pretty reasonable even in current economic circumstances.
I have simplified the annual rates by using rate/12 rather than adjusting for compounding. Its not so far out for a calculation of this size to materially affect the result (it slightly benefits the calculation using the higher rate)
Person A saves £80 per month net into a pension scheme that achieves 4% growth per annum, after 10 years its worth £14,774 (the £80 is made up to £100 via tax relief)
Person B invests £80 per month into his investment portfolio. He is better than the market and achieves 6% growth. After 10 years his portfolio is worth £13,176
If you look at month 1 contributions after 10 years A has gone from £80 to £149, B has gone from £80 to £146. Within about a year B would overtake A as B would continue to earn at 6% and A only at 4%. I takes this long for B with 2% extra growth to negate the tax effect.
The total pot is lower for B overall due to it taking that long to negate the tax benefit, if you look at the last month. A £80 has gone to £100.33 due to tax, B has gone from £80 to £80.4.
In order over 10 years to make up for the tax break of pension contributions B would actually have to achieve just over 8% growth.
Looking longer term over 20 years A would achieve a total pot of £34,395 and B would achieve £34,306. This is using the original 4% and 6% returns and the same contribution rate.
If the pension fund achieved the same 6% growth it would be worth £42,883 after 20 years for person A, vs £34,306 for person B thats a farily marked difference.