We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 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!

How Much to Accumulate for Retirement? (Excel analysis)

24567

Comments

  • BritishInvestor
    BritishInvestor Posts: 955 Forumite
    Sixth Anniversary 500 Posts Combo Breaker Name Dropper
    edited 6 November 2021 at 8:57PM
    It seems most people take the swr as the way forward. My understanding of swr is that the pot will be preserved at the swr? Is that incorrect? 
    Yes, incorrect. SWR allows the pot to be drawn down if required (unless you have explicitly specified a legacy amount in your modelling). 
  • It seems most people take the swr as the way forward. My understanding of swr is that the pot will be preserved at the swr? Is that incorrect? 
    Yes, incorrect. SWR allows the pot to be drawn down if required (unless you have explicitly specified a legacy amount in your modelling). 
    While the UK SWR for a 30 year retirement period is around 3.0-3.5% depending on asset allocation (e.g. see paper by Estrada at https://blog.iese.edu/jestrada/files/2018/03/MaxWR.pdf), historically the final pot ranged from 0 to more than 6 times the original (in real-terms) again dependent on asset allocation. Historically, in order to leave a minimum of about half the original pot (in real terms), the withdrawal would have had to have been  1.7-2.2% although the largest pot would then have been about 10 times the initial value. The latter values are my own calculations using UK returns and inflation from https://www.macrohistory.net - this dataset gives slightly more pessimist outcomes than that mostly used in the literature, see https://www.london.edu/-/media/files/faculty and research/subject areas/global investments yearbook.pdf, but $6k per year is a bit much for my retirement budget!

  • It seems most people take the swr as the way forward. My understanding of swr is that the pot will be preserved at the swr? Is that incorrect? 
    Yes, incorrect. SWR allows the pot to be drawn down if required (unless you have explicitly specified a legacy amount in your modelling). 
    While the UK SWR for a 30 year retirement period is around 3.0-3.5% depending on asset allocation (e.g. see paper by Estrada at https://blog.iese.edu/jestrada/files/2018/03/MaxWR.pdf), historically the final pot ranged from 0 to more than 6 times the original (in real-terms) again dependent on asset allocation. Historically, in order to leave a minimum of about half the original pot (in real terms), the withdrawal would have had to have been  1.7-2.2% although the largest pot would then have been about 10 times the initial value. The latter values are my own calculations using UK returns and inflation from https://www.macrohistory.net - this dataset gives slightly more pessimist outcomes than that mostly used in the literature, see https://www.london.edu/-/media/files/faculty and research/subject areas/global investments yearbook.pdf, but $6k per year is a bit much for my retirement budget!


    "historically the final pot ranged from 0 to more than 6 times the original (in real-terms) again dependent on asset allocation"

    That's the key takeaway - the vast range of historical (and therefore future?) outcomes. We just don't know whether we are going to be the lucky 6x starting pot, or running out way before we wanted to.






    "but $6k per year is a bit much for my retirement budget!"

    I wonder if there's enough of a market for DIY investors to pay for a tool that contained this data....
  • Audaxer
    Audaxer Posts: 3,547 Forumite
    Eighth Anniversary 1,000 Posts Name Dropper
    It seems most people take the swr as the way forward. My understanding of swr is that the pot will be preserved at the swr? Is that incorrect? 
    Whether or not the pot will be preserved will depend on the Sequence of Returns. If for example you get a poor sequence of returns in the first decade of retirement, the pot might not last throughout retirement if you don't have a cash buffer to draw from in loss years.
  • Audaxer said:
    It seems most people take the swr as the way forward. My understanding of swr is that the pot will be preserved at the swr? Is that incorrect? 
    Whether or not the pot will be preserved will depend on the Sequence of Returns. If for example you get a poor sequence of returns in the first decade of retirement, the pot might not last throughout retirement if you don't have a cash buffer to draw from in loss years.

    Yes to SoR being important.
    Additionally, the ability to "rein in" outgoings during years of poor investment returns is also important.  Several of the SWR methodologies suggest changes if returns are other than expected.  SWR is a guide, not a mandate - in a 30 year retirement flexing income (up as well as down) should be expected.
  • Audaxer
    Audaxer Posts: 3,547 Forumite
    Eighth Anniversary 1,000 Posts Name Dropper
    Audaxer said:
    It seems most people take the swr as the way forward. My understanding of swr is that the pot will be preserved at the swr? Is that incorrect? 
    Whether or not the pot will be preserved will depend on the Sequence of Returns. If for example you get a poor sequence of returns in the first decade of retirement, the pot might not last throughout retirement if you don't have a cash buffer to draw from in loss years.

    Yes to SoR being important.
    Additionally, the ability to "rein in" outgoings during years of poor investment returns is also important.  Several of the SWR methodologies suggest changes if returns are other than expected.  SWR is a guide, not a mandate - in a 30 year retirement flexing income (up as well as down) should be expected.
    I agree, but if you keep a good cash buffer you may not have to reduce income in loss years. 
  • Audaxer said:
    It seems most people take the swr as the way forward. My understanding of swr is that the pot will be preserved at the swr? Is that incorrect? 
    Whether or not the pot will be preserved will depend on the Sequence of Returns. If for example you get a poor sequence of returns in the first decade of retirement, the pot might not last throughout retirement if you don't have a cash buffer to draw from in loss years.
    I'm not sure the cash buffer is going to be a massive help (certainly not if you take it from the equity allocation).

    https://finalytiq.co.uk/cash-reserve-buffers-withdrawal-rates-old-wives-fables-retirement-portfolio/
  • Audaxer
    Audaxer Posts: 3,547 Forumite
    Eighth Anniversary 1,000 Posts Name Dropper
    Audaxer said:
    It seems most people take the swr as the way forward. My understanding of swr is that the pot will be preserved at the swr? Is that incorrect? 
    Whether or not the pot will be preserved will depend on the Sequence of Returns. If for example you get a poor sequence of returns in the first decade of retirement, the pot might not last throughout retirement if you don't have a cash buffer to draw from in loss years.
    I'm not sure the cash buffer is going to be a massive help (certainly not if you take it from the equity allocation).

    https://finalytiq.co.uk/cash-reserve-buffers-withdrawal-rates-old-wives-fables-retirement-portfolio/
    If for example I needed £4,000 a year income from a pot of £120,000, I would prefer to have £100,000 invested and take a 4% withdrawal rate with a cash buffer of £20,000. With the whole £120,000 invested, the £4,000 income would mean a withdrawal rate of 3.33%. Some may prefer that option, but the buffer option would feel safer to me. 
  • Linton
    Linton Posts: 18,352 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Hung up my suit!
    Audaxer said:
    It seems most people take the swr as the way forward. My understanding of swr is that the pot will be preserved at the swr? Is that incorrect? 
    Whether or not the pot will be preserved will depend on the Sequence of Returns. If for example you get a poor sequence of returns in the first decade of retirement, the pot might not last throughout retirement if you don't have a cash buffer to draw from in loss years.
    I'm not sure the cash buffer is going to be a massive help (certainly not if you take it from the equity allocation).

    https://finalytiq.co.uk/cash-reserve-buffers-withdrawal-rates-old-wives-fables-retirement-portfolio/

     - None of the strategies tested matched what it is proposed here that one does with a buffer. ie use it for covering crashes
     - The strategies were mostly tested when bond returns were of some significance - one of the major reasons for choosing a cash buffer is that safe bonds now seem to be sub-optimal.  If bond were returning say 5% the need for cash would be significantly reduced.
     - In retirement I would think most people are prepared to sacrifice returns if necessary to reduce risk

    If having a large cash buffer enables you to sail through a crash worry-free when you would otherwise lie awake at night then a cash buffer is a massive help.
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
  • 352.2K Banking & Borrowing
  • 253.6K Reduce Debt & Boost Income
  • 454.3K Spending & Discounts
  • 245.2K Work, Benefits & Business
  • 600.9K Mortgages, Homes & Bills
  • 177.5K Life & Family
  • 259K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only 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.