We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
How much pension will you get? Build your own dashboard to keep track of your progress

MSE_Chris_D
Posts: 31 MSE Staff
What's the best way to work out if you'll have enough pension when you retire? Start by finding out what your retirement nest eggs are currently worth. It can be a challenge keeping track of the different pots of pension cash you accumulate over your working life. Here's how to use a simple spreadsheet to see at a glance how much pension you've built up so far.
Read the full blog: How much pension will you get? Build your own dashboard to keep track of your progress
Read the full blog: How much pension will you get? Build your own dashboard to keep track of your progress
0
Comments
-
Care to substantiate this ?This calculation is based on the "safe withdrawal rate" – one where you shouldn't run out of money before you die. The rule of thumb has been that this is 4% a year, hence the divide-the-total-by-25 calculation,0
-
The sooner we talk of the Suggested Withdrawal Rate, the better.0
-
Since when was a rule of thumb a guarantee?0
-
I suspect most of the regulars here will have rather more detailed spreadsheets / "dashboards" than suggested. Those that don't visit won't find the suggestions.0
-
This calculation is based on the "safe withdrawal rate" – one where you shouldn't run out of money before you die. The rule of thumb has been that this is 4% a year, hence the divide-the-total-by-25 calculation, though some experts think 3.5% or less is safer. In that case, you would divide the total by, say, 30.
That is very bold of MSE. Regulated advisers wouldn't dare refer to it as a safe withdrawal rate. The FCA would have a field day. Pretty much auto-upheld complaints if that was used. However, if MSE is prepared to face the flack when it goes wrong then I guess that is fair enough.
Seeing as MSE is playing to mainly DIY investors and not advised and when you consider the recent FCA thematic review which had a number of significant concerns about DIY investing, there are plenty that could find the 4% rate is not "safe".
Maybe MSE should adjust the wording to make it a bit more sensible.6. How much pension could my fund buy? Forecasting the future pension your DC funds might produce when you retire is like gazing into a crystal ball. While annual statements will include projections of your retirement income, these are often based on complex assumptions that may not prove realistic.
That is fair enough. However, they tend to understate the likely income (often significantly). Although the use of the word "realistic" perhaps makes it sound like they are overstating when its the opposite.I am an Independent Financial Adviser (IFA). The comments I make are just my opinion and are for discussion purposes only. They are not financial advice and you should not treat them as such. If you feel an area discussed may be relevant to you, then please seek advice from an Independent Financial Adviser local to you.0 -
I really like this guy’s “cushioned withdrawals strategy”, which is a variation on variable withdrawal.
https://www.michaeljamesonmoney.com/2014/02/cushioned-retirement-investing.html
https://www.michaeljamesonmoney.com/2014/02/working-out-your-retirement-magic-number.html0 -
Deleted_User wrote: »I really like this guy’s “cushioned withdrawals strategy”, which is a variation on variable withdrawal.
https://www.michaeljamesonmoney.com/2014/02/cushioned-retirement-investing.html
https://www.michaeljamesonmoney.com/2014/02/working-out-your-retirement-magic-number.html
The guy assumes 0.12% fees in his spreadsheets.......so anyone in the UK paying more than that would need to take that into account. People throwing around 4% or 3.5% initial drawdown rates need to know that those don't include fees.....this have to be paid out of that withdrawal. So 2% fees would be half of your annual income at the start of retirement. As your withdrawals get larger to keep up with inflation you'd hope that the proportion going to fees would go down.“So we beat on, boats against the current, borne back ceaselessly into the past.”0 -
We discussed this before... I think 4% wild guesstimate is just fine as long as you are prepared to reduce your expenditure if the market were to tumble just after you retire. Because 4% is so uncertain, other variables like MER don’t need to be accurate either.
Safe constant withdrawal rate does not exist because the future is uncertain. And if you are 55 and really want high confidence of being able to withdraw a constant inflation corrected amount till death then I’d go with something way more conservative like 2% - assuming a balanced portfolio.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 349.5K Banking & Borrowing
- 252.5K Reduce Debt & Boost Income
- 452.9K Spending & Discounts
- 242.5K Work, Benefits & Business
- 619.2K Mortgages, Homes & Bills
- 176.3K Life & Family
- 255.4K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 15.1K Coronavirus Support Boards