mc2fool wrote:Ok, here it is. Investing the max. in General PEPs and ISAs on the earliest date possible each time:
the total invested is £310,760 and the XIRR to get to a million today is 7.42%pa.
if you qualified for the over-50s extra in 2009/10, applied from 1st Oct, the total is £313,760 and the XIRR to a million is 7.38%pa.
and if you also maxed single company PEPs it is £337,760 and 6.61%pa if over 50 in 2009/10, and £334,760 and 6.64%pa if not.
Now, for comparators ... well, the FTSE 100
capital only for the same period managed just an annualised 4.11%pa but with probably an extra 3-4% dividend yield it looks like one could have got to a million or so with the same contributions all going into just a FTSE 100 tracker (although such a beast probably didn't exist in the earlier years). Of course, if you'd put it all in Berkshire Hathaway instead ....
Data below if anyone wants to DIY for different starting dates or other variants.
Date Amount Runniing Total
1-Jan-1987 £2,400 £2,400
1-Jan-1988 £3,000 £5,400
6-Apr-1989 £4,800 £10,200
6-Apr-1990 £6,000 £16,200
6-Apr-1991 £6,000 £22,200 Add £3k for SC PEPs
6-Apr-1992 £6,000 £28,200 ditto
6-Apr-1993 £6,000 £34,200 ditto
6-Apr-1994 £6,000 £40,200 ditto
6-Apr-1995 £6,000 £46,200 ditto
6-Apr-1996 £6,000 £52,200 ditto
6-Apr-1997 £6,000 £58,200 ditto
6-Apr-1998 £6,000 £64,200 ditto
6-Apr-1999 £7,000 £71,200
6-Apr-2000 £7,000 £78,200
6-Apr-2001 £7,000 £85,200
6-Apr-2002 £7,000 £92,200
6-Apr-2003 £7,000 £99,200
6-Apr-2004 £7,000 £106,200
6-Apr-2005 £7,000 £113,200
6-Apr-2006 £7,000 £120,200
6-Apr-2007 £7,000 £127,200
6-Apr-2008 £7,200 £134,400
6-Apr-2009 £7,200 £141,600
1-Oct-2009 £3,000 £144,600 Extra allowance for over 50s
6-Apr-2010 £10,200 £154,800
6-Apr-2011 £10,680 £165,480
6-Apr-2012 £11,280 £176,760
6-Apr-2013 £11,520 £188,280
6-Apr-2014 £11,880 £200,160
1-Jul-2014 £3,120 £203,280 Allowance raised to £15,000 for the year
6-Apr-2015 £15,240 £218,520
6-Apr-2016 £15,240 £233,760
6-Apr-2017 £20,000 £253,760
6-Apr-2018 £20,000 £273,760
6-Apr-2019 £20,000 £293,760
6-Apr-2020 £20,000 £313,760
24-Feb-2021 -£1,000,000 For XIRR
Interesting table thanks. I don't have figures for the FTSE, but here is what the returns would have been had an MSCI World tracker fund been available, allowed and chosen as the investment vehicle (all divis reinvested):
Date Amount PV Runniing Total
01-Jan-87 £2,400 £41,721 £41,721
01-Jan-88 £3,000 £56,695 £98,416
06-Apr-89 £4,800 £64,517 £162,933
06-Apr-90 £6,000 £79,815 £242,748
06-Apr-91 £6,000 £79,548 £322,296
06-Apr-92 £6,000 £79,314 £401,610
06-Apr-93 £6,000 £60,996 £462,606
06-Apr-94 £6,000 £52,738 £515,344
06-Apr-95 £6,000 £52,669 £568,013
06-Apr-96 £6,000 £40,931 £608,944
06-Apr-97 £6,000 £40,082 £649,026
06-Apr-98 £6,000 £30,857 £679,883
06-Apr-99 £7,000 £30,699 £710,582
06-Apr-00 £7,000 £24,817 £735,399
06-Apr-01 £7,000 £29,435 £764,834
06-Apr-02 £7,000 £30,675 £795,509
06-Apr-03 £7,000 £44,711 £840,220
06-Apr-04 £7,000 £35,966 £876,186
06-Apr-05 £7,000 £33,295 £909,481
06-Apr-06 £7,000 £25,768 £935,249
06-Apr-07 £7,000 £25,118 £960,367
06-Apr-08 £7,200 £26,924 £987,291
06-Apr-09 £7,200 £33,589 £1,020,880
01-Oct-09 £3,000 £10,973 £1,031,853
06-Apr-10 £10,200 £32,865 £1,064,718
06-Apr-11 £10,680 £31,888 £1,096,606
06-Apr-12 £11,280 £33,192 £1,129,798
06-Apr-13 £11,520 £28,629 £1,158,427
06-Apr-14 £11,880 £27,076 £1,185,503
01-Jul-14 £3,120 £6,942 £1,192,445
06-Apr-15 £15,240 £29,012 £1,221,457
06-Apr-16 £15,240 £28,927 £1,250,384
06-Apr-17 £20,000 £28,611 £1,278,995
06-Apr-18 £20,000 £28,106 £1,307,101
06-Apr-19 £20,000 £24,957 £1,332,058
06-Apr-20 £20,000 £26,350 £1,358,408
These are figures up to the end of January 2021. All before charges of course and charges were much higher in the early days than they are now. Nonetheless I think it is interesting to see how important the early years were. In the first 10 years, the contribution was only £52,200 (17% of total), but the contribution to today's pot was £609k (45% of the total).
There are far more people around who could have and would have put the full amount into PEPs and ISAs than there are reported ISA millionaires, so what happened? As others have said, many will be missing simply because they hold ISAs across multiple brokers. One other thing that might have dragged total returns is some investors would have chosen to holding bonds and bond funds in ISAs. Interest income from bonds was taxed more heavily than dividend income, so it is reasonable to assume some of the wealthy stuffed their ISAs with bond funds for the higher income tax savings, but at the expense of long term total return within the ISA. I am sure another issue is that of inheritance tax for which £1m+ ISAs are sitting ducks. Some of the accumulated wealth will have been redirected down IHT mitigation routes.
ps, the £1,358,408 represents an internal rate of return (XIRR) of 9.0%. The CAGR of the index was only 8.76%, so the sequence of returns was actually quite favourable for ISA investors who maxed out at the earliest opportunity.