We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Growth assumptions in your models/spreadsheets
Options
Comments
-
Hoenir said:NoMore said:Hoenir said:westv said:Hoenir said:QrizB said:michaels said:2) I certainly think there is room for an annuity when rates exceed historic SWR (or whatever other 'worst case return scenario you use in your modelling)...The UK SWR is something like 3.5% but a single-life RPI annuity is yielding something like 4.8% for a 65-year-old retiree.
1 -
NoMore said:Hoenir said:NoMore said:Hoenir said:westv said:Hoenir said:QrizB said:michaels said:2) I certainly think there is room for an annuity when rates exceed historic SWR (or whatever other 'worst case return scenario you use in your modelling)...The UK SWR is something like 3.5% but a single-life RPI annuity is yielding something like 4.8% for a 65-year-old retiree.1
-
MK62 said:OldScientist said:michaels said:SimonSeys said:NoMore said:Hoenir said:westv said:Hoenir said:QrizB said:michaels said:2) I certainly think there is room for an annuity when rates exceed historic SWR (or whatever other 'worst case return scenario you use in your modelling)...The UK SWR is something like 3.5% but a single-life RPI annuity is yielding something like 4.8% for a 65-year-old retiree.
The reason people don't tend to follow it religiously, is it could take a lot of nerve to continue to take what could be a large percentage of your pot when the investment is not performing.
I'm not advocating it as a strategy, just explaining how it actually works.
Using the calculator at https://www.2020financial.co.uk/pension-drawdown-calculator/ with a 60/20/20 (Uk equities/long bonds/cash) portfolio the safemax (i.e., the SWR where no failures occurred) wasExpected length of retirement at retirement50 40 30 202.6 2.8 3.3 4.1
Assuming a longevity to 100yo (for a couple there is about a 10% chance of one or other or both living that long) then these would be for a retirement at ages 50, 60, 70, or 80.Retirement length
50 40 30 202.56 3.11 3.66 4.51
For comparison, 100% cash shows a 30y safemax of 2.82%, and 100% equities, 3.43% and 100% bonds, 1.49%
Bond returns are from Barclays equity gilt study where despite what the calculator says, before about 1962 they were returns on consols, from 1962 to 1980 or so, returns on 20 year gilts, and after 1980 15 year gilts. In other words, very long duration even compared to the 'all stocks' fund. Intermediate duration funds would have done better.
I think their model will underestimate the returns on cash when rates rise and overestimate it when rates fall. Certainly using the returns at macrohistory.net (which uses the same source for bond returns) gets a safemax of 1.5% for all bonds, 1.9% for all cash (actually 3-month bills) and 3.3% for all equities - i.e., close enough except for cash.
1 -
Thanks OldScientist. Am I correct in understanding from those safemax rates that cash has provided a better average return than bonds?0
-
Peterrr said:Thanks OldScientist. Am I correct in understanding from those safemax rates that cash has provided a better average return than bonds?2
-
MK62 said:Peterrr said:Thanks OldScientist. Am I correct in understanding from those safemax rates that cash has provided a better average return than bonds?
On a quick look, I've found that the difference in performance for 'cash' in the calculator I linked to and 'cash' in the calculator I've developed using the macrohistory.net data is the instruments used to represent cash (and the inflation model). The online calculator uses the bank rate (what used to be called the minimum lending rate in the 70s and dealing rate in the 80s and 90s), while macrohistory.net uses the returns from 3-month treasury bills. In one of the worst cases (a retirement starting in 1935) the bank rate was 2% until 1951 while the bill rate lay between 0.5 and 1%, and this makes a significant difference to the outcome (as does the inflation model).
0 -
Also, the calculator uses UK gilts for the "bonds" no corporate, no overseas, no high yield etc..........and uses UK equities for the "stocks".......but I suspect few these days invest their entire equity holding in just UK equities (though they might have years ago).0
-
MK62 said:Also, the calculator uses UK gilts for the "bonds" no corporate, no overseas, no high yield etc..........and uses UK equities for the "stocks".......but I suspect few these days invest their entire equity holding in just UK equities (though they might have years ago).0
-
Hoenir said:MK62 said:Also, the calculator uses UK gilts for the "bonds" no corporate, no overseas, no high yield etc..........and uses UK equities for the "stocks".......but I suspect few these days invest their entire equity holding in just UK equities (though they might have years ago).
0 -
Hoenir said:MK62 said:Also, the calculator uses UK gilts for the "bonds" no corporate, no overseas, no high yield etc..........and uses UK equities for the "stocks".......but I suspect few these days invest their entire equity holding in just UK equities (though they might have years ago).
I think the point is that future growth is unknown, future SWR is unknown, and (for adaptive withdrawal strategies) future income is unknown and that uncertainty needs to be incorporated into planning - my own preference has been to establish a floor of guaranteed income (not without its own risks, but that is a different conversation) that covers core expenditure and much of our discretionary needs and therefore we don't much care about variations in portfolio withdrawals. Such an approach will not suit everyone.
1
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 351.1K Banking & Borrowing
- 253.2K Reduce Debt & Boost Income
- 453.6K Spending & Discounts
- 244.1K Work, Benefits & Business
- 599.1K Mortgages, Homes & Bills
- 177K Life & Family
- 257.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards