Welcome, Guest. Please login or register.

Author Topic: Personal Retirement Fund Calculator  (Read 2692 times)

0 Members and 1 Guest are viewing this topic.

Online R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6008
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #45 on: March 12, 2018, 02:46:35 PM »
...now that I am seeing Mom's expenses for long term care, that has taught me a lot about quality of life and how "spending for the now" would have left her in dire straights.

That has me more scared than anything.  Without kids, Sheri and I won't have anyone to help so we'll be highly reliant on eldercare.  Which, as you have seen, isn't cheep.   :o
Only motorcycle riders know why a dog sticks its head out of a car window.

Online Black Hills

  • Member
  • Location: Rapid CIty, SD
  • Posts: 2853
  • Motorcycles: KTM 1190 Adventure R, KTM300xcw
Re: Personal Retirement Fund Calculator
« Reply #46 on: March 12, 2018, 02:52:48 PM »
...now that I am seeing Mom's expenses for long term care, that has taught me a lot about quality of life and how "spending for the now" would have left her in dire straights.

That has me more scared than anything.  Without kids, Sheri and I won't have anyone to help so we'll be highly reliant on eldercare.  Which, as you have seen, isn't cheep.   :o

that's when all those years of paying taxes finally gets you something. when your money is gone the state pays for it ;)

Online bungie4

  • Member
  • Location: Sudbury, Ontario
  • Posts: 645
    • Assistance List
  • Motorcycles: 2013 FJR
Re: Personal Retirement Fund Calculator
« Reply #47 on: March 12, 2018, 03:09:45 PM »
I've been using the calculators found at:

http://moneychimp.com/calculator/retirement_calculator.htm

Are they accurate, I dunno, but I do know that they lie to me in a way that makes my future not seem as bad as I thought.

Come and join me by MY VAN, DOWN BY THE RIVER.
-Steve
SnowMexican
WWPD
choo choo mf'r.

Offline kneescrubber

  • Contributor
  • Member
  • Location: Neither here nor there
  • Posts: 10210
  • Nothing beats good line of sight
  • Motorcycles: 1999 VFR
Re: Personal Retirement Fund Calculator
« Reply #48 on: March 12, 2018, 09:05:45 PM »
better to burn out than to fade away then??

I'll let you know how it goes. Pretty bull headed though. If I'm still alive in 20 years I'll be the Walmart greeter that shakes your hand, says "fuck Walmart" and "did you notice my motorcycle outside the door?" 40 year old chicks will dig it!
Do not go where the path may lead, go instead where there is no path and leave a trail.

Ralph Waldo Emerson

Online Skee

  • Contributor
  • Member
  • Location: SE PA
  • Posts: 1581
  • Motorcycles: '08 Wee & an overweight Connie
Re: Personal Retirement Fund Calculator
« Reply #49 on: March 12, 2018, 09:33:30 PM »
Finally had the time to check out the calculations in your spreadsheet.  I wasn’t concerned about downloading a virus.  I am concerned a monster northeaster will come up the coast after I opened your spreadsheet; and I believe that is a realistic fear.

I admire your willingness to share this with the group.  I usually build my spreadsheets to suit my personal circumstances.  I like to make my own spreadsheets so I can see where the numbers come from.

What I do different from you is build a flat file where each row represents a successive year and all the calculations are annualized.   I would use one column for current balance, one column for contributions, one column for employer contributions, one column for interest earned.   You copy a formula down in each column using standard assumptions, like a 6.5% average growth rate or a 15% contribution rate.  BUT you can go to any row and enter a different value.  That allows you to start (or stop) catch up contributions at some point in time, or change the amount of employer match.

Keep in mind that qualified savings are taxed as ordinary income and adjust your allocation strategy accordingly.
The fishermen know that the sea is dangerous and the storm terrible,
but they have never found these dangers sufficient reason for remaining ashore.   Vincent van Gogh

Online TwistedT

  • Contributor
  • Member
  • Location: North Jersey
  • Posts: 668
  • Now with contribution!
  • Motorcycles: Yes, please.
Re: Personal Retirement Fund Calculator
« Reply #50 on: March 13, 2018, 05:44:53 AM »
Nice try, do you get a cut of whatever Doug manages to siphon out of my accounts with his malware?!?!


Why would I wait till I die to come alive?
I'm ready now
I'm not waiting for the afterlife

Online R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6008
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #51 on: March 13, 2018, 07:11:19 AM »


I admire your willingness to share this with the group. 


Thanks for the feedback.  The willingness to share is 100% selfish as I believe there are other XL nerds out there like me that would and could review this for accuracy.  After all, I'm basing major decisions from the outcome of this sheet.  It has to  be correct.

Also, just to make sure everyone is crystal clear, other than my age and the % contribution factor from my employer, all of the other numbers are 100% made up and do not reflect my actual condition.  I'm not that willing.  :)

Nice try, do you get a cut of whatever Doug manages to siphon out of my accounts with his malware?!?!

That comes later from the blackmail of loading cockroach porn on the PCs I gain access and charge a fee to remove it before I report them.
Only motorcycle riders know why a dog sticks its head out of a car window.

Online TwistedT

  • Contributor
  • Member
  • Location: North Jersey
  • Posts: 668
  • Now with contribution!
  • Motorcycles: Yes, please.
Re: Personal Retirement Fund Calculator
« Reply #52 on: March 13, 2018, 03:13:11 PM »


Nice try, do you get a cut of whatever Doug manages to siphon out of my accounts with his malware?!?!

That comes later from the blackmail of loading cockroach porn on the PCs I gain access and charge a fee to remove it before I report them.

Ooh, I forgot about that.  :leghump:
Why would I wait till I die to come alive?
I'm ready now
I'm not waiting for the afterlife

Online Black Hills

  • Member
  • Location: Rapid CIty, SD
  • Posts: 2853
  • Motorcycles: KTM 1190 Adventure R, KTM300xcw
Re: Personal Retirement Fund Calculator
« Reply #53 on: March 13, 2018, 03:59:56 PM »
better to burn out than to fade away then??

I'll let you know how it goes. Pretty bull headed though. If I'm still alive in 20 years I'll be the Walmart greeter that shakes your hand, says "fuck Walmart" and "did you notice my motorcycle outside the door?" 40 year old chicks will dig it!

I think we have similar plans.  ;D

Online bungie4

  • Member
  • Location: Sudbury, Ontario
  • Posts: 645
    • Assistance List
  • Motorcycles: 2013 FJR
Re: Personal Retirement Fund Calculator
« Reply #54 on: March 14, 2018, 07:04:12 AM »
It's a toss up.

My first choice is to have income from an ice cream cart on the beach. This will likely turn into a situation where it isn't as desirable in the real world as my imagination.

The second choice is I'll sell bundles of naturally sourced kindling by the highway. Bundled artisianally!

Anyway it plays out, I'll need to supplement my income and fuck if I'm gonna keep slinging code.

I offered my 15 year old free room and board well into adult hood on one condition,  she works and saves 70% of her income. I showed her how in about 15 years, she could be very close to a millionaire and be retired and travel the world.  Her answer?

Nothing, she was to busy snapGramming with her friends.
-Steve
SnowMexican
WWPD
choo choo mf'r.

Offline sodapop6620

  • Member
  • Location: SEPA
  • Posts: 1192
  • Motorcycles: 4
Re: Personal Retirement Fund Calculator
« Reply #55 on: March 14, 2018, 07:07:36 AM »
^^^^^^ It will be fat sweaty kids and not superhot bikini models visiting the ice cream cart.

Offline minimac

  • Member
  • Location: C.N.Y.
  • Posts: 85
  • Motorcycles: GL1500A,Burgman Executive, Majesty, Morphous
Re: Personal Retirement Fund Calculator
« Reply #56 on: March 14, 2018, 10:59:50 AM »
 Your numbers may be made up or not, but the one thing you can count on is that you can't count on anything. While a 7% return may be historical, it may mean nothing going forward. You could get whacked crossing the road tomorrow and end up a veggie.  No one plans on things like that, but it happens. And not necessarily to 'someone else'. It's good to have a plan, but don't do it at the expense of enjoyment today. You very well may not have a tomorrow. Being an old, retired guy, the best advice is to live within your means. The corporate world today is much different than it was even ten years ago. People don't get "forever jobs", so how sure are you of guaranteed income? The marketplace is constantly changing, so even you you're self employed, you can't count on anything.
 I was very lucky. I have a decent pension, I'm comfortable with my meager investments and savings, and that's supplemented with my S.S. retirement. I'm still in good health, and so is my wife. I was able to retire  years before being eligible for S.S. and maintain my lifestyle. I could have continued to work, and wait, but  we decided to go as early as I could while we could both enjoy it, because a long healthy life is not a promise to anyone.

Offline kneescrubber

  • Contributor
  • Member
  • Location: Neither here nor there
  • Posts: 10210
  • Nothing beats good line of sight
  • Motorcycles: 1999 VFR
Re: Personal Retirement Fund Calculator
« Reply #57 on: March 14, 2018, 11:43:16 AM »
better to burn out than to fade away then??

I'll let you know how it goes. Pretty bull headed though. If I'm still alive in 20 years I'll be the Walmart greeter that shakes your hand, says "fuck Walmart" and "did you notice my motorcycle outside the door?" 40 year old chicks will dig it!

I think we have similar plans.  ;D

 :beerchug:
Do not go where the path may lead, go instead where there is no path and leave a trail.

Ralph Waldo Emerson

Online Black Hills

  • Member
  • Location: Rapid CIty, SD
  • Posts: 2853
  • Motorcycles: KTM 1190 Adventure R, KTM300xcw
Re: Personal Retirement Fund Calculator
« Reply #58 on: March 14, 2018, 12:45:37 PM »
another thing to consider: when your finally end up in a nursing home who are the nurses going to want to talk to more, the guy with a million cool stories or the guy that has a big bank book and nothing more ;)

Online radon222

  • Contributor
  • Member
  • Location: VA Beach
  • Posts: 1441
  • It's all Scratch's fault
  • Motorcycles: R1200GSAW, R1200RT
Re: Personal Retirement Fund Calculator
« Reply #59 on: March 14, 2018, 01:04:03 PM »
another thing to consider: when your finally end up in a nursing home who are the nurses going to want to talk to more, the guy with a million cool stories or the guy that has a big bank book and nothing more ;)

Well I guess that all depends.....

visitors can't see pics , please register or login