Welcome, Guest. Please login or register.

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

0 Members and 1 Guest are viewing this topic.

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Personal Retirement Fund Calculator
« on: March 10, 2018, 10:30:36 AM »
Download the attached XL file and shoot holes in my calculations.  The sheet is designed to take your current retirement fund balances along with your monthly contributions to retirement to calculate a future value at retirement.   The sheet allows you to play with the age you wish to retire (be sure to plug in your birthdate so it knows your current age).

On the second tab, it allows you to see how much annual income you could get if you invested all funds and lived off your own personal annuity (if you will).  At the bottom of the second page, it allows you calculate the net effect of annual income after taking inflation into account (that's depressing). 

The biggest assumptions in this sheet is assuming an average 7% return on investments while saving for retirement, assumes you can invest all funds safely and earn 3.5% as you're living off the funds at retirement, and it assumes a 3% average rate of inflation.  Of course, you can adjust any of these factors to change the outcome.

The amounts used are made up (except my date of birth and current employer 401 match / pay).  So, don't assume I actually look that good or bad.  :)

I look forward to your review.



« Last Edit: March 12, 2018, 09:44:20 AM by R Doug »
Only motorcycle riders know why a dog sticks its head out of a car window.

Offline Bounce

  • Contributor
  • Member
  • Location: USA
  • Posts: 3098
    • FJR-Tips
  • Motorcycles: Yes
Re: Personal Retirement Fund Calculator
« Reply #1 on: March 10, 2018, 11:53:47 AM »
Download a M$ document that I've not solicited, from a source I don't know, stored on an public forum?

Ooooookay.

Question, does it take into account a 10% - 50% "adjustment" (read decrease in value) every 10 years?

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #2 on: March 10, 2018, 01:08:06 PM »
Download a M$ document that I've not solicited, from a source I don't know, stored on an public forum?

Ooooookay.

Question, does it take into account a 10% - 50% "adjustment" (read decrease in value) every 10 years?

Well, the source is from me.  So, i suppose it's down to whether or not you trust me.

As for the "adjustment," the an average 7% return per year is a market historical average.  Some years are higher and some years are lower. 

Only motorcycle riders know why a dog sticks its head out of a car window.

Online HipGnosis

  • Member
  • Location: Between home and the horizon
  • Posts: 1535
  • It's Hip, ya know
  • Motorcycles: F800ST(low), VStar 950, Ninja 650
Re: Personal Retirement Fund Calculator
« Reply #3 on: March 10, 2018, 01:23:20 PM »
Download a M$ document that I've not solicited, from a source I don't know, stored on an public forum?

Ooooookay.

Question, does it take into account a 10% - 50% "adjustment" (read decrease in value) every 10 years?

There's a plethora of retirement calculators on line, many from established & trustworthy sources;
http://lmgtfy.com/?q=retirement+calculator
Life is made up of moments, small pieces of glittering mica in a long stretch of gray cement. We have to teach ourselves how to make room for them, to love them, and to live, really live. - Anna Quindlen

Offline Mrs. DantesDame

  • Moderator
  • Member
  • Location: Basel, Switzerland
  • Posts: 1479
  • Getting too old for this crap
    • DantesDame's Adventures
  • Motorcycles: -14 BMW F800 GSA
Re: Personal Retirement Fund Calculator
« Reply #4 on: March 10, 2018, 01:23:46 PM »
Well, the source is from me.  So, i suppose it's down to whether or not you trust me.

visitors can't see pics , please register or login
www.Dantesdame.com <-- Rides! Rides! Rides!

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #5 on: March 10, 2018, 01:40:16 PM »
Wow, you folks have some real trust issues.    :lol:
Only motorcycle riders know why a dog sticks its head out of a car window.

Online squeezer

  • Contributor
  • Member
  • Location: OC, CA
  • Posts: 2208
  • squirrelly geezer
  • Motorcycles: 16 Tiger Xr(x)
Re: Personal Retirement Fund Calculator
« Reply #6 on: March 10, 2018, 01:59:31 PM »
Hmm...  I downloaded and now my computer is speaking Russian.

Actually, I will play with this at some point. This weekend's financial thinking is going to taxes. Ugh.
A man with no sig

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #7 on: March 10, 2018, 02:46:41 PM »
I wanted to create a quick sheet which I could save periodically to check perforce and see if I'm on track.  Every quarter, I do a "save-as" and update the numbers.  That way, I can see how different funds are doing and see if I'm relatively on track. 

I'd like some folks to try it out and test it.  Doubt the calculations and formulas and let me know if you find any errors. 

I'm not even sure what an M$ document is.  This is my file and I uploaded it directly to ST.O.  Perhaps I'm naive to think it can't be contaminated somehow.  But, I know a lot of folks on this message board know me personally and had no idea anyone would be suspect to download it. 

For those of you "brave" enough to try it out :lol: , please let me know if you find any errors.

Thanks.
« Last Edit: March 10, 2018, 07:24:37 PM by R Doug »
Only motorcycle riders know why a dog sticks its head out of a car window.

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #8 on: March 10, 2018, 02:50:17 PM »

There's a plethora of retirement calculators on line, many from established & trustworthy sources;
http://lmgtfy.com/?q=retirement+calculator




With respect, if you think every link that will take you is established and trustworthy, you're about as naive as I was about how some would reply to this thread.     :rolleyes:
« Last Edit: March 10, 2018, 07:20:28 PM by R Doug »
Only motorcycle riders know why a dog sticks its head out of a car window.

Online Black Hills

  • Member
  • Location: Rapid CIty, SD
  • Posts: 2956
  • Motorcycles: KTM 1190 Adventure R, KTM300xcw
Re: Personal Retirement Fund Calculator
« Reply #9 on: March 10, 2018, 02:58:56 PM »
Who wouldn’t trust Doug? I mean seriously people, you sound like the IT people at work

Online Virginian

  • Contributor
  • Member
  • Location: Spotsylvania, VA
  • Posts: 2576
  • Motorcycles: '19 Husqvarna Svartpilen 401, '14 Vespa 946 Bellissma, '14 HD Wide Glide
Re: Personal Retirement Fund Calculator
« Reply #10 on: March 10, 2018, 04:29:16 PM »
Don't download it, he's voodoo hexed it and every ride you will be rained upon for the next year. Don't do it!  :lamer:
Show up on time, do your best and don't grumble about the outcome.

Online Papa Lazarou

  • Contributor
  • Member
  • Location: Lloegr
  • Posts: 6701
  • Freezing worms makes them easier to sharpen
  • Motorcycles: Moto Guzzi Griso 1200SE Diablo Rosso
Re: Personal Retirement Fund Calculator
« Reply #11 on: March 10, 2018, 05:21:39 PM »
Who is Nieve, when she's at home?
Putting the laughter back into manslaughter

Online Skee

  • Contributor
  • Member
  • Location: SE PA
  • Posts: 1658
  • Motorcycles: '08 Wee & an overweight Connie
Re: Personal Retirement Fund Calculator
« Reply #12 on: March 10, 2018, 06:36:08 PM »
Don't download it, he's voodoo hexed it and every ride you will be rained upon for the next year. Don't do it!  :lamer:

On the other hand, you could end up driving a Porsche if his calculations work out.   
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

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #13 on: March 10, 2018, 07:23:11 PM »
Who is Nieve, when she's at home?


I clearly need to rethink bifocals.  I cannot see the screen on this this.   naive 



visitors can't see pics , please register or login




I've had to have fat-fingered it and, for some reason, autocorrect put in the wrong word.


visitors can't see pics , please register or login
« Last Edit: March 10, 2018, 07:48:18 PM by R Doug »
Only motorcycle riders know why a dog sticks its head out of a car window.

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #14 on: March 10, 2018, 07:31:25 PM »
Don't download it, he's voodoo hexed it and every ride you will be rained upon for the next year. Don't do it!  :lamer:

On the other hand, you could end up driving a Porsche if his calculations work out.

Just to clarify, all of the numbers are made up, they do not reflect my actual numbers. 



The amounts used are made up (except my date of birth and current employer 401 match / pay).  So, don't assume I actually look that good or bad.  :)


The "match / pay" means match per pay not match and pay.  I made the pay a simple round number.
« Last Edit: March 10, 2018, 07:45:04 PM by R Doug »
Only motorcycle riders know why a dog sticks its head out of a car window.

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #15 on: March 10, 2018, 07:57:25 PM »
Here's a critique of the sheet.  I just noticed it will allow more than $18,000 / year to be contributed to a 401K.  The current annual limit in the US is $18,500 / year.  The sheet should include a calculation which caps the amount allowed to contribute. 
Only motorcycle riders know why a dog sticks its head out of a car window.

Offline CLAY

  • Moderator
  • Member
  • Location: Grand Rapids, MI
  • Posts: 6450
  • How did I become a moderator?
  • Motorcycles: '03 Bandit 1200S, '97 XR650L, '79 XS650 Tracker, '75 XS650 Standard
Re: Personal Retirement Fund Calculator
« Reply #16 on: March 10, 2018, 08:40:00 PM »
I downloaded it and now my computer plays gay cockroach porn constantly.  And don't even ask me how long I had to watch to figure out it was gay cockroach porn...   :crazy:









Seriously- thanks Doug!  A handy tool!
"Most accidents happen when the meek meet the douchebags."  -Viffergyrl
"The wider the road, the worse the food." -Coho

Online kneescrubber

  • Contributor
  • Member
  • Location: Neither here nor there
  • Posts: 10423
  • Nothing beats good line of sight
  • Motorcycles: 1999 VFR
Re: Personal Retirement Fund Calculator
« Reply #17 on: March 10, 2018, 09:05:57 PM »
I just got my computer back after 3 weeks of anxiety. Ain't no fucking way I'm downloading that file.

Plus, I gross less than 27K annually. Retirement is a dream I'll never see.
Do not go where the path may lead, go instead where there is no path and leave a trail.

Ralph Waldo Emerson

Offline Andrew

  • Contributor
  • Member
  • Location: on the left side, 5 blocks from salt water
  • Posts: 1925
  • Motorcycles: Got a Few
Re: Personal Retirement Fund Calculator
« Reply #18 on: March 10, 2018, 11:56:01 PM »
@ Clay, gay cockroach porn?  Well if your having fun and no one is hurt   :augie:

P.S. looks like the normal bondage S&M stuff when downloaded on my apple, I just can't remember the safe word,  Bannanas?? or was it "Ouch that hurts"
Freedom without regulations that protect the general good is nothing less than anarchy by the rich.

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #19 on: March 11, 2018, 04:37:56 AM »
I just tried it again and I'm missing the gay cockroach porn.  Could you send me a link?    :o 8)



As for this file being infected, can someone elaborate on why one may believe my personally created XL file contains a virus? 

And, I have another question for you.  Do you open images others attach to STO?  If so, are you wearing your tin foil hats then?


https://www.pcworld.com/article/2105408/3/watch-out-for-photos-containing-malware.html
Only motorcycle riders know why a dog sticks its head out of a car window.

Online Skee

  • Contributor
  • Member
  • Location: SE PA
  • Posts: 1658
  • Motorcycles: '08 Wee & an overweight Connie
Re: Personal Retirement Fund Calculator
« Reply #20 on: March 11, 2018, 08:35:53 AM »
I'm still trying to get rid of the Unread button virus, but new posts keep popping up.
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 sodapop6620

  • Member
  • Location: SEPA
  • Posts: 1236
  • Motorcycles: 4
Re: Personal Retirement Fund Calculator
« Reply #21 on: March 11, 2018, 09:04:08 AM »
Here's a critique of the sheet.  I just noticed it will allow more than $18,000 / year to be contributed to a 401K.  The current annual limit in the US is $18,500 / year.  The sheet should include a calculation which caps the amount allowed to contribute.

What about the catch money for the old farts. I believe that adds another 6K to put in the 401k.

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #22 on: March 11, 2018, 09:23:54 AM »
Here's a critique of the sheet.  I just noticed it will allow more than $18,000 / year to be contributed to a 401K.  The current annual limit in the US is $18,500 / year.  The sheet should include a calculation which caps the amount allowed to contribute.

What about the catch money for the old farts. I believe that adds another 6K to put in the 401k.

Good point.  Perhaps I can use the logic formulas to incorporate age into the cap restriction. 
Only motorcycle riders know why a dog sticks its head out of a car window.

Offline maddjack

  • Contributor
  • Member
  • Location: Earth Pa. McCandless
  • Posts: 683
  • UFO PILOT
  • Motorcycles: KLz1000 Versys
Re: Personal Retirement Fund Calculator
« Reply #23 on: March 11, 2018, 10:31:02 AM »
I calculate i can now retire anytime i want, with out using Doug's (aka DUG on the darkk web LOL) calcuator, i am just working till they piss me off enough to walk out, buying my retirement toys while working and stashing a little extra. :twofinger: :twofinger: :twofinger: :twofinger: :twofinger: :twofinger: :twofinger: :twofinger: :gerg:
VIVA EL STINKO

The little red bike is gone , sniff sniff, but the Batbike has begun.

Offline Bounce

  • Contributor
  • Member
  • Location: USA
  • Posts: 3098
    • FJR-Tips
  • Motorcycles: Yes
Re: Personal Retirement Fund Calculator
« Reply #24 on: March 11, 2018, 10:43:33 AM »
I'm not even sure what an M$ document is.  This is my file and I uploaded it directly to ST.O.

Did you use Excel or an open source speedsheet maker? Even you later reference XL.

If you don't understand the reference for a product being used, how much more/less financial intricacies?

As for "adjustments", check the dip the market just experienced. There was one that was anticipated (and counseled about by advisors) for about 3 years. It kept getting pushed back which made most advisors even more concerned. It can kill a year or two in progress overnight. OR it can kill 50% of your investment like it did in 2009.

As for viruses, the point of them is that the person infected often doesn't know they are. That's how it spreads. No tinfoil hats needed when the evidence of infections is historically there.

visitors can't see pics , please register or login

Online Cablebandit

  • Contributor
  • Member
  • Location: Stormshire
  • Posts: 4746
  • Pig Pilot
    • https://www.facebook.com/TheCablebandits
  • Motorcycles: A Blue One
Re: Personal Retirement Fund Calculator
« Reply #25 on: March 11, 2018, 01:10:23 PM »
You could end up driving Doug's Porsche if HIS numbers don't work out.   ;D

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #26 on: March 11, 2018, 02:12:55 PM »

As for viruses, the point of them is that the person infected often doesn't know they are. That's how it spreads. No tinfoil hats needed when the evidence of infections is historically there.

visitors can't see pics , please register or login


I understand.  That said, the topic of of the thread was asking for a review of the file for mathematical mistakes, not viruses.  Did I take the comments of me uploading a potential virus personally, yes.  After a little more research, I do understand where you're coming from.  Though, it does appear the trend and likelihood of getting hit by a microsoft macro virus is very low these days.  Perhaps the best feedback I can offer in return for your fears of a market collapse and PC viruses is to unplug from the web and be sure to store all of your cash in the bunker located in your backyard.    :lol:   :tinfoil:

Only motorcycle riders know why a dog sticks its head out of a car window.

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #27 on: March 11, 2018, 02:19:48 PM »
You could end up driving Doug's Porsche if HIS numbers don't work out.   ;D

No such disclaimer was made.   :nono:


Though, without the Porsche, I may have been able to retire about 3-4 years earlier.  Live for now or what may come in the future?  It's not that easy of an answer.  But, I made a choice.  :lol:


I have to admit, every major decision made these days get run through this calculator.  The thought is, do we really need _________, or would we rather retire _______ years sooner? 
Only motorcycle riders know why a dog sticks its head out of a car window.

Offline Mrs. DantesDame

  • Moderator
  • Member
  • Location: Basel, Switzerland
  • Posts: 1479
  • Getting too old for this crap
    • DantesDame's Adventures
  • Motorcycles: -14 BMW F800 GSA
Re: Personal Retirement Fund Calculator
« Reply #28 on: March 11, 2018, 02:41:08 PM »
I have to admit, every major decision made these days get run through this calculator.  The thought is, do we really need _________, or would we rather retire _______ years sooner?

That's always something that Dan and I discuss. Live life now? Or hope that we're healthy enough to enjoy it later? :shrug:
www.Dantesdame.com <-- Rides! Rides! Rides!

Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • Where there is Danger, there is Doug
Re: Personal Retirement Fund Calculator
« Reply #29 on: March 11, 2018, 03:26:48 PM »
I have to admit, every major decision made these days get run through this calculator.  The thought is, do we really need _________, or would we rather retire _______ years sooner?

That's always something that Dan and I discuss. Live life now? Or hope that we're healthy enough to enjoy it later? :shrug:

It's a balancing act, no doubt. 


For me, if I am well traveled and have experienced some things I've always wanted to experience while I have the cash flow to do it now, why not?  Tomorrow is not guaranteed and I very much see myself being more content in retirement if I've already covered much of the bucket list items now.  I can see myself getting a small place in the mountains somewhere after retirement and just chill.
Only motorcycle riders know why a dog sticks its head out of a car window.

Online kneescrubber

  • Contributor
  • Member
  • Location: Neither here nor there
  • Posts: 10423
  • Nothing beats good line of sight
  • Motorcycles: 1999 VFR
Re: Personal Retirement Fund Calculator
« Reply #30 on: March 11, 2018, 08:35:23 PM »
Firmly in the enjoy life now camp. Good thing I've always paid particular attention to my health.
Do not go where the path may lead, go instead where there is no path and leave a trail.

Ralph Waldo Emerson

Offline CLAY

  • Moderator
  • Member
  • Location: Grand Rapids, MI
  • Posts: 6450
  • How did I become a moderator?
  • Motorcycles: '03 Bandit 1200S, '97 XR650L, '79 XS650 Tracker, '75 XS650 Standard
Re: Personal Retirement Fund Calculator
« Reply #31 on: March 11, 2018, 09:10:30 PM »
Yeah, I fall into the "Enjoy the ride" kind of attitude.  I love pretty much every day. Even the ones that suck- without those I wouldn't know what a good one is. 
"Most accidents happen when the meek meet the douchebags."  -Viffergyrl
"The wider the road, the worse the food." -Coho

Offline Mrs. DantesDame

  • Moderator
  • Member
  • Location: Basel, Switzerland
  • Posts: 1479
  • Getting too old for this crap
    • DantesDame's Adventures
  • Motorcycles: -14 BMW F800 GSA
Re: Personal Retirement Fund Calculator
« Reply #32 on: March 12, 2018, 01:52:19 AM »
My father was (is) very good with money and while he has had a varied and interesting life, he has now reached a point where he can't / doesn't want to do anything. As he said to me the other night: "I have all of this money and don't want to do anything."

But having just gone through the tragedy of the last few years of Mom's life, with her needing specialized (and expensive) care, I know that reaching old age without money can be, well, terminal.


A difficult balancing act, to be sure.
www.Dantesdame.com <-- Rides! Rides! Rides!

Online Black Hills

  • Member
  • Location: Rapid CIty, SD
  • Posts: 2956
  • Motorcycles: KTM 1190 Adventure R, KTM300xcw
Re: Personal Retirement Fund Calculator
« Reply #33 on: March 12, 2018, 08:26:59 AM »
I didn't get the gay cockroach porn??

Offline maddjack

  • Contributor
  • Member
  • Location: Earth Pa. McCandless
  • Posts: 683
  • UFO PILOT
  • Motorcycles: KLz1000 Versys
Re: Personal Retirement Fund Calculator
« Reply #34 on: March 12, 2018, 09:15:18 AM »
I have to admit, every major decision made these days get run through this calculator.  The thought is, do we really need _________, or would we rather retire _______ years sooner?

That's always something that Dan and I discuss. Live life now? Or hope that we're healthy enough to enjoy it later? :shrug:

It's a balancing act, no doubt. 


For me, if I am well traveled and have experienced some things I've always wanted to experience while I have the cash flow to do it now, why not?  Tomorrow is not guaranteed and I very much see myself being more content in retirement if I've already covered much of the bucket list items now.  I can see myself getting a small place in the mountains somewhere after retirement and just chill.

My two cents,live like you are going to die tomorrow, save like you will live forever, yeah its sounding like a contradiction, but isn't.Don't hesitate to enjoy life, but don't go so hog wild that you have nothing in the future. it has worked for me, I can go at 60. :gerg: :gerg:
VIVA EL STINKO

The little red bike is gone , sniff sniff, but the Batbike has begun.

Offline oilhed

  • Member
  • Location: Central CT
  • Posts: 1358
  • Motorcycles: 2009 K1200LT (trunkless)
Re: Personal Retirement Fund Calculator
« Reply #35 on: March 12, 2018, 09:19:23 AM »
I've told my wife hundreds of time we can retire anytime.  As long as these places look good:
Rank   County   Per Capita Income
1   Wheeler County, GA   $16,267
2   Ziebach County, SD   $16,681
3   Union County, FL   $19,374
4   Bledsoe County, TN   $20,353
5   Telfair County, GA   $20,541
MarkF
aka OILHED
Central CT

Online Black Hills

  • Member
  • Location: Rapid CIty, SD
  • Posts: 2956
  • Motorcycles: KTM 1190 Adventure R, KTM300xcw
Re: Personal Retirement Fund Calculator
« Reply #36 on: March 12, 2018, 10:22:03 AM »
you'd be the richest guy in Bennett County SD.

Online radon222

  • Contributor
  • Member
  • Location: VA Beach
  • Posts: 1493
  • It's all Scratch's fault
  • Motorcycles: R1200GSAW, R1200RT
Re: Personal Retirement Fund Calculator
« Reply #37 on: March 12, 2018, 10:26:21 AM »
I don't know.   Every retirement calculator I've tried just comes back with... "yer phuqued"  ;D

Online Vulcanbill

  • Contributor
  • Member
  • Location: it's a secret, WV
  • Posts: 2711
  • no thank you ... still
  • Motorcycles: XT250
Re: Personal Retirement Fund Calculator
« Reply #38 on: March 12, 2018, 10:54:29 AM »
I have to admit, every major decision made these days get run through this calculator.  The thought is, do we really need _________, or would we rather retire _______ years sooner?

That's always something that Dan and I discuss. Live life now? Or hope that we're healthy enough to enjoy it later? :shrug:

It's a balancing act, no doubt. 


For me, if I am well traveled and have experienced some things I've always wanted to experience while I have the cash flow to do it now, why not?  Tomorrow is not guaranteed and I very much see myself being more content in retirement if I've already covered much of the bucket list items now.  I can see myself getting a small place in the mountains somewhere after retirement and just chill.

Vulcanbill approves this post. 

We got some interesting perspective on our 2010 trip.  4 months on the road w/ the camper had us meeting a LOT of full timers, most of whom were retired and traveling.  We heard, more often than anything else, was regret that they didn't act sooner.  Now they have the time and the money but not the bodies to allow them to do much about it.  Travel to the Grand Canyon and spend a week?  Sure no worries.  Walk into the canyon and see the wonders that are everywhere?  Nope, too old and broken or out of shape.  :(  I don't have time to wait to do stuff after retirement.  I probably won't live that long anyway. 

However, the objective is to make it so retirement doesn't cost us much of anything so we can live comfortably without much income. 
If a person's primary concern is increasing freedom, they should prepare for a reduction in average lifespan.  ---  Misanthropist

If you say "Gullible" real slow, it sounds like "Orange"

Online Black Hills

  • Member
  • Location: Rapid CIty, SD
  • Posts: 2956
  • Motorcycles: KTM 1190 Adventure R, KTM300xcw
Re: Personal Retirement Fund Calculator
« Reply #39 on: March 12, 2018, 11:45:03 AM »
better to burn out than to fade away then??

Offline Bounce

  • Contributor
  • Member
  • Location: USA
  • Posts: 3098
    • FJR-Tips
  • Motorcycles: Yes
Re: Personal Retirement Fund Calculator
« Reply #40 on: March 12, 2018, 12:06:58 PM »
Perhaps the best feedback I can offer in return for your fears of a market collapse and PC viruses is to unplug from the web and be sure to store all of your cash in the bunker located in your backyard.    :lol:   :tinfoil:

While not 100% effective, it does have a significant positive affect: macOS.

Online Vulcanbill

  • Contributor
  • Member
  • Location: it's a secret, WV
  • Posts: 2711
  • no thank you ... still
  • Motorcycles: XT250
Re: Personal Retirement Fund Calculator
« Reply #41 on: March 12, 2018, 12:10:07 PM »
better to burn out than to fade away then??

Not by design....  I'm 48 and the baby of 9 literally watching my DNA unfold in front of me.  I'm not made of longevity and other happy genetic stuff.  Sacrificing now for 25 years of blissful rocking chair time is just not good math.
If a person's primary concern is increasing freedom, they should prepare for a reduction in average lifespan.  ---  Misanthropist

If you say "Gullible" real slow, it sounds like "Orange"

Offline Bounce

  • Contributor
  • Member
  • Location: USA
  • Posts: 3098
    • FJR-Tips
  • Motorcycles: Yes
Re: Personal Retirement Fund Calculator
« Reply #42 on: March 12, 2018, 12:10:29 PM »
The thought is, do we really need _________, or would we rather retire _______ years sooner?

Similar was for us: PAY OFF ALL DEBT. Then... cash only. Use  credit only when it can be paid off before interest starts accumulating. In some cases the choice to "let 'er ride" for a few months to jack our ratings back up to 820 or more was also a thing.

Retired much earlier than originally planned. Also, 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.

Online Virginian

  • Contributor
  • Member
  • Location: Spotsylvania, VA
  • Posts: 2576
  • Motorcycles: '19 Husqvarna Svartpilen 401, '14 Vespa 946 Bellissma, '14 HD Wide Glide
Re: Personal Retirement Fund Calculator
« Reply #43 on: March 12, 2018, 12:26:27 PM »
I'm too young to not work and spend money. I'm quite sure I'll work into my golden years so I'm on the side of better live for today. How many folks do you personally know have worked their whole lives only to retire and die unexpectedly? When I reach the point in my life when I purchase an old Buick and ride with the blue hairs to bingo, I figure my life is pretty much over. 
« Last Edit: March 12, 2018, 01:28:39 PM by Virginian »
Show up on time, do your best and don't grumble about the outcome.

Online Black Hills

  • Member
  • Location: Rapid CIty, SD
  • Posts: 2956
  • Motorcycles: KTM 1190 Adventure R, KTM300xcw
Re: Personal Retirement Fund Calculator
« Reply #44 on: March 12, 2018, 01:22:36 PM »
It really is a crap shoot. Ex-father in law worked for  Union Pacific for 37 or so years, retired, bought a place in the country and died the next year. Crutzfeld jacob (sp?) disease killed a guy the ran and biked everyday and was in better shape than me by a long ways in only a month and a half. Never got to spend his money..
My grandmother finally moved to a nursing home when she was 98 and died at 103, spent every dime and then some. didn't get to do a lot in her relatively healthy retirement years because she couldn't afford it. 
my parents worked hard , with not much for fun, with the intent that they would enjoy retirement at 60. traveled to Europe annually for 10 or so years as well as enjoying many other  trips within the U.S. now they mostly stay home as their health is starting to go down hill.  they will leave a decent inheritance for my brother, sister, and I. I tell them to spend it instead they tell me they have nothing to spend it on??

I guess do what you think is best and good luck!!  personally I enjoy life quite a bit now but am working on being able to retire when I'm 59 and do as I please for as long as my body lets me. with my ultimate goal being killed in motorcycle accident after spending my last dollar on a good beer when I'm around 100 ;)


Offline R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 6089
  • 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: 2956
  • 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: 709
    • 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.

Online kneescrubber

  • Contributor
  • Member
  • Location: Neither here nor there
  • Posts: 10423
  • 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: 1658
  • 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