EvrClrx311
Full time employment: Posting here.
- Joined
- Feb 8, 2012
- Messages
- 648
I had some free time today and was interested to run some simulations on the effects of different retirement strategies using real world market conditions. I think it is safe to assume that people nearing retirement right now are experiencing one of the worst stretches leading up to retirement that you can expect historically (the last 10 years has really been a lost decade)... so running models on investing over the last 30-40 years is a good place to start for worst case planning.
I'll edit this post as I do more of these and add to it (or I might just post below).
Set-Up... for the purposes of this study we'll follow an individual born in 1951. Lets assume he was in school until the age of 23 (1974) and graduated as an engineer. Today the average engineer out of school makes approximately $50,000 a year... which inflation adjusted back to 1974 would have been a starting salary of $10,470. Lets assume this engineer worked his way up over a 36 years career to be making $80,083 in 2010 (an average 5.5% yearly raise over his entire working career). Looks about right... someone starting out his career at 50K in today's dollars and ending it at 80K. Obviously in some fields you have more or less room for salary increase.
To keep things a little simpler (at least for now), we'll assume all retirement investments are into an Index Fund tracking the S&P500... so we'll use real world returns of the S&P500 with dividends included as shown on this site:
CAGR of the Stock Market: Annualized Returns of the S&P 500
Option A) 20% Always - If this individual decided to set aside 20% of his pay no matter what in every single year he worked. He would have set aside a total of $269,155 over 36 years that would grow to $1,681,611 in 2010
Option B) Increasing - If this individual decided to set aside 10% of his pay his first decade, 20% his second, 30% his 3rd... He would have set aside a total of $412,482 over 36 years that would grow to $1,441,663 in 2010
Option C) Late Start 30% - If this individual never saved for retirement until age 35 and then started socking away 30% of his pay... He would have set aside a total of $352,465 over 36 years that would grow to $934,095 in 2010
These are all scenarios that look at his retirement account at age 60... now lets see what his options are for an earlier retirement under these same three options:
By Age 50 he would have...
Option A) $1,307,900
Option B) $975,539
Option C) $601,426
Even with as bad as the economy and stock market is today... you can see that investing early is crucial in building a nest egg. The reason is that over 35 years you are all but guaranteed an average compounded return of 8% or more... if you wait till later in your career to really ratchet up the savings, you are hoping that a much smaller time period (10 or 15 years) while near the entire of your career will obtain good or above average returns.
If anyone has ideas for different scenarios or tweaks to this one let me know. I'm having fun with excel in my boredom
I'll edit this post as I do more of these and add to it (or I might just post below).
Set-Up... for the purposes of this study we'll follow an individual born in 1951. Lets assume he was in school until the age of 23 (1974) and graduated as an engineer. Today the average engineer out of school makes approximately $50,000 a year... which inflation adjusted back to 1974 would have been a starting salary of $10,470. Lets assume this engineer worked his way up over a 36 years career to be making $80,083 in 2010 (an average 5.5% yearly raise over his entire working career). Looks about right... someone starting out his career at 50K in today's dollars and ending it at 80K. Obviously in some fields you have more or less room for salary increase.
To keep things a little simpler (at least for now), we'll assume all retirement investments are into an Index Fund tracking the S&P500... so we'll use real world returns of the S&P500 with dividends included as shown on this site:
CAGR of the Stock Market: Annualized Returns of the S&P 500
Option A) 20% Always - If this individual decided to set aside 20% of his pay no matter what in every single year he worked. He would have set aside a total of $269,155 over 36 years that would grow to $1,681,611 in 2010
Option B) Increasing - If this individual decided to set aside 10% of his pay his first decade, 20% his second, 30% his 3rd... He would have set aside a total of $412,482 over 36 years that would grow to $1,441,663 in 2010
Option C) Late Start 30% - If this individual never saved for retirement until age 35 and then started socking away 30% of his pay... He would have set aside a total of $352,465 over 36 years that would grow to $934,095 in 2010
These are all scenarios that look at his retirement account at age 60... now lets see what his options are for an earlier retirement under these same three options:
By Age 50 he would have...
Option A) $1,307,900
Option B) $975,539
Option C) $601,426
Even with as bad as the economy and stock market is today... you can see that investing early is crucial in building a nest egg. The reason is that over 35 years you are all but guaranteed an average compounded return of 8% or more... if you wait till later in your career to really ratchet up the savings, you are hoping that a much smaller time period (10 or 15 years) while near the entire of your career will obtain good or above average returns.
If anyone has ideas for different scenarios or tweaks to this one let me know. I'm having fun with excel in my boredom