Welcome, Guest. Please login or register.

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

0 Members and 1 Guest are viewing this topic.

Online R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 5630
  • Where there is Danger, there is Doug
  • Motorcycles: '13 R1200GS
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.

Online Bounce

  • Contributor
  • Member
  • Location: USA
  • Posts: 2687
    • 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?

Online R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 5630
  • Where there is Danger, there is Doug
  • Motorcycles: '13 R1200GS
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: 1192
  • It's Hip, ya know
  • Motorcycles: 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

Online Mrs. DantesDame

  • Moderator
  • Member
  • Location: Basel, Switzerland
  • Posts: 1377
  • 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!

Online R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 5630
  • Where there is Danger, there is Doug
  • Motorcycles: '13 R1200GS
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: 2044
  • 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

Online R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 5630
  • Where there is Danger, there is Doug
  • Motorcycles: '13 R1200GS
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.

Online R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 5630
  • Where there is Danger, there is Doug
  • Motorcycles: '13 R1200GS
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: 2628
  • 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: 2002
  • Motorcycles: '17 Yamaha FZ-10 '14 Vespa 946 Bellissma
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: 6189
  • 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: 1466
  • 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.   

Online R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 5630
  • Where there is Danger, there is Doug
  • Motorcycles: '13 R1200GS
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.

Online R Doug

  • Contributor
  • Member
  • Location: Clemmons, NC
  • Posts: 5630
  • Where there is Danger, there is Doug
  • Motorcycles: '13 R1200GS
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.