How much pension will you get? Build your own dashboard to keep track of your progress

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
«13456

Comments

  • Thrugelmir
    Thrugelmir Posts: 89,546 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    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,
  • westv
    westv Posts: 6,401 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    The sooner we talk of the Suggested Withdrawal Rate, the better.
  • Alexland
    Alexland Posts: 10,183 Forumite
    10,000 Posts Seventh Anniversary Photogenic Name Dropper
    westv wrote: »
    The sooner we talk of the Suggested Withdrawal Rate, the better.

    Suggested for whose circumstances and asset allocation? There are lots of different situations.
  • Brynsam
    Brynsam Posts: 3,643 Forumite
    Fifth Anniversary 1,000 Posts Name Dropper Combo Breaker
    Since when was a rule of thumb a guarantee?
  • westv
    westv Posts: 6,401 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    Alexland wrote: »
    Suggested for whose circumstances and asset allocation? There are lots of different situations.
    Obviously suggested for the same people who are suggested the "safe" rate.
  • LHW99
    LHW99 Posts: 5,089 Forumite
    Part of the Furniture 1,000 Posts Photogenic Name Dropper
    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.
  • dunstonh
    dunstonh Posts: 119,058 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Combo Breaker
    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.
  • bostonerimus
    bostonerimus Posts: 5,617 Forumite
    Sixth Anniversary 1,000 Posts Name Dropper

    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.”
  • 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.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

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

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.