Author Topic: Requesting Feedback on Simple Retirement Planning Spreadsheet  (Read 1141 times)

benSquared

  • 5 O'Clock Shadow
  • *
  • Posts: 3
  • Age: 42
  • Location: Austin
  • Replacing spending with living
    • Ben Benson
I've assembled a simple spreadsheet to help me with retirement planning.  I'd really appreciate help in catching any fatal flaws in the calculations or approach as I do intend to make some fairly serious decisions based on its high level projections. 

I know there are many complex tools out there but it seems to me that this spreadsheet distills things down in a reasonable manner and makes it easy to tweak things and see the impact.  I've considered the option of using a professional financial planner but I'm not convinced it is necessary (nor do I have any great personal recommendations for one that I could trust).

Here's how the spreadsheet is structured (I've attached the actual spreadsheet to this post):


  • Year  -- based on start of school year
  • In China --  either "Y" or "N" as input because I plan to be an expat living in China but am planning when and how long will result in what kind of impact
  • Percent Spending -- Less or more than base expenses column (for US or China)
  • Annual Savings/Withdrawal -- Resulting contribution to savings or withdrawal from savings
  • Net Worth -- Total net worth (I do not have property or other assets, only IRA and ETFs
  • Monthly 4% -- Just for reference
  • Monthly SS Income -- starting withdrawal at age 62 using estimate calculated by ssa.gov
  • Monthly Spending -- Resulting monthly spending required based on us/china budget and percent spending adjustment
  • US/China Expenses -- budget calculated for inflation in us/china respectively

I have included adjustment for investment return rate, inflation, income tax, IRA withdrawal tax, social security and income tax. 

In conclusion, I realize some of these formulas are crude but I'm still thinking they are close enough to actuals that they serve the purpose of helping me determine things like what happens in the long run if I become an expat sooner, or for longer periods before returning to US. 

Much appreciate everyone's feedback!  Brutal honesty is welcome.  :-)

benSquared

  • 5 O'Clock Shadow
  • *
  • Posts: 3
  • Age: 42
  • Location: Austin
  • Replacing spending with living
    • Ben Benson
Re: Requesting Feedback on Simple Retirement Planning Spreadsheet
« Reply #1 on: July 06, 2017, 05:32:38 PM »
Guess I'm asking for too much work on the reader!  :)

Any opinions on whether it is worth it (necessary) to hire a financial planner to review and give me some confidence that these numbers aren't all too far off the mark?

deborah

  • Walrus Stache
  • *******
  • Posts: 8673
  • Location: Australia or another awesome area
Re: Requesting Feedback on Simple Retirement Planning Spreadsheet
« Reply #2 on: July 07, 2017, 03:08:37 AM »
You may want to plug your numbers into https://forum.mrmoneymustache.com/share-your-badassity/one-sheet-to-rule-them-all/ and see if they come up similar.

Linea_Norway

  • Walrus Stache
  • *******
  • Posts: 5453
  • Location: Norway
Re: Requesting Feedback on Simple Retirement Planning Spreadsheet
« Reply #3 on: July 07, 2017, 03:55:25 AM »
I have made a spreadsheet for myself, starting from having enough net worth and then calculating when FIRE can start.
I put in options for both me and DH to work part time after FIRE and included the whole Norwegian calculation of income taxes, as we have different percentages, depending on your income, quite complicated. I also added wealth tax over my stash and over my house, you also need to consider property taxes. I also calculated tax to be paid out on my 4% withdrawal, as I need to pay taxes over stock profits.
Further, in my spreadsheet I just let the stash not grow. I hope it will grow with at least inflation correction and later also with the 4% withdrawal -> 6,5% in total.
I didn't count in that fact that if we have enough income that we don't need to take out the 4% or eat up the stash, that the stash can grow. I like my spreadsheet to be very conservative/bare bone scenario. Everything more is a bonus.