Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@.

    • 5 more years
    • By 5 more years 13th Apr 18, 12:54 AM
    • 1Posts
    • 0Thanks
    5 more years
    accuracy of online retirement calculators
    • #1
    • 13th Apr 18, 12:54 AM
    accuracy of online retirement calculators 13th Apr 18 at 12:54 AM
    This is my first post. I have had no luck to date so I thought I'd try an online forum to get people's thoughts. I'm only a few years from retirement and am always doing spreadsheets to work out how long my savings will last. The problem is that my spreadsheets differ from the online calculators. With this in mind, here is my question.

    Why do all the online financial calculators say that you require (as an example) more than $1million capital to fund say $100k per year (indexed) for 10 years? Surely if your investment return matches inflation, the initial capital sum should be adequate. A simple spreadsheet confirms this. What am I missing? Is it fees? I suspect that it is. Could someone please answer this for me as I have been racking my brain.
Page 1
    • MEM62
    • By MEM62 13th Apr 18, 10:29 AM
    • 2,025 Posts
    • 1,652 Thanks
    • #2
    • 13th Apr 18, 10:29 AM
    • #2
    • 13th Apr 18, 10:29 AM
    Without knowing the assumptions on which the forecast is made it cannot be fully understood.

    Just a few variations as examples;
    * Where is the capital invested? Is it assumed that investment return match inflation?
    * If invested to S&S, what tolerance is included for market fluctuations?
    * Is the sum in year 10 actually $100K or the equivalent of $100K when inflation is taken into account?

    In the UK a pension port of 1,000,000 would be expected to last around 12 years assuming 1) A drawdown rate of 10% (100K in year 1) 2) The capital invested in investments with a moderate risk profile, 3) No increases in income to account for inflation. As you may be in the US the profile is probably different.
    Last edited by MEM62; 13-04-2018 at 10:47 AM.
  • jamesd
    • #3
    • 13th Apr 18, 4:20 PM
    • #3
    • 13th Apr 18, 4:20 PM
    The variability off investment returns - sequence of return risk - is part of the problem. If you happen to have low returns at the start the plan can be devastated. Say a 40% or even 20% equity drop and still drawing 100k from reduced 600k or 800k pot.

    In the UK that same million Pounds could be expected to deliver an initial income of 5.8% minus one third of charges over a 40 year plan if the Guyton-Klinger rules are used with 90% success rate. So 53,000 a year to start.
Welcome to our new Forum!

Our aim is to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

4,096Posts Today

9,468Users online

Martin's Twitter
  • Right back to self imposed twitter exile until Thur - trying to be off work (not v successfully)

  • Too painful to talk about. That result really was offsensive. For rancid cheese & onion to beat powerful salt & v?

  • If you think this hypothetical's bad, here's some of my past polls - Which past PM would u resurrect to aid politi?

  • Follow Martin